Execute Query on a TOTALLY disconnected DataSet

[rawCoder]

Hi All

Is there a way to Execute a query (possibly including two tables and joins)
on a totally disconnected dataset.
By 'Totally Disconnted' , I mean there is no DB and there is no DBConnection
/ DBCommand - all the data and structure is in memory.
The query is to be used to databind a grid, so some sort of view is needed
( i.e. its not a one time query ).

Its like having a mini in-memory DB on the client side and looking for a way
to have a view running stored procedure.

( NOTE: DataView's RowStateFilter and DataTables Select might not be helpful
in this case )

Thank You
rawCoder

 

[Nicholas Paldino [.NET/C# MVP]]

rawCoder,

The DataSet is totally disconnected. There is no way to "connect" it to
anything. When it is populated, it doesn't have knowledge of the
connection, or the commands used to populate it.

The only way to perform a query on that data would be to use the Select
method on the DataTable class, and if that doesn't work, then you will have
to evaluate the values in the rows yourself.

Hope this helps.