Hie I hve a problem with rowfilter in vb.net.Im writing a program which displays two screens the first one should display the orders and the second one should show the order details of the selected order on the first screen.Im hvin a problem with the second screen becoz wen i double click a row on the first screen no results are displayed on the second screen i think ther is smething wrong with the way im filterin my dataview.
the code im using is
any help please?
the code im using is
Code:
Private Sub DataGrid1_DoubleClick(ByVal sender As Object, ByVal e As System.EventArgs) Handles DataGrid1.DoubleClick
Dim orderdetails As New Form2
Dim y As String
Dim d1 As Double
orderdetails.Show()
dvorders = New DataView
dvorders.Table = dsShop.Tables("orders")
y = (Me.DataGrid1.Item(Me.DataGrid1.CurrentRowIndex, 0))
d1 = y
dvorders.RowFilter = "orderid" = y
orderdetails.DataGrid1.DataSource = dvorders
End Sub