Loading

Stored Procedure on a C# datatable NOT a sql table

Joe T

16y8.7kLINQ

Hi,
I have a datatable:
DataTable dt = new DataTable();
dt = report.BodyTable;

Now I want to run a stored procedure on dt (i.e. the in-memory dt object NOT a Sql Server table) and return the results to another datatable. I am using SQL SERVER 2005.
Is this possible?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

16y ago
I don't think we can do this. If you want fiter records from a datatable, use dt.select() and it will return array of rows.
http://msdn.microsoft.com/en-us/library/system.data.datatable.select.aspx
http://authors.aspalliance.com/aspxtreme/sys/data/DataTableClassSelect.aspx
http://www.developerfusion.com/article/4703/filtering-and-sorting-in-adonet/2/
0