GridView2_RowUpdating更新数据

[习惯就好111]

protected void GridView2_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string id = GridView2.DataKeys[e.RowIndex].Value.ToString();
string strhead = ((TextBox)GridView2.Rows[e.RowIndex].Cells[1].Controls[0]).Text;



string settings = Convert.ToString(ConfigurationManager.ConnectionStrings["yonghuConnectionString"]);
SqlConnection myconn = new SqlConnection(settings);
myconn.Open();
SqlCommand cmd = new SqlCommand("update student set name='" + strhead + "' where id=" + id, myconn);
cmd.ExecuteNonQuery();

GridView2.EditIndex = -1;
GridView2.DataSource = Band("student");
GridView2.DataBind();

}
还有几个字段要更新，应该怎么做？（age，sex，beizhu，ssbjh）

[koukoujiayi]

string id = GridView2.DataKeys[e.RowIndex].Value.ToString();
string strhead = ((TextBox)GridView2.Rows[e.RowIndex].Cells[1].Controls[0]).Text;
string age = ((TextBox)GridView2.Rows[e.RowIndex].Cells[2].Controls[0]).Text;
string sex = ((TextBox)GridView2.Rows[e.RowIndex].Cells[3].Controls[0]).Text;
.........
........
SqlCommand cmd = new SqlCommand("update student set name='" + strhead + "',age='"+age+"',sex='"+sex+"' where id=" + id, myconn);
........

[only_lonely]

wa哇。好多英文字母呀！

[namhyuk]

看到在RowUpdating事件处理代码里手动更新数据库的动作，我实在是为asp.net 2.0里新增的数据源控件感到不值:-)