得到內網可用的SqlServer 及某數據庫下的表及其他的架構

2019-11-18 16:48:44

字體：大中小

來源：轉載

供稿：網友

1    PRotected void Button1_Click(object sender, EventArgs e)
2    {
3        //得到目前內網可用的SqlServer
4        System.Data.Sql.SqlDataSourceEnumerator instance = SqlDataSourceEnumerator.Instance;
5        DataTable dt1 = instance.GetDataSources();
6        Response.Write("目前內網可用的SqlServer" + "<br/>");
7        foreach (DataRow dr in dt1.Rows)
8        {
9            Response.Write(dr[0].ToString() + "<br/>");
10        }
11        Response.Write("==========================");
12        //得到某數據庫的架構集合
13        string strConn = "Data Source=192.168.0.36;Initial Catalog=NorthWind;Persist Security Info=True;User ID=sa;PassWord=sa";
14        System.Data.SqlClient.SqlConnection conn = new SqlConnection(strConn);
15        conn.Open();
16        DataTable dt2 = conn.GetSchema();
17        Response.Write("數據庫的架構集合"+"<br/>");
18        Response.Write("<table border='1'>");
19        foreach (System.Data.DataRow row in dt2.Rows)
20        {
21            Response.Write("<tr>");
22            foreach (System.Data.DataColumn col in dt2.Columns)
23            {
24                Response.Write("<td>"+col.ColumnName + "</td><td>" + row[col]+"</td>");
25            }
26            Response.Write("<tr/>");
27        }
28        Response.Write("</table>");
29
30        //具體應用得到某數據庫下的用戶表名
31        //string strConn = "Data Source=192.168.0.36;Initial Catalog=NorthWind;Persist Security Info=True;User ID=sa;Password=sa";
32        //System.Data.SqlClient.SqlConnection conn = new SqlConnection(strConn);
33        //conn.Open();
34        string[] strArray = new string[4];
35        strArray[3] = "BASE TABLE";// VIEW
36        DataTable dt3 = conn.GetSchema("Tables", strArray);
37        Response.Write("==========================");
38        Response.Write("某數據庫下的用戶表名");
39        foreach (DataRow dr in dt3.Rows)
40        {
41            Response.Write(dr["TABLE_NAME"].ToString());
42            Response.Write("<br/>");
43        }
44
45    }