DataSet Filter

[Eddy Balan]

Hi,

Please tell me how can I filter a dataset..!!!???? :-(((

Eddy

[Cor]

Hi Eddy,

You have to tell more what you want,

Because you can use by instance
dataset.select
dataset.compute
add a dataview
itterate throught the dataset with different methods

Please tell me how can I filter a dataset..!!!???? :-(((

So tell what you want to do, maybe we can help you?

Cor

[Jan Tielens]

Please tell a little bit more about your problem... e.g. some code would be
great!

--
Greetz

Jan Tielens
________________________________
Read my weblog: http://weblogs.asp.net/jan
"Eddy Balan" <ed**@romsoft.ro> wrote in message
news:eS**************@TK2MSFTNGP09.phx.gbl...

Hi,

Please tell me how can I filter a dataset..!!!???? :-(((

Eddy

[One Handed Man [ OHM# ]]

Here's an example.

Me.dview = New DataView(Me.tablePeople)

dview.RowFilter = "FirstName = 'Terry'"

Me.dg3.DataSource = dview

In this example, I create a DataView of my table tablePeople, and then I
set the DataSource of my datagrid dg3 to that view, before this I filter on
my own name, this returns one record in my case. I also could have sorted
this differently for example.

OHM#


Eddy Balan wrote:

Hi,

Please tell me how can I filter a dataset..!!!???? :-(((

Eddy

Regards - OHM# On**********@BTInternet.com

[Armin Zingler]

"Eddy Balan" <ed**@romsoft.ro> schrieb

Please tell me how can I filter a dataset..!!!???? :-(((

http://msdn.microsoft.com/library/en...ngdatasets.asp
--
Armin

http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html

[Eddy Balan]

If Me.txtKey.Text = "" Then
Me.Ds.Tables("MFM").Clear()
Me.view_MF.Parameters("@Key").Value = "n/a"
Me.daviewMFM.Fill(Me.Ds, "MFM")
Else
Me.Ds.Tables("MFM").Clear()
Me.view_MF.Parameters("@Key").Value=Me.txtKey.Text
Me.daviewMFM.Fill(Me.Ds, "MFM")
End If

At the moment I'm using a stored procedure witch I called every time the
textbox change to filter the dataset (this procedure require too many
resources). I've tried to use the select command but no results.

Regards
Eddy
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!