how to refresh my datagridview after I add new data

Question

I m having a lot of trouble finding ways to refresh my datagridview   I ve tried datagridview refresh    datagridview Update      but it doesn t work     here s my code  Imports System Data Imports System Data OleDb Imports System Data Odbc Imports System Data DataTable Public Class Form1  Dim provider As String Dim dataFile As String Dim connString As String Dim addstring As String Dim cnn As OleDbConnection   New OleDbConnection Dim ds As DataSet   New DataSet Dim da As OleDbDataAdapter Dim tables As DataTableCollection   ds Tables Dim cmd As New OleDb OleDbCommand Dim dr As System Data OleDb OleDbDataReader   Private Sub Form1 Load sender As Object  e As EventArgs  Handles MyBase Load      t date Text   Today     provider    Provider Microsoft Jet OLEDB 4 0  Data Source       dataFile    C  Users hp-2 Documents Visual Studio 2012 Projects Delta Delta mdb       connString   provider  amp  dataFile     cnn ConnectionString   connString     da   New OleDbDataAdapter  Select Customer Name  Job  Amount from  Transaction  where Trans date   Date     cnn      da Fill ds   Transaction        Dim view1 As New DataView tables 0       Dim source1 As New BindingSource       source1 DataSource   view1     showdata DataSource   view1     showdata Refresh       cnn Close   End Sub   I ve tried this one but it doesn t work too   Private Sub showdat       If Not cnn State   ConnectionState Open Then         cnn Open       End If     showdata Refresh       cnn Close   End Sub        Private Sub btmclose Click sender As Object  e As EventArgs  Handles btmclose Click     Me Close   End Sub  Private Sub C job SelectedIndexChanged sender As Object  e As EventArgs  Handles C job SelectedIndexChanged     Dim selected As String   C job SelectedItem ToString       If selected    Internet  Then         t amount Text    20          php Visible   True     ElseIf selected    Games  Then         t amount Text    10          php Visible   True     ElseIf selected    Print  short   Then         t amount Text    1          php Visible   True     ElseIf selected    Print  long   Then         t amount Text    2          php Visible   True     ElseIf t amount Text      Then         php Visible   False     End If End Sub   here is my ADD button    after i ve click it   the data is successfully added but the datagridview doesn t refresh     Private Sub btnadd Click sender As Object  e As EventArgs  Handles btnadd Click      provider    Provider Microsoft Jet OLEDB 4 0 Data Source       dataFile    C  Users hp-2 Documents Visual Studio 2012 Projects Delta Delta mdb       connString   provider  amp  dataFile     cnn ConnectionString   connString     cnn Open        cmd Connection   cnn      cmd CommandText    insert into  Transaction   Customer Name  Job  Trans date  Amount      amp              values      amp  C name Text  amp         amp  C job Text  amp         amp  t date Text  amp         amp  t amount Text  amp           cmd ExecuteNonQuery        showdat        cnn Close   End Sub  End Class

User · Answer

I think the problem is that you re adding a new entry to the database  but not the data structure that the datagrid represents   You re only querying the database for data in the load event  so if the database changes after that you re not going to know about it   To solve the problem you need to either re-query the database after each insert  or add the item to tables 0  data structure in addition to the Access table after each insert

User · Answer

You can use a binding source to bind to with your datagridview  Set your class or list of data  Set a bindingsource datasource equal to that  Set the datasource of your datagridview to your bindingsource

User · Answer

wish this will help Create Function           private sub loaddata           datagridview Datasource nothing         datagridview refresh         dim str as string    select   from database        using cmd As New OleDb OleDbCommand str cnn          using da As new OleDbDataAdapter cmd            using newtable as new datatable             da fill  newtable              datagridview datasource newtable           end using        end using      end using end sub

User · Answer

This reloads the datagridview   Me ABCListTableAdapter Fill Me ABCLISTDATASET ABCList    Hope this helps

User · Answer

reload the form  Form1 Load sender  e

User · Answer

I found this code to work if you re trying to refresh a bound datagridview with updated data from a dataset  Obviously  this was after I sent the update to the database    clear out the datasource for the Grid view Me DataGridView1 DataSource   Nothing  refill the table adapter from the dataset table  Me viewABCTableAdapter Fill Me yourDataSet viewABC   reset the datasource from the binding source Me DataGridView1 DataSource   Me viewABCBindingSource  should redraw with the new data Me DataGridView1 Refresh

User · Answer

If you using formview or something similar you can databind the gridview on the iteminserted event of the formview too  Like below  protected void FormView1 ItemInserted object sender  FormViewInsertedEventArgs e                GridView1 DataBind            You can do this on the data source iteminserted too

User · Answer

this tablenameTableAdapter Fill this databasenameDataSet tablename

User · Answer

In the code of the button that saves the changes to the database eg the update button  add the following lines of code   MyDataGridView DataSource   MyTableBindingSource  MyDataGridView Update    MyDataGridView RefreshEdit

[vb.net] how to refresh my datagridview after I add new data

Examples related to vb.net

Examples related to ms-access