Creating a Dataview from a Dataset using SQL?

[Simon Verona]

I'm probably missing the obvious.

I have a dataset that is built in code (it has a single datatable) that I
want to populate a datagrid based on an SQL statement that I want to run
against the dataset.

I can't work out though how to create a dataview from the dataset using an
SQL statement.

Have I missed something stupid?

Thanks
Simon

 

[Miha Markic]

Hi Simon,

Each DataTable has a DefaultView property (you can create as much DataView's
as you want) that lets you filter and sort rows. If this isn't enough for
you then you might take a look at
http://www.queryadataset.com/

 

[Simon Verona]

QueryaDataSet looks exactly what I need. Didn't think I'd missed anything!

Thanks
Simon

Hi Simon,

Each DataTable has a DefaultView property (you can create as much
DataView's as you want) that lets you filter and sort rows. If this isn't
enough for you then you might take a look at
http://www.queryadataset.com/

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

I'm probably missing the obvious.

I have a dataset that is built in code (it has a single datatable) that I
want to populate a datagrid based on an SQL statement that I want to run
against the dataset.

I can't work out though how to create a dataview from the dataset using
an SQL statement.

Have I missed something stupid?

Thanks
Simon

 

[Cor Ligthert[MVP]]

Simon,

You know as that you don't use a datatable that does not need to be
serialized and/or don't used in a strongly typed datatset, then you can use
the datatable direct in your actions.

Cor