It seems that do an update from the datagrid back to the datbase I need the .DataBind method for the DataGird. This option does not appear in my VB.Net 2003??? The closest I have is .DataBindings but it appears not to be the same function?
Any help would be greatly appreciated. I am trying to add a DataSet to an existing DataGrid and DataSet, and then update the database. Shown below is what I have but does not alter the database in any way.
connectionstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & ProjectFolder & "\" & ProjectName & "\points.mdb"
Dim dfins As New DataSet
Dim confin As OleDb.OleDbConnection = New OleDb.OleDbConnection(connectionstr)
Dim dafin As New OleDb.OleDbDataAdapter("select * from CoordList", confin)
MainDataGrid.DataSource = ds1.Tables(0)
Dim cm As OleDb.OleDbCommandBuilder = New OleDb.OleDbCommandBuilder(dafin)