VB 2008
MS Access 2007 for Database
I have a table in Ms access . And datagridview table to put data in ms access. When i put data in the datagridview table.it do not save in the table.Please guide my about my code.Please give me guide line for vb and ms access not for c# or other data base.
Public Class Form1 Private Sub EmpDataBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles EmpDataBindingNavigatorSaveItem.Click Me.Validate() Me.EmpDataBindingSource.EndEdit() Me.TableAdapterManager.UpdateAll(Me.EmplTableDataSet) End Sub Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'TODO: This line of code loads data into the 'EmplTableDataSet.EmpData' table. You can move, or remove it, as needed. Me.EmpDataTableAdapter.Fill(Me.EmplTableDataSet.EmpData) EmpDataBindingNavigator.Hide() End Sub Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click EmpDataBindingNavigatorSaveItem.PerformClick() End Sub Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click BindingNavigatorDeleteItem.PerformClick() End Sub End Class
Abhay ShankerPosted Jun 14, 2014, 2:15 PM
Check below link to bind Datagridview
http://www.dreamincode.net/forums/topic/148532-using-datagridview-with-access/
http://www.setha.info/ict-vb2008/35-ict-vb2008-0006.html
you can also check below link which can be helpful to you
http://www.codeproject.com/Articles/26801/Insert-Update-Delete-Search-Values-in-MS-Access
http://www.codeproject.com/Questions/529337/ConnectplusMSplusAccessplusDatabaseplus-mdb-pluswi
http://support.microsoft.com/kb/821765
http://www.homeandlearn.co.uk/NET/nets12p1.html