• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 268
  • Last Modified:

How do I use my custom Stored Proc to insert into a Dataset

I am using Visual Studio 2008 and my project is in VB.
The trouble I have run into involves a particular child table that is used for attendance. I wish a new record to be inserted with a stored proc that also updates a parent table that uses a calculated field to update the number of lessons attended and lessons remaining.

My question is how do I get the TableAdapterManager, or the TableAdapter to use my stored procedure? It needs a primary key parameter that is displayed on the parent datagridview. The error message is:

 "Procedure or function 'hott_InsertRecordedLesson' expects parameter '@RegID', which was not supplied. "

How do I get this parameter into the Stored Proc that I wish the tableadapter to use?
1 Solution
You can specify the parameters for the stored proc while defining it,
wdarnellgAuthor Commented:
Thanks everyone, but I found the exact answer on msdn's HOW DO I video series:

I would like to close this question, but I will have others soon I am sure.

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now