TableAdapter Question 1

[PsychoCoder]

I am working on creating a new DataSet (.xsd) for my web application. Ive created the DataTable, when I went to create the TableAdapter (using the TableAdapter Configuration Wizard) I select my ConnectionString, then choose "Use Stored Procedures" then it takes me to the screen to select my insert, update and delete procedures.

I select my Delete procedure then on the right side of the popup it asks you to select your columns for the parameters (I assume this is selecting fields from the DataTable Ive created) but there are no fields in the dropdown list. How do I get the fields from my datatable into this so I can finish the TableAdapter?

Anyone have any ideas?

Senior Qik III, ASP.Net, VB.Net ,SQL Programmer

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
** Do NOT feed Code Gremlins after midnight **
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

 

[PsychoCoder]

thank you, just wanted to make sure I was on the right track, another star for you

Senior Qik III, ASP.Net, VB.Net ,SQL Programmer

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

"In the new millennium there will be two kinds of business; those on the net and those out of business"

~ Bill Gates ~

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

 

[jbenson001]

No problem.. glad to help..
Thanks for the second star.. but I think you can only give me on.. lOL

 

[PsychoCoder]

jbenson001,

Well it came time to test what I had and at first it worked great, just what I wanted it to do, but when I went to show it to my team member I got an error stating that the Record Locator wasnt supplied, but I hard code it like this for testing:

Dim recloc As String
recloc = "741672"
mine.RecLoc = recloc

The weird thing is it worked like 6 times then I get this error (I even closed out the window and reloaded it)

Senior Qik III, ASP.Net, VB.Net ,SQL Programmer

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

"In the new millennium there will be two kinds of business; those on the net and those out of business"

~ Bill Gates ~

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~