SQL select on a DataTable

[SidTheSquid]

Hi, i'm new to VB.net and I'm curious to know if i can do an sql select statement on a dataTable in a dataSet.

I already created a myDataset and myDatable from a select statement from a database connection. Since myDataset can be worked on offline, I now want to make a subselection from myDataTable in myDataSet versus going back to the database connection.

Any help is greatly appreciated.
Thanks
Sid

 

[Blitz]

Im not sure if you can do a sql statement on it but if not you should be able to do what you need using dataviews.