Retrieve data from dataset (newbie)

[=?ISO-8859-1?Q?S=F8ren?=]

Hi guys

I hope this is the correct news group. If not .. then please point me in
the right direction.

Ok - to the problem:
I´ve got a dataset with a table that contains some rows. How to I
execute a sql statement like this:

SELECT DISTINCT [ROW] FROM [TABLE] WHERE ...

... on the dataset, and write the output to the console?
Regards Søren

[Cor Ligthert [MVP]]

Soren,

You cannot use a Select on a DataSet, however there is since version 2.0 an
overloaded DataView method which does what you ask.

http://msdn.microsoft.com/en-us/library/8sd1cd0a.aspx

Cor

"Søren" <sp******@die.youngschreef in bericht
news:e5**************@TK2MSFTNGP05.phx.gbl...

Hi guys

I hope this is the correct news group. If not .. then please point me in
the right direction.

Ok - to the problem:
I´ve got a dataset with a table that contains some rows. How to I execute
a sql statement like this:

SELECT DISTINCT [ROW] FROM [TABLE] WHERE ...

.. on the dataset, and write the output to the console?
Regards Søren

[Bill McCarthy]

Hi Søren,

If you are using VB 2008 you can use LINQ to Dataset, eg.

Dim customers As DataTable = ds.Tables("Customer")

Dim query = From cust In customers.AsEnumerable() _
Where cust.Field(Of String)("LastName") ="Smith" _
Select cust Distinct

Look for "LINQ to Dataset" for more examples.

"Søren" <sp******@die.youngwrote in message
news:e5**************@TK2MSFTNGP05.phx.gbl...

Hi guys

I hope this is the correct news group. If not .. then please point me in
the right direction.

Ok - to the problem:
I´ve got a dataset with a table that contains some rows. How to I execute
a sql statement like this:

SELECT DISTINCT [ROW] FROM [TABLE] WHERE ...

.. on the dataset, and write the output to the console?
Regards Søren

[=?ISO-8859-1?Q?S=F8ren?=]

Thanks. That was just what I needed. :-)

Regards Søren
Bill McCarthy skrev:

Hi Søren,

If you are using VB 2008 you can use LINQ to Dataset, eg.

Dim customers As DataTable = ds.Tables("Customer")

Dim query = From cust In customers.AsEnumerable() _
Where cust.Field(Of String)("LastName") ="Smith" _
Select cust Distinct

Look for "LINQ to Dataset" for more examples.

"Søren" <sp******@die.youngwrote in message
news:e5**************@TK2MSFTNGP05.phx.gbl...

>Hi guys

I hope this is the correct news group. If not .. then please point me
in the right direction.

Ok - to the problem:
I´ve got a dataset with a table that contains some rows. How to I
execute a sql statement like this:

SELECT DISTINCT [ROW] FROM [TABLE] WHERE ...

.. on the dataset, and write the output to the console?
Regards Søren