无法Updata数据??
public void MyDataGrid_Update(Object sender, DataGridCommandEventArgs e)
{
string txtname = ((TextBox)e.Item.Cells[2].Controls[0]).Text;
string txtpasswd = ((TextBox)e.Item.Cells[3].Controls[0]).Text;
string txtemail = ((TextBox)e.Item.Cells[4].Controls[0]).Text;
string txtpower = ((TextBox)e.Item.Cells[5].Controls[0]).Text;
string txtsex = ((TextBox)e.Item.Cells[6].Controls[0]).Text;
string txttel = ((TextBox)e.Item.Cells[7].Controls[0]).Text;
string txtfrom = ((TextBox)e.Item.Cells[8].Controls[0]).Text;
string txtshenghe = ((TextBox)e.Item.Cells[9].Controls[0]).Text;
SqlConnection connUpdate = new SqlConnection("server=192.168.0.1;uid=db_admin;pwd=admin;database=Jxdb");
connUpdate.Open();
String sql_edit = "UPDATE Reg " +
"SET name = '" + txtname.Replace("'","''")+ "'," +
"passwd = '" + txtpasswd.Replace("'","''")+ "'," +
"email = '" + txtemail.Replace("'","''")+ "'," +
"power = '" + txtpower.Replace("'","''")+ "'," +
"sex = '" + txtsex.Replace("'","''")+ "'," +
"tel = '" + txttel.Replace("'","''")+ "'," +
"frm = '" + txtfrom.Replace("'","''")+ "'," +
"shenghe = '" + txtshenghe.Replace("'","''")+ "'" +
" WHERE id = " + e.Item.Cells[1].Text;
SqlCommand sqlCommandUpdate = new SqlCommand(sql_edit,connUpdate);
sqlCommandUpdate.ExecuteNonQuery();
connUpdate.Close();
MyDataGrid.EditItemIndex = -1;
MyDataGrid.DataBind();
}
为什么无法Update数据?
估计是string txtname = ((TextBox)e.Item.Cells[2].Controls[0]).Text;
没有取到值。Controls[0]是什么意思呀?
帮忙~~