📄 chaxun1.aspx
字号:
<%@ Page Language="C#" ContentType="text/html" debug=true ResponseEncoding="gb2312" %>
<%@ Import Namespace="System.Data"%>
<%@ Import Namespace="System.Data.OleDb"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<script language="c#" runat="server">
public void page_load(Object src,EventArgs e)
{
string cstring="provider=Microsoft.Jet.OleDb.4.0;Data Source="+Server.MapPath(".")+"..\\data.mdb;";
string sql="select * from data where 日期>= #" + DateTime.Parse(Request["id3"]) + "# AND 日期<= #" + DateTime.Parse(Request["id4"]) + "#" ;
if (Request["id"] != "")
{
sql += " AND 姓名=" + Request["id"] ;
}
OleDbConnection Mycon=new OleDbConnection(cstring);
Mycon.Open();
OleDbDataAdapter adapter=new OleDbDataAdapter(sql,Mycon);
DataSet ds=new DataSet();
adapter.Fill(ds,"data");
PagedDataSource a=new PagedDataSource();
a.DataSource=ds.Tables[0].DefaultView;
a.AllowPaging=true;
a.PageSize=15;
int curpage;
if (Request.QueryString["page"]!=null)
curpage=Convert.ToInt32(Request.QueryString["page"]);
else
curpage=1;
a.CurrentPageIndex=curpage-1;
lb1.Text="当前页"+curpage.ToString();
if(!a.IsFirstPage)
lnkprev.NavigateUrl=Request.CurrentExecutionFilePath+"?page="+Convert.ToString(curpage-1);
if(!a.IsLastPage)
lnknext.NavigateUrl=Request.CurrentExecutionFilePath+"?page="+Convert.ToString(curpage+1);
dp.DataSource=a;
dp.DataBind();
}
</script>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<link href="css.css" rel="stylesheet" type="text/css">
</head>
<body class=bodycss>
<form name="form1" method="post" action="chaxun.aspx" runat="server">
<asp:Repeater id="dp" runat="server">
<headertemplate>
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="1" class="unnamed3">
<tr><td width="10%" class="tablemain3" align="center">
姓名
</td><td width="10%" class="tablemain3" align="center">
项目
</td><td width="10%" class="tablemain3" align="center">
单价
</td><td width="10%" class="tablemain3" align="center">
数量
</td><td width="10%" class="tablemain3" align="center">
总计
</td><td width="30%" class="tablemain3" align="center">
日期
</td></tr>
</table>
</headertemplate>
<itemtemplate>
<table>
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="1" class="unnamed3">
<tr><td align="center" class="tablemain1" width="10%">
<%#DataBinder.Eval(Container.DataItem,"姓名")%>
</td><td align="center" class="tablemain1" width="10%">
<%#DataBinder.Eval(Container.DataItem,"项目")%>
</td><td align="center" class="tablemain1" width="10%">
<%#DataBinder.Eval(Container.DataItem,"单价")%>(元)
</td><td align="center" class="tablemain1" width="10%">
<%#DataBinder.Eval(Container.DataItem,"数量")%>
</td><td align="center" class="tablemain1" width="10%">
<%#DataBinder.Eval(Container.DataItem,"总计")%>(元)
</td><td align="center" class="tablemain1" width="30%">
<%#DataBinder.Eval(Container.DataItem,"日期")%>
</td></tr>
</table>
</itemtemplate>
</asp:Repeater>
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="1" class="unnamed3">
<tr><td align="center" class="tablemain3" >
<asp:label id="lb1" runat="server"></asp:label>
<asp:HyperLink id="lnkprev" runat="server">上一页</asp:HyperLink>
<asp:HyperLink id="lnknext" runat="server">下一页</asp:HyperLink>
</td></tr>
</table>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -