I am designing a page for my students to practice their Latin vocabulary. I am having two problems with the design: 1) working with checkboxes, and 2) display one returned row at a time.
1) First, students select from CheckListBox1 those parts of speech (nouns, verbs, adjectives, etc.) they want to review, and then they click Button1 ("Submit"), which fires off a SELECT statement against a table named CoreVocab in a SQLEXPRESS database. How do I pass each selected part of speech from CheckListBox1 as a variable into the WHERE statement when the user clicks Button1? Do I place this code in the Button1_Click on the .cs page?
2) Ideally, the table returns the first row and Button1 changes to "Next," which the student then clicks to see the next Latin word. How do I get the Repeater table to show only one row at time until the Next button is clicked? And how do I get the same button to executed two functions (fire off the SELECT statement and then show the next row)? For what it's worth, I'm using the SqlDataReader command, since data will only be retrieved, not modified.
Thanks. I'm new at this. But I really need to do something for my suffering students.
View Complete Post