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;
}
}
}