getuserinfo.aspx.cs

分页其他人不需帐号就可自由下载此源码

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

public partial class GetUserInfo : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            string str = GetDBData();
            Response.Write(str);
        }
    }

    public string GetDBData()
    {
        int start = 1;
        int end = 10;
        int perPage = 10;
        string orderBy = "usID";
        if (Request.QueryString["startrecord"] != null && Request.QueryString["endrecord"] != null && Request.QueryString["perpage"] != null)
        {
            start = Convert.ToInt32(Request.QueryString["startrecord"].ToString());
            end = Convert.ToInt32(Request.QueryString["endrecord"].ToString());
            perPage = Convert.ToInt32(Request.QueryString["perpage"].ToString());
            if (Request.QueryString["orderBy"] != null)
            {
                orderBy = Request.QueryString["orderBy"].ToString();
            }
        }

        string temp = "";

        SqlConnection conn = new SqlConnection("server=.;uid=sa;pwd=123456;database=tmpDB;");

        DataSet ds = new DataSet();

        string sql = "select count(*) from Userinfo";

        SqlDataAdapter sda = new SqlDataAdapter(sql,conn);

        sda.Fill(ds);

        //start = Math.Min(start, ds.Tables[0].Rows.Count);
        //end = Math.Min(end, ds.Tables[0].Rows.Count);
        int total = (int)Math.Ceiling(Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString()) / (double)perPage);


        sql = "select top " + perPage + " usID,usNickName,usName,usPwd,usQus ,usAns,usQQ,usEmail,usScore,usOnLine from UserInfo where usID not in (select top "+ (start-1) +" usID from UserInfo order by " + orderBy + " desc) order by " + orderBy + " desc";

        sda = new SqlDataAdapter(sql, conn);

        DataSet dSet = new DataSet();

        sda.Fill(dSet);

        temp += "totalPage = " + total + ";";
        temp += "dataStore = [";

        //for (int i = start - 1; i < end; i++)
        //{
        //    DataRow dr = ds.Tables[0].Rows[i];
        foreach (DataRow dr in dSet.Tables[0].Rows)
        {
            temp += "\"<tr><td>" + dr[0].ToString() + "</td><td>" +
                    dr[1].ToString() + "</td><td>" +
                    dr[2].ToString() + "</td><td>" +
                    dr[3].ToString() + "</td><td>" +
                    dr[4].ToString() + "</td><td>" +
                    dr[5].ToString() + "</td><td>" +
                    dr[6].ToString() + "</td><td>" +
                    dr[7].ToString() + "</td><td class='alignCenter'>" +
                    dr[8].ToString() + "</td><td class='alignCenter'>" +
                    dr[9].ToString() + "</td></tr>\",";
        }
        temp = temp.Substring(0, temp.Length - 1);
        temp += "];";

        return temp;
    }
}