具有非映射列的存储过程的类型化数据集 [英] Typed Data Set with Stored Procedures with Non Mapping Columns

问题描述

那里
我有一个与预先创建的SQL SP链接的类型化数据集.我已经通过了VB.Net向导，并使用表修饰符填充了READ，INSERT，UPDATE和DELETE命令.但是，收到错误消息缺少某些参数绑定..."，我在DELETE SP中有一些额外的参数，这些参数未映射到源数据"表，因为我正在基于这些参数采取其他措施.如果我从表适配器中删除了DELETE操作，则无法获取消息，但是无法使用DELETE操作.

如何将不属于源表一部分的其他参数传递给表适配器.

请帮助....

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....

推荐答案

1.您可以使用sp定义中设置的默认值...但是在这种情况下，它将是固定的，不应将任何内容传递给这些变量以使用默认值...

2.您可以自行修改XML并添加参数以传递所需的值...

谢谢

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

这篇关于具有非映射列的存储过程的类型化数据集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！