Cant seem to filter 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,

I have answered this in another newsgroup,

Cor

"mike11d11" <mi*******@yaho o.comschreef in bericht
news:11******** *************@h 48g2000cwc.goog legroups.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

[Michel Posseth [MCP]]

That is because

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

will return a array of datarows

so you use this filetr like this

for each dr as datarow in Me.SQLDataSet.T ables("WorkList ").Select(" DSK =
'999'", "DSK")

debug.writeline (dr.item(0))

next

You might consider using a dataview wich gives you some more flexibility
with databinding
regards

Michel Posseth [MCP]


"mike11d11" wrote:

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]]

Was the same answer
:_)

Cor

"Michel Posseth [MCP]" <Mi************ **@discussions. microsoft.comsc hreef
in bericht news:3D******** *************** ***********@mic rosoft.com...

>
That is because

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

will return a array of datarows

so you use this filetr like this

for each dr as datarow in Me.SQLDataSet.T ables("WorkList ").Select(" DSK =
'999'", "DSK")

debug.writeline (dr.item(0))

next

You might consider using a dataview wich gives you some more flexibility
with databinding
regards

Michel Posseth [MCP]


"mike11d11" wrote:

>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.EventAr gs) Handles MyBase.Load

Me.WorkListTab leAdapter.Fill( Me.SQLDataSet.W orkList)

MsgBox(Me.Accu Logic_SQLDataSe t.WorkList.Rows .Count)
End Sub

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

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

End Sub

[mike11d11]

I'm trying to get to where I can filter down my datatable to see
specific records. Instead of the debug line, what code could i use to
view only these accounts. I tried taking these rows and adding them to
another table but it gives me an error saying these rows already belong
to a table?

[RobinS]

Are you using data binding? You can easily filter
it with the associated binding source.

myBindingSource .Filter = "DSK = '999'"

Or create a DataView object (which is bindable, by the way)
and then filter it:

Dim myDataView = New DataView(SQLDat aSet.Tables("Wo rkList"))
myDataView.Filt er = "DSK = '999'"

I think if you want to read through the rows of the DataView,
you have to cast it as a table using the ToTable method.

Hope that helps.
Robin S.
"mike11d11" <mi*******@yaho o.comwrote in message
news:11******** **************@ e3g2000cwe.goog legroups.com...

I'm trying to get to where I can filter down my datatable to see
specific records. Instead of the debug line, what code could i use to
view only these accounts. I tried taking these rows and adding them to
another table but it gives me an error saying these rows already belong
to a table?

[Cor Ligthert [MVP]]

Mike,

You never can add rows from one table to anothere.

The datarows have themselves no description of the items, those are in the
datacolumns.

The only thing you can do is make a datatable.copy and than filter that one,

Cor

"mike11d11" <mi*******@yaho o.comschreef in bericht
news:11******** **************@ e3g2000cwe.goog legroups.com...

I'm trying to get to where I can filter down my datatable to see
specific records. Instead of the debug line, what code could i use to
view only these accounts. I tried taking these rows and adding them to
another table but it gives me an error saying these rows already belong
to a table?