Gridview的更新

protected void Page_Load(object sender, EventArgs e)     {         if (IsPostBack == false)//页面第依次显示时，执行数据绑定             databind();     }       protected void databind()     {         SqlConnection sqlcon = new SqlConnection("Data Source=KEN;Initial Catalog=aspnettest;Persist Security Info=True;User ID=hyslove;Password=hyslove");         SqlCommand sqlcom = new SqlCommand("select * from UserTable", sqlcon);         sqlcon.Open();         SqlDataAdapter da = new SqlDataAdapter(sqlcom);         DataSet ds = new DataSet();         da.Fill(ds, "UserTable");         GridView1.DataSource = ds.Tables["UserTable"].DefaultView;         GridView1.DataBind();         sqlcon.Close();     }     protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)     {     }     protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)     {         GridView1.EditIndex = e.NewEditIndex;         databind();     }     protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)     {         try         {             string username = GridView1.DataKeys[GridView1.EditIndex][0].ToString(); //这个是根据前面的Datekeynames设置而得到的。             //如果多个键值，那么用GridView1.DataKeys[GridView1.EditIndex].Value三[0];             string passwordnew = ((TextBox)(GridView1.Rows[GridView1.EditIndex].Cells[3].Controls[0])).Text.ToString().Trim();                        string sql = "update UserTable set Password='"+passwordnew+                 "' where Username='" + username + "'";             SqlConnection sqlcon = new SqlConnection("Data Source=KEN;Initial Catalog=aspnettest;Persist Security Info=True;User ID=hyslove;Password=hyslove");             SqlCommand sqlcom = new SqlCommand(sql, sqlcon);             sqlcon.Open();             sqlcom.ExecuteNonQuery();             sqlcon.Close();             GridView1.EditIndex = -1;//返回正常状态             databind();         }         catch (Exception ex)         {             Response.Write(ex.Message);         }     }     protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)     {         GridView1.EditIndex = -1;         databind();     }