得到内网可用的SqlServer 及某数据库下的表及其他的架构

 1    protected void Button1_Click(object sender, EventArgs e)
 2    {
 3        //得到目前内网可用的SqlServer
 4        Sy***m.Data.Sql.SqlDataSourceEnumerator instance = Sq***taSourceEnumerator.Instance;
 5        DataTable dt1 = in***nce.GetDataSources();
 6        Re***nse.Write("目前内网可用的SqlServer" + "
");
 7        foreach (DataRow dr in dt1.Rows)
 8        {
 9            Re***nse.Write(dr[0].ToString() + "
");
10        }
11        Re***nse.Write("==========================");
12        //得到某数据库 的 架构集合
13        string strConn = "Data So***e=192.168.0.36;Initial Catalog=NorthWind;Persist Security Info=True;User ID=sa;Password=sa";
14        Sy***m.Data.SqlClient.SqlConnection conn = new SqlConnection(strConn);
15        co***Open();
16        DataTable dt2 = co***GetSchema();       
17        Re***nse.Write("数据库 的 架构集合"+"
");
18        Re***nse.Write("");
19        foreach (Sy***m.Data.DataRow row in dt2.Rows)
20        {
21            Re***nse.Write("");
22            foreach (Sy***m.Data.DataColumn col in dt***olumns)
23            {
24                Re***nse.Write("");               
25            }
26            Re***nse.Write("");
27        }     
28        Re***nse.Write("

"+co***olumnName + "	" + row[col]+"

");
29
30        //具体应用 得到某数据库下的用户表名
31        //string strConn = "Data So***e=192.168.0.36;Initial Catalog=NorthWind;Persist Security Info=True;User ID=sa;Password=sa";
32        //Sy***m.Data.SqlClient.SqlConnection conn = new SqlConnection(strConn);
33        //co***Open();
34        string[] strArray = new string[4];
35        strArray[3] = "BASE TABLE";// VIEW
36        DataTable dt3 = co***GetSchema("Tables", strArray);
37        Re***nse.Write("==========================");
38        Re***nse.Write("某数据库下的用户表名");
39        foreach (DataRow dr in dt3.Rows)
40        {
41            Re***nse.Write(dr["TABLE_NAME"].ToString());
42            Re***nse.Write("
");
43        }
44
45    }

http://www.cnblogs.com/freeliver54/archive/2006/12/13/590506.html