but what i want is when i change the data in the datagridview and click onto update button,changes i made should be saved in database so when i execute the application again i should be able to see the updated database in the datagridview. guide me to add data as well as to delete data too pls help me !! i have three buttons on the form else then the datagridview. sql A1 = New Sql Data Adapter("prc_select Staff", sqlcon) sql A1 = New Sql Data Adapter(sqlcom) sqlcom. Hi all, I am Rida, i have connected my access database to and program is capable to show the database in the datagridview. button1=update button2=add button3=delete Imports System Imports System. Data Grid View Public Class Form1 Dim row As Integer Dim col As Integer Dim current Time As System. Ole Db Command Builder(Ole Db Data Adapter1) Dim SQLString As String = "SELECT * FROM Table1" Dim Conn String As String = "Provider=Microsoft. OLEDB.12.0; Data Source=|Data Directory|\members.accdb; User ID=admin" Dim Ole DBConn1 As System.
Text = current Time End Sub Private Sub Button1_Click(By Val sender As System. Update(Data Set1, "table1") Dim item As New Data Grid View Row Data Grid View1. Create Cells(Data Grid View1) End Sub Private Sub Button2_Click(By Val sender As System.