DataGrid paging

[johno]

Hello everybody, I got myself a strange problem

I have a DataGrid in the page, nothing special about it, only it connects datasource programatically and it supports paging.y. So the code is something like this

private void Page_Load(objec t sender, System.EventArg s e

if (!IsPostBack
GridBind()

private void GridBind(

myGrid..DataSou rce = GetSomeDataSour ce()
myGrid.DataBind ()

private void PageChanged(obj ect source, System.Web.UI.W ebControls.Data GridPageChanged EventArgs e

myGrid.CurrentP ageIndex = e.NewPageIndex
BindData()
This worked perfectly OK. Then I decided to try also to create grid columns dynamically. So I set the AutoGenerateCol umns property to false. I changed the code, so it would create some columns like this

private void Page_Load(objec t sender, System.EventArg s e

AddSomeColumnsT oGrid();

if (!IsPostBack
GridBind()
Now when I load the page for the 1st time, everything is OK. When I want to go to another page grid mystically disappears. I tried to debug the page setting breakpoint inside the PageChanged event and I never got there
Being desperate I tried everything possible then I came to something like this

private void Page_Load(objec t sender, System.EventArg s e

AddSomeColumnsT oGrid();

//if (!IsPostBack
GridBind()
and it worked. But now I am creating dataset 2 times in postback (supposing it's the page changed event)

Am I doing anything wrong? Because I really don't know how to solve this problem. Any helps would be very appreciated.

[johno]

I made some errors in the first source code, it should be this

private void Page_Load(objec t sender, System.EventArg s e

if (!IsPostBack
GridBind()

private void GridBind(

myGrid.DataSour ce = GetSomeDataSour ce()
myGrid.DataBind ()

private void PageChanged(obj ect source, System.Web.UI.W ebControls.Data GridPageChanged EventArgs e

myGrid.CurrentP ageIndex = e.NewPageIndex
GridBind()

[johno]

I made some errors in the first source code, it should be this

private void Page_Load(objec t sender, System.EventArg s e

if (!IsPostBack
GridBind()

private void GridBind(

myGrid.DataSour ce = GetSomeDataSour ce()
myGrid.DataBind ()

private void PageChanged(obj ect source, System.Web.UI.W ebControls.Data GridPageChanged EventArgs e

myGrid.CurrentP ageIndex = e.NewPageIndex
GridBind()

[David Coe, MCP]

Add the AddSomeColumnsT oGrid() method to the GridBind method. That way, any time you are going to bind the grid you know you have the columns.

[johno]

I tried what you suggested, but the problem stays. Let's revisit the code once more (as you proposed):

private void Page_Load(objec t sender, System.EventArg s e)
{
if (!IsPostBack)
GridBind();
}
private void GridBind()
{
AddSomeColumnsT oGrid();

myGrid.DataSour ce = GetSomeDataSour ce();
myGrid.DataBind ();
}
private void PageChanged(obj ect source, System.Web.UI.W ebControls.Data GridPageChanged EventArgs e)
{
myGrid.CurrentP ageIndex = e.NewPageIndex;
GridBind();
}

Again it works OK when the page is loading for the 1st time. When I try to get another page, grid is gone. Debugging the project I found out that the execution never reaches the PageChanged handler. That is what confuses me mostly.

Because when I comment the line in Page_load like this:

private void Page_Load(objec t sender, System.EventArg s e)
{
// if (!IsPostBack)
GridBind();
}

it works. But now, unfortunately, the grid shows 2 copies of columns, logically, because I added them twice.

Resolution - the biggest problem as I see it is, that the execution is not passed to the handler of PageChanged event when postback occures, when I hit page number at the bottom of the grid.

This is pretty weird, I know. But that is why the solution is not easy to find in ANY help. Thanks in advance for further suggestions.