How to update data in Entity Framework?

Question

I have to update data in the data base. Data is shown in text boxes wen i select a data grid-view row. where am i wrong??

private void btnUpdate_Click(object sender, EventArgs e)
{
    ent = new EmployeeEntities();

        EmployeeInfo emp = new EmployeeInfo();
        emp.EmpID = Convert.ToInt32(txtID.Text);
        emp.EmpName = txtName.Text;
        emp.EmpAddress = txtAddress.Text;
        emp.EmpDesignation = txtDesignation.Text;
        //ent.EmployeeInfoes.Add(emp);
        ent.SaveChanges();
        MessageBox.Show("Updated");

}

Please don't post same question again and again stackoverflow.com/questions/22192045/updating-data-in-gridview — pravprab
– pravprab, Commented Mar 5, 2014 at 9:10

elolos · Accepted Answer · 2014-03-05 09:10:13Z

2

The entity/ies you wish to save have to be attached to a data context in order to be saved upon calling SaveChanges. If calling ent.SaveChanges() calls the context's SaveChanges() then you only have to use ent.EmployeeInfoes.Add(emp);. If not, you need to retrieve the EmployeeEntities from the database first and then add the EmployInfo.

answered Mar 5, 2014 at 9:10

elolos

4,4703 gold badges30 silver badges40 bronze badges

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

Comments

Cris · Accepted Answer · 2014-03-05 09:04:23Z

1

replace

EmployeeInfo emp = new EmployeeInfo();

by

int empId=Convert.ToInt32(txtID.Text);
EmployeeInfo emp =ent.EmployeeInfoes.Single(e=>e.EmpId==empId);

answered Mar 5, 2014 at 9:04

Cris

13.4k5 gold badges37 silver badges51 bronze badges

Comments

Ali Baghdadi · Accepted Answer · 2014-03-05 09:07:48Z

0

if you are trying to add emp as a new emplouee, try

ent.EmployeeInfoes.AddObject(emp);
ent.SaveChanges();

else you must get emp from the list of employees then save it

edited Mar 5, 2014 at 9:07

answered Mar 5, 2014 at 9:01

Ali Baghdadi

6581 gold badge5 silver badges17 bronze badges

Collectives™ on Stack Overflow

How to update data in Entity Framework?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related