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