使用SqlConnection显示连接信息

转载

mob604756e6f1ac 2012-07-17 13:29:00

文章标签 sql 数据库连接字符串 JAVA 文章分类 Java 后端开发

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;

namespace ConnectionDisplay
{
    class Program
    {
        static void Main(string[] args)
        {
            SqlConnection conn = new SqlConnection(@"
            server=.;
            user id=administrator;
            integrated security =true;
            ");
            try
            {
                conn.Open();
                Console.WriteLine("Connection opened.");
                Console.WriteLine("Connection Properties:");
                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 close.");
            }
            Console.ReadKey();
        }
    }
}