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

Me.WorkListTableAdapter.Fill(Me.SQLDataSet.WorkLis t)

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

[Cor Ligthert [MVP]]

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

"mike11d11" <mi*******@yahoo.comschreef in bericht
news:11**********************@k70g2000cwa.googlegr oups.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(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load

Me.WorkListTableAdapter.Fill(Me.SQLDataSet.WorkLis t)

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

[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*******@yahoo.comschreef in bericht
news:11*********************@m7g2000cwm.googlegrou ps.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().