Help.Enquires about SQL query

[qwer]

May I know if I want to add in a INSERT INTO statement do I have to declare anything above in the VB.Net programme?example,

INSERT INTO Carpark_table (Carplate, date, TimeIn)
VALUES (car_plate, datestr, timestr)

when I debug the INSERT and VALUES are considered as errors where declarations are needed

[debasisdas]

Question moved to .NET Forum.

[jrtox]

May I know if I want to add in a INSERT INTO statement do I have to declare anything above in the VB.Net programme?example,

INSERT INTO Carpark_table (Carplate, date, TimeIn)
VALUES (car_plate, datestr, timestr)

when I debug the INSERT and VALUES are considered as errors where declarations are needed

Hello,
I cant help you with VB.NET, i really dont know it its Same format in VB6
Anyway In VB6, the Format will be

INSERT INTO Carpark_table (Carplate, date, TimeIn)
VALUES ('" & car_plate & "', '" & datestr & "', '" & timestr & "')
 

Tell me if its Works.

Regards
Phils Ervin

[debasisdas]

try using this

"INSERT INTO Carpark_table (Carplate, date, TimeIn)
VALUES ('" & car_plate & "', '" & datestr & "', '" & timestr & "')"

[jeenajos]

You should have to establish a connection.
Then give a command text specifying INSERT/DELETE/or any query.
Then give execute query.
It wil work.
Im saying u the steps. U should develop the code

Thank U
Jeen