help regarding vb.net

[hitesh bhalkiya]

hi i am beginner in vb.net now i want to learn database connection in vb.net pls give me reply with specification of each line of code. Thanx.

[Paulson]

HI Hitesh

I cannot give you each line of code but this link will be helpfull.
http://www.startvbdotn et.com/

There are 2 types of connection methods Connected and Disconnected.

Eg: for connected is Datareader
Eg: for Disconnected is Dataset

For any connetion u need the connctionstring
like
"server='sqlser ver';database=' mydatabase';uid ='sa';pwd='sa'; "

where server is the type of server database is databse name uid and pwd are username and password respectively.

Then there are sqlCommand,Sqlc onnection,etc. depending on which method u use.Just go thru the link I gave you try it out yourself and if u have got any doubt be free to ask me but only after u try urself once.

Keep the good work going

Bye Paulson.

[kenobewan]

The experts on this site are more than happy to help you with your problems but they cannot do your assignment/program for you. Attempt the assignment/program yourself first and post questions regarding any difficulties you have or about a particular function of the code that you don't know how to achieve.

MODERATOR

[taffer23]

hi i am beginner in vb.net now i want to learn database connection in vb.net pls give me reply with specification of each line of code. Thanx.

dim con as new oledbconnection =new oledbconnection (" //insert conection string");
and to open the connection
con.open();