delete multiple row using checkbox in gridview ...i am using Entity Framework

Question

I have a requirement where I want to delete multiple row by placing check-box in each row I want to place only single button for deleting multiple row in a gridview....

I am using this code but it is not working ...

EmployeeModel.EmployeeEntities obj=new EmployeeModel.EmployeeEntities();
foreach(GridViewRow row in grdVw.Rows)
{
   if ((row.FindControl("chkBox1") as CheckBox).Checked)  
   {
     string id=grdVw.DataKeys[row.RowIndex].Value.ToString();
     int a=int.Parse(id);
     var result = from n in obj.Emps where n.Ecode == a select n;

     obj.DeleteObject(result.First());
   }
}
obj.SaveChanges();

Here is the code for declaring my GridView:

<asp:GridView ID="grdVw" runat="server" AutoGenerateColumns="false" ToolTip="Employee Details" DataKeyNames="Ecode"> 
    <Columns> 
        <asp:TemplateField HeaderText="select"> 
            <ItemTemplate> 
                <asp:CheckBox ID="chkBox1" runat="server" /> 
            </ItemTemplate> 
        </asp:TemplateField> 
        <asp:BoundField HeaderText="EmpCode" DataField="Ecode" /> 
        <asp:BoundField HeaderText="EmpName" DataField="Ename" /> 
        <asp:BoundField HeaderText="Address" DataField="Address" /> 
        <asp:BoundField HeaderText="City" DataField="city" /> 
        <asp:BoundField HeaderText="EmailId" DataField="Email" />
        <asp:BoundField HeaderText="DOB" DataField="DOB" /> 
        <asp:BoundField HeaderText="JoinDate" DataField="joinDate" /> 
        <asp:BoundField HeaderText="Salary" DataField="Salary" /> 
    </Columns> 
</asp:GridView>

acctually it not entering in if condition it is always going out of if.... — sanjeet
– sanjeet, Commented Aug 1, 2013 at 13:48
go to the on this link it will help you: stackoverflow.com/questions/1485570/… — anilprasad
– anilprasad, Commented Jan 2, 2014 at 10:29

Fals · Accepted Answer · 2013-08-01 13:46:08Z

2

You have to specify which cell contains the checkbox. Change the code for:

row.Cells[/*index of the cell*/].FindControl("chkBox1")

answered Aug 1, 2013 at 13:46

Fals

6,8394 gold badges26 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

sanjeet Over a year ago

it is first column so i m using [0] but it is not working fals

Fals Over a year ago

Could you post the ASPX pls? Theres something else wrong. My awnsear was one point, maybe we have more.

Karl Anderson · Accepted Answer · 2013-08-01 14:28:22Z

2

Your if ((row.FindControl("chkBox1") as CheckBox).Checked) condition is not true the first time though, because you are encountering the header row of your GridView in the first iteration of the loop through all of the rows in the grid, like this:

foreach(GridViewRow row in grdVw.Rows)

You need to check the row type, like this:

EmployeeModel.EmployeeEntities obj=new EmployeeModel.EmployeeEntities();
foreach(GridViewRow row in grdVw.Rows)
{
    if (row.RowType == DataControlRowType.DataRow)
    {
        if ((row.FindControl("chkBox1") as CheckBox).Checked)  
        {
            string id=grdVw.DataKeys[row.RowIndex].Value.ToString();
            int a=int.Parse(id);
            var result = from n in obj.Emps where n.Ecode == a select n;

            obj.DeleteObject(result.First());
        }
    }
}
obj.SaveChanges();

Note: Please read the MSDN documentation for GridViewRow.RowType Property for more information about the different types of rows in the GridView.

UPDATE:

Try binding your GridView only on non-postbacks (read: first time the page loads), like this:

protected void Page_Load(object sender, EventArgs e) 
{ 
    if (!Page.IsPostBack)
    {
        Blcommon obj = new Blcommon(); 
        grdVw.DataSource = obj.GetEmployee(); 
        grdVw.DataBind();
    } 
}

edited Aug 1, 2013 at 14:28

answered Aug 1, 2013 at 14:07

Karl Anderson

34.9k12 gold badges69 silver badges83 bronze badges

3 Comments

Karl Anderson Over a year ago

Okay, then that must mean your check box values are getting trashed before your if condition is being evaluated, where does the grdVw.DataSource and grdVw.DataBind logic happen relative to the code you have posted?

sanjeet Over a year ago

protected void Page_Load(object sender, EventArgs e) { Blcommon obj = new Blcommon(); grdVw.DataSource = obj.GetEmployee(); grdVw.DataBind(); }

Fals Over a year ago

@sanjeet put if(!IsPostback) before this databind... this is cleaning the selection.

Collectives™ on Stack Overflow

delete multiple row using checkbox in gridview ...i am using Entity Framework

2 Answers 2

2 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related