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 frmDeleteEvents : System.Web.UI.Page { SqlConnection sqlConn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["RSIC"].ConnectionString); SqlCommand cmd = null; SqlDataAdapter sda = null; protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { FillEventGrid(); } } protected void btnDeleteEvents_Click(object sender, EventArgs e) { try { sqlConn.Open(); int i = 1; foreach (GridViewRow str in gvDeleteGrid.Rows) { CheckBox check = (CheckBox)str.FindControl("chk"); if (check.Checked == true) { Label lblSrno = (Label)str.FindControl("Label1"); cmd = new SqlCommand(); cmd.CommandText = " Delete AddEventCalender Where Srno='" + lblSrno.Text + "'"; cmd.CommandType = CommandType.Text; cmd.Connection = sqlConn; cmd.ExecuteNonQuery(); i += 1; } } if (i == 1) { Response.Write(""); sqlConn.Close(); } else { sqlConn.Close(); Response.Write(""); FillEventGrid(); } } catch (Exception ex) { Response.Write(""); } finally { sqlConn.Close(); } } void FillEventGrid() { sda = new SqlDataAdapter(" Select Srno,EventHeader,EventDate from AddEventCalender ", sqlConn); DataSet ds = new DataSet(); sda.Fill(ds); if (ds.Tables[0].Rows.Count > 0) { gvDeleteGrid.DataSource = ds.Tables[0]; gvDeleteGrid.DataBind(); pnlDeleteEvents.Visible = true; } else { Response.Write(""); gvDeleteGrid.DataSource = null; gvDeleteGrid.DataBind(); pnlDeleteEvents.Visible = false; } } }