problem with the database vb.net(2008)

[pattex007]

Hi

I have a database(acces) with tabel questions and answers.
-->
tblquestions
questionId -> -> primary key
question -> string


tblanswers
questionId -> primary key
answerId-> primary key
answer-> string

There's a combobox with questions and a listbox with questions of the chosen answer(s).
I have already to add and show the questions, answers.
Now I wan't to delete the answer(s) (in the listbox) of the chosen questions
I have this already

   con = New OleDbConnection(providerStr & dbLoc)
            con.Open()
            Dim command As New OleDb.OleDbCommand("DELETE FROM Answers WHERE questionId= " & 0 & " AND answer='" & lstAnswers.SelectedIndex.ToString & "')", con)
            command.ExecuteNonQuery()
            con.Close()

pleas help

[Dököll]

Hey there good buddy!

I suspect you can get bette seved in the .net area; I'll send there...

Let us know if anything else:-)

Dököll

[pattex007]

@Dököll
hi

Sorry I thought this was the .net area

Can you give the link of the question please? Because I can't find it.

[Frinavale]

Are you getting an error? If so could you please post the error details. If not could you please explain what is going wrong.

Have you seen these articles on how to use a database in your program and how to use a database in your program part II?

You should use parameters instead of creating your sql queries the way you are. But that's probably not your problem.

Have you tried running the query in Access to make sure that it works properly?

-Frinny