0

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)
3
Contributors
4
Replies
5
Views
8 Years
Discussion Span
Last Post by babbu
0

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

0

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?!?

0

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!!!!!?

0

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

tht worked
thnx a ton

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.