I am busy learn from SAMS teach yourlsef c# in 24 hours and been struggling for the pass few hours on this Database lesson. My Code is as follows.
class Level Vairables
Code: Select all
OleDbConnection m_cnADONetconnection = new OleDbConnection();
OleDbDataAdapter m_daDataAdapter = new OleDbDataAdapter();
DataTable m_dtContacts = new DataTable();
int m_rowPosition = 0;
Code: Select all
m_cnADONetconnection.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\JosamRepairs.accdb;Persist Security Info=False";
m_cnADONetconnection.Open();
m_daDataAdapter = new OleDbDataAdapter ("SELECT * FROM Repairs ",m_cnADONetconnection);
OleDbCommandBuilder m_cbCommandBuilder = new OleDbCommandBuilder(m_daDataAdapter);
m_daDataAdapter.Fill(m_dtContacts);
Code: Select all
DataRow drNewRow = m_dtContacts.NewRow();
drNewRow["Client"] = cboClient.Text;
drNewRow["Date"] = dateTimePicker1.Text;
drNewRow["Serial"] = txtSerial.Text;
drNewRow["Fault"] = txtWorkDone.Text;
m_dtContacts.Rows.Add(drNewRow);
m_daDataAdapter.Update(m_dtContacts);
m_rowPosition = m_dtContacts.Rows.Count - 1;
With error message, (Syntax error in INSERT INTO statement)m_daDataAdapter.Update(m_dtContacts);
Can anyone see a fault here as i cant.