爱心加油站

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;namespace UseSQLserver
{
    class Program
    {
        static void Main(string[] args)
        {
            ShowConnectionProp();
        }
        static void ShowConnectionProp()
        {
            string conStr = "DataSource=yangmingyu\\SQlEXPRESS;InitialCatalog=Students;Integrated Security=True";
            SqlConnection con = new SqlConnection(conStr);
            System.Console.WriteLine(" 数据库连接--Open()前信息：");
            System.Console.WriteLine("   ConnectionString=[{0}]", con.ConnectionString);
            System.Console.WriteLine("   ConnectionStringTimeout=[{0}]", con.ConnectionTimeout);
            System.Console.WriteLine("   DataBase=[{0}]", con.Database);
            System.Console.WriteLine("   DataSource=[{0}]", con.DataSource);
            System.Console.WriteLine("   PacketSize=[{0}]", con.PacketSize);
            System.Console.WriteLine("   StaticsEnabled=[{0}]", con.StatisticsEnabled);
            System.Console.WriteLine("   Workstationld=[{0}]", con.WorkstationId);
            System.Console.WriteLine("   State=[{0}]", con.State);
            System.Console.WriteLine();            con.Open();
            System.Console.WriteLine("数据库连接--Open()后的信息：");
            System.Console.WriteLine("  ServerVition=[{0}]", con.ServerVersion);
            System.Console.WriteLine("  State=[{0}]", con.State);
            System.Console.WriteLine();
            con.Close();
            System.Console.WriteLine("数据库连接--Close()后的信息");
            System.Console.WriteLine("   State=[{0}]", con.State);
            System.Console.Read();
        }    }
}