public class StuAskDAL

 {

     public static BaseDAL<StuAsk> m_StuAskDal = new BaseDAL<StuAsk>();

     // 获取到用户信息表和帖子表的联合数据

     public static DataTable GetStuInnerAsk(int pageindex, int pagesize, string strWhere)

     {

        string strSql = string.Format(@"select top {0} *from

 (select ROW_NUMBER() over (order by UserId) as rownumber,* from

 (

 select UI.UserId,UI.RealName,UI.UserName,UI.Pwd,UI.Phase,UI.QQ,SA.AskId,

 SA.Title,SA.AskCategory from UserInfor UI inner join StuAsk SA on

 UI.UserId=SA.UserId where {2}

 )AB

 )B where rownumber>{0}*({1}-1) ", pagesize, pageindex, strWhere);

         DataTable dt = SqlHelper.ExecuteDataTable(DataBaseEnum.con, strSql, CommandType.Text, null);

         return dt;

     }

     // 获取到用户名和帖子表的总记录数

     public static int GetStuInnerAskCount()

     {

         string strSql = @"select UI.UserId,UI.RealName,UI.UserName,UI.Pwd,UI.Phase,UI.QQ,SA.AskId,

 SA.Title,SA.AskCategory from UserInfor UI inner join StuAsk SA on

 UI.UserId=SA.UserId";

         DataTable dt = SqlHelper.ExecuteDataTable(DataBaseEnum.con, strSql, CommandType.Text, null);

         return dt.Rows.Count;

     }

 }

 public partial class UserInnerAsk : System.Web.UI.Page

 {

     private int PageCount = ;

     private int PageSize = ;//一页多少条数据

     private int _pageIndex;

     public int PageIndex

     {

         get

         {

             try

             {

                 _pageIndex = Request.QueryString["page"] == null ?  : Convert.ToInt32(Request.QueryString["page"].ToString());

             }

             catch

             {

                 _pageIndex = ;

             }

             return _pageIndex;

         }

         set { _pageIndex = value; }

     }

     public string GetWhere()

     {

         StringBuilder sb = new StringBuilder();

         sb.Append("1=1");

         if (!string.IsNullOrEmpty(txtQQ.Text.Trim()) && WebSafe.SqlInsert(txtQQ.Text.Trim()))

         {

             sb.Append(string.Format(" and UI.QQ={0}", txtQQ.Text.Trim()));

         }

         return sb.ToString();

     }

     protected void Page_Load(object sender, EventArgs e)

     {

         DataTable dt = StuAskDAL.GetStuInnerAsk(PageIndex, PageSize, GetWhere());

         GridView1.DataSource = dt;

         GridView1.DataBind();

     }

     public string GetPager()

     {

         string s = Pager.GetPagerHtml(PageIndex, PageSize, StuAskDAL.GetStuInnerAskCount(), "UserInnerAsk.aspx");

         return s;

     }

     protected void btnSel_Click(object sender, EventArgs e)

     {

     }

 }