62,041
社区成员
发帖
与我相关
我的任务
分享
protected void update_Click(object sender, EventArgs e)
{
//access不支持多语句的;Select * from Categories;select * from Orders在SqlServer中支持
/*for (int i = 0; i < GridView1.Rows.Count; i++)
{
GridViewRow row = GridView1.Rows[i];
string empID = ((TextBox)row.Cells[0].FindControl("txtID")).Text.Replace("'", "");
string empRealName = ((TextBox)row.Cells[0].FindControl("txtRealName")).Text.Replace("'", "");
string empSex = ((DropDownList)row.Cells[0].FindControl("ddlSex")).SelectedValue;
string empAddress = ((TextBox)row.Cells[0].FindControl("txtAddress")).Text.Replace("'", "");
query.Append("update Employee set EmpID='" + empID + "',EmpRealName='" + empRealName + "',EmpSex='" + empSex + "',EmpAddress='" + empAddress + "' where ID=" + GridView1.DataKeys[i].Value + "");
query.Append(";");
}
Common.ExecuteSql(query.ToString());
bind();*/
for (int i = 0; i < GridView1.Rows.Count; i++)
{
StringBuilder query = new StringBuilder();
GridViewRow row = GridView1.Rows[i];
string empID = ((TextBox)row.Cells[0].FindControl("txtID")).Text.Replace("'", "");
string empRealName = ((TextBox)row.Cells[0].FindControl("txtRealName")).Text.Replace("'", "");
string empSex = ((DropDownList)row.Cells[0].FindControl("ddlSex")).SelectedValue;
string empAddress = ((TextBox)row.Cells[0].FindControl("txtAddress")).Text.Replace("'", "");
query.Append("update Employee set EmpID='" + empID + "',EmpRealName='" + empRealName + "',EmpSex='" + empSex + "',EmpAddress='" + empAddress + "' where ID=" + GridView1.DataKeys[i].Value + "");
Common.ExecuteSql(query.ToString());
}
bind();
}