Passing checkboxlist variables and returning one row at a time

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 s ...