ASP.NET获取MS SQL Server装配实例

2013-03-17

ASP.NET获取MS SQL Server安装实例View Code protected void Page_Load(object sender, EventArgs e){Data

ASP.NET获取MS SQL Server安装实例

View Code protected void Page_Load(object sender, EventArgs e)    {        DataTable dataTable = SqlDataSourceEnumerator.Instance.GetDataSources();        foreach (DataRow dr in dataTable.Rows)        {            if (string.IsNullOrEmpty(dr["InstanceName"].ToString()))               this.DropDownListInstance.Items.Add(string.Concat(dr["ServerName"]));            else               this.DropDownListInstance.Items.Add(string.Concat(dr["ServerName"], "\\", dr["InstanceName"]));        }    }