Typed DataSet for multi-result Stored Procedure

Hot Topic

writing XML to a socket
Displaying SQL default values in vb.net form
saving ref of remote object
Get Class and property name form an instance property
VB Code to open a Web Form
Who's using .Net?
Bug in VS2005 Custom Tool (XSDs) or VS2003 conversion problem
connection string
C#/VB.NET on linux
just in time debugger

.NET Development

XmlException: "Name cannot begin with the '.' character"
How to read Bitmap from a file.
Serial data to a text box
Insert fails, need to know if SQLCommand error or SQLServer
web service authentication
Large Result Sets and Datareader
inner join usage
how to get programatically the primary and foriegn key of a table in a database
Sending data using Socket class - problem with blocking thread
SqlDataSource Parameters

Typed DataSet for multi-result Stored Procedure

I have a stored procedure that contains 15 simple select statements. Whenever I try to create a typed DataSet, it only creates a DataTable for the first result. Is there a way to make the tool create a DataTable for each result in the DataSet


Answer this question

Typed DataSet for multi-result Stored Procedure

  • ZMAN!!

    Nope.

    While the DataAdapter can create N tables based on the SELECT statements executed, the TableAdapter is designed to expose a single (unmarried) table.



  • Evangelos

    Interesting. I don't need relationships and constraints in the typed DataSet, so this could get me what I want. All I've been doing thus far is creating a typed DataSet and dragging the StoredProcedure onto the DataSet designer, which results in only the first table. Is there a different way to do this using a DataAdapter that will create an "unmarried" table for each SELECT in my stored procedure

  • Typed DataSet for multi-result Stored Procedure
Answer this question