Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Show the connection properties for SqlConnection

using System; using System.Drawing; using System.Collections; using System.ComponentModel; using System.Windows.Forms; using System.Data; using System.Data.OleDb; using System.Data.SqlClient; public class MainClass{     static void Main() {        // Create a Connection Object        string ConnectionString ="server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI;";        SqlConnection conn = new SqlConnection(ConnectionString);        // Open the connection        if( conn.State != ConnectionState.Open)            conn.Open();        //         Console.WriteLine( "Connection String :"+conn.ConnectionString             + ", Workstation Id:"+ conn.WorkstationId.ToString()            +", Packet Size :"+ conn.PacketSize.ToString()            +", Server Version "+ conn.ServerVersion.ToString()            +", DataSource :"+ conn.DataSource.ToString()            +", Server Version:"+ conn.ServerVersion.ToString()            +", Connection Time Out:"+ conn.ConnectionTimeout.ToString() );        // Close the connection        if( conn.State == ConnectionState.Open)            conn.Close();            } } Connection String :server=(local)\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI;, Workstat ion Id:RNTSOFT, Packet Size :8000, Server Version 09.00.1399, DataSource :(local)\SQLEXPRESS, Server Version:09.00.1399, Connection Time Out:15