Incorrect syntax near ')' Error

Question

Hi. I have the following code:

m_conSqlConnection.ConnectionString = "Data Source=...;Uid=...;Pwd=...;Initial catalog=...;"
m_conSqlConnection.Open()
m_cmdSqlCommand = New SqlCommand("insert into Building(internalCodeBuilding, inUseNotBuilding) values('dsa','ds'))", m_conSqlConnection)
m_drDataReader = m_cmdSqlCommand.ExecuteReader

All I am trying to do is to insert a record into a Sql database using Visual Studio for Applications (from InfoPath) using C#. I have tried to do this in several ways, but every time I get this error:
Incorrect syntax near ')'
I have no ideea why. Can somebody help me please? Thank you so much!
P.S. I am new with C#.

qq qq · Answer

Thank you my friend. There was one extra bracket. Even thou I saw it i was sure that it has to be there. I guess that there was no one to tell me that i should not be there. LOL. Thank you!

Ranjitha C N · Answer

Hi friend Try this code May be you have missed some brackets. m_conSqlConnection.ConnectionString = Data Source=...;Uid=...;Pwd=...;Initial catalog=...; m_conSqlConnection.Open() m_cmdSqlCommand = New SqlCommand(insert into Building(internalCodeBuilding inUseNotBuilding) values('dsa''ds') m_conSqlConnection) m_drDataReader = m_cmdSqlCommand.ExecuteReader