Need help filtering dataset table by a value

[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(ByVa l sender As System.Object, ByVal e As
System.EventArg s) Handles MyBase.Load

Me.WorkListTabl eAdapter.Fill(M e.SQLDataSet.Wo rkList)

MsgBox(Me.AccuL ogic_SQLDataSet .WorkList.Rows. Count)
End Sub

Private Sub Button2_Click(B yVal sender As System.Object, ByVal e As
System.EventArg s) Handles Button2.Click

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

End Sub

[Cor Ligthert [MVP]]

Mike,

The select returns an array of datarows

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

I hope this helps,

Cor

"mike11d11" <mi*******@yaho o.comschreef in bericht
news:11******** **************@ k70g2000cwa.goo glegroups.com.. .

>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(ByVa l sender As System.Object, ByVal e As
System.EventArg s) Handles MyBase.Load

Me.WorkListTabl eAdapter.Fill(M e.SQLDataSet.Wo rkList)

MsgBox(Me.AccuL ogic_SQLDataSet .WorkList.Rows. Count)
End Sub

Private Sub Button2_Click(B yVal sender As System.Object, ByVal e As
System.EventArg s) Handles Button2.Click

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

End Sub

[mike11d11]

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( ).

[Cor Ligthert [MVP]]

Mike,

Please do not multipost, answer given in another newsgroup,

Cor

"mike11d11" <mi*******@yaho o.comschreef in bericht
news:11******** *************@m 7g2000cwm.googl egroups.com...

>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( ).