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();
    }