I've been working on a project lately but it has been unsuccessful. I would like to build a Windows Application Form program that can interact with a SQL table. When program runs, user has to fill some gaps as follows:
Exam type:
Exam number:
Theme:
No. of students:
No. of questions per students:
when I collect these information, I would like to then connect to a SQL table that has the following 2 rows:
theme
questions
Based on the info gathered from the user, I would like to randomly pick how many number of the questions that user wants for how many number of the students that he wants, and then put them in a table with the right header of the exam version and type and then print it.
I have built the interface and the table, but I don't know how to actually interact with my table.
I'm using SQL server 2005 integrated in Visual Studio 2008. I have northwind installed as well.
Please let me know how my application should interact with the tables, retrieve information, and then put it in a new table and print it?
Thanks