tags:

views:

18

answers:

0
+2  Q: 

Create entire DataSet from existing stored procedure

Hi,

I have stored procedures (they accept parameters) that return multiple result sets and I'd like to have this saved in a typed dataSet.

The question is: can I have Visual studio 2010 generate the typed dataset based on stored procedure? I know I can have this for a single table, but I need the whole dataSet (multiple tables, one for each result set)

related questions

.NET Table Adapters: Get vs. Fill?
How can I read multiple tables into a dataset?
.Net: Convert Generic List of Objects to DataSet
Synchronize DataSet
How to wire a middle tier of Objects to a data tier consisting of a DataSet?
How do I refresh the relationships in a dataset?
What triggers ConstraintException when loading DataSet?
Why is a SQL float different from a C# float
Point ADO.Net DataSet to different databases at runtime?
Should I return a strongly typed dataset from a webservice?
How many DataTable objects should I use in my C# app?
How to convert Typed DataSet Scheme when one of the types was changed?
DataSet.Select and DateTime
Select rows in dataset table based on other dataset table
Object initialization in C# (.Net)
What are the disadvantages of Typed DataSets
Read Access File into a DataSet
DBUnit dataset generation
Handling XSD Dataset ConstraintExceptions
VB.NET Get underlying system.type from nullable type
Get the DefaultView DataRowView from a DataRow
PHP Script to populate MySQL tables
C#: What Else Do You Use Besides DataSet
Is there some way of recycling a Crystal Reports dataset?
Datatable vs Dataset