Wednesday, March 21, 2012

parameter binding

I decided to try and rebuild a new SqlDataAdapter(having issues with the first one), and click use existing sql stored procedures . I select them from the drop-down list(s) and click next it, it then pops up w/the following warning:

Some parameter bindings are missing. Values from the dataset will not be used for those parameters.

Why is it saying this -- I've checked all my stored procedures in query analyzer and they work fine.

Paste the code please ?
There is no code to it -- it was in the Configure Sqldataadapter Window.

I don't know if this will help you but check out this link:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbconparametersindataadaptercommands.asp


It is probably late in the game to help the OneWiseHobbit but maybe this will help others.

I had the same problem. What happened is, I had changed some column names in one of the tables in the datset but I failed to make changes in either the insert, select or update procedures. That caused the binding problem. I fixed the stored procedures and it works again. I hope that this helps someone.

0 comments:

Post a Comment