Мне нужно обновить мою базу данных Access после того, как я внесу изменения в свой DataGridView
под названием DataGridView_Manage_Calculations
, а затем щелкну Button
под названием Button_Update
.
Вот код, который у меня есть до сих пор:
Dim dtManage As New DataTable
Dim ManageAdapter As OleDbDataAdapter
Dim Bsource As New BindingSource
Public Sub Show_Panel_Manage_Calculations()
Panel_Manage_Calculations.Show()
ManageAdapter = New OleDbDataAdapter("Select Calculation, [Interval], Formula From " & tblName & "", con)
dtManage.Clear()
ManageAdapter.Fill(dtManage)
Bsource.DataSource = dtManage
DataGridView_Manage_Calculations.DataSource = Bsource
End Sub
Private Sub Button_Update_Click(sender As Object, e As EventArgs) Handles Button_Update.Click
Dim ObjComander As New OleDbCommandBuilder(ManageAdapter)
ManageAdapter.Update(dtManage)
End Sub
Я получаю эту ошибку: Syntax error in INSERT INTO statement.
Что я делаю не так?
Дополнительная информация
Public Sub createTable_Criteria()
Dim cmd As New OleDb.OleDbCommand("CREATE TABLE " & tblName & "(" & "Calculation Text(10) NOT NULL," & "[Interval] Text NOT NULL," & "Formula Text," & "Tier_Juncture_1 Integer," & "Tier_Juncture_2 Integer," & "Tier_Juncture_3 Integer," & "Weight Integer, CONSTRAINT pk_Calculation PRIMARY KEY (Calculation, [Interval]));", con)
cmd.ExecuteNonQuery()
End Sub
Additional information: Object reference not set to an instance of an object.
в этой строке кодаDebug.WriteLine(ManageAdapter.InsertCommand.CommandText)
- person gromit1   schedule 11.10.2013