Typed Data Set with Stored Procedures with Non Mapping Columns

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

Hi There
I have a typed data set linked with pre-created SQL SP. I have gone through the VB.Net Wizard and populated the READ, INSERT, UPDATE and DELETE commands with Table Adpators. However, getting the Error msg "Some Parameter Bindings are missing..." My DELETE SP has some extra parametes which are not mapped to the Source Data table as I am taking some other actions based on those parameters. If I Blank-out the DELETE action from the Table Adaptr, I don't get the msg but, then I can't use the DELETE action.

How can I pass extra parameters to the Table Adapter which are not part of the Source Table.

Pls help....

Posted 3-Apr-10 0:24am

Fahim A

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

mhwasim · Answer 1 · 2011-05-16T23:48:00

Solution 1

1. You can use the default value set in sp definition...but in this case it will be fixed and nothing should be passed to those variables to use the default values...

2. You can modify the XML and add the parameter by your self to pass your desire value...

Thanks

Posted 16-May-11 23:48pm

mhwasim

Typed Data Set with Stored Procedures with Non Mapping Columns

1 solution

Solution 1

Add your solution here

Preview 0

Typed Data Set with Stored Procedures with Non Mapping Columns

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us