in my table the PK is RespondentID (auto incremental integer)
I added the query below into a SQLDataSource control's Inser Statement.
INSERT INTO [Respondent] ([DateTimeStarted])
When I open it in query builder in design view it says "Unable to Parse Query Text". When I run it in code behind (see the code below) the output value for SqlDataSource1.Inser() is always "1".
Where did I do wrong? please help
thanks in advance
View Complete Post