.NET Connectivity to SQL server using C sharp

Using an IP Address to Connect to SQL Server Problem You want to connect to a SQL Server using its IP address instead of its server name. Solution Use the Network Address and Network Library attributes of the connection string. ConnectSqlServerIpAddressForm.cs // Namespaces, variables, and constants using System; using System.Data.SqlClient; //  . . . private void connectButton_Click(object sender, System.EventArgs e) {     String connString =         "Network Library=dbmssocn;Network Address=127.0.0.1 ;" +         "Integrated security=SSPI;Initial Catalog=Northwind";         SqlConnection conn = new SqlConnection(connString);     conn.Open( );

File: ConnectionPoolingOptionsForm.cs

// Namespaces, variables, and constants

using System;

using System.Configuration;

using System.Windows.Forms;

using System.Data;

using System.Data.SqlClient;

private SqlConnection conn;

//  . . .

private void ConnectionPoolingOptionsForm_Load(object sender,

    System.EventArgs e)

{   

    conn = new SqlConnection( );

    conn.StateChange += new StateChangeEventHandler(conn_StateChange);

    connectionStringTextBox.Text =

        ConfigurationSettings.AppSettings["Sql_ConnectString"];

    connectTimeoutTextBox.Text = "15";

    connectLifetimeTextBox.Text = "0";

    minPoolSizeTextBox.Text = "0";

    maxPoolSizeTextBox.Text = "100";

    poolCheckBox.Checked = true;

    UpdateConnectionString( );

}

private void UpdateConnectionString( )

{

    connectionStringTextBox.Text =

        ConfigurationSettings.AppSettings["Sql_ConnectString"] +

        "Connection Timeout = " + connectTimeoutTextBox.Text + ";" +

        "Connection Lifetime = " + connectLifetimeTextBox.Text + ";" +

        "Min Pool Size = " + minPoolSizeTextBox.Text + ";" +

        "Max Pool Size = " + maxPoolSizeTextBox.Text + ";" +

        "Pooling = " + poolCheckBox.Checked.ToString( );

}

private void openButton_Click(object sender, System.EventArgs e)

{

    try

    {

        conn.ConnectionString = connectionStringTextBox.Text;

        conn.Open( );

    }

    catch(SqlException ex)

    {

        MessageBox.Show("ERROR: " + ex.ToString( ), "Open Connection",

            MessageBoxButtons.OK, MessageBoxIcon.Error);

    }

    catch(InvalidOperationException ex)

    {

        MessageBox.Show("ERROR: " + ex.ToString( ), "Open Connection",

            MessageBoxButtons.OK, MessageBoxIcon.Error);

    }

}

private void closeButton_Click(object sender, System.EventArgs e)

{

    conn.Close( );

}

private void conn_StateChange(object sender, StateChangeEventArgs e)

{

    connectionStateTextBox.Text =

        "Connection.StateChange event occurred" +

        Environment.NewLine +

        "OriginalState = " + e.OriginalState.ToString( ) +

        Environment.NewLine +

        "CurrentState = " + e.CurrentState.ToString( );

}