开通VIP,畅享免费电子书等14项超值服
首页
好书
留言交流
下载APP
联系客服
2014.02.27
/// <summary>
/// 塗聚文
/// 20140225
/// </summary>
public
partial
class
DatatablePage : System.Web.UI.Page
{
/// 测试 分页数据
DataTable pageDt;
///
void
geovinduDt()
pageDt =
new
DataTable();
pageDt.Columns.Add(
"id"
,
typeof
(
int
));
"ddno"
string
"dd"
//dtyhdd.Rows.Add("1", "n1");
//dtyhdd.Rows.Add("2", "n2");
for
i = 1; i <= 31; i++)
//保存到内存表中
DataRow tr =
this
.pageDt.NewRow();
tr[
] = i;
] = i.ToString();
] = i.ToString() +
"内容"
;
pageDt.Rows.Add(tr);
}
/// 隐患地点共分多少页
verypage = 0;
/// 隐患当前页
currentPage = 0;
/// 每页显示多少数据
PageSize = 1;
/// <param name="sender"></param>
/// <param name="e"></param>
protected
Page_Load(
object
sender, EventArgs e)
if
(!IsPostBack)
(!
.IsNullOrEmpty(Request.QueryString[
"page"
]))
currentPage =
.Parse(Request.QueryString[
]);
currentPage++;
.TextBox1.Text = currentPage.ToString();
//【初始化数据】
geovinduDt();
//【执行分页显示】
//每次显示10条数据 需要多少次
verypage = pageDt.Rows.Count / 1;
//是否有余数
numys = pageDt.Rows.Count % 1;
(numys > 0)
//comyhdd.Items.Clear();
(currentPage >= pageDt.Rows.Count)
Button1.Enabled =
false
return
DataRow[] mMatches = pageDt.Select(
"(id="
+ currentPage +
")"
);
//DataRow matches = new DataRow();
strName = mMatches[0][
].ToString();
DataSet pDS =
System.Data.DataSet();
System.Data.DataTable mDT = pageDt.Clone();
mDT.Clear();
//mDT.TableName = mTableName;
//mDT = mDT.Clone();
i = 0; i < mMatches.Length; i++)
mDT.Rows.Add(mMatches[i].ItemArray);
pDS.Tables.Add(mDT);
//1
Repeater1.DataSource = GetPagedTable(pageDt, currentPage, PageSize);
Repeater1.DataBind();
//2
//Repeater1.DataSource = pDS;
//Repeater1.DataBind();
.TextBox1.Text = strName;
//Repeater1.DataSource = GetPagedTable(pageDt, yhdddqi, PageSize);
.Label1.Text = currentPage.ToString() +
"/"
+ verypage;
Button1_Click(
verypage = 1;
answer =
.Empty;
(CheckBoxA.Checked ==
true
)
"A"
(CheckBoxB.Checked ==
.IsNullOrEmpty(answer))
answer = answer +
","
+
"B"
else
(CheckBoxC.Checked ==
"C"
(CheckBoxD.Checked ==
"D"
Jscript.Alert(answer);
Response.Redirect(
"DatatablePage.aspx?page="
+ (currentPage) +
"&name="
+ strName);
/// DataTable分页
/// <param name="dt">DataTable</param>
/// <param name="PageIndex">页索引,注意:从1开始</param>
/// <param name="PageSize">每页大小</param>
/// <returns></returns>
static
DataTable GetPagedTable(DataTable dt,
currentPageIndex,
pageSize)
//判断当前索引
(currentPageIndex == 0)
dt;
//从数据集合拷贝数据
DataTable newdt = dt.Copy();
//数据清空
newdt.Clear();
//开始数据索引 = 当前页-1 x 每页大小
rowbegin = (currentPageIndex - 1) * pageSize;
//结束数据索引 = 当前页 x 每页大小
rowend = currentPageIndex * pageSize;
//开始数据索引 大于等于 当前数据集合大小
(rowbegin >= dt.Rows.Count)
newdt;
//结束数据索引 大于 当前数据集合大小
(rowend > dt.Rows.Count)
rowend = dt.Rows.Count;
//遍历数据
i = rowbegin; i <= rowend - 1; i++)
DataRow newdr = newdt.NewRow();
DataRow dr = dt.Rows[i];
foreach
(DataColumn column
in
dt.Columns)
newdr[column.ColumnName] = dr[column.ColumnName];
newdt.Rows.Add(newdr);
//if (currentPageIndex == 0)
//{
//return dt;
//}
//DataTable newdt = dt.Clone();// dt.Copy();
//int rowbegin = (currentPageIndex - 1) * pageSize;//当前页的第一条数据在dt中的位置
//int rowend = currentPageIndex * pageSize;//当前页的最后一条数据在dt中的位置
//if (rowbegin >= dt.Rows.Count)
// return newdt;
//if (rowend > dt.Rows.Count)
// rowend = dt.Rows.Count;
//DataView dv = dt.DefaultView;
//for (int i = rowbegin; i <= rowend - 1; i++)
// newdt.ImportRow(dv[i].Row);
//return newdt;
<%@ Page Language=
"C#"
AutoEventWireup=
"true"
CodeBehind=
"DatatablePage.aspx.cs"
Inherits=
"ShoppingDeals.Admin.VipHKExamSystem.DatatablePage"
%>
<!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"
><meta http-equiv=
"Content-Type"
content=
"text/html; charset=utf-8"
/>
<title>Datatable paging,Repeater with Paging </title>
<meta name=
"author"
"塗聚文"
</head>
<body>
<form id=
"form1"
runat=
<div> <table style=
"width:100%;"
<tbody>
<tr>
<td>id</td>
<td>name:</td>
</tr>
<asp:Repeater ID=
"Repeater1"
<ItemTemplate>
<td><%# Eval(
).ToString()%></td>
</ItemTemplate>
</asp:Repeater> </tbody>
</table> <div><b>選擇答案:</b><asp:CheckBox ID=
"CheckBoxA"
Text=
/><asp:CheckBox ID=
"CheckBoxB"
"CheckBoxC"
"CheckBoxD"
/></div>
<asp:TextBox ID=
"TextBox1"
></asp:TextBox>
<asp:Button ID=
"Button1"
"下一頁"
OnClick=
"Button1_Click"
<asp:Label ID=
"Label1"
"Label"
></asp:Label></div>
</form>
</body>
</html>
微信登录中...请勿关闭此页面