Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# ASP.NET Gridview
When I enter new data and press update button it saves the old data (data that I want it to update).
 
public void fill()
{
    SqlCommand cmd = new SqlCommand("select * from school ",con );
    con.Open();
    SqlDataReader rd = cmd.ExecuteReader();
 
    GridView1.DataSource = rd;
    GridView1.DataBind();
    con.Close();
}
 
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
    fill();
}
 
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
 
    int id = int.Parse(((TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[0]).Text);
    string  stu =((TextBox)GridView1.Rows[e.RowIndex].Cells[2].Controls[0]).Text;
    int age = int.Parse(((TextBox)GridView1.Rows[e.RowIndex].Cells[3].Controls[0]).Text);
 
    SqlCommand cmd = new SqlCommand("UPDATE school SET  stu_name=@stu_name,age=@age where id=@id ", con);
    cmd.Parameters.Add(new SqlParameter("@id", id));
    cmd.Parameters.Add(new SqlParameter("@stu_name", stu));
    cmd.Parameters.Add(new SqlParameter ("@age",age));
 
    con.Open();
    cmd.ExecuteNonQuery();
    con.Close();
 
    GridView1.EditIndex = -1;
    fill();
}
 
he problem that the values that assigned to name,age are the existing values in the database not the new values which I entered in the runtime any one can help me?? thanks in advance
Posted 1-Feb-13 6:05am

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

I have corrected your code. I could have helped you im more detail if you have pointed out the line number where the error occurs.

You are missing
 
cmd.CommandType = CommandType.Text;
in your third code block
 
Refer this link
http://stackoverflow.com/questions/8389803/insert-data-into-database-in-c-sharp[^]
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 239
1 Sarvesh Kumar Gupta 185
2 George Jonsson 154
3 ArunRajendra 144
4 Richard MacCutchan 140


Advertise | Privacy | Mobile
Web03 | 2.8.140709.1 | Last Updated 1 Feb 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid