余小章 @ 大內殿堂

SqlDataSourceEnumerator SqlEnum = SqlDataSourceEnumerator.Instance;

//2.取得資訊並傳入DataTable中

DataTable dt = SqlEnum.GetDataSources();

//3.取出DataTable

foreach (DataRow row in dt.Rows)

{

    listBox1.Items.Add(i.ToString() + " Server Name Is: ");

    foreach (DataColumn col in dt.Columns)

    {

        listBox1.Items.Add(col.ColumnName + " : " + row[col.ColumnName].ToString());

    }

    listBox1.Items.Add("");

    i++;

}