Question

ASP.NET objectDatasource的问题

asp.net GrideView + ObjectDataSource
前台：
<asp:ObjectDataSource selectmethod="GetProduct" Type="Product" UpdateMethod="Update_Product" id="objectdatasource1"/>
Product.cs:

public class product
{

public static SqlDataReader GetProduct()
{
SqlConnection con = new SqlConnection(@"Server=local;Integrated Security=True;" + "Database=DB");
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "get_product";
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
return cmd.ExecuteReader(CommandBehavior.CloseConnection);
}

public void Update_Product(int ProductID,string Name,string Description,string Price)
{

SqlConnection con = new SqlConnection(@"Server=local;Integrated Security=True;" + "Database=DB");
string updateString = "UPDATE Product SET Name=@Name,Description=@Description,Price=@Price WHERE ProductID=@ProductID";
SqlCommand cmd = new SqlCommand(updateString, con);
cmd.Parameters.AddWithValue("@Name", Name);
cmd.Parameters.AddWithValue("@Description", Description);
cmd.Parameters.AddWithValue("@Price",Price);
cmd.Parameters.AddWithValue("@ProductID",ProductID);
con.Open();
cmd.ExecuteNonQuery();
con.Close();

}
}

更新数据的时候没办法输入数据，要是不该表数据直接点更新后，报错：objectDataSource1 未能找到带参数的非泛型方法
Update_Product:ProductID
什么原因？？

Answer 1

public void Update_Product(int ProductID,string Name,string Description,string Price)
{

SqlConnection con = new SqlConnection(@"Server=local;Integrated Security=True;" + "Database=DB");
string updateString = "UPDATE Product SET Name=@Name,Description=@Description,Price=@Price WHERE ProductID=@ProductID";
SqlCommand cmd = new SqlCommand(updateString, con);
cmd.Parameters.AddWithValue("@Name", Name);
cmd.Parameters.AddWithValue("@Description", Description);
cmd.Parameters.AddWithValue("@Price",Price);
cmd.Parameters.AddWithValue("@ProductID",ProductID);
con.Open();
cmd.ExecuteNonQuery();
con.Close();

}
}
里面的“@ProductID”数据库类型是否相同

Answer 2

数据库字段的问题，检查productID字段。是否存在。