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   &n

[1] [2] [3] 下一页