>>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
Semper ubi sub ubi.