DataList自定义分页(转)
来源:互联网 发布:linux 字体目录 编辑:程序博客网 时间:2024/04/28 19:40
<asp:datalist id="mydatalist" Runat="server">
<ItemTemplate>
<TABLE id="Table2" cellSpacing="0" cellPadding="0" width="400" border="0">
<TR>
<TD width="15"> </TD>
<TD width="85" height="22"> </TD>
<TD width="211"> </TD>
<TD width="80"> </TD>
</TR>
<TR>
<TD width="15"> </TD>
<TD class="ziti" bgColor="#f7eeef" colSpan="3" height="22">回 复:</TD>
</TR>
<TR>
<TD width="15"></TD>
<TD bgColor="#666666" colSpan="3" height="1"></TD>
</TR>
<TR>
<TD width="15" rowSpan="3"> </TD>
<TD class="ziti" vAlign="top" width="85" rowSpan="3">发贴人姓名<BR>
级别:<BR>
</TD>
<TD class="ziti" vAlign="top" height="22"><IMG height="20" src="images.files/face0.gif" width="20">发表于:<%...# DataBinder.Eval(Container.DataItem,"remessage_time") %></TD>
<TD class="brown" width="80">回复</TD>
</TR>
<TR>
<TD colSpan="2" height="5"></TD>
</TR>
<TR>
<TD><%...# DataBinder.Eval(Container.DataItem,"remessage_context") %></TD>
<TD width="80"> </TD>
<TD width="4"> </TD>
</TR>
<TR>
<TD width="15"></TD>
<TD bgColor="#666666" colSpan="3" height="1"></TD>
</TR>
</TABLE>
</ItemTemplate>
</asp:datalist>
<TABLE id="Table3" cellSpacing="0" cellPadding="0" width="400" border="0">
<TR>
<TD width="15"> </TD>
<TD class="ziti" colSpan="3" height="22">共有<asp:label id="lblRecordCount" runat="server" ForeColor="red"></asp:label>条记录
当前为<asp:label id="lblCurrentPage" runat="server" ForeColor="red"></asp:label>/<asp:label id="lblPageCount" runat="server" ForeColor="red"></asp:label>页
<asp:linkbutton id="lbnPrevPage"runat="server" Text="上一页" CommandName="prev" OnCommand="Page_OnClick"></asp:linkbutton><asp:linkbutton id="lbnNextPage" runat="server" Text="下一页" CommandName="next" OnCommand="Page_OnClick">下一页</asp:linkbutton></TD>
<TR>
</table>
<ItemTemplate>
<TABLE id="Table2" cellSpacing="0" cellPadding="0" width="400" border="0">
<TR>
<TD width="15"> </TD>
<TD width="85" height="22"> </TD>
<TD width="211"> </TD>
<TD width="80"> </TD>
</TR>
<TR>
<TD width="15"> </TD>
<TD class="ziti" bgColor="#f7eeef" colSpan="3" height="22">回 复:</TD>
</TR>
<TR>
<TD width="15"></TD>
<TD bgColor="#666666" colSpan="3" height="1"></TD>
</TR>
<TR>
<TD width="15" rowSpan="3"> </TD>
<TD class="ziti" vAlign="top" width="85" rowSpan="3">发贴人姓名<BR>
级别:<BR>
</TD>
<TD class="ziti" vAlign="top" height="22"><IMG height="20" src="images.files/face0.gif" width="20">发表于:<%...# DataBinder.Eval(Container.DataItem,"remessage_time") %></TD>
<TD class="brown" width="80">回复</TD>
</TR>
<TR>
<TD colSpan="2" height="5"></TD>
</TR>
<TR>
<TD><%...# DataBinder.Eval(Container.DataItem,"remessage_context") %></TD>
<TD width="80"> </TD>
<TD width="4"> </TD>
</TR>
<TR>
<TD width="15"></TD>
<TD bgColor="#666666" colSpan="3" height="1"></TD>
</TR>
</TABLE>
</ItemTemplate>
</asp:datalist>
<TABLE id="Table3" cellSpacing="0" cellPadding="0" width="400" border="0">
<TR>
<TD width="15"> </TD>
<TD class="ziti" colSpan="3" height="22">共有<asp:label id="lblRecordCount" runat="server" ForeColor="red"></asp:label>条记录
当前为<asp:label id="lblCurrentPage" runat="server" ForeColor="red"></asp:label>/<asp:label id="lblPageCount" runat="server" ForeColor="red"></asp:label>页
<asp:linkbutton id="lbnPrevPage"runat="server" Text="上一页" CommandName="prev" OnCommand="Page_OnClick"></asp:linkbutton><asp:linkbutton id="lbnNextPage" runat="server" Text="下一页" CommandName="next" OnCommand="Page_OnClick">下一页</asp:linkbutton></TD>
<TR>
</table>
CS代码:
using System.Data.SqlClient;
using System.Configuration;
protected System.Web.UI.WebControls.Label lblmcontent;
protected System.Web.UI.WebControls.Label lblmessagetime;
protected System.Web.UI.WebControls.Label lblmkind;
protected System.Web.UI.WebControls.Label lblmauthor;
protected System.Web.UI.WebControls.Label lblmessagetitle;
protected System.Web.UI.WebControls.DataList mydatalist;
protected System.Web.UI.HtmlControls.HtmlForm Form1;
int PageSize,RecordCount,PageCount,CurrentPage;
protected System.Web.UI.WebControls.Label lblCurrentPage;
protected System.Web.UI.WebControls.Label lblPageCount;
protected System.Web.UI.WebControls.LinkButton lbnPrevPage;
protected System.Web.UI.WebControls.Label lblRecordCount;
protected System.Web.UI.WebControls.LinkButton lbnNextPage;
private void Page_Load(object sender, System.EventArgs e)
...{
// 在此处放置用户代码以初始化页面
PageSize = 2;
SqlConnection con=new SqlConnection();
con.ConnectionString=ConfigurationSettings.AppSettings["ConnectionString"];
SqlCommand cmd=new SqlCommand();
cmd.CommandText="select message_title,message_content,message_content,message_time,message_author from message where message_id= '"+Request.QueryString["id"]+"'";
cmd.Connection=con;
con.Open();
if(!Page.IsPostBack)
...{
//设定PageSize
SqlDataReader reader=cmd.ExecuteReader();
if(reader.Read())
...{
this.lblmauthor.Text=Convert.ToString(reader["message_author"]);
this.lblmcontent.Text=Convert.ToString(reader["message_content"]);
this.lblmessagetime.Text=Convert.ToString(reader["message_time"]);
this.lblmessagetitle.Text=Convert.ToString(reader["message_title"]);
}
reader.Close();
ListBind();
CurrentPage = 0;
ViewState["PageIndex"] = 0;
//计算总共有多少记录
RecordCount = CalculateRecord();
lblRecordCount.Text = RecordCount.ToString();
//计算总共有多少页
//float pagetemp=0;
if((RecordCount%PageSize)==0)
PageCount = (RecordCount/PageSize);
else
PageCount = (RecordCount/PageSize)+1;
lblPageCount.Text = PageCount.ToString();
ViewState["PageCount"] = PageCount;
}
}
//****************************
public int CalculateRecord()
...{
int intCount;
SqlConnection recon=new SqlConnection();
recon.ConnectionString=ConfigurationSettings.AppSettings["ConnectionString"];
SqlCommand recmd=new SqlCommand();
recmd.CommandText="select count(*) as co from remessage where remessage_fatherid = '"+Request.QueryString["id"]+"'";
recmd.Connection=recon;
recon.Open();
SqlDataReader reader1=recmd.ExecuteReader();
if(reader1.Read())
...{
intCount = Int32.Parse(reader1["co"].ToString());
}
else
...{
intCount = 0;
}
reader1.Close();
return intCount;
}
ICollection CreateSource()
...{
int StartIndex;
SqlConnection recon=new SqlConnection();
recon.ConnectionString=ConfigurationSettings.AppSettings["ConnectionString"];
//设定导入的起终地址
StartIndex = CurrentPage*PageSize;
string strSel = "select * from remessage where remessage_fatherid = '"+Request.QueryString["id"]+"'";
DataSet ds = new DataSet();
SqlDataAdapter MyAdapter = new SqlDataAdapter(strSel, recon);
MyAdapter.Fill(ds,StartIndex,PageSize,"remessage");
return ds.Tables["remessage"].DefaultView;
}
public void ListBind()
...{
this.mydatalist.DataSource = CreateSource();
this.mydatalist.DataBind();
lbnNextPage.Enabled = true;
lbnPrevPage.Enabled = true;
if(CurrentPage==(PageCount-1)) lbnNextPage.Enabled = false;
if(CurrentPage==0) lbnPrevPage.Enabled = false;
lblCurrentPage.Text = (CurrentPage+1).ToString();
}
public void Page_OnClick(Object sender,CommandEventArgs e)
...{
CurrentPage = (int)ViewState["PageIndex"];
PageCount = (int)ViewState["PageCount"];
string cmd = e.CommandName;
//判断cmd,以判定翻页方向
switch(cmd)
...{
case "next":
if(CurrentPage<(PageCount-1))
...{
CurrentPage++;
}
break;
case "prev":
if(CurrentPage>0) CurrentPage--;
break;
}
ViewState["PageIndex"] = CurrentPage;
ListBind();
}
using System.Configuration;
protected System.Web.UI.WebControls.Label lblmcontent;
protected System.Web.UI.WebControls.Label lblmessagetime;
protected System.Web.UI.WebControls.Label lblmkind;
protected System.Web.UI.WebControls.Label lblmauthor;
protected System.Web.UI.WebControls.Label lblmessagetitle;
protected System.Web.UI.WebControls.DataList mydatalist;
protected System.Web.UI.HtmlControls.HtmlForm Form1;
int PageSize,RecordCount,PageCount,CurrentPage;
protected System.Web.UI.WebControls.Label lblCurrentPage;
protected System.Web.UI.WebControls.Label lblPageCount;
protected System.Web.UI.WebControls.LinkButton lbnPrevPage;
protected System.Web.UI.WebControls.Label lblRecordCount;
protected System.Web.UI.WebControls.LinkButton lbnNextPage;
private void Page_Load(object sender, System.EventArgs e)
...{
// 在此处放置用户代码以初始化页面
PageSize = 2;
SqlConnection con=new SqlConnection();
con.ConnectionString=ConfigurationSettings.AppSettings["ConnectionString"];
SqlCommand cmd=new SqlCommand();
cmd.CommandText="select message_title,message_content,message_content,message_time,message_author from message where message_id= '"+Request.QueryString["id"]+"'";
cmd.Connection=con;
con.Open();
if(!Page.IsPostBack)
...{
//设定PageSize
SqlDataReader reader=cmd.ExecuteReader();
if(reader.Read())
...{
this.lblmauthor.Text=Convert.ToString(reader["message_author"]);
this.lblmcontent.Text=Convert.ToString(reader["message_content"]);
this.lblmessagetime.Text=Convert.ToString(reader["message_time"]);
this.lblmessagetitle.Text=Convert.ToString(reader["message_title"]);
}
reader.Close();
ListBind();
CurrentPage = 0;
ViewState["PageIndex"] = 0;
//计算总共有多少记录
RecordCount = CalculateRecord();
lblRecordCount.Text = RecordCount.ToString();
//计算总共有多少页
//float pagetemp=0;
if((RecordCount%PageSize)==0)
PageCount = (RecordCount/PageSize);
else
PageCount = (RecordCount/PageSize)+1;
lblPageCount.Text = PageCount.ToString();
ViewState["PageCount"] = PageCount;
}
}
//****************************
public int CalculateRecord()
...{
int intCount;
SqlConnection recon=new SqlConnection();
recon.ConnectionString=ConfigurationSettings.AppSettings["ConnectionString"];
SqlCommand recmd=new SqlCommand();
recmd.CommandText="select count(*) as co from remessage where remessage_fatherid = '"+Request.QueryString["id"]+"'";
recmd.Connection=recon;
recon.Open();
SqlDataReader reader1=recmd.ExecuteReader();
if(reader1.Read())
...{
intCount = Int32.Parse(reader1["co"].ToString());
}
else
...{
intCount = 0;
}
reader1.Close();
return intCount;
}
ICollection CreateSource()
...{
int StartIndex;
SqlConnection recon=new SqlConnection();
recon.ConnectionString=ConfigurationSettings.AppSettings["ConnectionString"];
//设定导入的起终地址
StartIndex = CurrentPage*PageSize;
string strSel = "select * from remessage where remessage_fatherid = '"+Request.QueryString["id"]+"'";
DataSet ds = new DataSet();
SqlDataAdapter MyAdapter = new SqlDataAdapter(strSel, recon);
MyAdapter.Fill(ds,StartIndex,PageSize,"remessage");
return ds.Tables["remessage"].DefaultView;
}
public void ListBind()
...{
this.mydatalist.DataSource = CreateSource();
this.mydatalist.DataBind();
lbnNextPage.Enabled = true;
lbnPrevPage.Enabled = true;
if(CurrentPage==(PageCount-1)) lbnNextPage.Enabled = false;
if(CurrentPage==0) lbnPrevPage.Enabled = false;
lblCurrentPage.Text = (CurrentPage+1).ToString();
}
public void Page_OnClick(Object sender,CommandEventArgs e)
...{
CurrentPage = (int)ViewState["PageIndex"];
PageCount = (int)ViewState["PageCount"];
string cmd = e.CommandName;
//判断cmd,以判定翻页方向
switch(cmd)
...{
case "next":
if(CurrentPage<(PageCount-1))
...{
CurrentPage++;
}
break;
case "prev":
if(CurrentPage>0) CurrentPage--;
break;
}
ViewState["PageIndex"] = CurrentPage;
ListBind();
}
- DataList自定义分页(转)
- DataList自定义分页
- DataList自定义分页
- datalist自定义分页
- DataList自定义分页
- 自定义datalist分页
- DataList自定义分页
- asp.net datalist自定义分页
- 自定义分页(适用于DataList,Repeater)
- DataList中的自定义分页和编辑
- 关于DataList的自定义分页问题
- dede自定义留言分页,datalist运用实例
- NET DataList 分页源码 (转)
- datalist分页
- DataList 分页
- datalist分页
- DataList分页
- datalist 分页
- 开始思考~~~~~
- .NET泛型基础
- 猎头公司如何进行背景调查
- genexus 中combox 如何关联数据(从数据库读取数据)
- 在rabbit上实验字节对齐
- DataList自定义分页(转)
- 春意
- 分享一套基于WEB的ERP級專業權限管理繫統
- 原创笑话一则,软盘如何变硬盘
- .Net平台开发的技术规范与实践精华总结
- 续 dll using in C#
- 开始最重要
- VC++动态链接库(DLL)编程深入浅出 (全)
- 简单的c#文本文件读写