protected void grdCarsInfo_RowUpdating(object sender, GridViewUpdateEventArgs e) { string vehicalNum = ((Label)grdCarsInfo.Rows[e.RowIndex].FindControl("lblVNumberEdit")).Text; string manufacturer = ((TextBox)grdCarsInfo.Rows[e.RowIndex].FindControl("txtManufacturer")).Text; string make = ((TextBox)grdCarsInfo.Rows[e.RowIndex].FindControl("txtMake")).Text; int capacity = Convert.ToInt32(((TextBox)grdCarsInfo.Rows[e.RowIndex].FindControl("txtCapacity")).Text); string color = ((TextBox)grdCarsInfo.Rows[e.RowIndex].FindControl("txtColor")).Text; int userId = Convert.ToInt32(Session["userid"]); CarDetailsEntity cdetails = new CarDetailsEntity { VehicleNumber = vehicalNum, Manufacturer = manufacturer, Make = make, Capacity = capacity, Color = color, Owner = userId }; dalRegisteredCars.UpdateCarDetails(cdetails); grdCarsInfo.EditIndex = -1; FillGrdCarDetails(userId); }
/************************************************************************************* * Method Name : UpdateCarDetails * Return Value : void * Input Parameters : CarDetails * Description : This method is used to update registered car details for a owner *************************************************************************************/ public void UpdateCarDetails(CarDetailsEntity carInfo) { SqlCommand cmdUpdateCarDetails = new SqlCommand("usp_UpdateCarInfo", Con); cmdUpdateCarDetails.CommandType = CommandType.StoredProcedure; cmdUpdateCarDetails.Parameters.AddWithValue("@VehicleNumber", carInfo.VehicleNumber); cmdUpdateCarDetails.Parameters.AddWithValue("@Manufacturer", carInfo.Manufacturer); cmdUpdateCarDetails.Parameters.AddWithValue("@Make", carInfo.Make); cmdUpdateCarDetails.Parameters.AddWithValue("@Owner", carInfo.Owner); cmdUpdateCarDetails.Parameters.AddWithValue("@Color", carInfo.Color); cmdUpdateCarDetails.Parameters.AddWithValue("@Capacity", carInfo.Capacity); try { Con.Open(); cmdUpdateCarDetails.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } finally { Con.Close(); } }