'Declaration Public Function New( _ ByVal connectionString As String _ )
public SqlConnection( string connectionString )
Parameters
- connectionString
- The connection used to connect to SQL Server.
'Declaration Public Function New( _ ByVal connectionString As String _ )
public SqlConnection( string connectionString )
Properties | Initial Value |
---|---|
ConnectionString | connectionString |
ConnectionTimeout | 15 |
Password | empty string ("") |
UserId | empty string ("") |
public void CreateSqlConnection() { string myConnString = "User Id=sa;Server=localhost;Initial Catalog=Test;"; SqlConnection myConnection = new SqlConnection(myConnString); myConnection.Open(); //Do something myConnection.Close(); }
Public Sub CreateSqlConnection() Dim myConnString As String = _ "User Id=sa;Server=localhost;Initial Catalog=Test;" Dim myConnection As New SqlConnection(myConnString) myConnection.Open() 'Do something myConnection.Close() End Sub
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2