Quiz software using C# (Windows application) with Ms. Access

In the previous post I had show you how to use Ms. Access as your database. Now in this article I will explain you how to create a Quiz software. First take a look about the database.

Here I have done all the program in just one form. And using panel I did all the hiding and showing data.

Table Question (tblQuestion)

• ID (Number auto increment by 1)
• Question (Text)
• Option1 (Text)
• Option2 (Text)
• Option3 (Text)
• Option4 (Text)
• Answer (Text)

Read More

MS. Access connection with C# in windows or web application

Ms. Access is very useful database for the standalone application, where you need to run the program without installing the database in user's machine like a quiz or any other examination system. So lets have a look how to code the program to connect your software with Ms. Access database.

If you have done previously to connect the SQL server and done fetching or retrieving data from database it is more or less same for you. Everything is same except the connection string.

The Ms. Access connection string is here for you, with example of how to run a query(get or insert) in web application or windows application using of  C#.

You must hear about the OleDbConnection in .NET, we are going to use this one to connect your Ms. Access database.

Read More