Need help filtering dataset table by a value

  • Thread starter Thread starter mike11d11
  • Start date Start date
M

mike11d11

I cant seem to filter down my dataset table by criteria in expression.
Can someone tell me why I still have the same amount of rows after I
use this filter select option.



Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load

Me.WorkListTableAdapter.Fill(Me.SQLDataSet.WorkList)

MsgBox(Me.AccuLogic_SQLDataSet.WorkList.Rows.Count)


End Sub



Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button2.Click

Me.SQLDataSet.Tables("WorkList").Select("DSK = '999'", "DSK")

End Sub
 
Mike,

The select returns an array of datarows

dim mySelectedRows() as Datarows =
Me.SQLDataSet.Tables("WorkList").Select("DSK = '999'", "DSK")

I hope this helps,

Cor
 
I tried taking the mySelectedRows() rows and adding them to another
table and it gives me an error saying the rows already belong to
another table. How would you recommend breaking down my table to view
only specific records by using the mySelectedRows().
 
Back
Top