Query: dv.rowfilter = "firstname like 'a%'"; yes.
SqlConnection con = new SqlConnection ( "workstation id = yio; packet size = 4096; user id = sa; data source = yio; persist security info = True; initial catalog = Northwind"); SqlDataAdapter da = new SqlDataAdapter ( "select * from Employees ", con); DATATABLE DT = New DataTable (); DA.FILL (DT); DataView DV = New DataView (DT); dt); DV.RowFilter =" FirstName Like 'a%' "; DataGrid1.datasource = DV; DATABIND (); Positioning: dataView.find ()
