How to Update datagridview

Question

0.00/5 (No votes)

See more:

Gents,
Each time I edit the details in my database such as (delete, add) it works perfectly when I view the access database but does not update the data in my datagridview except I close the program and re-open it. Is there a way I can refresh the datagridview so that it updates itself automatically. I use microsoft access 2007 as my database.

Below is the code I have so far:

Private Sub btnDone_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDone.Click
      If InspDataGridView.SelectedRows.Count <> 0 And lblInsSheet2Edit.Text = "QuarryMech" Then
                Dim James As String
                James = MsgBox("Confirm this inspection has been completed", MsgBoxStyle.YesNo, "EwekoroII Inspections Tracker")
                If James = vbYes And lblWhoLogged.Text = lblInsSheet2Edit.Text Then
                    Dim agreement As OleDb.OleDbConnection
                    Dim dldb, myguy As String
                    
myguy = ("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\Methods Inspections.mdb")

                    agreement = New OleDb.OleDbConnection(myguy)
                    agreement.Open()

dldb = "UPDATE QuarryMech SET Status = '" & "Done" & "' WHERE Ins_Date = '" & lblReturnedDate.Text & "' AND Inspection = '" & lblReturnedInspection.Text & "'"

                    Dim halt = New OleDb.OleDbCommand

                    Try
                        halt = New OleDbCommand(dldb, agreement)
                        halt.ExecuteNonQuery()
                        InspDataGridView.RefreshEdit()

                        Catch ex As Exception
                        MsgBox(ex.Message, MsgBoxStyle.Critical, "Oledb Error")
                    End Try
                End If

Posted 25-Sep-13 4:35am

Damilare Onawoga

Updated 25-Sep-13 4:45am

Richard C Bishop

v2

Add a Solution

Comments

Richard C Bishop 25-Sep-13 10:46am

If you do not set the datasource, your datagridview will not refresh. Are you doing that at some point?

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)

Carlos Caride · Answer 1 · 2013-09-25T04:59:00

Hello,

The best way to update the datagridview is using DataSets. You can create a dataset with the wizard. The wizard create TableAdapters for each table of the database.

After that, you can update the datarid easier.

Example:

C#

MyDataSetTableAdapters.MyTableTableAdapter ta = new MyDataSetTableAdapters.MyTableTableAdapter();
ta.Fill(myDataSet.MyTable);

With this method you can obtain the last result from your database all times you need.

I do recommend that you take a interviewee to the documentation of microsoft ado.net concerning.

http://msdn.microsoft.com/en-us/library/e80y5yhx.aspx[^]