c#.net 的一个显示记录！
[
2008/05/20 09:26 | by Else ]
2008/05/20 09:26 | by Else ]
昨天晚上dw坏了，做了一个简单的测试，没有做出来，后来想重新安装，没有想到碰到了一个坏的dw,安装时间超过了我的极限，所以今天来到公司，把这个放出来，
<%@ Page Language="C#" ContentType="text/html" ResponseEncoding="utf-8" %>
<%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,culture=neutral" %>
<MM:DataSet
id="DataSet1"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings["MM_CONNECTION_STRING_conn"] %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings["MM_CONNECTION_DATABASETYPE_conn"] %>'
CommandText='<%# "SELECT * FROM dbo.em" %>'
Debug="true" PageSize="10" CurrentPage='<%# ((Request.QueryString["DataSet1_CurrentPage"] != null) && (Request.QueryString["DataSet1_CurrentPage"].Length > 0)) ? Int32.Parse(Request.QueryString["DataSet1_CurrentPage"]) : 0 %>'
></MM:DataSet>
<MM:PageBind runat="server" PostBackBind="true" />
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<table width="665" border="1">
<tr>
<td>id</td>
<td>password</td>
<td>name</td>
<td>emal</td>
<td>cp_num</td>
</tr>
<ASP:Repeater runat="server" DataSource='<%# DataSet1.DefaultView %>'>
<ItemTemplate>
<tr>
<td><%# DataSet1.FieldValue("ID", Container) %></td>
<td><%# DataSet1.FieldValue("p", Container) %></td>
<td><%# DataSet1.FieldValue("n", Container) %></td>
<td><%# DataSet1.FieldValue("e", Container) %></td>
<td><%# DataSet1.FieldValue("c", Container) %></td>
</tr>
</ItemTemplate>
</ASP:Repeater>
<tr>
<td colspan="5" align="center"><a href="<%# Request.ServerVariables["SCRIPT_NAME"] %>?DataSet1_currentPage=0">首页</a> <a href="<%# Request.ServerVariables["SCRIPT_NAME"] %>?DataSet1_currentPage=<%# Math.Max(DataSet1.CurrentPage - 1, 0) %>">上一页</a> <a href="<%# Request.ServerVariables["SCRIPT_NAME"] %>?DataSet1_currentPage=<%# Math.Min(DataSet1.CurrentPage + 1, DataSet1.LastPage) %>">下一页</a> <a href="<%# Request.ServerVariables["SCRIPT_NAME"] %>?DataSet1_currentPage=<%# DataSet1.LastPage %>">末页</a></td>
</tr>
</table>
</body>
</html>
<%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,culture=neutral" %>
<MM:DataSet
id="DataSet1"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings["MM_CONNECTION_STRING_conn"] %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings["MM_CONNECTION_DATABASETYPE_conn"] %>'
CommandText='<%# "SELECT * FROM dbo.em" %>'
Debug="true" PageSize="10" CurrentPage='<%# ((Request.QueryString["DataSet1_CurrentPage"] != null) && (Request.QueryString["DataSet1_CurrentPage"].Length > 0)) ? Int32.Parse(Request.QueryString["DataSet1_CurrentPage"]) : 0 %>'
></MM:DataSet>
<MM:PageBind runat="server" PostBackBind="true" />
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<table width="665" border="1">
<tr>
<td>id</td>
<td>password</td>
<td>name</td>
<td>emal</td>
<td>cp_num</td>
</tr>
<ASP:Repeater runat="server" DataSource='<%# DataSet1.DefaultView %>'>
<ItemTemplate>
<tr>
<td><%# DataSet1.FieldValue("ID", Container) %></td>
<td><%# DataSet1.FieldValue("p", Container) %></td>
<td><%# DataSet1.FieldValue("n", Container) %></td>
<td><%# DataSet1.FieldValue("e", Container) %></td>
<td><%# DataSet1.FieldValue("c", Container) %></td>
</tr>
</ItemTemplate>
</ASP:Repeater>
<tr>
<td colspan="5" align="center"><a href="<%# Request.ServerVariables["SCRIPT_NAME"] %>?DataSet1_currentPage=0">首页</a> <a href="<%# Request.ServerVariables["SCRIPT_NAME"] %>?DataSet1_currentPage=<%# Math.Max(DataSet1.CurrentPage - 1, 0) %>">上一页</a> <a href="<%# Request.ServerVariables["SCRIPT_NAME"] %>?DataSet1_currentPage=<%# Math.Min(DataSet1.CurrentPage + 1, DataSet1.LastPage) %>">下一页</a> <a href="<%# Request.ServerVariables["SCRIPT_NAME"] %>?DataSet1_currentPage=<%# DataSet1.LastPage %>">末页</a></td>
</tr>
</table>
</body>
</html>
