oledbexception was unhandled....syntax error in insert into statement is the error I get I can edit/update information, delete and everything except for add
the cmdSave code is::::
Dim drNewRow As DataRow = m_dtTable1.NewRow()
With Me
drNewRow("id") = .txtid.Text
drNewRow("Date") = .txtdate.Text
drNewRow("Time") = .txttime.Text
drNewRow("CallSign") = .txtcallsign.Text
drNewRow("Freq") = .txtfreq.Text
drNewRow("Mode") = .txtmode.Text
drNewRow("RST") = .txtrst.Text
drNewRow("Notes") = .txtnotes.Text
drNewRow("QslTX") = .txtqsltx.Text
drNewRow("QslRX") = .txtqslrx.Text
End With
m_dtTable1.Rows.Add(drNewRow)
m_daTable1.Update(m_dtTable1) <<<<-----ERROR HERE
m_intRowPosition = m_dtTable1.Rows.Count - 1
m_blnNewRecord = False
m_blnUpdateRecord = False
ShowCurrentRecord()
----------------------------------------------------------------
declarations:::
Public m_cnTable1 As New OleDb.OleDbConnection
Public m_daTable1 As OleDb.OleDbDataAdapter
Public m_cbTable1 As OleDb.OleDbCommandBuilder
Public m_dtTable1 As New DataTable
Public m_intRowPosition As Integer = 0
Public m_blnNewRecord As Boolean = False
Public m_blnUpdateRecord As Boolean = False
----------------------------------------------------------------
I can post full code if need be but I figured going through that much might be enough