Filtering a Dataset

[Shahriar]

I am using the following statement to filter a dataset.

ds.Tables(0).De faultView.RowFi lter = "ID='" & currentpos & " '
It seems to run fine. My question is since I have a filter set, why is the
following loop still goes through every record.

How can I achieve a real filter on a dataset? I dont want to create a
dataview.
For i = 0 To ds.Tables(0).Ro ws.Count - 1
MsgBox(ds.Table s(0).Rows(i)("c asenumber"))
Next
Many thanks

[Jay B. Harlow [MVP - Outlook]]

Shahriar,
You set the filter on the DataView object that DefaultView returns. This
DataView does not in any way effect the rows that are in the DataTable.
DataTable.Rows always returns all the rows in the DataTable.

I dont want to create a dataview. You just did, with this statement.
ds.Tables(0).De faultView.RowFi lter = "ID='" & currentpos & " '
How can I achieve a real filter on a dataset? What I normally do is use DataTable.Selec t when a DataView is not
"appropriat e" but I want to filter the rows of a table.

Something like:

For Each row As DataRow in ds.Tables(0).Se lect("ID='" & currentpos &
"'")
MessageBox.Show (row("casenumbe r")
Next

Hope this helps
Jay

"Shahriar" <He***********@ hotmail.com> wrote in message
news:FK1bd.2641 $y71.624@trnddc 02...I am using the following statement to filter a dataset.

ds.Tables(0).De faultView.RowFi lter = "ID='" & currentpos & " '
It seems to run fine. My question is since I have a filter set, why is
the following loop still goes through every record.

How can I achieve a real filter on a dataset? I dont want to create a
dataview.
For i = 0 To ds.Tables(0).Ro ws.Count - 1
MsgBox(ds.Table s(0).Rows(i)("c asenumber"))
Next
Many thanks

[Shahriar]

Jay.
Thanks for the reply. Here is my problem .
I have a dataset in a grid type layout. The user clicks on a record. There I
launch a new form displaying details on the data.
In the new form i have a text box that I want am binding to the dataset.
The issue is it has no way of knowing which row # the dataset is. That is
why I wanted to filter on the dataset itself.

tempTable = ds.Tables(0)

TextBox1.DataBi ndings.Add("tex t", tempTable, "casenumber ") ' always points
to the first record.

Where in the above example can I specify the row number of the dataset for
the binding.

If I dont do databinding I would have something like this which works fine,
but I want to avoid reassining the value back.

TextBox1.Text = tempTable.Rows( currentpos)("ca senumber")

Thanks

Shahriar

"Jay B. Harlow [MVP - Outlook]" <Ja************ @msn.com> wrote in message
news:u$******** ******@TK2MSFTN GP09.phx.gbl...

Shahriar,
You set the filter on the DataView object that DefaultView returns. This
DataView does not in any way effect the rows that are in the DataTable.
DataTable.Rows always returns all the rows in the DataTable.

I dont want to create a dataview.

You just did, with this statement.

ds.Tables(0).De faultView.RowFi lter = "ID='" & currentpos & " '

How can I achieve a real filter on a dataset?

What I normally do is use DataTable.Selec t when a DataView is not
"appropriat e" but I want to filter the rows of a table.

Something like:

For Each row As DataRow in ds.Tables(0).Se lect("ID='" & currentpos &
"'")
MessageBox.Show (row("casenumbe r")
Next

Hope this helps
Jay

"Shahriar" <He***********@ hotmail.com> wrote in message
news:FK1bd.2641 $y71.624@trnddc 02...

I am using the following statement to filter a dataset.

ds.Tables(0).De faultView.RowFi lter = "ID='" & currentpos & " '
It seems to run fine. My question is since I have a filter set, why is
the following loop still goes through every record.

How can I achieve a real filter on a dataset? I dont want to create a
dataview.
For i = 0 To ds.Tables(0).Ro ws.Count - 1
MsgBox(ds.Table s(0).Rows(i)("c asenumber"))
Next
Many thanks

[Cor Ligthert]

Shahriar,

For that is databinding and the currencymanager something as
\\\
dim cma As CurrencyManager
textbox1.DataBi ndings.Clear()
cma = DirectCast(Bind ingContext(dv), CurrencyManager )
textbox1.DataBi ndings.Add(New Binding("Text", dv, "MyfieldNam e"))
///

I hope this gives a starting idea

Do not forget when you want to a update first to do the
\\
BindingContext( dv).EndCurrentE dit()
///
I hope this helps a little bit?

Cor