asp.net +access 如何分页(不用控件)
因为要做一个Flash留言板，要用asp.net连接access，输出xml，然后与flah进行通信。
问题是asp.net连接数据库不知道如何分页，
有人有没有现成的flash+asp.net+access的留言板，可以用来借鉴的。如过没有，大家说清楚怎么分页，最好说明白，我是菜鸟呀
[解决办法]
www.51aspx.com
===建议楼主去看看
[解决办法]
一个笨方法分批读取
第一页：读取前10个
下一页：NEXT10个后，再读取10个
读取第N页：NEXT 10*N个后，读取10个
以前用过，不过不适合大量的数据库
[解决办法]
用存储过程吧.
思路：从publish 表中取出第 n 条到第 m 条的记录：
SELECT TOP m-n+1 *
FROM publish
WHERE (id NOT IN
(SELECT TOP n-1 id
FROM publish))
- SQL code
CREATE PROCEDURE pagination3@tblName varchar(255) , -- 表名@strGetFields varchar(1000) = '*', -- 需要返回的列 @fldName varchar(255)='', -- 排序的字段名@PageSize int = 10, -- 页尺寸@PageIndex int = 1, -- 页码@doCount bit = 0, -- 返回记录总数, 非 0 值则返回@OrderType bit = 0, -- 设置排序类型, 非 0 值则降序@strWhere varchar(1500) = '' -- 查询条件 (注意: 不要加 where)ASdeclare @strSQL varchar(5000) -- 主语句declare @strTmp varchar(110) -- 临时变量declare @strOrder varchar(400) -- 排序类型if @doCount != 0 begin if @strWhere !='' set @strSQL = 'select count(*) Total from where '+@strWhere else set @strSQL = 'select count(*) Total from ' end --以上代码的意思是如果@doCount传递过来的不是0，就执行总数统计。以下的所有代码都是@doCount为0的情况：else begin if @OrderType != 0 begin set @strTmp = '<(select min' set @strOrder = ' order by [' + @fldName +'] desc' --如果@OrderType不是0，就执行降序，这句很重要！ end else begin set @strTmp = '>(select max' set @strOrder = ' order by [' + @fldName +'] asc' end if @PageIndex = 1 begin if @strWhere != '' set @strSQL = 'select top ' + str(@PageSize) +' '+@strGetFields+ ' from [' + @tblName + '] where ' + @strWhere + ' ' + @strOrder else set @strSQL = 'select top ' + str(@PageSize) +' '+@strGetFields+ ' from ['+ @tblName + '] '+ @strOrder --如果是第一页就执行以上代码，这样会加快执行速度 end else begin set @strSQL = 'select top ' + str(@PageSize) +' '+@strGetFields+ ' from [' + @tblName + '] where [' + @fldName + ']' + @strTmp + '([' + @fldName + ']) from (select top ' + str((@PageIndex-1)*@PageSize) + ' [' + @fldName + '] from [' + @tblName + ']' + @strOrder + ') as tblTmp)' + @strOrder if @strWhere != '' set @strSQL = 'select top ' + str(@PageSize) +' '+@strGetFields+ ' from [' + @tblName + '] where [' + @fldName + ']' + @strTmp + '([' + @fldName + ']) from (select top ' + str((@PageIndex-1)*@PageSize) + ' [' + @fldName + '] from [' + @tblName + '] where ' + @strWhere + ' ' + @strOrder + ') as tblTmp) and ' + @strWhere + ' ' + @strOrder end endexec (@strSQL)--print @strSQLGO
[解决办法]
http://www.svnhost.cn/Article/Detail-75.shtml
[解决办法]
- C# code
///先定义一个分页的类
#region Saga.LiveChain.FlyOA.CommonTool.SetPage
using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.Common;
using System.Globalization;
using System.Configuration;
using System.Collections;
using System.Diagnostics;
using System.Text;
using System.Web.UI.WebControls;
namespace CommonTool.SetPage
{
public class SetPage
{
/// <summary>
/// pagination
/// </summary>
/// <param name="dt"> </param>
/// <param name="PageLabel"> </param>
/// <param name="SelectPageType"> </param>
/// <param name="TotalPagelb"> </param>
/// <param name="PreButton"> </param>
/// <param name="NextButton"> </param>
/// <param name="FirstButton"> </param>
/// <param name="LastButton"> </param>
/// <returns> </returns>
public PagedDataSource BindGrid(DataTable dt, Label PageLabel, DropDownList SelectPageType, Label TotalPagelb, LinkButton PreButton, LinkButton NextButton, LinkButton FirstButton, LinkButton LastButton)
{
PreButton.CausesValidation = false;
NextButton.CausesValidation = false;
FirstButton.CausesValidation = false;
LastButton.CausesValidation = false;
PagedDataSource ps = new PagedDataSource();
if (dt != null)
{
if (PageLabel.Text == "")
{
PageLabel.Text = "1";
}
int curpage = Convert.ToInt32(PageLabel.Text);
ps.DataSource = dt.DefaultView;
ps.AllowPaging = true;
ps.PageSize = Convert.ToInt32(SelectPageType.SelectedValue);
TotalPagelb.Text = ps.PageCount.ToString();
PreButton.Enabled = true;
NextButton.Enabled = true;
ps.CurrentPageIndex = curpage - 1;
if (curpage == 1)
{
PreButton.Enabled = false;
FirstButton.Enabled = false;
}
else
{
PreButton.Enabled = true;
FirstButton.Enabled = true;
}
if (curpage == ps.PageCount)
{
NextButton.Enabled = false;
LastButton.Enabled = false;
}
else
{
NextButton.Enabled = true;
LastButton.Enabled = true;
}
}
return ps;
}
/// <summary>
/// pagination when Error
/// </summary>
/// <param name="dt"> </param>
/// <param name="PageLabel"> </param>
/// <param name="SelectPageType"> </param>
/// <param name="TotalPagelb"> </param>
/// <param name="PreButton"> </param>
/// <param name="NextButton"> </param>
/// <param name="FirstButton"> </param>
/// <param name="LastButton"> </param>
/// <returns> </returns>
public PagedDataSource BindGridDelete(DataTable dt, Label PageLabel, DropDownList SelectPageType, Label TotalPagelb, LinkButton PreButton, LinkButton NextButton, LinkButton FirstButton, LinkButton LastButton)
{
PreButton.CausesValidation = false;
NextButton.CausesValidation = false;
FirstButton.CausesValidation = false;
LastButton.CausesValidation = false;
PagedDataSource ps = new PagedDataSource();
if (dt != null)
{
int curpage = Convert.ToInt32(PageLabel.Text);
ps.DataSource = dt.DefaultView;
ps.AllowPaging = true;
ps.PageSize = Convert.ToInt32(SelectPageType.SelectedValue);
TotalPagelb.Text = ps.PageCount.ToString();
if (PageLabel.Text == "2")
{
FirstButton.Enabled = false;
PreButton.Enabled = false;
}
else
{
FirstButton.Enabled = true;
PreButton.Enabled = true;
}
NextButton.Enabled = false;
LastButton.Enabled = false;
ps.CurrentPageIndex = ps.PageCount - 1;
PageLabel.Text = Convert.ToString(curpage - 1);
}
return ps;
}
}
}
#endregion
[解决办法]
access 好象不能用存储过程
可以先处理sql 语句 根据条件把sql语句写好了 再传进去不就可以分页 了
select top ...