I'm glad you thought that was a good question, because (now) I have a really stupid question.
If I want to do an SQL query and bring back the results in a dataset, do I *have* to use the data adapter?
I have a form where I need to bring back 3 data tables...so I do a
MyAdapter = new SqlDataAdapter("SELECT * FROM TABLE1; SELECT * FROM TABLE2; SELECT * FROM TABLE3,MyConnection)
DsReturn = new DataSet();
MyAdapter.Fill(DsReturn,"whatever");
Is there a 'simpler' way to do this? About the only requirement is that it has to be a dataset, it can't be a data reader.
Thanks,
Kevin