Hello, i have this sqlexception errors when i try to insert data into my sql2005 from vb2008.
SqlException unhandled : Incorrect syntax near '12' and also near '3'
I am sure it is coming from the datetimepicker. However the same code is working on other forms in
the same program. i am confused. pls help!!
What does your SQL statement look like? Please post some code.
hello this is the code which gives the error "Sql Hello this is the code which is creating the error "SqlException unhandled : Incorrect Syntax near '12' Imports System.Data.SqlClient Imports System.Data.SqlClient.SqlCommand Public Con As New SqlConnection("Data Source=SALVATNBYJESUS\SERVER05;Initial Catalog=SeizedVehiclesDb;User ID=sa;Password=password") Public qry, iqry As String Public cmd As SqlCommand Public dr As SqlDataReader 'SAVE NEW TRANSACTION ' ================= Con.Close() Con.Open() qry = "insert into ApplicationTb(inputcode,applicinputdate,declarationno,revenueliability,gphachargereceipt,shippersreceipt,paymentarrangedetails,firstofferexpirydate,applicationremarks)values('" & cboinputcode.Text & vbCrLf & _ "'," & Date.Today & ",'" & txtdeclno.Text & "','" & txtrevenueliab.Text & "','" & txtghpareceipt.Text & "','" & txtshippersreceipt.Text & _ "','" & txtpayarrangement.Text & "'," & dtpfirstofferEXPdate.Value.ToString & ",'" & txtapplicationremarks.Text & "')" cmd = New SqlCommand(qry, Con) cmd.ExecuteNonQuery() MsgBox(" Importer Application Saved successfully", MsgBoxStyle.Information, "Save")