how to update database from datagridview bound by linq query and entity model?

Question

I bind a datagridview from a linq query, but I don't know how to make it updated to database when users makes changes on the datagridview.

var q = from w in dowacodbEntities.worksheets
                    where w.ContractForm_id.Equals(g_ContractID)
                    orderby w.id
                    select new
                               {
                                   w.id,
                                   w.UnitPrice,
                                   w.LabourCost
                               };
            BindingSource bindingSource = new BindingSource(); // use bindingsource
            bindingSource.DataSource = q.ToList(); // convert linq query to bindingsource
            dataGridView1.DataSource = bindingSource; // add bindingsource to datagridview

p/s : I'm using C# winform

you should probably call some save method or acceptchanges method on the bindingSource object. Please try and show some code and ask if still does not work :) — Davide Piras, Sep 23 '11 at 11:16

score 0 · Accepted Answer · edited May 23 '17 at 11:55

0

I think this is the same problem

WinForms DataGridView - update database

edited May 23 '17 at 11:55

Community

1
1

answered Sep 23 '11 at 11:16

huMpty duMpty

14,346
14
60
99

1

no it's not the same as he is working with bindingSource object – Davide Piras Sep 23 '11 at 11:17

how to update database from datagridview bound by linq query and entity model?

1 Answers1