October 22, 2013 at 9:05 am
hello
i have a store procedure that return multiple datasets i want to manipulate one of theses datasets to input in a datatable is this posible and how
plese help me
December 10, 2013 at 1:20 pm
are you asking about the .net development side of it?
if yes, you can take a look at this one:
http://www.codeproject.com/Articles/675933/Returning-Multiple-Result-Sets-from-an-Entity-Fram
this is using a stored proc in an EF model.
December 10, 2013 at 1:37 pm
basically, you assign the results to a DataSet; since a DataSet contains a collection of DataTable,s you can then iterate through each datatable, or assign, say a grid's datasource to DataSet.Tables[0], for example.
Dim ds As New DataSet
ds = SqlHelper.ExecuteDataset(Me.ConnectionString, CommandType.Text, sql)
For Each dt As DataTable In ds.Tables
'do something with the results, like export?
Next
Lowell
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply