Currently I have a form which prompt to user select multiple display columns for the datagrid, and datagrid will be populated, using Itemplate to generate column dynamically, once user submit their selections. I need to implement paging, and in my case, datagrid's default paging feature is good enough. But here is the problem. According to the book, I just need to specify CurrentPageIndex = e.NewPageIndex with in the PageIndexChanged function, but that doesn't seem to work. If I have the BindData at page load then default paging works correctly, but user needs to specify the criteria first, and that happen before the page performs postback.
following is my code, can anyone give me a hint as to what I missed?



       private void Page_Load(object sender, System.EventArgs e)

      {

         // Put user code to initialize the page here

       }



       private void btn_Click(object sender, System.EventArgs e)

        {

            BindData();

        }



        private void BindData()

        {

            string cmdTxt = "Select num, title, acronym, comment from View";

            DataSet ds = SQLHelper.ExecuteDataSet(cmdTxt);

            foreach(DataColumn dc in ds.Tables[0].Columns)

            {

                dg.Columns.Add(DynamicColumns(dc.ColumnName));

            }

            dg.DataSource = ds.Tables[0];

            dg.DataBind();

        }



        protected TemplateColumn DynamicColumns(string column)

        {

            TemplateColumn genericcolumn = new TemplateColumn();

            genericcolumn.HeaderText = column;

            genericcolumn.ItemTemplate = new ItemColumnTemplate(column);

            return genericcolumn;

        }



        private void dg_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEvent Args e)

        {

            dg.CurrentPageIndex = e.NewPageIndex;

            BindData();

        }

you have to select page index in these lines


      private void btn_Click(object sender, System.EventArgs e)

        {
            dg.CurrentPageIndex =0
            BindData();

        }

Ahmed Ali
Software Developer

Thanks for the reply, but I don't think I explained my problem quite right. The problem is that the way I am setting up my page, user submit the random selected categories from web form and populate the datagrid, which does show correctly. However, when user trying to do paging by selecting 2nd or any other page, the datagrid itself will disappear entirely.

All the paging example I found had the following

     private void Page_Load(object sender, System.EventArgs e)
    {
         if(!IsPostBack)
         {
            BindData()
         }
     }

But this does not work in my situation, I have to show the form first and then show the grid after submit. Using AutoGenerateColumns="True" does solve this problem, but then I have no way of setting the columns to show hyperlink or images dynamically. Can anyone help with this problem?