当我使用SqlDataSource's UpdateCommand时，函数或过程指定了太多参数

本文关键字：过程 函数 参数 太多 UpdateCommand SqlDataSource | 更新日期: 2023-09-27 18:10:11

我正在使用启用编辑和更新的gridview，并使用SqlDataSource中的UpdateCommand来更新数据。但是每当我尝试更新记录时，我都会得到异常

函数或过程指定了太多参数

代码:

using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
public partial class Manager_UnApprovedActivites : System.Web.UI.Page
{
   protected void Page_Load(object sender, EventArgs e)
   {
   }
   protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
   {
        string id = GridView1.DataKeys[e.RowIndex].Value.ToString();
        string Appproval =     ((CheckBox)GridView1.Rows[e.RowIndex].Cells[9].Controls[0]).Text;
        SqlDataSource1.UpdateParameters["id"].DefaultValue = id.ToString();
        SqlDataSource1.UpdateParameters["approval"].DefaultValue = Appproval.ToString();
        SqlDataSource1.Update();
    }
}
ASP.net: 

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="UnApprovedActivites.aspx.cs" Inherits="Manager_UnApprovedActivites" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
    <head runat="server">
       <title></title>
   </head>
   <body>
       <form id="form1" runat="server">
       <div>
       </div>
       <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
            DataKeyNames="AcitivityId" DataSourceID="SqlDataSource1" 
            Height="273px" Width="976px" AutoGenerateEditButton ="True">
          <Columns>
             <asp:BoundField DataField="AcitivityId" HeaderText="AcitivityId" InsertVisible="False" ReadOnly="True" SortExpression="AcitivityId" />
             <asp:BoundField DataField="ActiviityName" HeaderText="ActiviityName" SortExpression="ActiviityName" />
             <asp:BoundField DataField="ActivityLocation" HeaderText="ActivityLocation" SortExpression="ActivityLocation" />
             <asp:BoundField DataField="ActivityStartDate" HeaderText="ActivityStartDate" SortExpression="ActivityStartDate" />
             <asp:BoundField DataField="ActivityDueDate" HeaderText="ActivityDueDate" SortExpression="ActivityDueDate" />
             <asp:BoundField DataField="ActivityDescription" HeaderText="ActivityDescription" SortExpression="ActivityDescription" />
             <asp:BoundField DataField="ActvityTypeId" HeaderText="ActvityTypeId" SortExpression="ActvityTypeId" />
             <asp:BoundField DataField="BarchId" HeaderText="BarchId" SortExpression="BarchId" />
             <asp:CheckBoxField DataField="Approval(Authority)" HeaderText="Approval(Authority)" SortExpression="Approval(Authority)" />
             <asp:CheckBoxField DataField="ApprovalManager" HeaderText="ApprovalManager" SortExpression="ApprovalManager" />
             <asp:BoundField DataField="DateAdded" HeaderText="DateAdded" SortExpression="DateAdded" />
          </Columns>
       </asp:GridView>
       <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:WCA DatabaseConnectionString2 %>" 
            SelectCommand="SELECT * FROM [Activities]" 
            UpdateCommand="ApproveActivity" 
            UpdateCommandType="StoredProcedure">
            <UpdateParameters>
                   <asp:Parameter Name="id" Type="Int64" />
                   <asp:Parameter Name="approval" Type="Boolean" />
            </UpdateParameters>
        </asp:SqlDataSource>
     </form>
  </body>
</html>

当我使用SqlDataSource's UpdateCommand时，函数或过程指定了太多参数

下一行:

  string Appproval =     ((CheckBox)GridView1.Rows[e.RowIndex].Cells[9].Controls[0]).Text;

返回复选框文本而不是复选框值，而是使用

CheckBox chb= ((CheckBox)GridView1.Rows[e.RowIndex].Cells[9].Controls[0]);             
if (chb != null)
            {
                SqlDataSource1.UpdateParameters["approval"].DefaultValue =chb.Checked;
            }
相关文章：