Hi,
could someone please show me how or direct me to a source where i can learn how to connect and manipulate SQL Server 2008 database with VB.NET. I have created a database in SQL Server 2008 and i've created forms for viewing data on VB.NET but i dont know how to connect the two. Im pretty green on this. Some help please?

Recommended Answers

All 4 Replies

Dim objConnection As New SqlConnection _
            ("server=localhost;database= dbase-name;" + _
             "user id= id;password= @password;")

explanation of my code:
localhost- means the sql-server exists on the local machine (your system)
database- the name of your database in sql-server
user id - the id used in loggin into your sql server
password- password to login into sql server

voila

Hi Chris, please close this as well if you are done with this post, thanks.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.