[Solved] datapager and radgrid

[C]

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Collections;
using Telerik.Web.UI;
using System.IO;
using System.Web.Services;

namespace My_Workshop.A4f
{
    public partial class DataSource : System.Web.UI.Page
    {
        public AllClass AllClass = new AllClass(); SqlConnection con = AllClass.dbConnection();
        //获取页码
        public void getcnt()
        {
            AllClass.SearchDef Def = new AllClass.SearchDef();
            Def.AssPat = this.RadAssPat; Def.Business = this.RadBusi; Def.ProSeries = this.RadPro; Def.PtoTyp = this.RadPtoTyp;
            Def.Disposal = this.RadDisposal1; Def.DefMat = this.RadDefMat; Def.STimd = this.TxtSTim.Text; Def.OTimd = this.TxtOTim.Text;
            Def.ProCode = this.RadProCode; Def.Modul = this.RadModul; Def.CusCode = this.RadCusCode; Def.CityOffice = this.RadCityOffice;
            Def.PlantCode = this.RadPlantCode; Def.OilWay = this.RadOilWay.Text; Def.AssPlant = this.RadAssPlant1;
            Def.AssPatCod = this.RadPat; Def.STima = this.TxtSTima.Text; Def.OTima = this.TxtOTima.Text;
            string sc = "select count(*) from tbDef where(1=1) " + AllClass.getwdd(Def);
            ViewState["cnt"] = AllClass.ExecuteScalar(sc, con).ToString();
        }
        //显示
        public void show(int currentpage)
        {
            AllClass.SearchDef Def = new AllClass.SearchDef();
            Def.AssPat = this.RadAssPat; Def.Business = this.RadBusi; Def.ProSeries = this.RadPro; Def.PtoTyp = this.RadPtoTyp;
            Def.Disposal = this.RadDisposal1; Def.DefMat = this.RadDefMat; Def.STimd = this.TxtSTim.Text; Def.OTimd = this.TxtOTim.Text;
            Def.ProCode = this.RadProCode; Def.Modul = this.RadModul; Def.CusCode = this.RadCusCode; Def.CityOffice = this.RadCityOffice;
            Def.PlantCode = this.RadPlantCode; Def.OilWay = this.RadOilWay.Text; Def.AssPlant = this.RadAssPlant1;
            Def.AssPatCod = this.RadPat; Def.STima = this.TxtSTima.Text; Def.OTima = this.TxtOTima.Text;
            int pagesize = this.RadDataPager1.PageSize;
            string sw = AllClass.getwdd(Def);
            string s = "select top " + pagesize +
    "DefID,MendDat,Business,OilSystem,CusNam,AssDat,AssPlant,DefMat,ProSeries,AssPatCod,AssPat,Disposal,Modul,PlantNam from tbDef where DefID not in(select top " + pagesize * (currentpage) +
    " DefID from tbDef where(1=1) " + sw + "order by DefID desc)" + AllClass.getwdd(Def) + "order by DefID desc";
            AllClass.showdata0(s, con, this.RadGrid2);
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                ((Label)(this.Page.Master.FindControl("LblSitMap"))).Text = "故障明细管理";
                this.TxtOTim.Text = DateTime.Now.ToString("yyyy-MM-dd");
                this.TxtSTim.Text = DateTime.Now.ToString("yyyy-01-01");
                DataTable dtt = new DataTable();
                this.RadGrid2.MasterTableView.NoMasterRecordsText = "欢迎您！";
                this.RadGrid2.DataSource = dtt;
                this.RadGrid2.DataBind();
                dtt.Dispose();
            }


        }

        protected void tb_ButtonClick(object sender, Telerik.Web.UI.RadToolBarEventArgs e)
        {
            switch (e.Item.Text)
            {
                case "查询":
                    getcnt();
                    show(this.RadDataPager1.CurrentPageIndex);
                    break;
                default:
                    break;
            }
        }
        protected void RadGrid2_ItemDataBound(object sender, GridItemEventArgs e)
        {
            if (e.Item.ItemType == GridItemType.Item || e.Item.ItemType == GridItemType.AlternatingItem)
            {
                e.Item.Attributes.Add("OnDblClick", "window.radopen('DataView/DefDetail.aspx?DefID=" +
                    this.RadGrid2.MasterTableView.DataKeyValues[e.Item.ItemIndex]["DefID"]+ "', 'RadWindow1');");
            }
        }


        protected void RadDataPager1_TotalRowCountRequest(object sender, RadDataPagerTotalRowCountRequestEventArgs e)
        {
            e.TotalRowCount = Convert.ToInt32(ViewState["cnt"]);
        }
        protected void RadDataPager1_PageIndexChanged(object sender, RadDataPagerPageIndexChangeEventArgs e)
        {
            show(e.NewPageIndex);
        }

        string GenerateButtonText(string argument)
        {
            return String.Format("<span>{0}</span>", int.Parse(argument) + 1);
        }

        protected void RadDataPager1_FieldCreated(object sender, RadDataPagerFieldCreatedEventArgs e)
        {
            if (e.Item.Field is RadDataPagerButtonField && (e.Item.Field as RadDataPagerButtonField).FieldType == PagerButtonFieldType.Numeric)
                foreach (IButtonControl ctrl in e.Item.Controls)
                    ctrl.Text = GenerateButtonText(ctrl.CommandArgument);
        }

    }
}

public void showdata0(string s, SqlConnection con, RadGrid gv)
        {
            DataTable dt = AllClass.dt(s, con);
            gv.DataSource = dt;
            gv.DataBind();
            dt.Dispose();
        }

I got this Exception"RegisterRequiresControlState can only be called before and during PreRender."but asp:gridview works well

[Daniel]

Hi,

I'm unable to identify the problem just by looking at these code fragments. Please provide a runnable demo so that I can debug it locally. Alternatively you can past self-contained demo in code-snippets here.

Regards,
Daniel
Telerik