vb database connection help.

Question

0.00/5 (No votes)

See more:

hi,

i am a beginner with visual basic and i need help as i have a deadline for monday for a university project.

i am making a tool where the user enters a name in a text box and the software automatically brings up the related information for that name from a database called database1.

if the database looks like the one below as an example:

name d.o.b address
user1 01/01/1987 10 1st street
user2 02/02/1988 11 2nd street

and i have 2 forms, form1 and form2.

how do i tell vb to get the d.o.b of the name entered in the text box txtname.text on form1 to a text box called txtdob.text on form2 from the database?

and how do i initially connect the database to my vb windows form?

p.s. i am using visual basic 2008 express edition

thank you in advance for any help much appreciated.

Posted 12-Aug-10 14:39pm

hamza_786

Updated 12-Aug-10 15:16pm

Not Active

v3

Add a Solution

Comments

[no name] 12-Aug-10 21:17pm

Removed URGENT as it is rude here. This site is voluntary and people will answer on their time, not yours.

2 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)

AspDotNetDev · Accepted Answer · 2010-08-12T16:44:00

You'll need to make use of the System.Data.SqlClient namespace. You'll need to have SQL Server 2008 installed (there is a free version). You'll need to know how to use a SQL SELECT statement. You'll make use of the SqlCommand and SqlConnection classes. You'll need to know how to build a connection string. You'll need to have a valid database user/password. You'll probably want to pass data between forms using either constructors or properties. Google some of those terms and you should have no problem coming up with a solution.

Yusuf · Accepted Answer · 2010-08-12T17:00:00

Solution 2

Well, if you willing to learn, go through these tutorials

Posted 12-Aug-10 17:00pm

Yusuf

Updated 12-Aug-10 17:01pm

v2