SQL query on DataSet

Question

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?

airguillo · Answer

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 Wegierski · Answer

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.