Typed dataset via stored procedure.

  • Thread starter Thread starter Jim Boyd
  • Start date Start date
J

Jim Boyd

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
 
Assuming your DataAdapter and DataSet were generated properly, it works just
like any other data adapter. Something like:

myDataAdapter.Fill(myDataSet);
 
Back
Top