Datagridview VB.net Update

See more:

VB

Hi Guys,

I dont want to use databinding / (I have solved it with databinding but its not what im looking for)


How do I save changes in cell on Datagridview to my database?

Here is my code to load the data to the Datagridview "MASTERGRID".

Imports System.Data.OleDb
Imports System.ComponentModel
Imports System.Console


Public Class MASTER
    Dim con1 As New OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=C:\MyTools\POS\Data\master.mdb")

  Dim sqlsearch As String
            sqlsearch = "SELECT * FROM TBLMaster where status = 'Active'"


            Dim adapter As New OleDbDataAdapter(sqlsearch, con1)

            Dim dt As New DataTable("TBLMASTER")
            adapter.Fill(dt)
            MASTERGRID.DataSource = dt

'I want the data to save to my Table when I am finished edit cell'.

Private Sub MASTERGRID_Cellendedit(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles MASTERGRID.CellEndEdit


end sub