对象数据源找不到在使用更新和删除时具有参数的非泛型方法

本文关键字：参数 泛型方法 删除 找不到 数据源 更新 对象 | 更新日期: 2023-09-27 18:32:46

嗨，我收到此错误：

"对象数据源'对象数据源 1' 找不到非泛型 具有参数的方法"UpdateEmployee"：originalEmployeeId， 原始名称， 原始性别， 原始城市， 员工 ID， 姓名， 性别， 城市。

当我按下更新按钮时。但是我的删除按钮没有问题。这是我的代码：
网络表单1.aspx

<form id="form1" runat="server">
<div>
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        DataSourceID="ObjectDataSource1" DataKeyNames="EmployeeId">
        <Columns>
            <asp:CommandField ShowEditButton="True" ShowDeleteButton="True" />
            <asp:BoundField DataField="EmployeeId" HeaderText="EmployeeId" 
                SortExpression="EmployeeId" />
            <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
            <asp:BoundField DataField="Gender" HeaderText="Gender" 
                SortExpression="Gender" />
            <asp:BoundField DataField="City" HeaderText="City" SortExpression="City" />
        </Columns>
    </asp:GridView>
    <br />
    <asp:ObjectDataSource ID="ObjectDataSource1" runat="server" 
        SelectMethod="GetAllEmployee2S" TypeName="EditingData.Employee2" 
        UpdateMethod="UpdateEmployee" DeleteMethod="DeleteEmployee" ConflictDetection="CompareAllValues" OldValuesParameterFormatString="original{0}">
        <DeleteParameters>
            <asp:Parameter Name="originalEmployeeId" Type="Int32" />
            <asp:Parameter Name="originalName" Type="String" />
            <asp:Parameter Name="originalGender" Type="String" />
            <asp:Parameter Name="originalCity" Type="String" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="originalEmployeeId" Type="Int32" />
            <asp:Parameter Name="originalName" Type="String" />
            <asp:Parameter Name="originalGender" Type="String" />
            <asp:Parameter Name="originalCity" Type="String" />
        </UpdateParameters>
    </asp:ObjectDataSource>
</div>
</form>

员工2.cs

public static List<Employee2> GetAllEmployee2S()
    {
        var dal = new Employee2Dal();
        return dal.GetAllEmployee2S();
    }
    public static void DeleteEmployee(int originalEmployeeId, string originalName, string originalGender, string originalCity)
    {
        var dal = new Employee2Dal();
        dal.DeleteEmployee(originalEmployeeId, originalName, originalGender, originalCity);
    }
    public static void UpdateEmployee(int originalEmployeeId, string originalName, string originalGender, string originalCity)
    {
        var dal = new Employee2Dal();
        dal.UpdateEmployee(originalEmployeeId, originalName, originalGender, originalCity);
    }

员工2达尔.cs

public void DeleteEmployee(int originalEmployeeId, string originalName, string originalGender, string originalCity)
    {
        var cs = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString;
        using (var con = new SqlConnection(cs))
        {
            const string deleteQuery = "Delete from Employee2 where EmployeeId=@OriginalEmployeeId and Name = @OriginalName and Gender = @OriginalGender and " +
                                       "City = @OriginalCity";
            var cmd = new SqlCommand(deleteQuery, con);
            cmd.Parameters.AddWithValue("@OriginalEmployeeId", originalEmployeeId);
            cmd.Parameters.AddWithValue("@OriginalName", originalName);
            cmd.Parameters.AddWithValue("@OriginalGender", originalGender);
            cmd.Parameters.AddWithValue("@OriginalCity", originalCity);
            con.Open();
            cmd.ExecuteNonQuery();
        }
    }
    public void UpdateEmployee(int employeeId, string name, string gender, string city)
    {
        var cs = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString;
        using (var con = new SqlConnection(cs))
        {
            const string updateQuery = "Update Employee2 set Name=@Name, Gender=@Gender, City=@City where EmployeeId=@EmployeeId";
            var cmd = new SqlCommand(updateQuery, con);
            cmd.Parameters.AddWithValue("@EmployeeId", employeeId);
            cmd.Parameters.AddWithValue("@Name", name);
            cmd.Parameters.AddWithValue("@Gender", gender);
            cmd.Parameters.AddWithValue("@City", city);
            con.Open();
            cmd.ExecuteNonQuery();
        }
    }

对象数据源找不到在使用更新和删除时具有参数的非泛型方法

您的代码可以正常工作，因为Delete方法不需要参数的当前值。因此，您只有旧值参数，这些参数的格式设置为orignial{0}'. But with更新method you have both old and current values. Old values are also formatted with原始{0}"前缀，但当前值使用未修改的 GridView 字段名称传递。所以你总共有 8 个参数：

originalEmployeeId, originalName, originalGender, originalCity
employeeId, name, gender, city

您可以简单地将缺少的参数添加到 UpdateEmployee 方法。但我认为你在这里不需要原始值。甚至更多 - 除了员工 ID 之外，您不需要任何 DeleteEmployee 方法的值。所以干脆不要使用原始值（请注意，ConflictDetection应该等于OverwriteChanges，以便关闭传递给Update方法的原始值）：

<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" 
    TypeName="EditingData.Employee2"
    SelectMethod="GetAllEmployee2S"  
    UpdateMethod="UpdateEmployee"
    DeleteMethod="DeleteEmployee" ConflictDetection="OverwriteChanges">       
</asp:ObjectDataSource>

并让 GridView 传递与字段名称对应的参数

public static void DeleteEmployee(int employeeId)
{
    var dal = new Employee2Dal();
    dal.DeleteEmployee(employeeId); // modify dal method
}
public static void UpdateEmployee(int employeeId, string name, string gender, string city)
{
    var dal = new Employee2Dal();
    dal.UpdateEmployee(employeeId, name, gender, city);
}
相关文章：