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