How to delete a row in gridview using Entity Framework 4.0

Question

1.00/5 (1 vote)

See more:

How to delete a row in gridview using entity framework 4.0. The row is not deleting and this is my code:

C#

protected void DeleteRecord(object sender, GridViewDeleteEventArgs e)
{
    tbl_emp objempdelete = new tbl_emp();

    //int empId = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value);
    foreach (GridViewRow row in GridView1.Rows)
    {
        int empId = Convert.ToInt32(GridView1.DataKeys[row.RowIndex].Value);

        var deleteQuery = from objsel in objLMS.tbl_emp
                                          where (objsel.empid == empId)
                                          select objsel;
        objLMS.DeleteObject(deleteQuery);
        objLMS.SaveChanges();

    }
    BindData();
}

Thanks for your attention!

Posted 18-Oct-11 20:53pm

jayanthik

Updated 18-Oct-11 23:05pm

Manfred Rudolf Bihy

v6

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kerr · Answer 1 · 2011-10-18T21:25:00

Solution 1

We'll need more information than you have provided.

If you need to delete a row in the entity framework data model, it's like this:

C#

MyModel model = ;// your model.
model.DeleteOject(myEntity); // the entity you want to delete
model.SaveChanges(); // commit the changes

Now when you say grid view, are you talking about the grid view mode of a list view? If so, you should be binding the ItemsSource to an observable collection of your entities. Then you can remove an entity from the observable collection and the grid will automatically be updated.

Posted 18-Oct-11 21:25pm

Dave Kerr

Comments

jayanthik 19-Oct-11 4:36am

see this

protected void DeleteRecord(object sender, GridViewDeleteEventArgs e)
{
tbl_emp objempdelete = new tbl_emp();

//int empId = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value);
foreach (GridViewRow row in GridView1.Rows)
{
int empId = Convert.ToInt32(GridView1.DataKeys[row.RowIndex].Value);

var deleteQuery = from objsel in objLMS.tbl_emp
where (objsel.empid == empId)
select objsel;
objLMS.DeleteObject(deleteQuery);
objLMS.SaveChanges();

}
BindData();
}