Paging in a panel control

[aguywonderer]

I created a quiz and used a panel control for dynamic loading. It works well only that I would like to 3 questions appear at a time and then move on to the next three with a next button and have DONE button on the last 3 questions. My code is below -- can anyone fill in the blanks or lead me in the right direction?

DBCommand = New OleDbDataAdapter _

("Select SectionName from CourseSections Where " _

& "CourseID = " & Session("CourseID"), DBConn)

DBCommand.Fill(DSPageData, "SectionName")

lblTitle.Text = "<center> " _

& DSPageData.Tables("SectionName").Rows(0).Item("SectionName") _

& "</center>"

DBCommand = New OleDbDataAdapter _

("Select SectionQuestionID, QuestionText " _

& "From SectionQuestions Where CourseID = " _

& Session("CourseID"), DBConn)

DBCommand.Fill(DSPageData, "QuizQuestions")

For I = 0 To DSPageData.Tables("QuizQuestions").Rows.Count - 1

Dim lcHTML = New LiteralControl

lcHTML.Text = "<b><br>" _

& DSPageData.Tables("QuizQuestions").Rows(I).Item("QuestionText") & "</b><br>"

pnlQuestions.Controls.Add(lcHTML)

Dim MyDDL = New RadioButtonList

TempID = DSPageData.Tables("QuizQuestions").Rows(I).Item("SectionQuestionID")

MyDDL.ID = "Q" & TempID

DBCommand = New OleDbDataAdapter _

("Select AnswerText " _

& "From QuestionAnswers Where SectionQuestionID = " _

& TempID, DBConn)

DBCommand.Fill(DSPageData, TempID)

For J = 0 To DSPageData.Tables(TempID).Rows.Count - 1

Dim MyItem = New ListItem

MyItem.Text = DSPageData.Tables(TempID).Rows(J).Item("AnswerText")

MyDDL.Items.Add(MyItem)

Next

pnlQuestions.Controls.Add(MyDDL)

Dim lcHTML2 = New LiteralControl

lcHTML2.Text = "<br><br>"

pnlQuestions.Controls.Add(lcHTML2)

Next

 

[ayozzhero]

I am not sure how to do this with ASP.Net. But my common practice would be putting a save button and link to the next three question e.g: questions.aspx?page=2

Upon receiving the variable (page=2), you put that in your SQL to list the next 3 questions.

Hope this gives you an idea...