showuserinfo.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 ShowUserInfo : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            Response.Expires = -1;
            AjaxPro.Utility.RegisterTypeForAjax(typeof(ShowUserInfo));
        }
    }


    /// <summary>
    /// 得到用户总记录数
    /// </summary>
    /// <returns></returns>
    [AjaxPro.AjaxMethod]
    public string GetUserCount()
    {
        string str = "";
        SqlConnection conn  = new SqlConnection("server=.;uid=sa;pwd=123456;database=tmpDB;");
        DataSet ds = new DataSet();

        SqlDataAdapter sda = new SqlDataAdapter("select count(*) from UserInfo",conn);

        sda.Fill(ds);

        foreach (DataRow dr in ds.Tables[0].Rows)
        {

            str = dr[0].ToString();
        }

        return str;
    }
}