得到内网可用的SqlServer及某下的表及其他的架构_查询sqlserver下面某个架构的所有表 csdn-CSDN博客

1   protectedvoidButton1_Click(objectsender,EventArgse)
2   {
3       //得到目前内网可用的SqlServer
4       System.Data.Sql.SqlDataSourceEnumeratorinstance=SqlDataSourceEnumerator.Instance;
5       DataTabledt1=instance.GetDataSources();
6       Response.Write("目前内网可用的SqlServer"+"<br/>");
7       foreach(DataRowdrindt1.Rows)
8       {
9           Response.Write(dr[0].ToString()+"<br/>");
10       }
11       Response.Write("==========================");
12       //得到某数据库的架构集合
13       stringstrConn="DataSource=192.168.0.36;InitialCatalog=NorthWind;PersistSecurityInfo=True;UserID=sa;Password=sa";
14       System.Data.SqlClient.SqlConnectionconn=newSqlConnection(strConn);
15       conn.Open();
16       DataTabledt2=conn.GetSchema();
17       Response.Write("数据库的架构集合"+"<br/>");
18       Response.Write("<tableborder='1'>");
19       foreach(System.Data.DataRowrowindt2.Rows)
20       {
21           Response.Write("<tr>");
22           foreach(System.Data.DataColumncolindt2.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       //stringstrConn="DataSource=192.168.0.36;InitialCatalog=NorthWind;PersistSecurityInfo=True;UserID=sa;Password=sa";
32       //System.Data.SqlClient.SqlConnectionconn=newSqlConnection(strConn);
33       //conn.Open();
34       string[]strArray=newstring[4];
35       strArray[3]="BASETABLE";//VIEW
36       DataTabledt3=conn.GetSchema("Tables",strArray);
37       Response.Write("==========================");
38       Response.Write("某数据库下的用户表名");
39       foreach(DataRowdrindt3.Rows)
40       {
41           Response.Write(dr["TABLE_NAME"].ToString());
42           Response.Write("<br/>");
43       }
44
45   }