How can I refresh DataGridView?

Question

I'm trying to refresh datagridview after adding multiple records which were added programmatically, using bindingsource and datasource. My code:

Private Async Function RefreshData() As Task

    Await Task.Delay(15000)

    bs.EndEdit()
    daProducts.Update(dtProducts)

    DataGridView1.DataSource = Nothing
    DataGridView1.DataSource = bs 'Insert your DataSource here
    bs.ResetBindings(False)
    ...

When I call this function on form load event, it can't display any records.

Another thing is I get error if I don't use async function (because of setting DefaultCellStyle.Alignment).

My formload event: http://sudrap.org/paste/text/554747/

but you're calling it in `Form_Load`... so if you don't call RefreshData dataGridView1 is not empty? — stefankmitph, Apr 18 '15 at 10:16
no it's not empty if I don't call the function. thanks for helping. — nikel, Apr 18 '15 at 11:40

score 2 · Answer 1 · answered Apr 18 '15 at 10:00

2

This might be helpful for you:

Private Sub updatedgv()
        Dim conn As New MySqlConnection(My.Settings.myConn)
        Dim da As New MySqlDataAdapter
        Dim ds As New DataSet
        Dim str1 As String = "select * from tableName"
        da.SelectCommand = New MySqlCommand(str1, conn)
        da.Fill(ds)
        conn.Close()
        ProductDataGridView.DataSource = ds.Tables(0)
End Sub

the explanation can be found in the link http://www.codeproject.com/Questions/372731/how-to-refresh-datagridview-in-vb-net

answered Apr 18 '15 at 10:00

user_4685802

155
9

1

it seems it works. I need some time to try it. thank you for your answer. – nikel Apr 18 '15 at 10:16
@nikel if you have tested the code mark it as answer. – user_4685802 Apr 18 '15 at 10:19
clicking a header doesn't sort after using your code. why is this happening? – nikel Apr 18 '15 at 11:35
1

I think if you add yourdatagrdview.Refresh() it will work as well. – user_4685802 Apr 18 '15 at 12:21
you welcome, it is a long time i am away from VB, and if it worked plz mark it as answer. – user_4685802 Apr 18 '15 at 13:28
it doesn't work :( they say refresh command only repaints the datagridview. http://stackoverflow.com/questions/10133946/datagridview-does-not-refresh-after-dataset-update-vb-net – nikel Apr 18 '15 at 14:15
1

sorry to hear that :( , have no idea why it is like that for you because i think the code that you use has nothing to do with this sorting issue. – user_4685802 Apr 18 '15 at 14:27

How can I refresh DataGridView?

1 Answers1