Loading

SQL query on DataSet

metos

Is there any possibility to run sql query on disconnected dataset? I need to get DataView that is result of the JOIN operation of two tables in my dataset... How can I do it?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

airguillo22y ago
You can use a DataAdapter object, to execute your sql query...and then to fill the dataset. after that you can create your dataview with sql data. SqlDataAdapter da = new SqlDataAdapter("select * from customers"); DataSet ds = new DataSet(); da.Fill(ds);
Andrzej Wegierski22y ago
DataView is'nt a good object I think. You must modify DataTable first. DataView will be based on this DataTable, so, you must add relation between joined tables and expression columns based on joined table - or create new table with all columns from joined tables.