62,271
社区成员
发帖
与我相关
我的任务
分享Student_InfoTableAdapter adapter = new Student_InfoTableAdapter();
DataTable S_Info = adapter.GetData();
StringBuilder Info_B = new StringBuilder();
Info_B.Append("<table ><tr><td>Id</td><td>姓名</td><td>年龄</td><td>学院</td><td>年级</td></tr><tr><td colspan='5'><hr /></td></tr>");
for (int i = 0; i < S_Info.Rows.Count;i++ )
{
Info_B.Append("<tr>");
for (int j = 0; j < S_Info.Columns.Count; j++)
{
string _Info = S_Info.Rows[i][j].ToString();
Info_B.Append("<td>"+_Info+"</td>");
}
Info_B.Append("</tr>");
}
Info_B.Append("</table>");
context.Response.Write(Info_B);<script src="Scripts/jquery-1.4.1.min.js" type="text/javascript"></script>
<script type="text/javascript">
$(function () {
$("#main").load("HandlerStudent_Info_Read.ashx");
});
</script><%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>
<!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 runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
增删改查 纯HTML(c#版)<br />
<br />
<br />
<a href="add.aspx"><img src="要美观请美工或.png"></img>增加</a>
<a href="add.aspx"><img src="自己做按钮图片.png"></img>查询</a>
<br /><hr />
<div id="View" runat="server"></div>
<hr />
<p nowrap="nowrap">总页数<a id="countPage" runat="server">0</a> 当前页数<a id="ThisPage" runat="server">0</a>
<a href="Default2.aspx?page=f">首页</a>
<a href="Default2.aspx?page=n">下一页</a><%-- Default2 为当前页名字 --%>
<a href="Default2.aspx?page=p">上一页</a>
<a href="Default2.aspx?page=e">末页</a></p>
</div>
</form>
</body>
</html>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Text;
public partial class Default2 : System.Web.UI.Page
{
/// <summary>
/// 当前页
/// </summary>
protected int nPage
{
get
{
if (Session["page"] == null)
return 1;
return Convert.ToInt32(Session["page"]);
}
set { Session["page"] = value; }
}
/// <summary>
/// 总页数
/// </summary>
protected int nPageCount
{
get
{
if (Session["PageCount"] == null)
return 1;
return Convert.ToInt32(Session["PageCount"]);
}
set { Session["PageCount"] = value; }
}
/// <summary>
/// 分页大小
/// </summary>
private int nSize = 5;
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["page"] != null)
{
switch (Request.QueryString["page"].ToString())
{
case "p":
setPage(-1);
break;
case "n":
setPage(1);
break;
case "e":
nPage = nPageCount;
break;
default://f
nPage = 1;
break;
}
}
if (Request.QueryString["id"] != null)
{
// 调用删除方法。。删除数据库 该ID记录
}
BindData();
}
private void setPage(int n)
{
if (nPage == nPageCount || nPageCount == 1)
{
if (n > 0)
{
n = 0;
}
}
if (nPage + 1 > nPageCount || nPage - 1 < 1)
{
return;
}
nPage += n;
}
protected void BindData()
{
List<User> list = LUsers();//数据源 测试为泛型 。DataSet 等 一样。
if (list != null && list.Count > 0)
{
nPageCount = (list.Count / nSize) + (list.Count % nSize == 0 ? 0 : 1);
StringBuilder strHtml = new StringBuilder();
strHtml.Append("<ul>");
for (int i = nSize * (nPageCount - nPage); i < list.Count; i++) //分页不好玩。。这里不好处理
{
string s = string.Format("编号:{0},姓名:{1},生日{2}. <a href='修改页面.aspx?id={0}'>修改</a> <a href='本(删除)页面.aspx?id={0}'>删除</a>", list[i].nID, list[i].sName, list[i].dtBriday);
strHtml.Append(string.Format("<li>{0}</li>",s));
}
strHtml.Append("</ul>");
View.InnerHtml = strHtml.ToString();
}
countPage.InnerHtml = nPageCount.ToString();
ThisPage.InnerHtml = nPage.ToString();
}
//测试数据。暂时为查询所用
protected List<User> LUsers()
{
List<User> list = new List<User>();
for (int i = 10; i < 25; i++)
{
User objUser = new User();
objUser.nID = i;
objUser.sName = "名字" + i;
objUser.dtBriday = Convert.ToDateTime("1920-01-01").AddYears(i);
list.Add(objUser);
}
return list;
}
public class User
{
public int nID;
public string sName;
public DateTime dtBriday;
}
}
