|
bsp; {
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(上一页 [1] [2] [3] 下一页 |
|
|
|
|
|
|
|
