在线等，急。。。请各位帮忙

Question

public partial class newsclass : System.Web.UI.Page
    {
        DataTable Dt;
        int intPageSize, intRecordCount, intPageCount, intCurrentPage;
        
        protected void PageLoad(object sender,System.EventArgs e)
       {
           intPageSize = 50;
           this.datagrid1.PageSize = intPageSize;           if (!Page.IsPostBack)
           {               intCurrentPage = 0;
               ViewState["PageIndex"] = 0;
               DisplayPage();
               DropDind();
               View_Musics();           }
        
        }
        void DisplayPage()
        {            this.lblPageSize.Text = "每页:<font color='red'>" + intPageSize.ToString() + "</font>";
            //计算总共有多少条记录
            intRecordCount = CalucateRecord();
            lblRecordCount.Text = "本类共有<font color='red'>[" + intRecordCount.ToString() + "]</font>";
            //计算出总页数
            intPageCount = intRecordCount / intPageSize;
            //如果有余数说明还页数得多1
            if (intRecordCount % intPageSize != 0)
                intPageCount++;
            lblPageCount.Text = intPageCount.ToString();
            //使表格里的页数和我们计算出来的页数相同
            ViewState["PageCount"] = intPageCount;
        }
        void DropDind()
        {
            for (int i = 0; i < intPageCount; i++)
            {
                this.DropDownList1.Items.Add(new ListItem("第" + (i + 1).ToString() + "页", i.ToString()));
            }
            this.DropDownList1.DataBind();
        }        //计算总记录数
        public int CalucateRecord()
        {
            int intCount;
            string strsql = "select count(*) as n  from user1";
            OverAll.ReadTable.MyConn.Close();
            OverAll.ReadTable.MyConn.Open();
            SqlCommand MyComm = new SqlCommand(strsql, OverAll.ReadTable.MyConn);
            SqlDataReader MyReader = MyComm.ExecuteReader();
            if (MyReader.Read())
                intCount = Int32.Parse(MyReader["n"].ToString());
            else
                intCount = 0;
            MyReader.Close();
            OverAll.ReadTable.MyConn.Close();
            return intCount;
        }        int Get_RequsetID()
        {
            int id = 1;
            if (Request.QueryString["id"] != null)
            {
                try
                {
                    id = int.Parse(Request.QueryString["id"]);
                }
                catch
                {
                    id = 1;
                }
            }
            return id;
        }
        //IC接口
        ICollection CreateSource()
        {            int StartIndex;
            string strsql = "select * from user1 order by id desc";            StartIndex = intCurrentPage * intPageSize;            DataSet ds = new DataSet();
            SqlDataAdapter MyAdapter = new SqlDataAdapter(strsql, OverAll.ReadTable.MyConn);
            MyAdapter.Fill(ds, StartIndex, intPageSize, "user1");
            return ds.Tables["user1"].DefaultView;
        }
        void View_Musics()
        {
            datagrid1.DataSource = CreateSource();
            datagrid1.DataBind();
            prevpage.Enabled = true;
            nextpage.Enabled = true;
            firstpage.Enabled = true;
            lastpage.Enabled = true;
            if (intCurrentPage == (intPageCount - 1))
            {
                nextpage.Enabled = false;
                lastpage.Enabled = false;
            }
            if (intCurrentPage == 0)
            {
                prevpage.Enabled = false;
                firstpage.Enabled = false;
            }
            if (intPageCount == 0)
            {
                nextpage.Enabled = false;
                lastpage.Enabled = false;
                prevpage.Enabled = false;
                firstpage.Enabled = false;
            }
            lblCurrentPage.Text = (intCurrentPage + 1).ToString();
        }
        public void Page_OnClick(object sender, CommandEventArgs e)
        {
            //取得当前页
            intCurrentPage = (int)ViewState["PageIndex"];
            //取得总页数
            intPageCount = (int)ViewState["PageCount"];
            string cmd = e.CommandName;
            switch (cmd)
            {
                case "next":
                    if (intCurrentPage < (intPageCount - 1))
                        intCurrentPage++;
                    break;
                case "prev":
                    if (intCurrentPage > 0)
                        intCurrentPage--;
                    break;
                case "first":
                    intCurrentPage = 0;
                    break;
                case "last":
                    intCurrentPage = intPageCount - 1;
                    break;
            }
            this.DropDownList1.SelectedValue = intCurrentPage.ToString();
            ViewState["PageIndex"] = intCurrentPage;
            View_Musics();
        }        #region Web 窗体设计器生成的代码
        override protected void OnInit(EventArgs e)
        {
            //
            // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
            //
            InitializeComponent();
            base.OnInit(e);
        }        /// <summary>
        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
        /// 此方法的内容。
        /// </summary>
        private void InitializeComponent()
        {        }
        #endregion        protected void DropDownList1_SelectedIndexChanged(object sender, System.EventArgs e)
        {
            intCurrentPage = int.Parse(this.DropDownList1.SelectedValue);
            ViewState["PageIndex"] = intCurrentPage;
            this.DisplayPage();
            View_Musics();
        }        
}
这个帮绑数据显示不出来

Answer 1

没有错，就断点跟踪一下，看SQL查出来有记录么