<%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.SqlClient" %> <%@ page language="C#" %> <script runat="server"> void Page_Load(object sender, EventArgs e) { string connString = "Northwind的连接串"; SqlConnection conn = new SqlConnection(connString); conn.StatisticsEnabled = true; conn.ResetStatistics(); conn.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM Orders", conn); SqlDataReader reader = cmd.ExecuteReader(); reader.Close(); conn.Close(); Hashtable ht = (Hashtable)conn.RetrieveStatistics(); foreach (string key in ht.Keys) { Label1.Text += "Key: " + key + " = " + ht[key] + "<BR />"; } } </script> <html> <head id="Head1" runat="server"> <title>Untitled Page</title> </head> <body> <form id="Form1" runat="server" autocomplete="on"> <asp:Label ID="Label1" Runat="server" Text=""></asp:Label> </form> </body> </html> |