using System; using System.Collections.Generic; using System.Data; using System.Data.SqlClient; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; public partial class fromModifyEvents : System.Web.UI.Page { SqlConnection sqlConn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["RSIC"].ConnectionString); SqlDataAdapter sda = null; DataSet ds = null; SqlCommand cmd = null; protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { FillViewEventDetails(); } } protected void gvViewEvents_RowDeleting(object sender, GridViewDeleteEventArgs e) { pnlModifyevents.Visible = true; Label lbl =(Label) gvViewEvents.Rows[e.RowIndex].FindControl("Label1"); string srno = Convert.ToString(lbl.Text); Session["SrnoUp"] = srno; string EventHeader = Convert.ToString(gvViewEvents.Rows[e.RowIndex].Cells[2].Text); string EventDate = Convert.ToString(gvViewEvents.Rows[e.RowIndex].Cells[3].Text); string EventsDetails = Convert.ToString(gvViewEvents.Rows[e.RowIndex].Cells[4].Text); txtAddEvent.Text = EventHeader; txtEventDate.Value = EventDate; txtEventDetails.Text = EventsDetails; } void FillViewEventDetails() { sqlConn.Open(); sda = new SqlDataAdapter("Select Srno, EventHeader,EventDate,EventDetails From AddEventCalender ", sqlConn); ds = new DataSet(); sda.Fill(ds); if (ds.Tables[0].Rows.Count > 0) { pnlModifyevents.Visible = false; pnlViewEvents.Visible = true; gvViewEvents.DataSource = ds.Tables[0]; gvViewEvents.DataBind(); } else { Response.Write(""); pnlModifyevents.Visible = false; pnlViewEvents.Visible = false; gvViewEvents.DataSource = null; gvViewEvents.DataBind(); } } protected void btnEnterDetails_Click(object sender, EventArgs e) { sqlConn.Open(); cmd = new SqlCommand(); int intSrno = Convert.ToInt32(Session["SrnoUp"]); cmd.CommandText = "Update AddEventCalender Set EventHeader ='" + txtAddEvent.Text + "',EventDate ='" + txtEventDate.Value + "',EventDetails='" + txtEventDetails.Text + "' Where SrNo = " + intSrno + " "; cmd.CommandType = CommandType.Text; cmd.Connection = sqlConn; int j= cmd.ExecuteNonQuery(); if (j != 0) { Response.Write(""); pnlModifyevents.Visible = false; sqlConn.Close(); FillViewEventDetails(); } else { Response.Write(""); } } }