Refresh DataGridView after data inserted in DB by another dialog

Question

On my Winforms app, I have a primary form with a DataGridView bound to a database Entity datasource.

The grid is set up not to allow inserts. Instead I have a button on my form that kicks of a second dialog where the insert takes place (ie. with friendlier ui than is possible with the DataGridView).

The insert is working fine.. query of the underlying table in db shows that the record has been inserted. However, I can't seem to get the DataGridView on the primary form to see the new data just created by the second dialog.

I have read many Stack Overflow q & a's and tried various solutions to get the DataGridView to refresh to show new data.. but nothing works.

This must be a common situation ?? Can someone suggest some VB.NET code that will work ?

Thanks,

Bazza

    Dim qry = From o In mDB.tblFOMTestResults From p In mDB.tblProduct.DefaultIfEmpty _
                                              From c In mDB.tblCalibration _
                Where o.ProductID = p.ID And o.CalibrationID = c.ID _
                Order By o.RunDate, p.ProductName Select _
                o.ID, o.SampleCode, o.RunDate, o.ConditioningDays, o.ConditioningRHAndTemp, _
                o.TestArea, o.EdgeSeal, o.SealedBags, o.FaceSeal, _
                o.MoisturePercentage, o.CalibrationID, o.FYFOMH1, o.FYFOMH2, o.FYFOMH3, _
                o.FYFOMH4, p.ProductName, o.ProductID

    Me.TblFOMTestResultsDataGridView.DataSource = qry

Thanks for reply Nudier. Have added binding code - please see above. — Bazza Formez, Jun 25 '12 at 22:20

score 1 · Answer 1 · answered Jun 17 '12 at 22:50

1

Try to bind to the results of the query rather than the query:

dataGridView.Source = query.Execute(MergeOption.AppendOnly);

answered Jun 17 '12 at 22:50

Jacob Seleznev

8,013
3
24
34

Hi, My query doesn't have an Execute method ?? (I am using .NET 4.0 if that helps?). Thanks for you reply Jacob. – Bazza Formez Jun 25 '12 at 22:18
[ObjectQuery.Execute Method](http://msdn.microsoft.com/en-us/library/system.data.objects.objectquery.execute). – Jacob Seleznev Jun 25 '12 at 22:39

score 0 · Accepted Answer · edited May 23 '17 at 12:04

0

After trying a number of things, I finally got this going by following the advice from the following SO answer.. Refresh DataGridView in Windows form

edited May 23 '17 at 12:04

Community

1
1

answered Jun 26 '12 at 00:35

Bazza Formez

179
5
16

Refresh DataGridView after data inserted in DB by another dialog

2 Answers2

Linked