Member Avatar for chris evans

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?

  • 3 Contributors
  • 4 Replies
  • 211 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by AndreRet
Member Avatar for Netcode 
Dim objConnection As New SqlConnection _
            ("server=localhost;database= dbase-name;" + _
             "user id= id;password= @password;")
Member Avatar for Netcode

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

Member Avatar for AndreRet

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.