Computing.Net > Forums > Programming > Database Connectivity in VB.NET

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Click here to start participating now! Also, check out the New User Guide.

Database Connectivity in VB.NET

Reply to Message Icon

Name: Haja
Date: March 13, 2005 at 18:04:21 Pacific
OS: windows xp
CPU/Ram: P4/512mb
Comment:

I need help in database connectivity in vb.net



Sponsored Link
Ads by Google

Response Number 1
Name: secrets
Date: March 14, 2005 at 07:59:46 Pacific
Reply:

there are alot of example available on net and also alot is available on msdn.
here are steps i am considering sqlserver as database server.
1- past an sql connection control from toolbar to your form rename it to sqlcon.
2- Select sqlcon you have just created and in its properties click on its connection string.
3-click new then select connection provider as Microsoft SQL Server.
4- click ok your connection is open now on form load event of your form put this line
if sqlcon.state=connection.closed then sqlcon.open()
it will open the connection if it is still close.
now you can do your work databse is connected.


0
Reply to Message Icon

Related Posts

See More


Java Problem XP batch to auto-input in...



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Programming Forum Home


Sponsored links

Ads by Google


Results for: Database Connectivity in VB.NET

Database connection in VB.NET www.computing.net/answers/programming/database-connection-in-vbnet/11398.html

data base connection to vb.net 2008 www.computing.net/answers/programming/data-base-connection-to-vbnet-2008/16948.html

Questions vb.net www.computing.net/answers/programming/questions-vbnet/12968.html