Update data in DataTable

[Tengkorak]

How to make the data in the DataTable automatically change when there is the Insert, Update or Delete.

my code like this:

Imports System.Data
Imports System.Data.OleDb
 
Public Class frmSupplier
 
    Dim dt As New DataTable
 
 
    Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Me.WindowState = FormWindowState.Maximized
    End Sub
 
    Sub setData()
        Try
 
            Dim sql As String = "select vendor_id,vendor_name,address,phone from inv_t_vendors order by vendor_id"
            dt = ggDB.SelectRecordToDT(dbConn, sql)
 
            dg.DataSource = dt
 
        Catch ex As Exception
            ERRDesc(ex)
        End Try
 
 
    End Sub
 
    Private Sub cmdRefresh_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdRefresh.Click
        setData()
    End Sub
 
    Private Sub tFilter_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles tFilter.TextChanged
        ' filter data
    End Sub
 
 
    Function AddData()
        'load form entry
        ' refresh data 
    End Function
 
    Sub ModifyData()
        'load form entry
        ' refresh data 
    End Sub
 
    Sub DELETEData()
        ' delete data
        ' refresh data
    End Sub
End Class

I want the data in a DataTable is changed according to the data on the actual database.

whether I should call my method setData() at AddData, ModifyData & DeleteData for getting the data at this time.


thank you

[jmcilhinney]

If you're talking about your DataTable being updated when you update the database then you shouldn;t have to. You're supposed to update the DataTable first and then save the changes from there to the database, not the other way around.

If you're talking about your DataTable being updated when some other client updates the database then, generally speaking you can't. If you want data from the database then you have to ask for it. It's not going to send it to you uninvited.