Delete rows in Gridview

Discussion in 'C Programming' started by PetroTiburcio, Jun 3, 2013.

  1. PetroTiburcio


    May 17, 2013
    Likes Received:
    hi, I am having a problem with deleting gridview rows. I am populating my gridview by selecting value in a dropdownlist then by clicking the add button, value will be added in my gridview, here is my code:

    Code (Text):
    <asp:GridView ID="GridView1" runat="server"
                    CssClass="mGrid" EmptyDataText = "There are no records to display">
                        <asp:TemplateField ItemStyle-Width="10">
                    <asp:CheckBox ID="CheckBox1" runat="server"/>
    in my code behind:

    Code (Text):
    protected void Page_Load(object sender, EventArgs e)
          if (!IsPostBack)
                DataSet ds = new DataSet();
                DataTable dt = new DataTable();
                DataColumn dc = new DataColumn("Id");
                DataColumn dc1 = new DataColumn("Name");
                //DataColumn dc2 = new DataColumn("Id");
               // dt.Columns.Add(dc2);
                Session["data"] = ds;
    protected void btnSave_Click(object sender, EventArgs e)
            SqlConnection con = new SqlConnection("Data Source=GATE-PC\\SQLEXPRESS;Initial Catalog=dbProfile;Integrated Security=True");
            foreach (GridViewRow row in GridView1.Rows)
                SqlCommand cmdd = new SqlCommand("Insert into Profile (Id, profile_Id)VALUES(@id, @pid)", con);
                cmdd.CommandType = System.Data.CommandType.Text;
                cmdd.Parameters.AddWithValue("@id", row.Cells[1].Text);
                cmdd.Parameters.AddWithValue("@pid", txtbid.Text);
    protected void btnAdd_Click(object sender, EventArgs e)
            DataSet ds = (DataSet)Session["data"];
            DataRow dr = ds.Tables[0].NewRow();
            dr[0] = DropDownList1.Text.Trim();
            dr[1] = DropDownList1.SelectedItem;
            //dr[2] = txtId.Text.Trim();
            GridView1.DataSource = ds;
    Now, I am trying to remove checked rows on my gridview with this code:

    Code (Text):
    protected void btnRemove_Click(object sender, EventArgs e)
            ArrayList del = new ArrayList();
            foreach (GridViewRow row in GridView1.Rows)
                if (row.RowType == DataControlRowType.DataRow)
                    CheckBox chkDelete = (CheckBox)row.Cells[0].FindControl("CheckBox1");
                    if (chkDelete != null)
                        if (chkDelete.Checked)
                            string id = row.Cells[1].Text;
    With the btnRemove codes above, If I clicked it, it'll remove all values in my gridview even the unchecked rows, what I want is that just the checked rows not all. And are there any other simple way of removing rows in a gridview than using checkbox? I am using c# with Thanks in advance and God Bless.
    PetroTiburcio, Jun 3, 2013
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.