I'm setting up a simple customer survey: a batch of questions, each connected to a dropdown list giving a choice of possible answers.
I've already created a possible questions table and a possible answers table in sql, as well as an interface in visual studio which allows the survey's administrators to create and edit both questions and associated answers. It runs fine.
Now, I'm faced with the task of making the end user survey itself. I set up a gridview for the questions and created a new datasource to feed it questions (and the question ID#, though that isn't visible). Then, I added a column, made it a template, and pulled in a drop-down list, which I tried to databind to my answers table, sorting according to the associated question ID. It doesn't work.
Should I be using a detalsview instead of a gridview to do something like this? Are there templates out there I can model?