asked on

insert new record into SQL not working

Hi

I am trying to create a small software license database and when i try and insert a new record using

Dim connstring As String = Nothing

Dim sqlconn As New SqlConnection
Dim sqlcmd As New SqlCommand

connstring = "server=simon-pc;database=licenses;trusted_connection=yes;"

sqlconn.ConnectionString = connstring

sqlconn.Open()
sqlcmd.Connection = sqlconn

sqlcmd.CommandText = "insert into licenses (Manuafacture, appname, version, username, ci, license, po, invoice, date_logged) values(" & manufacturerCb.SelectedValue & "," & _
applicationNameCb.SelectedValue & "," & verstionTxt.Text & "," & assignedUserTxt.Text & "," & machineNameTxt.Text & "," & licenseKeyTxt.Text & "," & poNumberTxt.Text & "," & _
invoiceNumberTxt.Text & "," & dateloggedDtp.Value & ");"

sqlcmd.ExecuteNonQuery()
sqlconn.Close()

I receive the error message

Incorrect syntax near ','.

using VS2010 in the autos window the last place this gets to is version.

Can anyone shed any light on to why I am getting this please?

Thanks

Simon

Paul Jackson

Have you spelt this control correctly ? verstionTxt.Text
Are you maybe missing a continuation character after the & on the 3rd line

ASKER CERTIFIED SOLUTION

pdd1lan

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SimonPrice33

ASKER

thanks guys, will try now, spelling of version is correct now... will try using the single quotes too...

one question, what does the # represent?

Thanks
Simon

SimonPrice33

ASKER

Bonza! thanks :)

worked a charm with single quotes, changed the # to ' too :)

thanks

Simon

pdd1lan

you don't have to use a sing quote around value if value is number, but it requires the value is text value. "#" around variable for date field value.

SimonPrice33

ASKER

hi, the spelling mistake was in my post here, actual code was correct, solution that was awarded the points was the correct and in full..