Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Stored procedure
Message
From
11/09/2002 16:47:37
 
 
To
11/09/2002 16:39:01
General information
Forum:
ASP.NET
Category:
Other
Miscellaneous
Thread ID:
00699524
Message ID:
00699528
Views:
14
Sure ...
// assuming you already have the connection, oConnection, and the DataSet, ds
SqlCommand sc = new SqlCommand("mySP", this.oConnection);
sc.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(sc);

int iRows = da.Fill(ds)
Easy enough for ya? <g>

~~Bonnie


>is there a way to populate a dataset table by calling a stored procedure. i know i can run the executereader method to populate a datareader and then populate the dataset from the reader, but is there a way to populate a dataset without executing the executereader first. thanks for the help
Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform