How I can connect VB.net to SQL Server 2005 Express?

[ATC]

I am very new for VB.net (Visual Studio 2005) and also very new for SQL Server 2005 Express I do have a Trial1.mdf install in Server Local c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Trial1.mdf I tried to connect/open/close as the following codes: Imports System.Data.SqlClient Public Class Form1 Dim sqlConnection As New SqlConnection("server=localhost;uid=NULL;pwd=NULL;database= c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Trial1.mdf") sqlConnection.Open() sqlConnection.Close() End Class But it fail to run (even re-build no-error), can someone tell me what should I do to use my Trial1.mdf correctly? Thanks for any help

[Harini N K]

Hi For connecting to database, you need to provide UID, password and database. The .MDF file can be attached to the SQL Server. For attaching the database, Check this link Attaching Database[^] After attaching, your database name will be the datasource in your connection string. Hope this helps.

Harini

[ATC]

I did try as you said and it improves my issue, however I still can not open and use my trial1.mdf. Here my update codes: Imports System.Data.SqlClient Public Class Form1 'Link database Dim DB_Location = "c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Trial1.mdf" Dim MyConnection = "Server=localhost; DataBase= " & DB_Location & "Integrated Security=SSPI" Dim sqlConnection As New SqlConnection(MyConnection) 'Use database Dim strSQL As String = "SELECT FROM Trial1 WHERE col2 = 'trial' " Dim cmd As New SqlCommand(strSQL, MyConnection) sqlConnection.Open() ' ----> error cmd.ExecuteNonQuery() ' ----> error sqlConnection.Close() ' ----> error End Class At the last 3 line of codes I got the errors ... can you help me to correct it? Thanks:(