protected void UpdateClick(object sender, EventArgs e) { try { GridViewRow row = (sender as LinkButton).NamingContainer as GridViewRow; OracleConnection conn = new OracleConnection("Data Source =XE; User ID = system; Password= Wright2015"); OracleCommand cmd; lblmsgforupdateadmin.Visible = false; conn.Open(); DataTable checkdt = new DataTable(); TextBox tc = (TextBox)row.Cells[0].FindControl("TextBox1"); TextBox tc1 = (TextBox)row.FindControl("TextBox2"); TextBox tc2 = (TextBox)row.FindControl("TextBox3"); Gridviewadminfroupdate.EditIndex = -1; OracleDataAdapter oadp = new OracleDataAdapter("SELECT count(*) FROM PARKING_DETAILS,PARKS where PARKING_DETAILS.PARKID= '" + dt.Rows[row.RowIndex]["PARKID"].ToString() + "' AND PARKING_DETAILS.PARKID = PARKS.PARKID AND PARKS.PARKDATE>= TRUNC(CURRENT_DATE)", conn); oadp.Fill(checkdt); if (Convert.ToInt32(checkdt.Rows[0]["count(*)"].ToString()) > 0) { lblmsgforupdateadmin.Text = " Details for this ParkID for current day cannot be upated as some user have registered for this Parking space "; lblmsgforupdateadmin.Visible = true; Gridviewadminfroupdate.DataSource = dt; Gridviewadminfroupdate.DataBind(); } else { dt.Rows[row.RowIndex]["PArkarea"] = tc.Text; dt.Rows[row.RowIndex]["PARKZIPCODE"] = tc1.Text; dt.Rows[row.RowIndex]["PARKLOTNO"] = tc2.Text; String commandtext = "UPDATE PARKING_DETAILS SET PARKAREA = '" + tc.Text + "',PARKZIPCODE='" + tc1.Text + "',PARKLOTNO='" + tc2.Text + "' WHERE PARKID = '" + dt.Rows[row.RowIndex]["PARKID"].ToString() + "'"; cmd = new OracleCommand(commandtext, conn); cmd.ExecuteNonQuery(); Gridviewadminfroupdate.DataSource = dt; Gridviewadminfroupdate.DataBind(); cmd.Dispose(); } conn.Close(); } catch (Exception ex) { } }
protected void btnupdateadmin_Click(object sender, EventArgs e) { try { Pnlforadminupdate.Visible = true; Pnlforadmin.Visible = false; Pnladmintosearchuserdetails.Visible = false; pnlfordeleteadmin.Visible = false; dt.Clear(); OracleConnection conn = new OracleConnection("Data Source =XE; User ID = system; Password= Wright2015"); conn.Open(); OracleDataAdapter Odataadapter = new OracleDataAdapter("SELECT * FROM PARKING_DETAILS", conn); Pnlforadmin.Visible = false; Odataadapter.Fill(dt); Gridviewadminfroupdate.DataSource = dt; Gridviewadminfroupdate.DataBind(); conn.Close(); } catch (Exception ex) { Response.Write("Error in btnupdateadmin_click" + ex.Message); } }
protected void On_Rowediting(object sender, GridViewEditEventArgs e) { Gridviewadminfroupdate.EditIndex = e.NewEditIndex; Gridviewadminfroupdate.DataSource = dt; Gridviewadminfroupdate.DataBind(); }
protected void CancelClick(object sender, EventArgs e) { Gridviewadminfroupdate.EditIndex = -1; Gridviewadminfroupdate.DataSource = dt; Gridviewadminfroupdate.DataBind(); }