hi there

I was wondering, in C#, is there a way to obtain a datatable or dataset of results when using sp_executeSQL?

I can use normal SQL queries fine, but when using the stored proc sp_executeSQL, i do not know how to obtain the entire collection of results into a datatable or dataset.

any ideas?