how to make connection with sql 2005 database

UmeshA · February 3rd, 2010, 02:29 PM

hi Friends,
I am working with the small project of Invice Package.
i have using the Visual Studio 2005
the project is in VB.Net
so how to make the connection of this variables with the SQL server 2005
& where can i get the code samples?

om_prakash · February 4th, 2010, 01:00 AM

To get connection strings, please check the following site:
http://www.connectionstrings.com/
For examples, please check the following links:
http://www.developerfusion.com/artic...th-sql-server/

Example:

Code:

 Dim thisConnection As New SqlConnection("server=(local)\SQLEXPRESS;integrated security=sspi;database=MyDatabase")
 Dim thisCommand As New SqlCommand ("SELECT FirstName FROM Employee", thisConnection)
 ' Open Connection
 thisConnection.Open()
 ' Execute Query
 Dim thisReader As SqlDataReader = thisCommand.ExecuteReader()
 While (thisReader.Read())
    Console.WriteLine("Name: {0}", thisReader(0))
 End While
 'Close DataReader
 thisReader.Close()
 thisConnection.Close()

Please check following URL (Database ADO.net Section) for more examples:
http://www.java2s.com/Code/VB/CatalogVB.htm