Syntax error in INSERT INTO statement

[ccworld]

I'm trying to creat a registration page. It says I have a Syntax error in INSERT INTO statement and highlights Adapter.Update(CscapeDS, "cscape"). I've tried everything I can think of to fix it. I hope someone here can help.

[diegojancic]

I use c#, thats why i didn't understand everything, but i think that the problem is here (only if the "registration_date" is set as DateTime):

Row.Item("registration_date") = Today & " at " & Format(Now, "t")

[ccworld]

No it's only a basic text. I didn't want to have to deal with correct formating of the date.

[Andy Tacker]

change your Select statement from
SelectStatement = "Select * From cscape Where id=" & IDNumSent

to simply
SelectStatement = "Select * From cscape"

you can debug your application and see what happens when you use first statement and when you use second statement.