Retrieve data from dataset (newbie)

[Søren]

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

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

 

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

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.

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

WHERE ...

.. on the dataset, and write the output to the console?


Regards Søren