undefined SQL

[menyki]

below is a code to input data from vb.net to ms access. in the code SqlCommand is underlined and the error msg is that, is not defined. can somebody tell me how i can define it

Dim Objconn As New SqlClient.SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector      y|\chiscoTransport.mdb;Integrated Security=True;Connect Timeout=30;User Instance=True")
        Objconn.Open()
 
        Dim ObjCmd As SqlCommand = New SqlCommand("INSERT INTO seatReservation (vehicleID, pname, deptureT, trvllingft, pssngerAD, phoneNo, fare, time, exptdjd, date) VALUES (@vehicleID, @pname, @deptureT, @trvllingft, @pssngerAD, @phoneNo, @fare, @time, @exptdjd, @date)", Objconn)
 
 
        ObjCmd.Parameters.Add("@vehicleID", Data.SqlDbType.VarChar).Value = vehicleIDComboBox.Text
        ObjCmd.Parameters.Add("@pname", Data.SqlDbType.Text).Value = pnameTextBox.Text
        ObjCmd.Parameters.Add("@deptureT", Data.SqlDbType.Text).Value = deptureTComboBox.Text
        ObjCmd.Parameters.Add("@trvllingft", Data.SqlDbType.Text).Value = trvllingftComboBox.Text
        ObjCmd.Parameters.Add("@pssngerAD", Data.SqlDbType.Text).Value = pssngerADTextBox.Text
        ObjCmd.Parameters.Add("@phoneNo", Data.SqlDbType.Int).Value = phoneNoTextBox.Text
        ObjCmd.Parameters.Add("@fare", Data.SqlDbType.Int).Value = fareTextBox.Text
        ObjCmd.Parameters.Add("@time", Data.SqlDbType.Text).Value = timeTextBox.Text
        ObjCmd.Parameters.Add("@exptdjd", Data.SqlDbType.Text).Value = exptdjdTextBox.Text
        ObjCmd.Parameters.Add("@date", Data.SqlDbType.Text).Value = dateTextBox.Text
 
 
        ObjCmd.ExecuteNonQuery()
 
 
        Objconn.Close()

[shweta123]

Hi,

I think , there may be something wrong in one of the paramter values especially you can check for the date.Otherwise command object declaration seems to be Right.

[Plater]

I think your are missing a namespace include.
If you click on the SQLCommand and hover your mouse there, a little tiny underline should appear under the last character. Mousing over that should give you the option to add the correct namespace.

It could also be that you have capitalization issues. Use CTRL+SpaceBar to auto correct/complete and pick from a list of correct terms.