OleDBException was unhandled by user

Question

0.00/5 (No votes)

See more:

I was ask to create a website that allow a user to enter the Question with an
answer on the website. when I click the button add, Question and Answer will
be store into an access database with ID number (AutoNumber). Below is the
code for my website.

Protected Sub btnQuestion_Click(...............)Handles btnQuestion.Click
lblDisplay.Text = "Question:" & txtQuestion.Text & "<br />"
lblDisplay.Text = "Answer:" & txtAnswer.Text


adsRevision.InsertParameters("Question").DefaultValue = txtQuestion.Text
adsRevision.InsertParameters("Answer").DefaultValue = txtAnswer.Text
adsRevision.Insert()

End Sub

Please,Can anyone help provide the code for AutoNumber ID? I don't know
how to write.

Posted 1-Oct-13 10:42am

Tekitaa Mautaake

Updated 1-Oct-13 10:46am

Richard C Bishop

v2

Add a Solution

Comments

Richard C Bishop 1-Oct-13 16:48pm

I know in an MS SQL database there is a property that increments the primary key when an entry is added. You might look up the equivalent to "IsIdentity" for access.

Homero Rivera 1-Oct-13 19:59pm

You need to add the SQL code you are trying to run as well, just incase. The error is evidently in the SQL code, not the VB, your VB looks just fine (in rule). If you are not sure your sql is right, well at least let us see it!

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)