Help with connecting to SQL database

:cry: Well im so frustrated at this point Im start this new job,and I don't know much about databases. So the boss tell me Im mus do this webpage that has multiple choose questions so that he test the staff. Well let me start with my problem.

I have to have about 100 questions in a sql database,and 3000 possible answers. Problem is I don't know how to connect to database with code.
Could some please help me. Could you explain in detail what everything means eg.datasource,dataset and so on. Maybe if I know what all this means I would know what to do.

Im sure you must be wondering you would I want to coding in this. Reason being is that Ill have to display all questions in labels,and all answers in radiobuttons. All have to have random questions. And then random answers. Not everyone answering this test must have the same answer.


But please I really first need to be able to connect to the database.

Im using visual studio 2005->asp.net 2.0->vb.net
ms sql server 2005

Thanks for taking the time to read my problem

Are you comfortable working in .Net, in general?? Any specific language and working in ASP.Net??

I suggest you to take a good book (not really beginner's level) and go through the fundamentals and intermediate level concepts of ADO.Net, .Net language like VB.Net, and ASP.Net.

Obviously you cannot these many books entirely in just a day or two, but try getting the basics first, start little development and then you can carry on with the rest of the book, developing and improving your application.

Hi gupta
Unfortunately I don't have that much money to buy books.
but thanx anyway

Download them!!

Or search for tutorials here and on net. You would find plenty of them, on DataSet, DataSources, ADo.Net in general etc.

For the startup, how to connect it to a SQL DB, check this if you find it helpful. If you still need some help, there are plenty of people around here.

You traitors. :mad:

There's a tutorial right here!

http://www.vbforums.com/showthread.php?t=466658