Question Locked

how to connect the database from vb.net

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
how to connect a sql server 2005 express edition database through vb.net

3 replies

by tony hopkinson

You to create a SQLConnection object.
Pass in or set the ConnectionString
then call the open method.

If you are using integrated security then the connection string will be

"data source = MyServer\MyInstance; intial catalog = MyDataBaseName; integrated security = SSPI"

if you are using SQL Server Security
it's
"data source = MyServer\MyInstance; intial catalog = MyDataBaseName; User ID = MyUserName; Password = MyPassword"

Hit Help on SQLConnection in Visual Studio, there's a lot of it.

by 19remyavinod

can you tell me
wht are the step by step procedure of .vb.Net progrms

means,firstly how can I do
Please explain

This discussion is closed to new replies.