i have a dataset

Dim query1 As SqlDataAdapter = New SqlDataAdapter("SELECT * FROM AnswerList WHERE SurveyID=83 AND QuestionNum='" & counter & "'", strConnection)
            Dim ds As New DataSet
            query1.Fill(ds)

how can i refer to specific column for example if i want to search for column QuestionNum=1 in table AnswerList
what i want to do is to perform specific action like this..
if QuestionNum=1 Then
****add controls here
Else if QuestionNum=2 Then
****another new controls here..
Else.....
.....
End if

can anyone tell me how to perform this?

Recommended Answers

All 2 Replies

please find one way of doing it with my understanding of your prob..


Dim query1 As SqlDataAdapter = New SqlDataAdapter("SELECT * FROM AnswerList WHERE SurveyID=83 AND QuestionNum='" & counter & "'", strConnection)
Dim ds As New DataSet
query1.Fill(ds)
Dim dt As DataTable
Dim dr As DataRow
dt = ds.Tables(0) ' OR ds.Tables("AnswerList")
For Each dr In dt.Rows
If dr("QuestionNum") = 1 Then
'/****add controls here
ElseIf dr("QuestionNum") = 2 Then
'****another new controls here..
'Else.....
'.....
End If


Next

//do the needed casting if required

Dim query1 As SqlDataAdapter = New SqlDataAdapter("SELECT * FROM AnswerList WHERE SurveyID=83 AND QuestionNum='" & counter & "'", strConnection)
Dim ds As New DataSet
query1.Fill(ds)
int question=ds.tables[0].rows[0]["QuestionNum"].Tostring();
if(question==1)
{
control enabled logic goes here ...
}
else if (question==2)
{
control enabled logic goes here ...
}

hope this help you :)
cheeers

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.