I Am Not Getting Any Error But Value Is Not Updated In Gridview I Check With Debug Its Shows Only Old Value Not Show Update Value...

See more:

ASP.NET

Hi frds please help for me..
I am not getting any error but value is not updated in gridview i check with debug its shows only old value not show update value...

protected void GridView2_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
         
     
        GridViewRow row = (GridViewRow)GridView2.Rows[e.RowIndex];
        int BookingRefNo=int.Parse(GridView2.DataKeys[e.RowIndex].Value.ToString());
             
        string AssignedPriority = ((TextBox)row.Cells[11].Controls[0]).Text;
        string Status = ((TextBox)row.Cells[12].Controls[0]).Text;

        
        
        SqlConnection con1 = new SqlConnection(constr);
        SqlCommand cmd = new SqlCommand("Update TSafetyMaster set AssignedPriority=@AssignedPriority,Status=@Status where BookingRefNo=@BookingRefNo", con1);
        cmd.Parameters.Add("@BookingRefNo", SqlDbType.Int).Value = BookingRefNo;
        cmd.Parameters.Add("@AssignedPriority", SqlDbType.VarChar).Value = AssignedPriority;
        cmd.Parameters.Add("@Status", SqlDbType.NVarChar).Value = Status;
        con1.Open();
        cmd.ExecuteNonQuery();
        GridView2.EditIndex=-1;
        GridView2.DataBind();
        

        
    }