非常感谢,,,最近正在想为做得BBS排序,,刚好用上,,,呵呵,,谢谢了
  回复  引用  查看    

@King_Boy_Hcc
能帮得上兄弟忙就行了^_^
  回复  引用  查看    

呵呵，我也在做，给了点思路。。 不过我是用存储过程做的 = =+！！
  回复  引用  查看    

@メ冰枫ぱ雪
其实也一样的,使用参数一样也可以做到的
  回复  引用  查看    

恩，还真的得感谢下你哈。。

交个朋友好吗。。？

偶的QQ：570389199 ， Popo：lantk@163.com
  回复  引用  查看    

@メ冰枫ぱ雪
当然可以了,我加你QQ
  回复  引用  查看    

你的sql语句是这样写的吗？
USE [AjaxDemo]
GO
/****** 对象: StoredProcedure [dbo].[pageM] 脚本日期: 10/29/2006 01:40:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

create proc [dbo].[pageM]

@Start int,
@PageCount int
as
select top (@PageCount) * from a where id not in (select top (@Start-1) id from a)
  回复  引用  查看    

有没有源码文件下载啊老哥，我是初哥。用不了，不知那里出错。
或能发个源码文件给我吗？wininfo@tom.com谢谢
  回复  引用    

大哥,可以说一下有那些名命空间吗?
我改成这么样,报错,初学.NET的不知道是什么问题.

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Text;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data.SqlClient;


public partial class Search : System.Web.UI.Page
{
private void Page_Load(object sender, System.EventArgs e)
{
if (!Page.IsPostBack)
{
//开始显示第一页
ShowDate(Convert.ToInt64(lblCurrentPage.Text));
}
}

/**//// <summary>
/// 显示数据
/// </summary>
/// <param name="page"></param>
private void ShowDate(long page)
{


/**//*-------------------设置参数------------------*/

string tblName = "db";
string fldName = "id";
string orderStr = "asc";
int PageSize = 10;

/**//*-------------------设置结束------------------*/

SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
conn.Open();
SqlCommand cmd = new SqlCommand("select count(*) from " + tblName,conn);
lblPageCount.Text = Convert.ToString(((int)cmd.ExecuteScalar() / PageSize + 1));
DataGrid1.VirtualItemCount = Convert.ToInt32(lblPageCount.Text);//datadrid每次就显示一页，所有要手动加上总页

string sql = string.Empty;

sql = "select top " + Convert.ToString((page - 1) * PageSize) + " " + fldName + " from " + tblName + " order by " + fldName + " " + orderStr; //排除的记录部分
sql = "select max (" + fldName + ") from ( " + sql + " ) as t"; //得到排除记录里的最大ID号
sql = "select top " + PageSize.ToString() + " * from " + tblName + " where " + fldName + ">(" + sql + ") order by " + fldName + " " + orderStr;

if (page == 1){sql = "select top " + PageSize + " * from " + tblName;lblCurrentPage.Text = "1";}

try
{
SqlDataAdapter da = new SqlDataAdapter(sql,conn);
System.Data.DataSet ds = new DataSet();
da.Fill(ds);
DataGrid1.DataSource = ds.Tables[0].DefaultView;
DataGrid1.DataBind();

conn.Close();

}
catch ( Exception ex)
{
Response.Write(ex.Message.ToString());
}

}

/**//// 首页
private void lbtnFirst_Click(object sender, System.EventArgs e)
{
lblCurrentPage.Text = "1";
ShowDate(1);
}

/**//// 上页
private void lbtnBack_Click(object sender, System.EventArgs e)
{
if (lblCurrentPage.Text != "1")
{
lblCurrentPage.Text = Convert.ToString(Convert.ToInt64(lblCurrentPage.Text) - 1);
ShowDate(Convert.ToInt64(lblCurrentPage.Text));
}
}

/**//// 下页
private void lbtnNext_Click(object sender, System.EventArgs e)
{
if (lblCurrentPage.Text != lblPageCount.Text)
{
lblCurrentPage.Text = Convert.ToString(Convert.ToInt64(lblCurrentPage.Text) + 1);
ShowDate(Convert.ToInt64(lblCurrentPage.Text));
}
}

/**//// 尾页
private void lbtnLast_Click(object sender, System.EventArgs e)
{
lblCurrentPage.Text = lblPageCount.Text;
ShowDate(Convert.ToInt64(lblPageCount.Text));
}

/**//// 跳转
private void btnToPage_Click(object sender, System.EventArgs e)
{
if ( Convert.ToInt64(txtToPage.Text.Trim()) > 0 && Convert.ToInt64(txtToPage.Text.Trim()) < Convert.ToInt64(lblPageCount.Text))
{
lblCurrentPage.Text = txtToPage.Text;
ShowDate(Convert.ToInt64(txtToPage.Text));
}
}

/**//// dataGrid单击的页数
private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
DataGrid1.CurrentPageIndex = e.NewPageIndex;
lblCurrentPage.Text = Convert.ToString(e.NewPageIndex + 1);
ShowDate(e.NewPageIndex + 1);
}
}
  回复  引用    

@游客
不好意思，很久上博客了
命名空间在MSDN Library有详细说明的
从你的命名空间看你使用的是vs2005

你把
SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);

改成：
System.Configuration.ConfigurationManager.AppSettings["ConnectionString"].ToString()


试试看

  回复  引用  查看