在Web服务里代码

/// 
/// WebService1 的摘要说明/// 
[WebService(Namespace = "http://tempuri.org/")][WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)][System.ComponentModel.ToolboxItem(false)]// 若要允许使用 ASP.NET AJAX 从脚本中调用此 Web 服务，请取消对下行的注释。[System.Web.Script.Services.ScriptService]public class WebService1 : System.Web.Services.WebService{[WebMethod]public string HelloWorld(){return "Hello World";}[WebMethod]public List GetListAjax(int pageindex,int pagesize) {BLL.T_Student bll = new BLL.T_Student();int count= bll.GetRecordCount("");DataTable dt = bll.GetListDataTable(pageindex, pagesize);List li = new List();string name = "";int age;string gender = "";foreach (DataRow row in dt.Rows){name = row["sName"].ToString();age =Convert.ToInt32(row["sAge"]);gender = row["sGender"].ToString();Model.T_Student model = new Model.T_Student();model.sName = name;model.sAge = age;model.sGender = gender;li.Add(model);}return li;}[WebMethod]public int GetLastPageindex(int pagesize){BLL.T_Student bnews = new BLL.T_Student();int totalcount = bnews.GetRecordCount("");if (totalcount % pagesize == 0){return totalcount / pagesize;}else{return totalcount / pagesize + 1;}}}

html页代码

第一页上一页下一页最后一页Go

Bll层

private readonly 分页一小时内完成.SQLServerDAL.T_Student dal = new SQLServerDAL.T_Student();
public T_Student()
{}public DataTable GetListDataTable(int PageIndex, int PageSize) {return dal.GetListDataTable(PageSize, PageIndex);}

DAL层

public DataTable GetListDataTable(int PageSize, int PageIndex){SqlParameter[] parameters = {
new SqlParameter("@sindex", SqlDbType.Int),
new SqlParameter("@ssize", SqlDbType.Int),
};parameters[0].Value = PageIndex;parameters[1].Value = PageSize;return DbHelperSQL.RunProcedureDataTable("usp_student1", parameters);}

DataAccess

public static DataTable RunProcedureDataTable(string storedProcName, IDataParameter[] parameters){SqlConnection connection = new SqlConnection(connectionString);DataTable dt = new DataTable();connection.Open();SqlCommand command = BuildQueryCommand(connection, storedProcName, parameters);command.CommandType = CommandType.StoredProcedure;SqlDataAdapter adapter = new SqlDataAdapter(command);adapter.Fill(dt);connection.Close();return dt;}