我用的.net做的管理系统,在用gridview的自带编辑和删除中,更新时出现至少一个参数没有被指定

怎么回事啊,急
2025-03-22 18:55:49
推荐回答(1个)
回答1:

没有指定更新的列参数?贴段代码给你参考一下
.cs:
protected void gvBooks_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string cnnstr = ConfigurationManager.ConnectionStrings["cnnstr"].ConnectionString;
SqlConnection cnn = new SqlConnection(cnnstr);
GridViewRow row = gvBooks.Rows[e.RowIndex];
string isbn = gvBooks.DataKeys[e.RowIndex].Values[0].ToString();
string s1 = ((TextBox)row.FindControl("BookName")).Text.ToString();
string sql = "Update Book Set BookName=‘" + s1 + "‘ Where ISBN=" + isbn + "";
SqlCommand myCommand = new SqlCommand(sql, cnn);
gvBooks.EditIndex = -1;
}

aspx:
AutoGenerateColumns="False"
onrowupdating="gvBooks_RowUpdating" >











没贴完,把关键代码贴出来了,看得懂吧