acees 2007 vb 2005
error: "Syntax error in insert into statement"
m_ColourCount = m_ColourCount + 1
Dim drNewRow As DataRow = m_ColourDataTable.NewRow()
drNewRow("CID") = m_ColourCount
drNewRow("ID") = m_CustomerCount
drNewRow("Colour Name") = txtColourName.Text.Trim
m_ColourDataTable.Rows.Add(drNewRow)
m_ColourDataAdapter.Update(m_ColourDataTable)