Q: How to Create CheckBox inside GriedView and if the User is checked that record how to delete that record from GridView.
1; One gridView
2: One button checkAll/UncheckAll
3: One Button for Delete all the Checked CheckBox..
Lets see one by one how can we put checkbox inside GridView
SOURCE FILE:
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">
<Columns>
<asp:BoundField DataField="roll_no" HeaderText="Roll No" />
<asp:BoundField DataField="s_name" HeaderText="Student Name" />
<asp:BoundField DataField="class" HeaderText="Class" />
<asp:TemplateField>
<ItemTemplate>
<asp:CheckBox ID="ch1" Text='<%# Eval("roll_no") %>' runat="server" />
ItemTemplate>
asp:TemplateField>
Columns>
asp:GridView>
.CS FILE: In your .cs file in the class level write this line of code
ArrayList alist = new ArrayList();
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//Populate data and Bind in Gridview
}
}
//BTN UN-CHECK & Check all
protected void Button2_Click(object sender, EventArgs e)
{
//check all and un-checkAll
if (Button2.Text == "Check All")
{
for (int i = 0; i < GridView1.Rows.Count; i++)
{
CheckBox cbb = (CheckBox)GridView1.Rows[i].FindControl("ch1");
cbb.Checked = false;
}
Button2.Text = "Un-Check";
}
else if (Button2.Text == "Un-Check")
{
for (int i = 0; i < GridView1.Rows.Count; i++)
{
CheckBox check = (CheckBox)GridView1.Rows[i].FindControl("ch1");
check.Checked = true ;
}
Button2.Text = "Check All";
}
}
//delete btn..here Button1 is your delete button to delete all selected rows inside gridview in your web page
protected void Button1_Click(object sender, EventArgs e)
{
for (int i = 0; i < GridView1.Rows.Count; i++)
{
CheckBox cbb;
cbb = (CheckBox)GridView1.Rows[i].FindControl("ch1");
if (cbb.Checked == true)
{
alist.Add(i);
}
}
string str = "select * from student";
SqlDataAdapter da = new SqlDataAdapter(str,con);
DataSet ds = new DataSet();
da.Fill(ds);
for (int j = 0; j < alist.Count; j++)
{
int index = Convert.ToInt32(alist[j]);
string roll = ds.Tables[0].Rows[index][0].ToString();
string qry1 = "delete from student where roll_no='" + roll + "'";
SqlCommand com1 = new SqlCommand(qry1, con);
com1.ExecuteNonQuery();
}
Response.Redirect("default3.aspx"); // Note: re-direct SamePage..
}
susant