我想在后台添加一个参数到InsertCommand里 要怎么做啊啊啊急死了<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$
ConnectionStrings:GeDaiSystem %>"
SelectCommand="SELECT a.ID, a.Name, a.Agent, a.DelegationAmount, a.NewBalance, a.DelegationUnit, a.CaseStatus, a.CaseType, a.AdjustmentCity FROM GeDai a INNER JOIN Legal_services b ON a.P_ID = b.ID"
InsertCommand=""
UpdateCommand="UPDATE GeDai SET Name = @Name, Agent = @Agent, DelegationAmount = @DelegationAmount, NewBalance = @NewBalance, DelegationUnit = @DelegationUnit, CaseStatus = @CaseStatus, CaseType = @CaseType, AdjustmentCity = @AdjustmentCity WHERE (ID=@ID)"
DeleteCommand="DELETE FROM GeDai WHERE (ID=@ID) ">
<InsertParameters>
<asp:Parameter Name="legalstatus" />
<asp:Parameter Name="Name" />
<asp:Parameter Name="Address" />
<asp:Parameter Name="TEl" />
<asp:Parameter Name="Note" />
<asp:Parameter Name="FinalTime" />
<asp:Parameter Name="Agent" />
<asp:Parameter Name="ArchiveTime" />
<asp:Parameter Name="ArchiveManage" />
<asp:Parameter Name="ArchiveNo" />
<asp:Parameter Name="DelegationAmount" />
<asp:Parameter Name="NewBalance" />
<asp:Parameter Name="DelegationUnit" />
<asp:Parameter Name="CaseStatus" />
<asp:Parameter Name="CaseType" />
<asp:FormParameter FormField="P_ID" Name="P_ID" />
<asp:Parameter Name="AdjustmentCity" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="Name" />
<asp:Parameter Name="Agent" />
<asp:Parameter Name="DelegationAmount" />
<asp:Parameter Name="NewBalance" />
<asp:Parameter Name="DelegationUnit" />
<asp:Parameter Name="CaseStatus" />
<asp:Parameter Name="CaseType" />
<asp:Parameter Name="AdjustmentCity" />
<asp:Parameter Name="id" />
</UpdateParameters>
<DeleteParameters>
<asp:Parameter Name="id" />
</DeleteParameters>
</asp:SqlDataSource>
ConnectionStrings:GeDaiSystem %>"
SelectCommand="SELECT a.ID, a.Name, a.Agent, a.DelegationAmount, a.NewBalance, a.DelegationUnit, a.CaseStatus, a.CaseType, a.AdjustmentCity FROM GeDai a INNER JOIN Legal_services b ON a.P_ID = b.ID"
InsertCommand=""
UpdateCommand="UPDATE GeDai SET Name = @Name, Agent = @Agent, DelegationAmount = @DelegationAmount, NewBalance = @NewBalance, DelegationUnit = @DelegationUnit, CaseStatus = @CaseStatus, CaseType = @CaseType, AdjustmentCity = @AdjustmentCity WHERE (ID=@ID)"
DeleteCommand="DELETE FROM GeDai WHERE (ID=@ID) ">
<InsertParameters>
<asp:Parameter Name="legalstatus" />
<asp:Parameter Name="Name" />
<asp:Parameter Name="Address" />
<asp:Parameter Name="TEl" />
<asp:Parameter Name="Note" />
<asp:Parameter Name="FinalTime" />
<asp:Parameter Name="Agent" />
<asp:Parameter Name="ArchiveTime" />
<asp:Parameter Name="ArchiveManage" />
<asp:Parameter Name="ArchiveNo" />
<asp:Parameter Name="DelegationAmount" />
<asp:Parameter Name="NewBalance" />
<asp:Parameter Name="DelegationUnit" />
<asp:Parameter Name="CaseStatus" />
<asp:Parameter Name="CaseType" />
<asp:FormParameter FormField="P_ID" Name="P_ID" />
<asp:Parameter Name="AdjustmentCity" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="Name" />
<asp:Parameter Name="Agent" />
<asp:Parameter Name="DelegationAmount" />
<asp:Parameter Name="NewBalance" />
<asp:Parameter Name="DelegationUnit" />
<asp:Parameter Name="CaseStatus" />
<asp:Parameter Name="CaseType" />
<asp:Parameter Name="AdjustmentCity" />
<asp:Parameter Name="id" />
</UpdateParameters>
<DeleteParameters>
<asp:Parameter Name="id" />
</DeleteParameters>
</asp:SqlDataSource>
解决方案 »
- asp.net textbox判断只能是小数或者是整数
- 100分:使用OracleCommand执行Update命令为何无效?
- linq问题
- Server.Transfer方法在页面间传值
- 哪种控件效果和LABEL一样,而且又能在JAVASCRIPT中获取该控件????
- “ManagementException: 访问遭到拒绝”的问题
- DATALIST REPEATCOLUMNS
- 为什么我的asp.net(C#)项目在调试时对JS脚本程序所作的修改不能即时更新,调试用的代码仍是原来的代码
- Jquery 怎么给时间 加一个小时???
- 如何弹出一个新的页面?
- 水晶报表的问题
- 如何用VC++改变checkbox控件的外形
InsertCommand后面点不出来Parameters 这是什么事件里面的呢?
InsertCommand后面点不出来Parameters 这是什么事件里面的呢?