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)

Recommended Answers

All 4 Replies

Have you tried taking renamed "Colour Name" to something like "ColourName"? It might not like the space.

How do I post a question!?!
I am being hi-jacked with this message-computer is infected(is not for a fact)
download this tool to keep secure.I did not download anything-I have enough protection.But it won't let me navigate some of my favourite sites.I don't know what to do.Can anyone help me?!?

I am being hi-jacked with a message that says my computer is infected(it is not)This false message says I have to download some tool to fix it.It won't let me navigate my favourite websites. Can someone please HELP ME!!!!!?

Have you tried taking renamed "Colour Name" to something like "ColourName"? It might not like the space.

tht worked
thnx a ton

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.