建立数据库 website 家里表movies
在web.config中配置好连接字符串:
<connectionStrings>
<add name="Movies_Conn" connectionString="Data Source=./express;Initial Catalog=WebSiteTest;User ID=sa;Password=123;Persist Security Info=True;"
providerName="System.Data.SqlClient" />
</connectionStrings>
页面代码:
<%@ Page Language="C#" %>
<%@ Import Namespace ="System.Data.SqlClient" %>
<%@ Import Namespace ="System.Web.Configuration" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat ="server" >
void Page_Load()
{
string _connectionString = WebConfigurationManager.ConnectionStrings["Movies_Conn"].ConnectionString;
SqlConnection con = new SqlConnection(_connectionString );
SqlCommand cmd = new SqlCommand("Waitfor Delay '0:0:03';select title,director from Movies",con);
con.StatisticsEnabled = true;
using (con)
{
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
}
grdStats.DataSource = con.RetrieveStatistics();
grdStats.DataBind();
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="head1" runat="server">
<style type ="text/css" >
td,th
{
padding:4px 20px;
}
</style>
<title>显示所有的状态信息</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<h1 >Connection Statistics</h1>
<asp:GridView ID="grdStats" AutoGenerateColumns ="False" runat ="server" >
<Columns >
<asp:BoundField DataField ="Key" HeaderText ="Key" />
<asp:BoundField DataField ="Value" HeaderText ="Value" />
</Columns>
</asp:GridView>
</div>
</form>
</body>
</html>