PC Review


Reply
Thread Tools Rate Thread

Typed dataset via stored procedure.

 
 
Jim Boyd
Guest
Posts: n/a
 
      26th Aug 2003
I am looking for some documentation or instruction on how to populate a
typed dataset via an associated stored procedure.

Here is what I have done...
Added a new typed data set via the "Add new item" menu.
Dragged a stored procedure from my SQL database to the .xsd dataset form.

I want to execute the stored procedure to populate my dataset.

I can do this by creating an external connection and command. The trick is I
want to use the API provided in my generated dataset class. I can see that
the stored procedure is referenced in the class but I am not sure how to
proceed to populate the dataset.

Thanks in advance,
-jim



 
Reply With Quote
 
 
 
 
John Viele
Guest
Posts: n/a
 
      26th Aug 2003
Assuming your DataAdapter and DataSet were generated properly, it works just
like any other data adapter. Something like:

myDataAdapter.Fill(myDataSet);


"Jim Boyd" <(E-Mail Removed)> wrote in message
news:uXNrtq$(E-Mail Removed)...
> I am looking for some documentation or instruction on how to populate a
> typed dataset via an associated stored procedure.
>
> Here is what I have done...
> Added a new typed data set via the "Add new item" menu.
> Dragged a stored procedure from my SQL database to the .xsd dataset

form.
>
> I want to execute the stored procedure to populate my dataset.
>
> I can do this by creating an external connection and command. The trick is

I
> want to use the API provided in my generated dataset class. I can see

that
> the stored procedure is referenced in the class but I am not sure how to
> proceed to populate the dataset.
>
> Thanks in advance,
> -jim
>
>
>



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Fill typed dataset with one stored procedure call =?Utf-8?B?R2VuZQ==?= Microsoft ADO .NET 3 17th Nov 2007 07:23 PM
Typed dataset with stored procedure Chris Microsoft ASP .NET 0 1st Mar 2007 06:04 PM
How to: Can you build a Typed DataSet for a stored procedure w/o using a DataAdapter? Eric Microsoft ADO .NET 4 16th Dec 2004 10:04 PM
Re: Typed DataSet and Stored Procedure Mythran Microsoft ADO .NET 0 25th Aug 2004 07:10 PM
Re: Typed DataSet and Stored Procedure David Browne Microsoft ADO .NET 0 25th Aug 2004 07:07 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:12 PM.