'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