Creating Connections to SQL Server


  • ' Visual Basic
    Public Sub ConnectToSql()
    Dim conn As New SqlClient.SqlConnection
    ' TODO: Modify the connection string and include any
    ' additional required properties for your database.
    conn.ConnectionString = & _
    "integrated security=SSPI;data source=SQL Server Name;" & _
    "persist security info=False;initial catalog=northwind"
    Try
    conn.Open()
    ' Insert code to process data.
    Catch ex As Exception
    MessageBox.Show("Failed to connect to data source")
    Finally
    conn.Close()
    End Try
    End Sub

    // C#
    public void ConnectToSql ()
    {
    System.Data.SqlClient.SqlConnection conn =
    new System.Data.SqlClient.SqlConnection ();
    // TODO: Modify the connection string and include any
    // additional required properties for your database.
    conn.ConnectionString =
    "integrated security=SSPI;data source=SQL Server Name;" +
    "persist security info=False;initial catalog=northwind";
    try
    {
    conn.Open();
    // Insert code to process data.
    }
    catch (Exception ex)
    {
    MessageBox.Show("Failed to connect to data source");
    }
    finally
    {
    conn.Close();
    }
    }

 

0 comments: