can i fire a sql query on the table of Dataset?

Question

I know this is very stupid thing to ask. But i am not as genius as you all. if i have a dataset as give below:-

adapter.fill(ds,"Login");

Now the table created in Dataset is "Login". Now can i fire a sql command over this table like

sqlcommand cmd = new sqlcommand("select * from Login");

Answer 1

you can filter the data table, eg

ds.Tables["Login"].Select("ID=1 AND ID2=3"); // sample expression

more on this link

• Filtering and Sorting in Datasets