protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
clsDBaccess dbobj = new clsDBaccess();
try
{
int rowupdate = e.RowIndex;
String txtCarNo = (String)GridView1.Rows[rowupdate].Cells[1].Text;
//TextBox txtCarCat = (TextBox)GridView1.Rows[rowupdate].Cells[2].Controls[0];
/* TextBox txtCarName = (TextBox)GridView1.Rows[rowupdate].Cells[3].Controls[0];
*
* TextBox txtCarType = (TextBox)GridView1.Rows[rowupdate].Cells[4].Controls[0];
* TextBox txtFuelType = (TextBox)GridView1.Rows[rowupdate].Cells[5].Controls[0];
* TextBox txtDescription = (TextBox)GridView1.Rows[rowupdate].Cells[6].Controls[0];
* TextBox txtHrlyRate = (TextBox)GridView1.Rows[rowupdate].Cells[7].Controls[0];
* TextBox txtMinHrs = (TextBox)GridView1.Rows[rowupdate].Cells[8].Controls[0];*/
TextBox txtbooked = (TextBox)GridView1.Rows[rowupdate].Cells[9].Controls[0];
// String password = (String)GridView1.Rows[rowupdate].Cells[5].Text;
String query = "update tblcar set Booked='" + txtbooked.Text + "' where CarNo='" + txtCarNo + "'";
dbobj.InsertUpdateDelete(query);
//remove the edit mode
GridView1.EditIndex = -1;
populateGridview();
}
catch (Exception err)
{
lblmsg.Text = err.Message;
}
}