How to resolve an error where a table that is contained in a defined dataset is not a member of System.Data.Dataset
Posted on 2006-11-08
I'm experiencing a problem where I'm attempting to use a table that is defined to a dataset, yet receiving an error message indicating that the table is not part of System.Data.Dataset. Below please find the code snippet that is generating the error:
Dim cmdACSelect As New OleDbCommand("SELECT intCandidateAnswerChoiceSysID, intCandidateQuestionSysID FROM tblCandidateQuesHasAnswers WHERE tblCandidateQuesHasAnswers.intCandidateQuestionSysID = " & CInt(strcqid) & "AND" & tblCandidateQuesHasAnswers.intCandidateQuestionSysID = " & CInt(strcqcollect)", OleDbConnection1)
The dataset that contains this table, tblCandidateQuesHasAnswers is dsAnswerChoices which has been included with the form.
I'm also receiving a related error indicating that the tblCandidateQuesHasAnswers is not declared.
Any assistance that you can offer to resolve this would be greatly appreciated.