upadating record in gridview

PankaJ D

16y2.2k.NET

I am trying to update record in grid view using following commmand.But it does not Update the record.

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex];
Label lbl = (Label)row.FindControl("label8");
TextBox txtq = (TextBox)row.FindControl("TextBox7");

GridView1.EditIndex = -1;
cn.Open();

string sql = "UPDATE Q_Master SET Que = '" + txtq.Text + " ' WHERE Q_id='" + lbl.Text + "' ";
SqlCommand cmd = new SqlCommand(sql, cn);

cmd.ExecuteNonQuery();
cn.Close();
LoadBind();
}

LoadBind()
{
string sql = "SELECT * FROM Q_Master";

SqlCommand cmd = new SqlCommand(sql, cn);
SqlDataAdapter da = new SqlDataAdapter(cmd);

da.Fill(ds, "Q_Master");
GridView1.DataSource = ds;
GridView1.DataBind();
}

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

PankaJ D16y ago
To Krishna Garad Sir.....
solved....thanx
0
Krishna Garad16y ago
Check the values of field are comming new or not if the old values are comming in the fields then the probleme is of postback it's the normal cause. For this just bind your gridview under
if(!IsPostBack)
{
// Bind your gris here. This is the general cause values not get change becoz of firstly
//the page_load event will fire befire any event thats why it is taking old values.
}
0
PankaJ D16y ago
Same problem occur
0
Krishna Garad16y ago
Try like this
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
TextBox txtq= (TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox7");
Lable lbl=(Lable)GridView1.Rows[e.RowIndex].FindControl("Lable8");
cn.Open();

string sql = "UPDATE Q_Master SET Que = '" + txtq.Text + " ' WHERE Q_id='" + lbl.Text + "' ";
SqlCommand cmd = new SqlCommand(sql, cn);

cmd.ExecuteNonQuery();
cn.Close();
Gridview1.EditIndex=-1;
LoadBind();
}

LoadBind()
{
string sql = "SELECT * FROM Q_Master";

SqlCommand cmd = new SqlCommand(sql, cn);
SqlDataAdapter da = new SqlDataAdapter(cmd);

da.Fill(ds, "Q_Master");
GridView1.DataSource = ds;
GridView1.DataBind();
}
0