>>I had a thought when I woke up this morning. Can I pass a SP as an Adapter's SelectCommand?
>>If it is possible are there any advantages/disadvantages for doing this?
>>
>>Einar
>
>I may not understand your question but here is something that I do.
>
>I have a Class that controls my data handling. When I use a DataAdapter I call a SP. Now as for advantages/disadvantages, I am guessing that allowing the SP to do “the work” would be better.

I think you understand my question.
This is in a nut-shell what I want to do:

oleDbAdapter = new OleDbDataAdapter();
oleDbAdapter.SelectCommand = new OleDbCommand("MyStoredProcedureName", oleDbConnection);
oleDbAdapter.Fill(myDataset, "myTable");

I realize how easy it would be for me to test this, but I just wanted to check here before I dove into that.

Einar