DataGridView does not refresh after dataset update vb.net

Question

I have a vb.net form with a dataGridView

The dataGridView data source is the dgvTableAdapter with this sql statement

SELECT membres.ID, membres.refere_par, bands.titre, 
       membres_1.prenom & ' ' & membres_1.nom  AS reference_nom
FROM ((bands INNER JOIN membres ON bands.ID = membres.[band]) 
      INNER JOIN membres membres_1 ON membres.refere_par = membres_1.ID)

I delete membres from the membres Table like this

' Get member id 
Dim userId As Integer 
userId = DataGridView1.Item( 0,0).Value

' Delete the member
Me.MeoshowDataSet2.membres.FindByID(userId).Delete()
Me.MembresTableAdapter.Update(Me.MeoshowDataSet2)

' Refresh datagrid
dataGridView1.Refresh() ' does nothing

I know the delete statement works because I saw the changes in the database. If I close the form and reopen it, the dataGridView is up to date.

The membres table is an access table

I'm running the app in visual 2010 debug mode.

score 3 · Accepted Answer · answered Apr 13 '12 at 01:17

3

The usual way of doing this is to reset the DataSource of the DataGridView.

Try like this code (with correct code to provide the right table from the dataset):

dataGridView1.DataSource = typeof(List); 
dataGridView1.DataSource = dataset.Tables["your table"];

Calling .Refresh() doesn't work since it only forces a repaint, but the code that paints the grid doesn't know of the changes.

answered Apr 13 '12 at 01:17

David Hall

32,624
10
90
127

I did not use dataGridView1.DataSource = typeof(List); but reassigning the dataset did work. Thanks! – pec Apr 13 '12 at 01:21
I think you need to - that is the part that fixes the problem! Essentially you need to empty the datasource - you could set the datasource to null, but using typeof(List) will maintain the autogenerated columns. However, if it does work without that, great :) – David Hall Apr 13 '12 at 01:22
1

I used dataGridView1.Datasouce = Nothing – pec Apr 13 '12 at 01:24
Ah - yes, that is roughly the same (forgot that you were working in vb.net). – David Hall Apr 13 '12 at 01:25
Couldn't this also be solved with a BindingSource to notify the DGV of the changes in the DataTable? – Origin Apr 13 '12 at 01:27
@Origin I've seen the BindingSource work and not work - that is what I usually try first (and probably have a few answers on here suggesting that) and I'm honestly not 100% sure when it will or won't work. – David Hall Apr 13 '12 at 01:29
@Origin I seem to remember that part of the issue is that some source of data just don't tell anyone that they have changed (they don't raise the list changed event) so you are out of luck - EVEN when you know that the list has changed. One solution is to use the bindingsource and tell it to raise that event. Last encountered this with an Oracle TableAdapter, can't recall if others behave in the same annoying way. – David Hall Apr 13 '12 at 01:32
@Origin final comment - just browsed through you answers and saw the one where you advocate BindingList over table adapters. That is exactly what I do too, for reasons like this issue - I find using the BindingList very trouble free compared to table adapters. – David Hall Apr 13 '12 at 01:34

score 3 · Answer 2 · answered Feb 22 '13 at 17:29

I stumbled upon this while searching for exact same problem. Didn't find it online though. Here's what worked for me:

Public Sub RefreshData()
    dTable.Clear()
    dAdapter.Fill(dTable)
    dtaDataGrid.DataSource = dTable
End Sub

Private Sub btnRefresh_Click(sender As System.Object, e As System.EventArgs) Handles btnRefresh.Click
    RefreshData()

    ClearAllTextBox(Me)
End Sub

Cleared all the data in the data table first then refilled it with the data from the data adapter since you said that the database was updated with your code, only that it didn't refresh.

thanks, It worked for me too. Reseting datasource to nothing just scrambles my Datagrid because I have DataPropertyName set for each column. Your suggestion works perfect ! — LuckyLuke82, Dec 09 '16 at 18:00

score 1 · Answer 3 · edited Feb 04 '17 at 00:39

1

You can also use this:

DirectCast(dataGridView1.DataSource, DataTable).AcceptChanges()

Just replace dataGridView1. The 2nd parameter is the DataTable class.

edited Feb 04 '17 at 00:39

JCarlosR

1,598
3
19
32

answered Jan 16 '13 at 16:46

AlexVMM

126
4

score 0 · Answer 4 · edited Mar 04 '14 at 08:44

...and an alternative that worked for me:

'reset datasource

dgvBHL.DataSource = nothing

' Assign datatable to dgv this always works 1st time it is called

dgvBHL.DataSource = dtData 

'To fix the DGV not refreshing properly after the 1st time, switch the sort order

dgvBHL.Sort(dgvBHL.Columns(0), System.ComponentModel.ListSortDirection.Descending)

dgvBHL.Sort(dgvBHL.Columns(0), System.ComponentModel.ListSortDirection.Ascending)

'No need to do a refresh or anything else

score 0 · Answer 5 · answered Mar 02 '21 at 07:26

0

I just added this line:

    Me.EmpTableAdapter.Fill(Me.MyDbDataSet1.Emp)

answered Mar 02 '21 at 07:26

Sami Alkendi

77
8

DataGridView does not refresh after dataset update vb.net

5 Answers5

Linked