Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Connection Display

using System; using System.Data; using System.Data.SqlClient;     class ConnectionDisplay     {         static void Main()         {             SqlConnection conn = new SqlConnection(@"server = .\sqlexpress;user id=administrator;integrated security = true;");             try             {                 conn.Open();                 Console.WriteLine("\tConnection String: {0}",conn.ConnectionString);                 Console.WriteLine("\tDatabase: {0}",conn.Database);                 Console.WriteLine("\tDataSource: {0}",conn.DataSource);                 Console.WriteLine("\tServerVersion: {0}",conn.ServerVersion);                 Console.WriteLine("\tState: {0}",conn.State);                 Console.WriteLine("\tWorkstationId: {0}",conn.WorkstationId);             }             catch (SqlException e)             {                 Console.WriteLine("Error: " + e);             }             finally             {                 conn.Close();                 Console.WriteLine("Connection closed.");             }         }     }