getdatabydb.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 GetDataByDB : 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 = 9;
        int perPage = 8;
        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());
        }

        string temp = "";

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

        DataSet ds = new DataSet();

        SqlDataAdapter sda = new SqlDataAdapter("select * from titles ", 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(ds.Tables[0].Rows.Count / (double)perPage);
        temp += "totalPage = " + total + ";";
        temp += "dataStore = [";

        for (int i = start - 1; i < end; i++)
        {
            DataRow dr = ds.Tables[0].Rows[i];
            temp += "\"" + "{id} " + dr["title"].ToString() + " <br/>\",";
        }
        temp = temp.Substring(0, temp.Length - 1);

        temp += "];";

        return temp;
    }
}