http://expert.csdn.net/Expert/TopicView1.asp?id=2928057
解决方案 »
- 控件
- 安装部署时SQL脚本出错的问题
- 求救!`
- 以前装了个2003,现在装了2005,担用2005发布网站后,出现以下错误,
- 建立asp.net web应用程序,跳出错误,已经重新安装,还是如此,如何解决,求助
- 我用editplus来编cs编译的时候总是说:
- 新手提问:asp.net中怎样获取上一页中表单的值,还是用request吗?是否还需要其他配置
- 发一个 迅雷的 VS2008 bata2中文版 下载地址
- 通过自己计算机上的.net在别人的计算机创建工程文件怎么做到?
- IIS7 site 下添加application报错
- 500分找Together , 只要能使(不要限时的那种)再开贴给分
- 郁闷的错误,大家帮忙来看看哈!!!!!!!!!!!!!!
AutoEventWireup="false" Inherits="eMeng.Exam.DataGridPaging.DataGridPaging" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<meta content="Visual Basic 7.0" name="CODE_LANGUAGE">
<meta content="JavaScript" name="vs_defaultClientScript">
<meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" runat="server">
<asp:datagrid id="MyDataGrid" runat="server" AutoGenerateColumns="False"
HorizontalAlign="Center" AlternatingItemStyle-BackColor="#eeeeee"
HeaderStyle-BackColor="#aaaadd" Font-Size="8pt" Font-Name="Verdana"
CellSpacing="0" CellPadding="3" GridLines="Both" BorderWidth="1"
BorderColor="black" OnPageIndexChanged="MyDataGrid_Page" PagerStyle-HorizontalAlign="Right"
PagerStyle-Mode="NumericPages" PageSize="5" AllowPaging="True">
<AlternatingItemStyle BackColor="#EEEEEE"></AlternatingItemStyle>
<HeaderStyle BackColor="#AAAADD" Font-Bold="True" HorizontalAlign="Center"></HeaderStyle>
<PagerStyle HorizontalAlign="Right" Mode="NumericPages"></PagerStyle>
<Columns>
<asp:BoundColumn HeaderText="标题" DataField="Title" HeaderStyle-Width="480px">
</asp:BoundColumn>
<asp:BoundColumn HeaderText="发表日期" DataField="CreateDate" DataFormatString="{0:yyyy-MM-dd hh:mm:ss}">
</asp:BoundColumn>
</Columns>
</asp:datagrid>
<p style="FONT-SIZE:9pt" align="center">
<asp:label id="lblPageCount" runat="server"></asp:label>
<asp:label id="lblCurrentIndex" runat="server"></asp:label>
<asp:linkbutton id="btnFirst" onclick="PagerButtonClick" runat="server" Font-Name="verdana"
Font-size="8pt" ForeColor="navy" CommandArgument="0"></asp:linkbutton>
<asp:linkbutton id="btnPrev" onclick="PagerButtonClick" runat="server" Font-Name="verdana"
Font-size="8pt" ForeColor="navy" CommandArgument="prev"></asp:linkbutton>
<asp:linkbutton id="btnNext" onclick="PagerButtonClick" runat="server" Font-Name="verdana"
Font-size="8pt" ForeColor="navy" CommandArgument="next"></asp:linkbutton>
<asp:linkbutton id="btnLast" onclick="PagerButtonClick" runat="server" Font-Name="verdana"
Font-size="8pt" ForeColor="navy" CommandArgument="last"></asp:linkbutton>
</p>
</form>
</body>
</HTML>DataGridPaging.aspx.csusing System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;namespace eMeng.Exam.DataGridPaging
{
/// <summary>
/// DataGridPaging 的摘要说明。
/// </summary>
public class DataGridPaging : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataGrid MyDataGrid;
protected System.Web.UI.WebControls.Label lblPageCount;
protected System.Web.UI.WebControls.Label lblCurrentIndex;
protected System.Web.UI.WebControls.LinkButton btnFirst;
protected System.Web.UI.WebControls.LinkButton btnPrev;
protected System.Web.UI.WebControls.LinkButton btnNext;
protected System.Web.UI.WebControls.LinkButton btnLast;
private OleDbConnection cn = new OleDbConnection();private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
btnFirst.Text = "最首页";
btnPrev.Text = "前一页";
btnNext.Text = "下一页";
btnLast.Text = "最后页";
OpenDatabase();
BindGrid();
}
private void OpenDatabase()
{
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("xxxx.mdb");
cn.Open();
}
private void ShowStats()
{
lblCurrentIndex.Text = "第 " + (MyDataGrid.CurrentPageIndex + 1).ToString() + " 页";
lblPageCount.Text = "总共 " + MyDataGrid.PageCount.ToString() + " 页";
}public void PagerButtonClick(object sender, EventArgs e)
{
string arg = ((LinkButton)sender).CommandArgument.ToString();
switch(arg)
{
case "next":
if (MyDataGrid.CurrentPageIndex < (MyDataGrid.PageCount - 1))
{
MyDataGrid.CurrentPageIndex += 1;
}
break;
case "prev":
if (MyDataGrid.CurrentPageIndex > 0)
{
MyDataGrid.CurrentPageIndex -= 1;
}
break;
case "last":
MyDataGrid.CurrentPageIndex = (MyDataGrid.PageCount - 1);
break;
default:
MyDataGrid.CurrentPageIndex = System.Convert.ToInt32(arg);
break;
}
BindGrid();
ShowStats();
}
public void BindGrid()
{
OleDbConnection myConnection = cn;
DataSet ds = new DataSet();
OleDbDataAdapter adapter = new OleDbDataAdapter("Select Title,CreateDate from Document", myConnection);
adapter.Fill(ds, "Document");
MyDataGrid.DataSource = ds.Tables["Document"].DefaultView;
MyDataGrid.DataBind();
ShowStats();
}
public void MyDataGrid_Page(object sender, DataGridPageChangedEventArgs e)
{
int startIndex ;
startIndex = MyDataGrid.CurrentPageIndex * MyDataGrid.PageSize;
MyDataGrid.CurrentPageIndex = e.NewPageIndex;
BindGrid();
ShowStats();
}#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN:该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);}
#endregion
}
}
2、使用存储过程和使用Sql语句的。
3、计算页数以及最后一页记录的数量。
4、根据导航情况判断前后按钮的显示与否。
5、生成相应的UI以及添加事件。
6、设置CoustomAllowPage = true;我记得好像就这些如果不全请指教!
<form id="Form1" method="post" runat="server">
<asp:datagrid id="DataGrid1" runat="server" AllowPaging="True" Width="100%" PageSize="3">
<AlternatingItemStyle BorderColor="Red" BackColor="#D4D0C8"></AlternatingItemStyle>
<PagerStyle Visible="False"></PagerStyle>
</asp:datagrid>
<!-------------------------------------分页区域------------------------------>
<asp:panel id="panPage" runat="server" Height="16px">
<TABLE width="100%" border="0">
<TR>
<TD align="right">当前
<asp:Label id="labCurPage" runat="server" ForeColor="Red"></asp:Label>/
<asp:Label id="labToTalPage" runat="server" ForeColor="Red"></asp:Label> 页
<!--</TD><TD align="right">-->
<asp:linkbutton id="btnFirst" CommandArgument="btnFirst" Runat="server">首页</asp:linkbutton>
<asp:linkbutton id="btnNext" CommandArgument="btnNext" Runat="server">下一页</asp:linkbutton>
<asp:linkbutton id="btnPrev" CommandArgument="btnPrev" Runat="server">上一页</asp:linkbutton>
<asp:linkbutton id="btnLast" CommandArgument="btnLast" Runat="server">尾页</asp:linkbutton>
<asp:TextBox id="tbPage" runat="server" Width="20px" MaxLength="5" BorderStyle="Groove"></asp:TextBox>
<asp:Button id="btnLink" runat="server" Text="Go"></asp:Button></TD>
</TR>
</TABLE>
</asp:panel>
</form>
参照 回复人: jpusaddam(孤独客) ( ) 信誉:99 2004-04-12 20:52:00 得分:0