C# 请指教

来源：百度知道 编辑：UC知道 时间：2024/05/27 00:04:18
我写的控制台程序如下，可是不能输出 数据库名称，实例名称，和连接状态。SQL本地服务器已经配置过了，现在可以用SQLserver用户名登陆了，代码如下：
using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
namespace SqlConnectionDemo
{
class Program
{
static void Main(string[] args)
{
SqlConnection Connection = new SqlConnection();
Connection.ConnectionString = "Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=Northwind;server=(local)";
Connection.Open();
Console.WriteLine("数据库名称:{0} 实例的名称:{1} 连接状态:{2}", Connection.Database, Connection.DataSource, Connection.State);
Connection.ChangeDatabase("master");//改变连接数据库
Console.WriteLine("数据库名称:{0} 实例的名称:{1} 连接状态:{2}", Connection.Database, Connection.DataSource, Connection.State);
Connection.Close();
}

}<

SqlConnection Connection = new SqlConnection();
Connection.ConnectionString = "Persist Security Info=false;Integrated Security=SSPI;Initial Catalog=model;server=127.0.0.1;user=tang";//tang是我的主机名
try
{
Connection.Open();
Console.WriteLine("数据库名称:{0} 实例的名称:{1} 连接状态:{2}", Connection.Database, Connection.DataSource, Connection.State);
Connection.ChangeDatabase("master");//改变连接数据库
Console.WriteLine("数据库名称:{0} 实例的名称:{1} 连接状态:{2}", Connection.Database, Connection.DataSource, Connection.State);
}
catch (SqlException e)
{
Console.WriteLine(e.Message.ToString());
}
catch (Exception ex)
{
Console.WriteLine(ex.Message.ToString());
}
finally