How do I call a stored procedure from my database to run in my form that already has a table adpater on it?

I have VS2005.
I have a form that was created through the datasource wizard, dropping the proper objects onto my form. The form is now  connected to my database through the table adapter, bindingsource, and bindingnavigator that it created. This all works fine. Is there a way to use this table adapter to call a stored procedure from my database? I can't seem to get it to work. I really don't want to have to code all the objects on the form if I don't have to, to save time. I'm hoping there is way to use the existing table adpater.
The code I'm trying to use is

dim Com as new SqlClient.SqlCommand
Com.CommandType =  CommandType.StoredProcedure
Com.CommandText = "StoredProcedure"

Who is Participating?
vb_jonasConnect With a Mentor Commented:
Dim Com as new SqlClient.SqlCommand
Com.Connection = TableAdapter1.Connection ' from the designer object
Com.CommandType =  CommandType.StoredProcedure
Com.CommandText = "StoredProcedure"


grouchyfdAuthor Commented:
Excellent!!! I have this now working. The points are yours, vb jonas. This updates the table properly. Now I'm trying to get the textboxes on my form to show the changes when the procedure is fired. I can't seem to get it.

Dim Received as integer
Received = Textbox1.Text
Received = Com.ExecuteScalar
Textbox1.Text = Rec
Great! :-)

and you have filled your dataset again, TableAdapter1.fill(DataSet1)?
grouchyfdAuthor Commented:
Thank you for helping me through a "Duh" type moment on the tableadapter.fill method.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.