Delete Multiple Rows From Gridview

[bhagyap]

Hi..

I am populating my GridView as follows:

protected void Button1_Click(object sender, EventArgs e)
{
  string con = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
  SqlDataAdapter sda = new SqlDataAdapter("Select * from DropDownFilter", con);
  sda.Fill(dt);
  GridView1.DataSource = dt;
  GridView1.DataBind();
}

And then I have CheckBox for every row. Now I want to delete the checked rows on another button event. How can I achieve this??

Can anyone please help me??

[Ammu]

button_click
{
  foreach (GridViewRow gvr in GridView1.Rows)
  {
    CheckBox chk = (CheckBox)gvr.FindControl("CheckBox1");
    if (chk.Checked==true)
    {
      //delete command         
    }
  }
}