sqlcon = new SqlConnection(strCon);
string sqlstr = "update User set UserID='"
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[0].Controls[0])).Text.ToString().Trim() + "',Uname='"
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[1])).Text.ToString().Trim() + "',PassWord='"
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[2])).Text.ToString().Trim() + "' where UserID='"
+ GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
sqlcom = new SqlCommand(sqlstr, sqlcon);
sqlcon.Open();
sqlcom.ExecuteNonQuery();
sqlcon.Close();
GridView1.EditIndex = -1;
bind();
帮我看看啊!谢谢了!新手也不容易!!
string sqlstr = "update User set UserID='"
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[0].Controls[0])).Text.ToString().Trim() + "',Uname='"
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[1])).Text.ToString().Trim() + "',PassWord='"
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[2])).Text.ToString().Trim() + "' where UserID='"
+ GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
sqlcom = new SqlCommand(sqlstr, sqlcon);
sqlcon.Open();
sqlcom.ExecuteNonQuery();
sqlcon.Close();
GridView1.EditIndex = -1;
bind();
帮我看看啊!谢谢了!新手也不容易!!
GridView1.DataSource = ...;
GridView1.DataKeys = new string[]{"id"};
GridView1.DataBind();
是什么
sqlcon = new SqlConnection(strCon);
string sqlstr = "update User set UserID='"
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[0].Controls[0])).Text.ToString().Trim() + "',Uname='"
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[1])).Text.ToString().Trim() + "',PassWord='"
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[2])).Text.ToString().Trim() + "' where UserID='"
+ GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
sqlcom = new SqlCommand(sqlstr, sqlcon);
sqlcon.Open();
sqlcom.ExecuteNonQuery();
sqlcon.Close();
GridView1.EditIndex = -1;
bind();