Updating database using datagridview in vb net

However, I'm trying to get the Data Grid View to update the Access database file with any changes that are made to it but after countless attempts at trying to fix my code or looking for an alternative solution, I am stumped. Can anyone see anything wrong or something I've missed out that would cause the code not to function as desired? It disappears like it was deleted or something erased it. I close the app and restart and I am back to the original 3 rows. But unable to handle which event will fire at this mode. Thanks in advance I have a datagridview containing both normal textbox columns and combobox columns.Microsoft is conducting an online survey to understand your opinion of the Msdn Web site.MY OBSERVATION I'm designing a program where i can update and create user login details to a Database.Also i have a login form which checks the user login database before granting access.What i would obtain is a "SQL Server Management Studio-style".

It populates the Data Grid View as it is intended to so that part of the program works. Ole Db Public Class frm Database Dim con As New Ole Db Connection Dim ds As New Data Set Dim dt As New Data Table Dim da As New Ole Db Data Adapter Private Sub frm Database_Load(sender As Object, e As Event Args) Handles My Base. Update(ds, "trial1") Msg Box("Records Updated= " & i) Catch ex As Exception Msg Box(ex. "Dynamic SQL generation for the Update Command is not supported against a Selec Command that does not return any key column information" thanks for your efficient, straightforward solution to updating user input to a datagridview in VB. NET and had spent several hours trying to find code for what I had thought should be a simple procedure - I was ready to give up; thanks again - Hi, im new for OLEDB.4.0; Data Source=D:\OFC\aadata\wms1.mdb") it showing error, A first chance exception of type 'System. Data Member = "trial1" End Sub Private Sub Button1_Click(By Val sender As System. Odbc Command Builder(adp) Dim i As Integer Try i = adp. Odbc Command("Select * from trial1", cn) adp = New Odbc. Message) End Try End Sub End Class Hello, thanks for the code. im am using same code, but only connection string is changed, Dim cn As New Odbc.