Asp.net(C#)写的GridView更新代码

By bboncn

Asp.net(C#)写的GridView更新代码

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            try
            {
                string userid = GridView1.DataKeys[e.RowIndex].Value.ToString();//获取主键
                GridViewRow myrow = GridView1.Rows[e.RowIndex];
                string name = ((TextBox)myrow.Cells[1].Controls[0]).Text;//获取选中行单元格数据
                string pwd = ((TextBox)myrow.Cells[2].Controls[0]).Text;

                string sql = ”update dc4_user_def set username=’” + name + ”‘,password=’” + pwd + ”‘where userid=’” + userid + ”‘”;
                DBHelper.ExcuteQuery(sql);

                GridView1.EditIndex = -1;
                this.BindGridView();                
            }
            catch (Exception ex)
            {
                Response.Write(ex.Message);
            }
        }

Leave a Reply