Want to use database in vb.net program

Question

0.00/5 (No votes)

See more:

Hey all,

I'm trying to create a game for myself (and learn to program a bit), and I want to learn how to use SQL queries to get information from a database. I'll use that information to set a custom object's variables.

All I have to do now is:
- create the database.
- learn how to have my program get information from that database.

I've tried searching the web, but I don't really know what to search for...

Please point me in the right direction.

I'm using Visual Basic 2010 Express.
I think I can learn enough about SQL from w3schools.
I want my database to contain the variables for 1499 objects, each object has 20-30 variables. (I still have to figure out how many :P .)

Help would be greatly appreciated!

EDIT:
Thanks for the responses, seems I've got a lot of reading to do.

Posted 20-Jan-13 21:06pm

OneInNineMillion

Updated 20-Jan-13 21:22pm

v2

Add a Solution

4 solutions

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)

Sergey Alexandrovich Kryukov · Answer 1 · 2013-01-20T21:12:00

Solution 1

Short answer is: use ADO.NET:
http://en.wikipedia.org/wiki/ADO.NET[^],
http://msdn.microsoft.com/en-us/library/aa286484.aspx[^].

I usually recommend this short by very informative CodeProject article to get started: Using ADO.NET for beginners[^].

—SA

Posted 20-Jan-13 21:12pm

Sergey Alexandrovich Kryukov

Tharaka MTR · Answer 2 · 2013-01-20T21:16:00

Best place is MSDN
http://msdn.microsoft.com/en-us/library/s4yys16a(v=vs.71).aspx[^]
http://www.dreamincode.net/forums/topic/32392-sql-basics-in-vbnet/[^]
http://www.developer.com/net/vb/article.php/3558771/Binding-Data-to-WinForms-Controls-in-VBNET-20.htm[^]
http://www.microsoft.com/en-us/download/details.aspx?id=4856[^]

you better check Entity Framework also
An Introduction to Entity Framework for Absolute Beginners[^]
http://adoeftutorial.codeplex.com/[^]
http://msdn.microsoft.com/en-us/library/bb399572.aspx[^]

The Doer · Answer 3 · 2013-01-20T21:17:00

A long way to travel-
You have to learn about the connection string for database and Data retrieval and processing in VB.net .
Its better if you start with ADO.net, here is an article For beginners-

Using ADO.NET for beginners[^]

I think the above article is enough for beginning, rest you can explore later.

Hope it helps.

Rahul Rajat Singh · Answer 4 · 2013-01-20T22:44:00

Solution 4

This link could also be useful for you.

A Beginner's Tutorial for Understanding ADO.NET[^]

Posted 20-Jan-13 22:44pm

Rahul Rajat Singh

Want to use database in vb.net program

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0