Quiz V2 Beta 1
OK here we go !
The Beta of my little Quiz application is finally there !
Be aware, I give this as an educative tool, without any warranty it will satisfy everything you need.
So to make this working you need to have the front-end Quiz and to help you managing the content of the Quiz, I write a Management tool you can download here.
A single Database table is required to make this working. Why one and not a full relational database ?
Because I need myself to implement this code quickly and easily in some 5 different projects, so I didn't like the idea to transform the other databases as a kind of 'relational spaghetti'.
That's why the Admin is a bit complex, because I had to build some dynamic datatables, and manage a lot of Postback.
Another thing. You will find a method to fill a drop down list with some information coming from a project I work on.
Of course, you have to modify this drop down code to suit your own requirements.
I also include the use of FreeTextBox for the case you want to have an Answer or Question in HTML with some fancy elements.
Just edit the content in the FreeTextBox, and Drag and drop to the right placeholder would do the job.
For the Scores, still some job to be done, like a checksum to be sure that you don't have more Score lines than the total of Questions !
Surely also some validation controls to add there and there.
In the Zip file, you have the aspx page and the code-behind, the DAL (indeed Database Application Block 2.0 from Microsoft) and the SQL script to generate the database.
You have to create in VB a project name Quiz, and also add the DAL project to the solution.
Don't forget to edit the Web.Config to include your database connection in the appSettings section, something like:
<add key="Quiz" value="server=yourSQLServerName;uid=SQLusername;pwd=SQLpassword;database=Quiz"/>
This version don't include so much code comments, but the code is quite straight forward.
Of course, I will be happy to receive any comments, improvements, or feedbacks :-)
