Reading Mulitple Records randomly in a database and displaying it on a windows forms

Question

3.00/5 (2 votes)

See more:

VS2010

Hello guys new here!

I have a question that I hope someone here on this site can answer. I'm building an Math application in Visual C# where students can do math quizzes , tutorials etc.

With regards to building my math quizzes what I have decided to do is to build a table in SQL server that will hold questions and answers for a particular topic.
For example, one of the tables that I have in my database is as follows:-

Name of Table : Algebra

Columns : QuestionId (primary key) , Question, Answer, LevelOfDifficulty

What I want to do is to pull RANDOM questions from the above table and display them on a windows forms. In this windows form there will be labels which will hold the questions that I read from the 'Algebra' table in the database and there will be text boxes where the student can answer the question

Can someone please give me a of a methodology to build something like this???

Posted 27-Mar-13 8:48am

Darren501

Add a Solution

Comments

Sergey Alexandrovich Kryukov 27-Mar-13 14:55pm

Not really a valid question. Learn ADO.NET, write your code, ask specific questions if you stuck...
—SA

Darren501 27-Mar-13 14:58pm

I'm not really looking for code or posting code. I just want a general idea how to approach this problem.

PIEBALDconsult 27-Mar-13 15:20pm

Essentially what you asked breaks down to three things (SQL, Data Access, and UI). These three things should be kept separate.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

PIEBALDconsult · Answer 1 · 2013-03-27T08:56:00

Solution 1

One common way is to sort on a reasonably random value, e.g. ORDER BY NEWID()

Posted 27-Mar-13 8:56am

PIEBALDconsult

v2

Comments

Darren501 27-Mar-13 15:27pm

Thank you for the response. I also found some code to help with with regards to the random selection of questions from a database

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=1316&lngWId=5

However I still have the issue about displaying this information on a windows form. I know how to display information from a database one at time with labels. But if i have to display MULTIPLE data on a form in separate labels, what methodology should I us???