DataGrid Paging Events not firing - Rick Strahl's Web Log

# re: DataGrid Paging Events not firing
by Kevin Pirkl January 21, 2004 @ 5:24 am

There is a little know bug in C# under VS.Net that I run into all the time where in the Region

#region Web Form Designer generated code

under

private void InitializeComponent()

the code for the event handler for some objects get's throw out. I don't exactly know why but that is the first place that I would look.

See if your event handler has dissapeared. Usually this occurs when you are making changes under the Designer interface and VS.Net attempts to update all the hooked code events and for some reason drops your event.

# re: DataGrid Paging Events not firing
by Rick Strahl January 21, 2004 @ 10:08 am

Kevin, yeah I know about that, but that's not it, as I see the event handler hookup code and it runs. The problem you describe often occurs under Windows forms for me in which case moving the generated #region to the top of the class usually works best.

# re: DataGrid Paging Events not firing
by Chris January 27, 2004 @ 9:05 am

Same thing happened to me... another "Black Magic" solution: Using Property Builder add an empty column to the DataGrid such as:

<Columns>
<asp:BoundColumn></asp:BoundColumn>
</Column

Suddenly things start working.

See Also: microsoft.public.dotnet.framework.aspnet.datagridcontrol

# re: DataGrid Paging Events not firing
by Paul January 30, 2004 @ 11:31 am

Same thing happened with me also; came to just the same solution (delete, add new, copy over) with no idea, none, nada.

Btw, cool article on 2-way binding. I've been playing with something similar to bind to brokered classes (http://sourceforge.net/projects/sisyphuspf) that have two states; display (a label displays the data) and edit (a.n.other control appears bound to the correct point), but hadn't cracked the databinding properly. The article helps much!

# re: DataGrid Paging Events not firing
by andla February 15, 2004 @ 9:37 am

Check if the aspx is identical before and after the strange happening. I experienced I think in a usercontrol that when adding some changes in the aspx code and then switched to design view and added a textbox and then switched back to aspx view the code change was gone. I suspect that maybe property builder created code are not serialized in the IDE.

Regards
Andla

# re: DataGrid Paging Events not firing
by An Phu February 20, 2004 @ 8:36 am

I got the same problem. It's very frustrating but I finally got my datagrid to fire those events (SortCommand, PageIndexChanged, etc).

For me, the issue was databinding. I did something similiar to what you have done, copy and paste the datagrid from one page to another page. I even explicitly register the event handlers in the PageInit event.

It turns out that in my Page Load event, I'm not binding the datagrid to the datasource.

So when it comes time for the ASP.net engine to dish out the server events (PageIndexChanged, SortCommand, etc) after the Page_Load event, the datagrid has no data and doesn't fire its server events.

# re: DataGrid Paging Events not firing
by vash5b5 February 23, 2004 @ 12:02 pm

I have run into this problem a couple of times. It happens everytime I set autogeneratecolumns to false. The only way I have been able to fix the problem by using Chris's solution above.

<Columns>
<asp:BoundColumn></asp:BoundColumn>
</Column>

# re: DataGrid Paging Events not firing
by Graucsh March 04, 2004 @ 5:22 pm

A bit late in the game, perhaps, but I discovered something else about this last night.

In my case, the ItemCommand event was firing first, and mistakenly Redirect-ed so the PageIndexChanged event didn't fire.

Telling the ItemCommand event to completely ignore paging events allowed the event to cascade down correctly

# re: DataGrid Paging Events not firing
by SusyW March 18, 2004 @ 12:58 pm

I run into the same problem and tried the delete and add the control but it didn't work. The only way to fix this is by using Chris's solution too.

<Columns>
<asp:BoundColumn></asp:BoundColumn>
</Column>

# re: DataGrid Paging Events not firing
by Kingsley Tagbo March 23, 2004 @ 10:51 am

I have been working on a similar challenge.

I was doing some work in a load balanced environment with dev. servers, QA servers and production servers.

The challenge is that after developing a web pages that returns several rows of data in a datagrid, I added about 3 different bound columns to the datagrid and handled them in the itemcommand event

I read the Primary Key of the DataGrid Row selected with Dim code As String = dataGrid.DataKeys(e.Item.ItemIndex)

I also check the command name as each of the three bond columns has a different command name using :
url = e.CommandName

Based on the url string retrieved, I do a Response.Redirect as in :

Dim redirectURL As string = url & code
Response.ReDirect(redirectURL)

The game starts about now.

This code worked perfectly fine on my development PC but the moment I transfered it to the Dev. Server. it refused to work.

The ItemCommand Event will not fire hence, no ReDirecting was taking place.

The strange thing was that the DataGrid_ItemCreated event was firing even on post back.

After several iterations, I added EnableViewState="True" on th ePage and Hey Presto!, it started working.

# re: DataGrid Paging Events not firing
by Ash March 23, 2004 @ 2:24 pm

This has been driving me nuts. Glad I'm not the only one. The only way I've been able to get around it is to use the solution several people are using here (except I make the bound column invisible)

<Columns>
<asp:BoundColumn Visible="False"></asp:BoundColumn>
</Columns>

*and* re-attatch my created columns before I rebind the data

Public Sub PageIndexChanged(ByVal sender As Object, ByVal e As DataGridPageChangedEventArgs) Handles DataGrid1.PageIndexChanged

DataGrid1.CurrentPageIndex = e.NewPageIndex

DataGrid1.DataSource = FillDataGrid()
Call attatchcolumns()
DataGrid1.DataBind()

End Sub

# re: DataGrid Paging Events not firing
by Rovol April 08, 2004 @ 12:55 am

I think setting the property EnableViewState="True" of the DatarGrid will solve the problem. But after setting this property, you'll need to check if the events PageIndexChanged and ItemDataBound are hooked.

# re: DataGrid Paging Events not firing
by Jon Slocombe May 13, 2004 @ 7:59 pm

Bizarre.

The [i]only[/i] way I could get the paging event (pageindexchanged) to fire was to have some code in the page_load event that dealt with the event of a postback.

Most unsatisfactory.

# re: DataGrid Paging Events not firing
by Steve May 20, 2004 @ 12:11 am

This worked for me (Thanks to Rovol for his post):

1:
In the page load event ensure that you check for the IsPostBack
Page_Load

if (!IsPostBack)
{
//Bind to data
ds = oBusiness.GetMyData();
myDataGrid.DataSource = ds;
myDataGrid.DataBind();
}

2. Then make sure EnableViewState is True for the datagrid.

# re: DataGrid Paging Events not firing
by shreemannarayana dash May 30, 2004 @ 4:21 am

hi
I didnot got that problem and i have followed what steve mentioned check ispostback in form load

if (!IsPostBack)
{
//Bind to data
ds = oBusiness.GetMyData();
myDataGrid.DataSource = ds;
myDataGrid.DataBind();
}
and i ve handled the onpageindex changed event to change the page to next page.

the problem what i faced is all works finebut the i have to click twice on the navigation button provided by datagrid for next page.

any soloutions?

I also have set the appropriate setting in web.config
but still not working
shreeman

# re: DataGrid Paging Events not firing
by Parthi June 03, 2004 @ 10:01 am

When "EnableViewState" is set to false, the datagrid would not be able to maintain current-page-index by itself and that may be reason why the PageIndexChanged event handler did not fire.

See the following topic "Enduring an Over-sized ViewState" in this article: 'Common datagrid mistakes' http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnaspp/html/aspnet-pageablesortable.asp

# re: DataGrid Paging Events not firing
by Rick Strahl June 03, 2004 @ 11:24 am

That's not true. The Page to be selected is posted back as part of the page submission when you clcik one of the page links, but it is true that it doesn't automatically get updated unless you have a handler for the paging event. I never have Viewstate enables on my datagrids and typically use paging.

# re: DataGrid Paging Events not firing
by Scorpio June 08, 2004 @ 9:46 am

I think I am having the same problem and going out of mind in trying to resolve it, I've tried the suggestions above but still not working for me. In summary, I have a datagrid to allow paging and sorting but when clicking on the page numbers or the columns to sort I get error: "Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index"???

I don't understand, especially when this was working last week??

Any other suggestions, what else could I be missing? What should I have under the private void InitializeComponent() of the Web Form Designer generated code???

Help!

# re: DataGrid Paging Events not firing
by Chuck Wagner July 13, 2004 @ 6:37 am

my events stopped firing too so I removed these properties in the html design view:

AllowPaging="True" PagerStyle-Visible="False" AllowCustomPaging="True"

Saved the file and then added them back...it works fine now

# re: DataGrid Paging Events not firing
by Charlie Kunkel July 16, 2004 @ 9:49 am

I have had the same problem numerous times. The only thing that finally fixed it was setting my enableviewstate to false on the datagrid.

I also had to put this in my button onitemcommand event procedure:

//This event (DataGrid1_OnItemCommand) fires for ChangeGridPage as well so we need to make sure it doesn't try to do a details page redirect if that's the case

if(e.Item.ItemType == ListItemType.Pager)
return;

//also ignore sort requests
if (e.Item.ItemType == ListItemType.Header)
return;

Hope this helps. I'm still trying to get my DataKeyField to pass appropriately after paging so my fix may not be the 'right' one. :/ Man this is frustrating.

# re: DataGrid Paging Events not firing
by compton July 16, 2004 @ 11:03 am

I had a similar problem. However, my datagrid was built dynamically. Instead of binding the datagrid in the PageLoad event, I would bind the data in the PreRender evnet with the following code:

private void BuildGrid()
{
...Add the PreRender event handler
_DataGrid.PreRender += new EventHandler(_DataGrid_PreRender);

}

private void _DataGrid_PreRender(object source, EventArgs e)
{
DataGrid myDataGrid = (DataGrid)source;
myDataGrid.DataSource = myAssetList;
myDataGrid.DataBind();
}

# re: DataGrid Paging Events not firing
by Andreas Göransson July 28, 2004 @ 6:56 am

I was so relieved when I found this page!!! I have been building a Webshop application containing a datagrid control. I used a buttoncolumn to fire an event to add items to the shopping cart(OnItemcommand). Everything worked just fine until I implemented a pagechangeevent for the datagrid. Somehow the ItemCommandevent also fired when the pagechangeevent fired. The solution above worked fine for me btw.

The source code:

Sub dgProdukter_PageIndexChanged(obj As Object, e As DataGridPageChangedEventArgs)
dgProdukter.CurrentPageIndex=e.NewPageIndex
Bindgrid()
End Sub

Sub dgProdukter_ItemCommand(obj As Object, E As DataGridCommandEventArgs)
' An if-statement added in VB to stop pagechangeevent from firing Itemcommandevent...
If e.Item.ItemType = ListItemType.Pager Then
Return
End If
'Do something else
End Sub

# re: DataGrid Paging Events not firing
by david August 13, 2004 @ 2:19 am

I've tried everything posted and nothing works still this is my code:

public void dataGrid1_PageIndexChanged(object source,DataGridPageChangedEventArgs e)
{

dataGrid1.EditItemIndex = -1;
dataGrid1.CurrentPageIndex = e.NewPageIndex;

BindGrid();
}
i can see the initial page but when i try to navigate to another index all it does is re-display page one.

# re: DataGrid Paging Events not firing
by Juan Carlos August 16, 2004 @ 5:59 am

I had the same problem and fixed looking at this. I had not understood what the "ItemCommand" event means.

http://www.eggheadcafe.com/ng/microsoft.public.dotnet.framework.aspnet.datagridcontrol/post93109.asp

# re: DataGrid Paging Events not firing
by Alan Cheetham August 31, 2004 @ 9:33 am

I was having the same problem. The suggestion of <Columns> <asp:BoundColumn Visible="False"></asp:BoundColumn> </Columns> helped.
Also, since I was adding the columns to the data grid in code, the columns need to be added to the datagrid again on every page change.

# re: DataGrid Paging Events not firing
by Eli David September 04, 2004 @ 9:00 pm

I have the same problem with the buttons event. When I changed the button type (push button into link) the problem solved.

# re: DataGrid Paging Events not firing
by Anthony Z September 10, 2004 @ 10:12 am

I got the same problem.

I added EnableViewState="True"

Kingsley Tagbo's solution worked for me!

Thanks

# re: DataGrid Paging Events not firing
by Allard Schripsema September 18, 2004 @ 6:03 am

I had a page with this problem.
In the page directive i had put enableViewStateMac="false" and EnableViewState="false"
This caused the paging problem.
Removing EnableViewState="false" was the solution for this page (default for EnableViewState is "true")

# re: DataGrid Paging Events not firing
by Rick Strahl September 18, 2004 @ 7:18 am

Allard, this is a different issue. If you don't have EnableViewstate enabled you have to handle paging in code since ASP.NET can't track the state of the current page. However, this is unrelated to events not firing...

# re: DataGrid Paging Events not firing
by Deepak September 19, 2004 @ 10:28 pm

My problem is somewhat similar !
I have got a page with a datagrid and 3 bound columns, all I am trying to do is sort the columns which I have generated dynamically in code. I have got a Item_Command event in code hooked to the datagrid. This event does the sorting and rebinding of the datagrid. Now, the problem is that the Sorting "works" but only in alternate turns :) (I am serious) The first click on any of the header buttons sorts in ascending order, the second click on any of the buttons will not do anything, the third click on any of the buttons will perform the descending sort, and so on....
Can any of you help me ?
Thanks

# re: DataGrid Paging Events not firing
by yelwob September 30, 2004 @ 3:12 am

Hi,

I found this thread very useful for the problem I was experiencing. It kept me occupied for quite some time. The symptoms were exactly as described here, except that none of the described solutions worked.

However, on re-checking the code I noticed that 'Handles DataGrid.PageIndexChanged' had been missed off the end of the eventhandler(don't ask me how, as this was generated code).

I never thought to check the end of the line. I wonder whether this is why you guys corrected it when you deleted and created a new one. In my case I didn't replace the code so this didn't help.

Phew!

# re: DataGrid Delete Events not firing
by Suresh September 30, 2004 @ 4:47 pm

Iam not able 2 fire the delete event of the DataGrid
Plz if any one can help me iam in urgent need of that
thankx in advance

# re: DataGrid Paging Events not firing
by Peter October 05, 2004 @ 1:21 am

Maybe this is interesting too. I had the same problem of PageIndexChanged not firing. None of the solutions above worked, so things kept me occupied some time. Finally the solution for me was as follows. My .ascx contained several panels that I switched on and of by setting the visible property.
In a panel which was not visible at the time my 'problem datagrid' was shown, I used a third party component.(Treeview from ComponentArt.com). The component had the EnableViewstate property set to false which cause the PageIndexChanged event of my datagrid not firing:-(

# re: DataGrid Paging Events not firing
by Dirk October 05, 2004 @ 8:03 am

I have the same componentart tree component and the problem of no events firing in my grid. I had it working before - restarted the code with just the function shells - and nothing is being fired. I tried changing the viewstate on the tree but no use... :(

# re: DataGrid Paging Events not firing
by Dirk (again) October 05, 2004 @ 8:34 am

Well. I posted a bit too fast. It seems that all my troubles lied in the ComponentArt's TreeView component's viewstate attribute. When I set it to true all events in the page fire fine. Thanks for the head's up ComponentArt...

# Repeater OnItemDataBound Events not firing either
by Mike October 14, 2004 @ 4:37 am

Similar problem here as well - I have a parent repeater and a child repeater inside one of the parent's ItemTemplates. The parent is also hooked to an OnItemDataBound event which when it fires is responsible for data-binding the child repeater to a new data source. The problem is that for the very last item in the parent repeater the event never fires and consequently the child repeater does not display the last piece of data. I am a bit lost as for why this happens?

# Events firing, UI not updating
by Gene October 15, 2004 @ 6:14 am

How about this- I've got a user control with some post-back events that perform as the result of actions taken in the ui (ie. click a tree node, display some text, etc.)

Everything worked, checked the code into sourcesafe and checked it out to keep working on it...

Now the events fire, like before, only the UI doesn't update when the page refreshes- ie. label.Text = <something> is set, however that label is empty when the page is drawn.

Any ideas?

# re: DataGrid Paging Events not firing
by Miguel Castro October 19, 2004 @ 3:53 am

The ItemCommand fires right before the page event is supposed to fire. If you have code in the ItemCommand to account for links in your grid, you may want to case around e.CommandName.ToLower() = "page", which is what the case will be when you click on a page number. Maybe code executing in ItemCommand is nullifying the firing of PageIndexChanged. Good luck.

# DataGrids, Custom columns and Paging
by Fear and Loathing October 19, 2004 @ 5:08 pm

# re: DataGrid Paging Events not firing
by Naeem October 21, 2004 @ 7:48 am

Superb! I have had a similar problem but mroe specifically, the event fires when I move forward pages but when I attempt to click back to a previous page in the pager, the event doesn't fire. I'll certainly try the solutions listed that I haven't tried yet.

# re: DataGrid Paging Events not firing
by Naeem October 22, 2004 @ 3:45 am

Jsut to let you all know: The only thing that fixed my problem of the PageIndexChanged event not firing when navigatin back to previous pages in the pager was: calling the datagrid's DataBind() method in the Page_Load event. I tried everything else and it didn't work. There is obviously some peculiar event cycle corruption happening. I had a few pages all defined in roughly the same way so I can only put it down to the Visual Stuido Environment (2003) or the framework 1.1

# re: DataGrid Paging Events not firing
by whitethelightning October 26, 2004 @ 11:39 am

I found this article helpful...or blog that is.

http://forums.aspfree.com/archive/t-20561

-wl

# re: DataGrid Paging Events not firing
by jagannadh November 02, 2004 @ 4:07 pm

I have a datagrid in a page, and the page is not going into pageload().

After writing pageindexchanged event in the viewcode it is not firing the event page_load()

# re: DataGrid Paging Events not firing
by Handy Andy November 03, 2004 @ 4:09 am

Hi Fellas! Thanks for the lifesaver of a page. I just spent a day-and-a-half fighting with this! I resolved the issue by putting all code for datagrid item cmd event handler inside an if loop .

after, working example:
private void dgCourseSessions_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{

if(e.CommandName=="Add")
{
int iSelectedRowIndex = e.Item.ItemIndex;
//must cast the result from datakeys from obj->str
string strSessionID = dgCourseSessions.DataKeys[iSelectedRowIndex].ToString();
int iSessionID = int.Parse(strSessionID);
//check to see what function the user clicked on
string strSSN = ddlEmployee.SelectedValue;
TrainingSession.addEmployeeToASession(strSSN,iSessionID);
BindDataEmployeeCourses(strSSN);
BindDataCourseSessions();
}
}

# re: DataGrid Paging Events not firing
by Parul November 08, 2004 @ 4:04 am

Hi, I had same problem. I wrote code for Datagrid1_SortCommand, DataGrid1_PageIndexChanged, Datagrid1_ItemCommand events. But events for sorting and Paging was not firing, but ItemCommand event was firing instead of Sorting and Paging. Following Code works Fine.

private void dgrdSearchResult_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e){
switch (e.Item.ItemType)
{
case ListItemType.Pager:
break;
case ListItemType.Header:
break;
case ListItemType.Item:
//do your work
break;

# re: DataGrid Paging Events not firing
by Mike November 08, 2004 @ 5:25 pm

Here is how to fix the need to double-click the datagrid to go to the next page into just one single click. The datagrid bind method needs to be taken out of the page_load event into it's own function. See below.

private void Page_Load(object sender, System.EventArgs e)
{
BindData();
}
private void BindData()
{
// Bind to datagrid code here.
}

Under the PageIndexChanged event of the datagrid. Dow the following code.
{
DataGrid1.CurrentPageIndex = e.NewPageIndex;
BindData();
}

Have fun.

# re: DataGrid Paging Events not firing
by David November 15, 2004 @ 3:50 am

I also had been suffering the loss of the item commands on any datagrid that I was programmatically creating the coloumns. I was able to work around this by moving the coumn creation routine from the databinding method and call it from the Page initalisation method (OnInit - part of the autogenerated code). Having tried every other conceivable option this has shown to be the only successfull method short of defining the columns within the aspx to setting autogeneratecolumns to 'true'.
Hope this hint can prevent someone else going throught the same hoops I went through.

# re: DataGrid Paging Events not firing
by Rick Strahl November 15, 2004 @ 7:23 am

David, adding controls to the page during databinding is probably not a good place to do this no matter what you do, because databinding occurs pretty late in the page cycle. Things like adding controls should usually happen as early as you possibly can - OnInit makes sense.

# re: DataGrid Paging Events not firing
by Dave November 17, 2004 @ 2:33 pm

Some problems can be eliminated if you're sure to check for the things a data row can be when you use Datagrid ItemDataBound

If e.Item.ItemType = ListItemType.Item Or_
e.Item.ItemType = ListItemType.AlternatingItem Or _
e.Item.ItemType = ListItemType.EditItem Or
e.Item.ItemType = ListItemType.SelectedItem Then

# re: DataGrid Paging Events not firing
by Archana November 17, 2004 @ 9:00 pm

Hi
I have faced the same problem for DataGrid. Only differnce is that, though I have EnableViewState to false and all the above obstacle conditions set, things were working fine for all the numeric page links except for number 1. For number 1 neither OnItemCommand nor PageIndexChanged events are getting fired for rest things are working absolutely fine.

Only with two solutions I could make it work
1) Set EnableViewState = True (For I am against of)
2) Or call the databinding function in Page_Load even without checking for !IsPostback
But here I have a check for is there need to fetch the data from database if not then get it from session and display it. So, calling DataBind menthod in Pageload is not that costly. Though my session will be bit heavy (I have customized paging implemented here so at max 20 objects I have in Dataset and in Session as a result)

I am not sure how good is the way I am implementing. But a experties comments are really appricated.

# re: DataGrid Paging & sorting Events not firing
by Vijay November 19, 2004 @ 12:44 am

Hi,

First : Arrgh...., Grrrr
Next : Please Help URGENT !

mine is a datagrid with no editing, therefore no item command come into picture.

i just have to do sorting and paging.
This damn thing was working before, suddenly it isn't.

i tried , viewstate, binding during pageload, adding invisible columns to datagrid, cutting and deleting the grid, creating a new page altoghether .......Phew !

what else can i do ?

# re: DataGrid Paging Events not firing
by Wolf Logan November 24, 2004 @ 10:46 am

After wrestling with this same problem this afternoon, I think I've figured out another piece of the puzzle.

In my case, I wasn't binding the DataGrid in my page_load handler (since the data wasn't guaranteed to be available at that time). The reason that interferes with the pageIndexChanged event seems to be that the postback handler for the paging controls checks the requested page against the current state of the DataGrid -- in the space between the page_load handler and the datagrid_pageIndexChanged handler. If the datagrid doesn't have the data bound in that interval, then the comparison fails (it looks like an out-of-bounds request), and the event doesn't fire.

Similarly, the event won't fire if (for some reason) the requested page happens to be the same as the current page of the DataGrid. So if you set the page index in the page_load handler, your pageIndexChanged event won't fire for the page that matches what you set it to.

I guess the rule seems to be that the data state of the DataGrid must be the same *after* the page_load handler (during the paging postback) as it is *before* the paging control is clicked. if it's different for any reason, it's possible that the event will not fire.

# re: DataGrid Paging Events not firing
by Joel November 25, 2004 @ 11:28 pm

I have been designing a windows form in c#. The form contains a datagrid with a Bool Grid Column. I add an event handler to this column for the TrueValueChanged Event. Firstly it all works fine, events firing and no problems with checking and unchecking this column. Next day I come back to the same project and all other events are firing for the grid but not this one. I have tried the "delete save recreate" procedure but still no difference. Is there anyone out there who has a possible solution for this? All help appreciated.

# re: DataGrid Paging Events not firing
by Dave December 01, 2004 @ 10:17 am

I've solved one issue after a full two evenings of frustration.

The thing that caused my problem was that I was moving a datagrid around on the page in response to user requests. I think that because I was dropping the grid into a panel (server control) the post back wasn't able to find it.

My best guess is that this resulted in the HTML post back not matching some magical thing that needs to happen behind the scenes in order for .Net to process the post back page.

I solved the problem by moving other controls around the datagrid instead of moving it. I guess it's true that the world revolves around the data grid :D

# re: DataGrid Paging Events not firing
by Anye December 07, 2004 @ 8:55 am

I had begun to despair of being able to fix this since the majority of the suggestions had no effect but David's suggestion of 11/15 above did the trick.

Thanks!

(In my scenario, I wasn't even using the ItemCommand handler explicitly yet, as my data is actually just display only, but the AutoGenerateColumns=false was messing me up since I had the column creation outside of my custom control's CreateChildColumns method in with the databinding that doesn't fire until the event does. Doh!)

# re: DataGrid Paging Events not firing
by Steven A Bristol January 12, 2005 @ 3:02 am

Setting EnableViewState = true worked for me.

# re: DataGrid Paging Events not firing
by Rick Strahl January 12, 2005 @ 11:40 am

Steven, EnabledViewState will work in some cases - especially paging, but if you don't want ViewState (because of page size) this can be a problem.

# re: DataGrid Paging Events not firing
by kula January 17, 2005 @ 7:36 am

Maybe I solved this problem. You have to move 'datagrid.DataBind()' before 'Handling postback events' in lifecycle of page. In 'DataBind' method child controls of datagrid are created so It's needed to found sender of events before handling them. I think, it was the reason not firing of events.

# re: DataGrid Paging Events not firing
by Daniel Wellesley January 17, 2005 @ 12:05 pm

I had a similar problem the other day which took me a while to sort out. Basically the viewstate in the page had been bloated by all the data in the datagrid, and a page which used to postback fine now gave a 500 error with no postback events firing.

I outline the solution at http://tempurisnacks.blogspot.com/2005/01/waste-of-few-days.html

# re: DataGrid Paging Events not firing
by matchbx January 20, 2005 @ 5:36 pm

Here's what worked for me.

http://thedotnet.com/howto/work398504.aspx

<Quote from page>

At the beginning of a PostBack, you have to recreate the same control
hierarchy which was present at the end of the previous request.

You can then take into account any events which happen on this request </Quote From Page>

My problem was occuring while trying to filter the data in the grid through the query tied to the dataset. Since the filter could change every time a postback occured I had to create a way to capture the previous filter criteria.

Just for testing purposes I added a label to my form and when the DataGrid_ItemCommand fired for the first time I set the label.text value with my filter criteria.

At the Page Load event was set as follows.

if not page.isPostBack
strFilter = ""
else
strFilter = Label1.Text
end if

So the label persisted the previous filter criteria allow me to recreate the datagrid with exactly the same data (prior to the ItemCommand event firing).

This worked for me.

P.S. this was the most comprehensive page I found on this bug. Thanks to everyone that posted.

# re: DataGrid Paging Events not firing
by ety b. January 31, 2005 @ 10:45 pm

hi u all !!

I had the same problem and I thought I was loosing it...

you will never believe what it was - somehow the "handels datagrid1.PageIndexChanged" at the end of the sub that handels this event HAD BEEN DELETED !!!

can u imagine ???

so, add this to the list of things to check when an event isnot firing.

ety

# re: DataGrid Paging Events not firing
by Aks February 02, 2005 @ 2:26 am

Hi all..

I am also facing the same datagrid pagination and sort problem. But as u said, the viewstate is enabled. and i have even added the code in Initialize component.

But no idea, these 2 events are firing Itemcommand methods instead of the corrresponding ones. Do u have any idea how to solve this?

regards,

aks...

# re: DataGrid Paging Events not firing
by Ajl February 04, 2005 @ 2:57 am

Hi all,

Glad Im not the only one suffering. The problem I have is that the event is firing, but its not moving on to the page selected. I've tried adding the bound column, recreating the datagrid, setting viewstate to true but none of them have worked. This datagrid was originally copied from one that's paging is working.

# re: DataGrid Paging Events not firing
by Ajl February 04, 2005 @ 3:20 am

I dont believe it! Somehow a set CurrentPageIndex to 0 statement had crept into my bind function!!! No wonder it wouldnt work!!

Forgot the first rule of programming - check for the really blindingly obvious before spending hours debugging!!!!!

# re: DataGrid Paging Events not firing
by Atrul February 08, 2005 @ 4:55 pm

Enabling viewstate is working fine and this is more fesible instead of avoiding IsPostBack from PageLoad.

# re: DataGrid Paging Events not firing
by Atul February 08, 2005 @ 4:57 pm

Enabling viewstate is working fine and this is more fesible instead of avoiding IsPostBack from PageLoad;- Because if we do not use IsPostBack then everytime, we have to bind the data to the DataGrid

# re: DataGrid Paging Events not firing
by Rick Strahl February 08, 2005 @ 8:04 pm

You have to bind back anyway for paging to work no matter what. Viewstate might help with other reposts, but there's always the issue of huge viewstate size for all the objects in the data grid which is a big issue if you have a lot of data and/or objects in the grid.

# re: DataGrid Paging Events not firing
by DavidG February 21, 2005 @ 9:55 am

My DataGrid was working perfectly fine with PagingEvents. It had no other command but that one.
I set EnableViewState=false for performance (the datagrid created an excessive Viewstate and made the postbacks take an eternity once installed in the client).

After that, if a clicked a page number the datagrid will dissapear. The PagingEvent wasnt firing (the handler was there). I tried the firsts solution of copy paste and adding a column but nothing.

I finally had to Bind the Datagrid in the postback so it would work just as some people said it above.
private void Page_Load(object sender, System.EventArgs e)
{
if (!this.IsPostBack)
{
...
...
}
BindData();
}

private void BindData()
{
dgSearch.DataSource = dtb; //(Session DataTable)
dgSearch.DataBind();
}

public void dgSearch2_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
{
dgSearch2.CurrentPageIndex = e.NewPageIndex;
BindData();
}
Somehow having data made the pageChanged to fire, but I had to Bind the Datagrid twice :(.
Any better solutions are accepted..!

# re: DataGrid Paging Events not firing
by David Cooper February 25, 2005 @ 8:27 am

DYNAMIC COLUMN GENERATION

I have had the same problems as other users on this forum. I have read this entire page of responses and had no solution work for me, but I figured my problem out on my own... it may help someone.

PROBLEM --------
I am trying to build a dynamically generated DataGrid; the columns are all generated at runtime. Therein lies MY problem. Because the DataGrid columns are generated on Page_Load, it can't handle events that occur on the generated columns. Sorting, Paging, Button Commands.

SOLUTION --------
Building and binding the DataGrid on Page_Load causes all events to fire correctly.

I feel this is a messy solution, because I don't really want to hit the Database every Page_Load for performance reasons. If anyone has better ideas in this particular situation, please post and enlighten us!!!

.NET is powerful, but quirky.

# re: DataGrid Paging Events not firing
by Anthony Main March 01, 2005 @ 2:05 am

I am always having these problems, my steps to solving it are:

1) right click it add use property builder to add a bound column then save etc and rebuild

2) make sure that I have used "if not page.ispostback" cause when the page loads it changes the dataset and therefore the handler doesnt work

3) if all the above fail, I normally find its number 2 and Im just being stupid, but I then hardcode the events using the onitemdatabound properties. If your datagrid is within another control such as a IE pageview control you WILL HAVE to do this manually anyway

# re: DataGrid Paging Events not firing
by Simon March 02, 2005 @ 7:34 am

One solution I ended up using was to store the whole grid in the Session and bind the events on !IsPostBack :O Not a very memory-efficient solution but it does work.

# re: DataGrid ItemCommand Events not firing
by Vinay March 06, 2005 @ 9:21 pm

Something on same trcak !
I was facing same type of probelm with my "ItemCommand" event...... and the solution was....

if(!Page.IsPostBack )
{
// gatagrid.DataBind();
}

on page load event.

Hope this may help to someone like me :) asp.net learners.

# re: DataGrid Paging Events not firing
by K March 10, 2005 @ 12:17 pm

Has anyone actually solved the double-binding problem originally mentioned by Rick?

PageIndexChanged event won't fire for a stateless DataGrid unless the DataSource is set and bound once on every PageLoad and then again in response to the PageIndexChanged event.

I have a Datagrid with the ViewState off. I also have custom paging with a stored procedure which returns only the number of rows needed for each page. So I don't need to hang onto any data since I am making a SQL call on each page load. However, the PageIndexChanged puts me in a catch 22 where I have to load my data from sql and bind the grid in order for the event to be generated. Once I get the event, then it's a whole new page, so I have to reload the grid with the new page's data from Sql.

I am about to resort to parsing the postback parameters. Argh!

# re: DataGrid Paging Events not firing
by zakaria March 16, 2005 @ 3:45 am

I have a strange problem, Everything is working fine, i am building dynamic columns, first page is ok, second page is ok, third page is ok, but when i again click the first page, everything is reset, paging does not fire. Sort forget its state...

Anyone to help me out???
mail me at zakaria7@gmail.com

# re: DataGrid Paging Events not firing
by sash March 18, 2005 @ 3:52 am

Im talking about the original prob.
The reason, paging event is not firing, maybe because "pageindexchanged" events fire "itemcommand" first and then go to paging event handler. So if you have handled "itemcommand" also on the page, you may not fire "pageindexchanged" at all depending upon the logic you have coded into "itemcommand".(Although, it should eventually fire "pageindexchanged",if there is no interference from the logic)
So if you have any such event handlers, try this first thing inside its body.

if(e.CommandName == "Page") return;

This should take you straight to your "pageindexchanged" eventhandler.
Hope this helps

# re: DataGrid Paging Events not firing
by K.Tweedy April 03, 2005 @ 8:32 pm

Nice page. I have been working on this for days and after searching through at least 50 googles result came to this page.

What worked for me is to check in the ItemCommand for a paging item and return.

Then with EnableViewState=True all the events would fire.

With EnableViewState=False I had to bind the datasource in the page load event and then again in the PageIndexChange event.

# re: DataGrid Paging Events not firing
by Brian April 05, 2005 @ 8:18 am

I have a problem with the datagrid "not firing" on page change, however, it takes an age - 30 seconds or more - for the page to return. I've got breakpoints on the pageindexchanged event etc and nothing is actioned... until this 30 seconds or more later has elapsed.

First time in, the page loads fine, with 1200+ (unfiltered) records, ten per page (though the user has the option to up this to varying numbers including 50).

I just can't understand when clicking a page number, why and where it disappears to during this time!

brian.roberts@totalise.co.uk

# re: DataGrid Paging Events not firing
by Wayne H. April 07, 2005 @ 5:32 pm

I have been working on this all day. I had copied and re-used a page that had a functioning datagrid. Then the SortCommand event didn't fire. Nothing I saw here or on google worked.

Then I finally found the solution: in the InitializeComponent procedure (auto-code) make sure the event handlers are there. I had to add two, as follows:

this.Datagrid1.ItemCommand += new DataGridCommandEventHandler(this.Datagrid1_ItemCommand);

this.Datagrid1.SortCommand += new DataGridSortCommandEventHandler(this.Datagrid1_SortCommand);

Hope this helps someone!

# re: DataGrid Paging Events not firing
by Tim April 08, 2005 @ 2:22 am

By Anthony Main: "if all the above fail, I normally find its number 2 and Im just being stupid, but I then hardcode the events using the onitemdatabound properties. If your datagrid is within another control such as a IE pageview control you WILL HAVE to do this manually anyway"

How is this done?

# re: DataGrid Paging Events not firing
by rdagger April 11, 2005 @ 5:47 pm

I think I have a solution to one of the troubles people are experiencing. The problem with the datagrid is that its events such as paging and sorting will not fire if the grid has not been bound. During post back you have to first bind the datagrid and then the event will fire. This is usually terribly inefficient, because normally your event is also going to have to call the binding procedure when it's done. Therefore, you end up binding twice, which is a waste of resources and greatly reduces speed. The solution I have found is to not use the built in events. Instead, I use the function Request.Form.Item("__EVENTTARGET") during post back in the Page_Load sub to check for datagrid events and run the appropriate function to handle the event. For example the event target might look like this “DataGrid1:_ctl2:_ctl1” for a sorting call. My function would see that this is datagrid sorting event for the second column (ctl1) and then set the query and bind. Here is a sample code:
If Not Page.IsPostBack Then
BindData()
Else
Dim sEventTarget As String = Request.Form.Item("__EVENTTARGET")

If sEventTarget.StartsWith("DataGrid1:_ctl2:_ctl") Then
DataGrid1_CustomSort()
End If
End If

# re: DataGrid Paging Events not firing
by rugved April 14, 2005 @ 6:50 am

yope enabletheview state
put pageindex even
throw some code in
it will work fine

# re: DataGrid Paging Events not firing
by Steve Klaus April 26, 2005 @ 9:29 am

While my issue is not exactly related to paging, this may help someone having postback problems.

After struggling with an ASP.NET page that would not post back even a new submit button, I recalled fixing this in January on another computer. I am not sure, but I probably broke my postback by copying and pasting a validation control into a new blank form.

BUG: The Submit button on ASP.NET pages does not work after you install the .NET Framework 1.1 Service Pack 1
http://www.support.microsoft.com/?kbid=889877

the KB article is basically says run:

C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322.aspnet_regiis.exe –c

if your project is under source control, you might not have read access to the files so delete the aspnet_client folder and rerun the aspnet_regiis.exe –c command.

My page was still not firing events so I found more information on it and here is my findings:

If your page still is failing to postback even for a simple button, you need to modify the ValidationCommonOnSubmit function inside the WebUIValidation.js file in your aspnet_client folder under you Inetpub. My file was in C:\Inetpub\wwwroot\Almanac\aspnet_client\system_web\1_1_4322 WebUIValidation.js.

function ValidatorCommonOnSubmit() {
event.returnValue = !Page_BlockSubmit;
Page_BlockSubmit = false;
return event.returnValue;
}

# re: DataGrid Paging Events not firing
by Sasan May 02, 2005 @ 1:50 pm

Here is another good one. My problem went away after adding DataKeyField="ProductId" to the datagrid property. I was not doing any sorting etc. I just wanted to access value of ProductId when a checkbox in the datagrid was checked.

# re: DataGrid Paging Events not firing
by Aidan Orton May 03, 2005 @ 2:28 am

I've had a similarly frustrating time with datagrid paging and tried many of the suggestions on this page and others (if I had a pound for the amount of times I've seen someone suggest the obvious of "enable viewstate").

I have 2 pages, both with 4 datagrids on - one the paging works like a dream, the other has all sorts of quirks, such as going from page 4 to page 3 brings back page 1 and selecting an item from page 3 hits the associated item on page 1.

The problem I had was caused by dynamically adding in a usercontrol (page.controls.addat..) above the datagrids. The datagrids seem to reference their location on the page and if that changes all hell breaks loose. My workaround is to add a dummy control onto the design and remove that when the other controls are added, so that the datagrids always have the same index.

# re: DataGrid Paging Events not firing
by Jess May 04, 2005 @ 10:19 am

I'm thinking that all these problems with having to re-databind is because there is a user control in the page. Can people post if they've had this problem with a user control?

# re: DataGrid Paging Events not firing
by Empty May 09, 2005 @ 8:50 am

I ran into this problem as well. Link buttons would work, but pushbuttons wouldn't. I found out that I was rebinding the datagrid @ page load (old newb code there).

In an article I read http://blogs.msdn.com/benmiller/archive/2003/04/04/4844.aspx , I found that the rebinding causes the event to be cleared. After I removed the unnecessary rebind (thanks to viewstate) my buttons worked great.

Part of my ordeal was my own fault because at the time I wrote the loading code I didn't know that the viewstate was retained, so I thought I had to rebind everytime.

I used to use the link button and it uses javascript instead of submitting the form, so I never had this problem before. The problem came when I changed the linkbutton into a pushbutton.

Thanks for this blog!

# re: DataGrid Paging Events not firing
by TheCameleon May 12, 2005 @ 7:42 am

Hi Everybody,
I have been stuck with some issue with datagrids for a couple of hours now. I was trying to create the EditCommand and UpdateCommand method and whereas the edit seemed to work fine the update button was not reacting, so it s not firing I guess...

I found out what was wrong. The bloody Internet Explorer! I don t know if it s due to security settings but I have tried my best to be as permissive as one can be and nothing. But in Firefow no problem , the button works fine. It s pretty funny to see that MS is not the best one to use its own technologies anyway... Maybe some people will face such issue too so I have felt like sharing... Btw the version of IExplore is 6. SP1, I ll check out the latest version to see if it solves the issue.

# re: DataGrid Paging Events not firing
by TheCameleon May 12, 2005 @ 7:42 am

Hi Everybody,
I have been stuck with some issue with datagrids for a couple of hours now. I was trying to create the EditCommand and UpdateCommand method and whereas the edit seemed to work fine the update button was not reacting, so it s not firing I guess...

I found out what was wrong. The bloody Internet Explorer! I don t know if it s due to security settings but I have tried my best to be as permissive as one can be and nothing. But in Firefow no problem , the button works fine. It s pretty funny to see that MS is not the best one to use its own technologies anyway... Maybe some people will face such issue too so I have felt like sharing... Btw the version of IExplore is 6. SP1, I ll check out the latest version to see if it solves the issue.

# re: DataGrid Paging Events not firing
by marko May 12, 2005 @ 11:18 am

argh
i'm another one having problems with paging

i have a page with two datagrids, and while one is working fine, the other dosen't.
they are very similar, both have enableviewstate set to true, allowpaging and all properties needed for paging set.
also i had <asp:boundcolumn> on both of them
why the other pagechanged event is not working is mistery to me????????

# re: DataGrid Paging Events not firing
by derek May 15, 2005 @ 6:13 pm

I got this to work.

this goes in codebehind

private void InitializeComponent()
{
this.dgAudit.SelectedIndexChanged += new System.EventHandler(this.Grid_Change);
this.Load += new System.EventHandler(this.Page_Load);
}
protected void Grid_Change(Object sender, DataGridPageChangedEventArgs e)
{
dgAudit.CurrentPageIndex = e.NewPageIndex;
// Rebind the data to refresh the DataGrid control.
BindGrid();
}

this is my grid element

<asp:datagrid id="dgAudit" runat="server" AutoGenerateColumns="False" AllowPaging="True" AllowSorting="True" OnPageIndexChanged="Grid_Change">

# re: DataGrid Paging Events not firing
by acirep May 20, 2005 @ 6:48 am

You need to populate datagrid or (dynamic created data grid) imidiate after you assign new event to data grid.

ex:
this.dgAudit.SelectedIndexChanged += new System.EventHandler(this.Grid_Change); BindGrid();

# re: DataGrid Paging Events not firing
by mabell May 20, 2005 @ 7:47 am

Seems like a bug in Visual Studio. I was having only one event not firing. I deleted the event and then recreated the event in Visual Studio by selecting the control and then the event in the dropdown menus.

The next time I ran the code, it hit the event. Nothing changed in the code.

# re: DataGrid Paging Events not firing
by Jack May 24, 2005 @ 10:39 am

Steve's post on 5/20/2004 works for me. Thanks.

# re: DataGrid Paging Events not firing
by Nick May 27, 2005 @ 4:20 pm

It was an easy fix for me after reading through these posts (keyword was postback) -- Thanks

You must code for the post back on your page load event. I think it must mess up the binding if it does more than once during the load posts.

If not ispostback
' you code to bind
end if

# re: DataGrid Paging Events not firing
by dom June 04, 2005 @ 8:54 am

Well, if anyone who is reading this is having problem with their ItemCommand not firing. check the function ends with 'handles datagrid.ItemCommand

doh...doh..doh..doh...doh..doh....!!!!

# re: DataGrid Paging Events not firing
by cam tran June 07, 2005 @ 5:38 pm

I got the same problem

The problem caused by EnableViewState

make sure at the very top line in HTML page
EnableViewState = "true"

this will solve it.

# re: DataGrid Paging Events not firing
by ceejay June 21, 2005 @ 11:45 am

I think this is a problem with IE6 SP1 or SP2. Im having the same probelms was Camelion. My grid pages in Firefox but not IE!!

# Solution
by Fran7 June 22, 2005 @ 2:03 am

Try this, It works when the event ItemCommand of the DataGrid should work but it doesn't.

On the Page_Load event:

If (!Page.PostBack)
cmdFindDataFromDB_Click(null,null)
else
{
this.dgData.DataSource=dt;
this.dgData.DataBind();
}

and after it's fill up once, erase the part else.

# re: DataGrid Paging Events not firing
by Al Todd June 28, 2005 @ 8:26 am

Well I've had this unpredictable behaviour too...

Ive a UserControl that is my main FormControl (this is dynamically loaded (LoadControl()) by a Page and placed into another UserControl, my PageTemplate).

The FormControl has two custom (derived) datagrids. I've implemented custom paging and sorting, and the grid raises events when these change, and the events are handled by my FormControl.

Only one of the grids raises its events.

If i copy all of the code into one page and no longer dynamically load the FormControl, just embed the grids straight in, both grids sets of events fire.

I'm now having to resort to having my PageTemplate as a WebControl and write out all my html in code-behind, which is the last thing I wanted... unless anyone has any ideas?

# re: DataGrid Paging Events not firing
by Jonathan July 01, 2005 @ 10:51 am

Only thing that worked for me was the adding of the bound empty column.

[trying to hold back sarcasm to all the "wow .net is perfect" comments I hear]

# re: DataGrid Paging Events not firing
by Sean July 07, 2005 @ 7:43 am

Set the EnableViewState=true,
if you need to clear the grid from the form (say from a cancel button or whatnot) add this to your page_load event
(dgServerContacts is my grid)

dgServerContacts.Columns.Clear()
dgServerContacts.DataSource = ""
dgServerContacts.DataBind()

# re: DataGrid Paging Events not firing
by Fitz July 09, 2005 @ 12:45 pm

I also could not get PageIndexChanged Event to fire for the DataGrid. I backed up my code at the point when the problem began, then spent over two hours trying everything posted here and also I tried manually registering the event-handling method for the PageIndexChanged event of the DataGrid control:

AddHandler dgFindings.PageIndexChanged, AddressOf dgFindings_Change

Nothing worked so I restored my backup code to the point when the problem started and tried it again but still no event was firing. So then I tried something really difficult...I rebooted my computer. This worked, the event began firing away normally.

Fitz

# Designer datagrid vs programmatic datagrid
by gregwmay July 12, 2005 @ 2:05 am

Interesting read on this blog. I think rdagger's post of 4/11 is going to help me the most.

My deal is that a regular old datagrid dragged into a designer works just fine, exactly as I want it to. But if I try and programmatically create the whole thing and add it as a control to, say, a Placeholder, I get bizarre, random, and unfortunate behaviour as described by others here.

Since I am extending the datagrid myself to include things like auto-reverse sorting (e.g. click the "name" column, sort ascending, click it again, sort descending) then I'm just going to try some fixes as well. Good tip re the _EVENTTARGET... I was wondering how to trap that stuff.

Thanks!
mailto:gregwmay@hotmail.com

# re: Designer datagrid vs programmatic datagrid
by gregwmay July 12, 2005 @ 2:08 am

PS. If anyone knows of any good (and free) alternatives to the datagrid, I'd love to know of them!

As my contribution, I found an excellent alternative to the TreeView control (http://www.asp.net/ControlGallery/ControlDetail.aspx?Control=75&tabindex=2). It's by a dude called Pascale, the control is free, its called "Crapstuff" and can be found here: http://www.asp.net/ControlGallery/ControlDetail.aspx?Control=1014&tabindex=2

# re: DataGrid Paging Events not firing
by RAINinMI July 14, 2005 @ 7:06 am

I had the same problem and tried all of the above solutions but none of them worked. But finally I figured it out! I had been using

Page.DataBind()

because I read in a book that will bind all of the DataGrids on the page. I don't know why this wasn't working ... maybe because I called it once in my PageLoad and then again in another method. Anyway, when I changed that and called

DataGridName.DataBind()

(seperately for each datagrid), IT WORKED!!! The _ItemCommand event began firing again :)

I hope this helps someone.

# re: DataGrid Paging Events not firing
by Moojjoo July 25, 2005 @ 3:10 pm

Well everyone... Thank you. I read everybody's response and everyone helped out. My problem was with the ItemCommand Event not firing..

Solutions... Use a link instead of a button worked, but since I am developing for a client I must make everything look the same and use a button. Yes I did copy the code from another Grid that was working and have been scratching my head until I found this site "Thank you GOD".

Solution to fix all...

private void Page_Load(object sender, System.EventArgs e)
{
if(!Page.IsPostBack )
{
DataGrid.DataBind();
}
}

What a waste of developer time... ARGH I am dying on my time left on my project...

On to solving streaming an image loaded from Active Directory to a object in memory to presenting it to the end user inside a datalist...

.NET got to love it. 2 more years I should be at the professional level and quote my price for hourly wages... LOL....

</Moojjoo>

# re: DataGrid Paging Events not firing
by Andrew July 25, 2005 @ 5:28 pm

Hi all. Great thread and very useful. I had the same problem as Aidan Orton posted on 5/3/2005 2:28 AM.

My problem was that the Data Set was not being sorted correctly after subsequent postbacks. For some very very strange reason this meant the PageIndexChanged event did not fire going from 3 to 1 but it did from 1 to 2!!!!

I fixed the sorting and it worked. Bloody bizarre!

I wasted a day on this too, I'm going to have some words now with the bloke who wrote the original code!

# Check Viewstate Twice
by The Wrench August 11, 2005 @ 4:44 pm

Similar problem ... EnableViewState on the datagrid was being set to True in a common object but was False on the property page in the aspx file. Just having as false after the page was loaded and before it was set to true in the code caused the item command not to fire.

# re: DataGrid Paging Events not firing
by BloodBaz August 22, 2005 @ 3:06 pm

The problems as listed by all are well documented here. We should see if Microsoft have an answer to this problem with VS2005.

In the interest of efficiency etc..., we really need the ability to set ViewState="False" but still retain the internal state of PageCount etc.. so that the PageChanged event will still fire etc... without (a) having to retain the State of the whole grid and b) requiring a redundant "DataBind()" on the Page_Load() event during a PostBack.

If we can do this then it may be possible to win both ways i,e only hit the database once per postback and not have to store a huge viewstate but hte DataGrid code will need changing first.

BloodBaz

# re: DataGrid Paging Events not firing
by Rick Strahl August 22, 2005 @ 4:59 pm

I think both those are addressed in ASP.NET 2.0. The combination of partial classes and the use of ControlState instead of Viewstate for controls should alleviate these types of problems. I'm not sure though whether the datagrid has been been fixed in this respect or whether this will apply only to the new DataGridView - I certainly haven't looked at this closely at this point.

# Too much bitching and moaning
by Rick Strahl's WebLog August 26, 2005 @ 6:08 pm

My blog has a lot of 'problem' content, but this is not necessarily a reflection on how I feel about development or the tools I use.

# re: DataGrid Paging Events not firing
by srea September 02, 2005 @ 1:39 pm

If Your Sortcommand is not firing instead it fires itemcommand put
if e.Item.Itemtype=ListItem.Header
return

# re: DataGrid Paging Events not firing
by Ismail Mayat September 09, 2005 @ 5:54 am

I am having a problem with data grid in composite server control. The event PageIndexChanged fires when clicking next and when viewstate is set to true. I have tried everything in previous posts except for putting databind in page load which i cannot do becuase its all in composite server control. Any help much appreciated!!

# re: DataGrid Paging Events not firing
by Bhavana October 17, 2005 @ 9:53 pm

I am having a similar problem.I am creating a datagrid dynamically and adding handlers for the edit, cancel and update commands.

If i initially bind the datagrid in the isPostBack method then the edit command event does not fire.

But if i bind the datagrid outside the isPostBack method the edit command event fires but then the update and cancel command events dont fire.

I really dont understand whats going wrong.
Please can someone help. I have tried all the hints in this post. Please help i am really getting frustrated.

# re: DataGrid Paging Events not firing
by Anthony Main October 19, 2005 @ 1:18 am

Have you checked your not repopulating on postback !?!?!

I.E in your Load if(!this.page.ispostback) ?!??!

As if you rebind on your postback you wont have any controls to handle events for

# re: DataGrid Paging Events not firing
by RAH October 20, 2005 @ 2:23 pm

If you want to (1) implement a datagrid with EnableViewState="False" so that you don't have a large ViewState and (2) still want your PageIndexChanged event to fire and (3) do not want to perform two databindings, here's the solution:

(I am not using ItemCommand, so I can't say whether this will be the solution for those of you who have this added complication)

First of all, going back to 6/3/2004 10:01 AM Parthi, this is indeed the problem that the CurrentPageIndex does need to be saved in the viewstate (or some place that will persist a postback) and restored to the datagrid's CurrentPageIndex property in the PageLoad.

The information at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnaspp/html/aspnet-commondatagridmistakes.asp: Enduring an oversized viewstate is correct EXCEPT that the implementation is wrong!

You cannot try to store the viewstate in the CurrentPageIndex event; it's too late because the LoadPage event fires before the CurrentPageIndex event so there is never a chance to actually save it. Instead, you could save it in your procedure where you grab your data and bind it to the grid.

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If Not ViewState("CurrentPageIndex") Is Nothing Then
datagrid.CurrentPageIndex = ViewState("CurrentPageIndex")
End If

If Not IsPostBack Then
.
.
End If
End Sub

Private Sub BindData()
.
.
datagrid.BindData()
ViewState("CurrentPageIndex") = dgResults.CurrentPageIndex
End Sub

# re: DataGrid Paging Events not firing
by RAH October 20, 2005 @ 2:29 pm

Correction: replace the dgResults above with datagrid.

# re: DataGrid Paging Events not firing
by RAH October 20, 2005 @ 3:09 pm

Ack! Sorry everyone. It seems that the above was still not enough, but I did get it to work again.

I do have two databinds BUT I have modified my routine in which I load and bind my data to accept an optional boolean parameter.
This way, I can tell if I am going to do that "dummy" bind or a real one.

Then, using this boolean in my routine, I decide if to load minimal data (1 record) or the real thing.

This way, at least it's not two full data loads.

# re: DataGrid Paging Events not firing
by RAH October 26, 2005 @ 11:14 am

I found another way to do this. This method involves leaving the ViewState of the datagrid enabled BUT preventing the datagrid from storing your grid data in the ViewState.

First, see this article: http://www.codeproject.com/aspnet/DataGridViewState.asp

However, what I did was to disable each item's viewstate as it is being created, so in the datagrid's ItemCreated event, you simply add:

e.Item.EnableViewState = False

The end result is that the datagrid gets to keep the data it needs to do the paging, but not the data that you are populating the grid with.

# re: DataGrid Paging Events not firing
by Ren Withnell November 16, 2005 @ 7:45 am

Just rebind the datagrid as you do in the displaying page, then response.redirect

This rebinds the datagrid so it's ready for when the displaying page shows it

# re: DataGrid Paging Events not firing
by chiranjib patra November 22, 2005 @ 5:05 am

same above problem i am getting. I am unable to fire onPageIndexevent.Instead of that all time onItemCommandEvent is firing.

# re: DataGrid Paging Events not firing
by Jason Bartlet November 26, 2005 @ 1:34 pm

I have been struggling with the following problem for days now with no solution in site, would appreciate any thoughts on the following.

I have a datagrid defined in the aspx page with one column, an EditCommand Command column. The remainder of the columns are added dynamically.

Clicking on the edit,update and cancel links all work fine but I would prefer to have the edit command column as the last column in my datagrid so I decided to add an EditCommandColumn dynamically an dremove it fromteh aspx page.

This is where my problems start, clicking on Edit in the dynamically created EditCommandColumn does not fire the EditCommand event as my handler dgDisplay_Edit is not called.

Because I have the following in my Page_load

If Not IsPostBack Then
BindData()
End If
I end up with a blank datagrid.

The only way I could get the event to fire, be caught and display the datagrid in edit mode is by calling BindData() regardless of the IsPostBack state. Unfortunately this means that when I click update the new values are lost because I have called BindData to be able to capture the Update event. So in summary:

To be able to capture the edit\update event I have to call BindData to recreate the Datagrid in Page_Load but doing this means that I overwrite any data chnages that were made. Any Ideas?

# re: DataGrid Paging Events not firing
by Pierre Ruiz November 28, 2005 @ 7:54 pm

After reading all your comments I was able to get the event to fire by manually adding the event handler in the code-behind:

private void InitializeComponent()
{
this.Load += new System.EventHandler this.Page_Load);
// added this manually
this.listAuthor.ItemCommand +=new DataListCommandEventHandler(listAuthor_ItemCommand);
}

private void listAuthor_ItemCommand(object source, DataListCommandEventArgs e)
{
// whatever you need to do
}

in the apsx file I have:

<asp:datalist id="listAuthor"
runat="server"....>
.....
<itemTemplate>
....
<asp:Button id="SelectButton" Text="Select" CommandName="Select" runat="server" />
</itemTemplate>

# re: DataGrid Paging Events not firing
by shampya December 02, 2005 @ 2:04 pm

Please help!! i am also having the same problem as bhavna. i have edit command firing up but the update and cancel dont fire. the update click just goes back to edit command event handler. please help.
page load has the following code
If Not Page.IsPostBack Then
Call populatedatagrid()
End If
Call MyDataBind("")

# re: DataGrid Paging Events not firing
by alankford December 09, 2005 @ 6:18 am

I was getting no results when I turned on paging in my DataGrid. After some research, I found that you can't bind to a data reader when using paging, because the data reader doesn't know how many records are in the data.

I resolved this by using a data table instead of a data reader.

# re: DataGrid Paging Events not firing
by Amit Karir December 19, 2005 @ 9:00 pm

Hi Guys,
I have a DataGrid in a user control with AutoGenerateColumns=false. I dynamically generate columns at runtime, to hide the primary key (id) column.Every event fires up normally in a page where I load the control dynamically except for the SortCommand event of the DataGrid. Any suggestions will be highly appreciated. HELP!!

# re: DataGrid Paging Events not firing
by ernestp December 21, 2005 @ 10:18 am

i had a problem with my datagrid paging not working correctly with the Next,Previous (<>) buttons. it would display the first two pages and then repeat the second page when you try to advance. i change the Paging Mode to use Page Numbers and that solved the problem.

# re: DataGrid Paging Events not firing
by tekHedd December 21, 2005 @ 6:57 pm

Adding a DataBind to the OnLoad() function fixed my problem. (Thanks everyone!) Now it works even with EnableViewState=false. My view state is entirely empty, and the grid works. This rules!

My problem: I could not get any grid events to fire on postback, even with EnableViewState=true.

I normally databind in OnPreRender, so that my grid will reflerct any changes in event callbacks. Ideally If the view state is enabled, this usually works. However, in some of my pages, it does not, which may be the result of an overlarge view state.

# DataGrid Events not firing
by Chuck December 23, 2005 @ 8:38 am

I was having an issue with the viewstate not reloading my DataGrid and events not firing.

In the end I discovered that I had a Page.DataBind() in one of my User Controls.

Removing the Page.DataBind() fixed my issue.

# re: DataGrid Paging Events not firing
by Parikshit bhatia January 02, 2006 @ 12:01 am

i found my solution in InitializeComponents()
thanks.

# re: DataGrid Paging Events not firing
by Grant Merwitz January 09, 2006 @ 4:39 am

What a frustrating problem.

I found it only occurred when EnableViewState was set to false.

I got around it by DataBinding in the PageLoad everytime.

# re: DataGrid Paging Events not firing
by Eldor Coder January 17, 2006 @ 1:58 am

'Handles DataGrid.PageIndexChanged' was missing off the end of the PageIndexChanged event. After adding it all was fine.

# re: DataGrid Paging Events not firing
by Patrick January 19, 2006 @ 1:36 am

I placed code in the ItemCommand handler to get out if the pager was clicked. What the heck is wrong with .NET. This thing just started happening out of the blue.

http://www.SURFThru.com

Private Sub DataGrid1_ItemCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles Grid1.ItemCommand

If e.CommandName = "Page" Then
Exit Sub
End If

Dim TransNumber As String
TransNumber = CDec(e.Item.Cells(1).Text)

Session("TransNumber") = TransNumber
Session("TransType") = e.Item.Cells(6).Text
Session("OrderDesc") = e.Item.Cells(2).Text & " " & e.Item.Cells(3).Text
Session("BackTest") = True
Session("ReturnURL") = "OrderSummary.aspx"
Response.Redirect("OrderDetail.aspx")

End Sub

# re: DataGrid Paging Events not firing
by Surajit February 08, 2006 @ 5:25 pm

Is this creating a problem? try the tips below, hope it will work.please let me know wheather its happening or not.

The problem arises when you have one event declared on the .aspx page by setting DataGrid's property and the other one you created by using VStudio editor.So delete all declared event from (.aspx page )the datagrid property like OnItemCommand event.Declare every events carefully on the vs editor by using event/property window.
If its not working till now take the event name from .aspx.cs page and set it at the .aspx page explicitly, for example if its for OnItmCommand event then the event will generated in the .aspx.cs page as DataGridName_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e).
Take this event name and on the .aspx page set the datagrid property OnItemCommand as
OnItemCommand="DataGridName_ItemCommand".
And now what last thing you have to do is to differentiate the source of the event like
using the statement if(e.Item.ItemType == ListItemType.Pager) for PageIndexChange event.

Try this, if still facing problem your doubts are welcome at write2surajit@gmail.com

# re: DataGrid Paging Events not firing
by Melanie February 10, 2006 @ 12:49 pm

Hi,

I had the same freaking problem..and i tried almost everything in this page.

However this is what i did and it worked.

I had a datagrid with some columns froma database and a select button column. Also i had the paging option on. I wanted a value from a certain column to be displayed in a textbox when the select button was clicked

The problem i was getting :

At a time only either one of them worked. i.e either the select buttons or the paging option.
Most of the time the paging option gave an eror when run together ..some arrayindexoutofbound thing

Then i read in some article that everytime any button on the datagrid is clicked the itemcommand gets fired :o(

So i just inserted this code in the itemcommand
event

Private Sub DataGrid1_ItemCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.ItemCommand

If e.CommandName = "Select" Then
TextBox1.Text = e.Item.Cell(1).Text
End If

Earlier i didnt check the name of the button..I think that it what caused this error.. Its working fine now

Hope this helps

# re: DataGrid Paging Events not firing
by Big Wave Dave February 20, 2006 @ 9:30 am

I needed to dynamically add columns to a datagrid based on a type; i.e. Type A – add columns 1-2-3. Type B – add columns 4-5-6, etc.

The first column is an edit button tied to an ItemCommand event and the last column is a delete button tied to an ItemCommand event.

If I added the LinkButton columns dynamically, the ItemCommand event never fired. If the columns were defined in the ASPX page instead of the code behind, then the ItemCommand always worked.

To solve the problem, I defined the LinkButton columns in the ASPX page.

<asp:buttoncolumn buttontype="LinkButton" text="Edit" commandname="Edit" />
<asp:buttoncolumn buttontype="LinkButton" text="Delete" commandname="Delete" />

The code behind then looked something like this:

Define method to create dynamic column…

private BoundColumn BoundColumn(string dataField, string headerText, bool makeVisible)
{
BoundColumn c = new BoundColumn();
c.DataField = dataField;
c.HeaderText = headerText;
c.Visible = makeVisible;
return c;
}

Create Dynamic Columns…

this. Grid.Columns.AddAt(this. Grid.Columns.Count-2, this. BoundColumn ("Data1", "Column A", true));
this. Grid.Columns.AddAt(this. Grid.Columns.Count-2, this. BoundColumn ("Data2", "Column B", true));
this. Grid.Columns.AddAt(this. Grid.Columns.Count-2, this. BoundColumn ("Data3", "Column C", true));

The key was to only insert dynamic columns that were needed using the AddAt method and leave the LinkButton columns, which did NOT need to be dynamic in the ASPX. (If I did not need the Delete button in the last column, I could have just used the Add method instead.)

# re: DataGrid Paging Events not firing
by Matthew Webster March 01, 2006 @ 4:02 am

I found that calling

DataGrid1.DataBind()

in the Page_Load, rather than

DataBind()

suddenly made all the event linking work again. Can't guarantee it however, as with this I never would.

# re: DataGrid Paging Events not firing
by yj March 17, 2006 @ 9:11 am

i had the same problem. what i did was to set enableViewState="True", suddenly works.

<%@ Page Language="vb" AutoEventWireup="false" Codebehind="files.aspx.vb" Inherits="project.files" enableViewState="True"%>

i believe this is the part makes the difference.

# re: DataGrid Paging Events not firing
by Katya March 21, 2006 @ 2:47 am

Yes !!! EnableViewState ="True"
also for a panel where the datagrid is placed ,otherwise even if the datagrid EnableViewState ="True" but panel's "False" it's not fired!

# re: DataGrid Paging Events not firing
by Shaun April 04, 2006 @ 8:11 am

Hi

After reading the first few posts I can confirm that setting EnableViewState to True solved the problem. Just like that.

Dan

# re: DataGrid Paging Events not firing
by Richard Fencel April 20, 2006 @ 2:22 pm

Are you generating columns dynamically as in:

bc = new BoundColumn();
bc.DataField = "AttrName";
bc.HeaderText = "Attribute";
grid.Columns.Add(bc);

If so, try putting all the above definitions into a method, e.g. DefineColumns() which you then insert in the Page Load event as follows:

Page_Load
{
DefineColumns();
if (!PostBack)
{
}
else
{
}

This solved the problem for me. Apparently, the column definitions do not get cached.

# re: DataGrid Paging Events not firing
by birre April 21, 2006 @ 12:10 pm

nothing won't work for me, i'm getting desperate

i'm working with postback on a dropdown list for user functions, everything fine, unless the paging thing...
when i go to other pages then first, the datagrid just dissapears :(

damnnnnn!!!!!!!please help

# re: DataGrid Paging Events not firing
by birre April 21, 2006 @ 8:59 pm

well, i found my problem

though, my event was triggering (tested with filling up a txtfield in my event), the datagrid just dissapeared when going to page 2

for me, the problem was that in my page load, i had If Not Page.IsPostBack Then

but, it had to make the connection again, so in my event I just made the command.fill again, and the datasource

Sub datagrid_PageIndexChanged(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridPageChangedEventArgs) Handles datagrid.PageIndexChanged
datagrid.CurrentPageIndex = e.NewPageIndex
myCommand.Fill(ds, "tblDVDs")
datagrid.DataSource = ds.Tables("tblDVDs")
DataBind()
End Sub

with this code, my user functions worked , and the paging and sorting worked :)

hope this can help!

# re: DataGrid Paging Events not firing
by Shruti April 27, 2006 @ 5:07 am

Hi All,

I have a datagrid with link buttons in a column. When I click on the link I do some server side processing and then redirect to another page, say XYZ.aspx

I then hit the browser back button and come back to the page displaying the datagrid.

Now when i try changing the page, the page change event gets fired and then the link button click event is also fired. As a result I see the page XYZ.aspx and not page 2 of the datagrid.

I tried all the above suggestions but nthn seems to be working...Any help is greatly appreciated.

Thanks,
Shruti

# sorting event is not fired when columns generated at runtime
by Arun May 12, 2006 @ 12:57 am

Hi All!
Can any body help me how can i implementing sorting with runtime column binding. code snipp

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Put user code to initialize the page here

End Sub

Public Sub BindResultData(ByVal sortField As String)
BindDColumn()
Dim myCmnd As SqlCommand
Dim myrdr As SqlDataReader
Dim myConn As New SqlConnection(ConfigurationSettings.AppSettings("CSConnectionString"))

myCmnd = New SqlCommand("Select MainID, Name, Date_Of_Birth from MainForm order by " & sortField, myConn)
Try
myConn.Open()
myrdr = myCmnd.ExecuteReader
dtgResult.DataSource = myrdr
dtgResult.DataBind()
BindDColumn()
Catch ex As Exception
lblAlert.Text = ex.Message
Finally
If myConn.State Then myConn.Close()
End Try
End Sub
Public Sub BindDColumn()

Dim boundClm As New BoundColumn
boundClm.HeaderText = "Main ID"
boundClm.DataField = "MainID"
boundClm.SortExpression = "MainID"
boundClm.Visible = True
dtgResult.Columns.Add(boundClm)

Dim boundClm2 As New BoundColumn
boundClm2.HeaderText = "Name"
boundClm2.DataField = "Name"
boundClm2.SortExpression = "Name"
boundClm2.Visible = True
dtgResult.Columns.Add(boundClm2)

Dim boundClm2 As New BoundColumn
boundClm2.HeaderText = "DOB"
boundClm2.DataField = "Date_Of_Birth"
boundClm2.SortExpression = "Date_Of_Birth"
boundClm2.Visible = True
dtgResult.Columns.Add(boundClm2)
End Sub

the html code for datagrid is as follow

<asp:DataGrid id="dtgResult" runat="server" CssClass="popups" OnSortCommand="GoSorted" AllowSorting="True"
AutoGenerateColumns="False"> </asp:DataGrid>

Please help me soon its urgent

# re: DataGrid Paging Events not firing
by lyqfqy May 30, 2006 @ 4:25 am

My problem is: I added one sentence:"Server.Execute("JudgeLogin.aspx");"
in Page_Load.And those paging or delete fuction could't work..
When I remove this sentence ,all worked..
damn it,it took me more than 3 days to work out this problem.....ft
ps:JudgeLogin.aspx Souce File is
public class JudgeLogin : System.Web.UI.Page
{
private void Page_Load(object sender, System.EventArgs e)
{
if(Session["flag"]==null||(string)Session["flag"]!="ok")
{
Response.Redirect("LoginFailure.aspx");
}
// ???????????????
}
#region Web ??????????
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: ???? ASP.NET Web ??????????
//
InitializeComponent();
base.OnInit(e);
}

/// <summary>

/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);

}
#endregion
}

# re: DataGrid Paging Events not firing
by LoveToSpod June 01, 2006 @ 4:52 am

YOU HAVE PAGING ISSUE???:

THE PageIndexChanged EVENT HANDLER NEEDS SOME CODE!!

Go to the PageIndexChanged event handler of the DataGrid.

Paste the follwoing VB.NET code:
------------------------------------ DataGrid1.CurrentPageIndex = e.NewPageIndex
SqlDataAdapter1.Fill(DataSet1)
DataGrid1.DataSource = DataSet1
DataGrid1.DataKeyField = "ID"
DataGrid1.DataBind()
------------------------------------

You may need to edit the DataKeyField from "ID" to your setting.

Voila!! Sorted. 4hrs wasted - Disgruntled... Hmmmphh! ;(

# re: DataGrid Paging Events not firing
by LoveToSpod June 01, 2006 @ 4:54 am

Code above needs carriage return Ooops!

Use this:

Paste the follwoing VB.NET code:
------------------------------------
DataGrid1.CurrentPageIndex = e.NewPageIndex
SqlDataAdapter1.Fill(DataSet1)
DataGrid1.DataSource = DataSet1
DataGrid1.DataKeyField = "ID"
DataGrid1.DataBind()
------------------------------------

# re: DataGrid Paging Events not firing
by Andreas Bjerkeholt June 08, 2006 @ 5:44 am

For me, Kevin Pirkl's solution helped. Thanks!

# re: DataGrid Paging Events not firing
by jenny F June 12, 2006 @ 4:29 pm

The main issue here is that this is a Microsoft product:)

I implemented page handler, it worked fine for 2 months, suddenly breaking today when i found out that ItemCommans function is called intead of pageChanged. Why? Who knows?:)

That kinda thing would never happen with php or perl.....

# re: DataGrid Paging Events not firing
by Adhar Jain June 18, 2006 @ 2:35 pm

I have generated a datagrid dynamically and placed it in a placeholder. Now I called

((DataGrid)(this.plhContentDGrid.Controls[0])).PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.dg_PageIndexChanged);

after placing the datagrid on placeholder. Problem is I am getting my (<>) button disabled even when there are more records than the page size is defined. PLEASE REPLY..It has really wasted my lot of time..

# re: DataGrid Paging Events not firing
by Pritesh Dusara July 03, 2006 @ 8:34 am

If your application keeps firing the ItemCommand instead of the PageIndexChanged event then include the following bit of code to the begining of the ItemCommand event:

If e.Item.ItemType = ListItemType.Pager Then
Return
End If

This will return control and fire the PageIndexChanged event.

Can't explain why this happens.

Hope this has helped.

# re: DataGrid Paging Events not firing
by Sudip July 07, 2006 @ 3:47 am

Thanx guys,
i was facing the same problem. It was fixed as soon as i set the enableViewState to TRUE.

# re: DataGrid Paging Events not firing
by Archana Bala July 23, 2006 @ 7:06 am

This discussion was very useful.Thanks everyone. I had the same problem where my Itemcommand event of the datagrid was not firing. It was working before. After seeing Rovol;s solution I set the EnableViewState to true and the problem got solved. I would also suggest putting event handler code outside Initialise in the OnInit immediately after the Initialise call statement

# re: DataGrid Paging Events not firing
by JWoo August 07, 2006 @ 9:47 am

After sifting through a tonne of junk the solution for my interpretation of the problem was from WayneH above:

"in the InitializeComponent procedure (auto-code) make sure the event handlers are there. I had to add two, as follows:

this.Datagrid1.ItemCommand += new DataGridCommandEventHandler(this.Datagrid1_ItemCommand);

this.Datagrid1.SortCommand += new DataGridSortCommandEventHandler(this.Datagrid1_SortCommand); "

It appears when copying and pasting the datagrid that the event handlers are not copied automatically. The issue affects the sort, page and item command - well anything that involves an event handler.

# re: DataGrid Paging Events not firing
by virgil August 08, 2006 @ 1:28 am

Well, my problem was about the same with the difference that the event would fire from almoust all the pages with the exception of the last page from where it would take me directly to the first and form any page if i wanted to go to the first one. I still don't know what the problem with the first page was, but the problem with the last page was the __TARGETEVENT that on all pages was something like dataGrid:_ctl7:_ctl<page number> and on the last page it was dataGrid:_ctl5:_ctl<page number> and it could not recognize that _ctl5 was the pager, all this because the last page had fewer rows. I'm sure you can find a way to parse this in the OnLoad event and do whatever you did in the paging event and I'm sure it would work well, but you will have the same last page problem and another problem if you want to modify the number of rows on a page and you hardcode it in the program. But there must be a way without hardcoding the value. What I did was to enable view state, it did work fine that way, and I'm probably going to go back again later to try and do it the other way.
So, just check in the OnLoad method for Request.Form["__EVENTTARGET"]; (C#)

# re: DataGrid Paging Events not firing
by I give UP! August 14, 2006 @ 5:14 pm

I've done everything on this entire thread, and it still doesn't work -- I'm screwed!!!

# re: DataGrid Paging Events not firing
by ram August 22, 2006 @ 7:38 am

Hi,
Below is the C# code I have in which datagrid is created dynamically.Now how do I achieve paging in this?When I tried using "DataGrid2.AllowPaging=true;Datagrid2.pagesize=15;",it doesnt work.please let me know how to achieve paging in this datagrid.

Thanks!
****************************************
DataGrid DataGrid2 = new DataGrid();

this.Controls.Add(DataGrid2);
SqlConnection myConnection3 = new SqlConnection(ConfigurationSettings.AppSettings["sqlConnection1.ConnectionString"]);

myConnection3.Open();
SqlDataAdapter daSelect = new SqlDataAdapter("select * from bl_AlertDetails ",myConnection3);

DataSet dsSelect = new DataSet();
daSelect.Fill(dsSelect,"tbl_AlertDetails");
DataView dv = new DataView( dsSelect.Tables["tbl_AlertDetails"] );
DataGrid2.DataSource = dv;
DataGrid2.DataBind();

# re: DataGrid Paging Events not firing
by Jim Gonzales Omaha NE August 25, 2006 @ 8:52 am

I was doing the method described above by DavidG where you bind in your sort / page subs and you get the problem mentioned of double binding.

I got around that issue with this in the post back:

If Request.Form.Get(”__EVENTARGUMENT”) = “” Then
Bind the Grid
End If

If the event is empty this is not a page/sort so go ahead and bind but if there is something there then we must be doing a page/sort and don't need to bind.

If your doing more then just paging and sorting it might be a little more complicated and you might have to check what the event was etc.

# Tim Mackey's Weblog - Asp.Net DataGrid PageIndexChanged not working
by Tim Mackey's Weblog September 29, 2006 @ 9:00 am

# re: DataGrid Paging Events not firing
by Muhammad Naveed Aslam October 09, 2006 @ 11:32 pm

Thanks a lot to all!

It was really driving me crazy. Page Index changed handler was not getting fired.
I set:
EnableViewState = "true"

And its works fine now. Voila!!!

# re: DataGrid Paging Events not firing
by Rajesh October 25, 2006 @ 1:04 pm

This post helped a lot. Delete, save and recreate did the trick for me.

While I could solve the paging event, my sort event for the Datagrid will not fire for some reason. I did all possible ways discussed in this thread. My question would be if page event can fire why can't the sort event? Any Ideas?

# re: DataGrid Paging Events not firing
by Si November 29, 2006 @ 1:00 pm

How absolutely crap that this problem is still happening and has never been resolved or the reason bottomed out!

# re: DataGrid Paging Events not firing
by Mark V December 04, 2006 @ 10:31 am

Anthony,

Your solution works!
Thank you for your input & help

# re: DataGrid Paging Events not firing
by Richa January 09, 2007 @ 3:11 am

hey thanks for all,
but i think to bind the grid on pageload will work good.

# re: DataGrid Paging Events not firing
by l January 16, 2007 @ 10:28 am

What worked for me for pagination not working:

I added in the html for the datagrid (right click design and say view html):

OnPageIndexChanged="DataGrid1_PageIndexChanged" allowpaging = true

in ASP add:

public void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
DataGrid1.CurrentPageIndex=e.NewPageIndex;

//bind grid with your sql statement:
BindGrid(Request.Cookies["eName"]["strSQL"]);
}

# re: DataGrid Paging Events not firing - ANSWER
by Tony D January 26, 2007 @ 12:45 pm

I believe I have the answer, or at least the answer to why my paging didn't work.

My paging was working fine until I made some changes (using Visual Studios 2003) in the HTML view (not the Design view). The changes I made caused an error when I tried to go back into the Design View. Because of this the DataGrid would not display. I went back into the HTML View and backed out my change then I decided to run the project and that's when I discovered that the paging didn't work anymore due to the PageIndexChanged Event not firing.

After carefully looking over the codebehind (C#) I discovered that a line of code was removed as a result of the error I received when I tried to go back into the Design View. The line of code that was removed is the following:

this.dgEmpCL.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.dgEmpCL_PageIndexChanged);

This code is actually hidden in C# codebehind under...

Web Form Designer generated code

I hope this helps.

You have to click the + symbol to expand this section of code.

# Too much bitching and moaning - Rick Strahl's Web Log
by Rick Strahl's Web Log February 17, 2007 @ 4:43 am

My blog has a lot of 'problem' content, but this is not necessarily a reflection on how I feel about development or the tools I use.

# re: DataGrid Paging Events not firing
by Fekri February 23, 2007 @ 8:56 am

Here is the solution guys for datagrid not firing an event. The reason is not firing an event is when you use itemcommand event, this handles all the events that come from the datagird. All the events. So if you want to use it anyway, the itemcommand specially if you added your events to the datagrid, this how you could do paging. In the itemcommand event ignore the paging event do something like this

if e.commandName = "Page" then
exit sub
end if
and then add the pageindexchanged event which will look something like this
datagrid.currentPageIndex = e.NewPageIndex
But very important point here, you need to rebind you data to the datagrid after you change the index otherwise nothing will change

# re: DataGrid Paging Events not firing
by Wladimir March 08, 2007 @ 12:41 pm

I added a "faked" data binding on postback, it solved this problem for me:

private void Page_Load(object sender, System.EventArgs e)
{
if(!IsPostBack) getStoryData();
else bindEmptyDataSet();
}

private void bindEmptyDataSet()
{
DataSet ds = new DataSet();
ds.Tables.Add(new DataTable("fake"));
StoryGrid.DataSource = ds.Tables[0];
StoryGrid.DataBind();
}

# re: DataGrid Paging Events not firing
by Heather March 13, 2007 @ 2:00 pm

Ok, after fighting with this all day, I came across another post, which I forgot to save to give credit for. My datagrid is part of a composite WebControl and I had the issue where no events at all were firing. Make sure that you implement INamingContainer. My class declaration now looks like such:

public class MyCompositClass: System.Web.UI.WebControls.WebControl, INamingContainer

Hope this helps someone.

# re: DataGrid Paging Events not firing
by Lisa Z. Morgan March 28, 2007 @ 6:42 am

I tried the recommendation to switch to Source view, delete AllowPaging="True" PagerStyle-Visible="False" AllowCustomPaging="True", run the app, then re-enable these through the designer. I also turned off Enable Sorting and Paging, forcing the datagrid to handle it on the server side. Not sure which part of this worked, or if it was the combination, but it is working now.

# re: DataGrid Paging Events not firing
by Roy/Stefan April 12, 2007 @ 12:36 am

We also had a problem with the PageIndexChanged event not firing. In our case we binded the data in the prerender event. This will contradict with the lifecycle of ASP.NET, because the Raise Changed Events are fired directly after the load event. When you put the binding in the prerender event handler the data wont be there when the raise events fires (and the PageIndexChanged event neither).
Place the binding in the load event and the PageIndexChanged handler will execute.

# re: DataGrid Paging Events not firing
by AndyC April 23, 2007 @ 3:55 am

FWIW I managed to solve this by doing a data bind in the datagrid load event even on a postback. This is important, you must bind on a postback! Great thread.

# Overcoming DataGrid Problems when Sorting on programmatically adding columns
by RobLog July 14, 2007 @ 5:21 am

# re: DataGrid Paging Events not firing
by David Miller July 19, 2007 @ 8:01 pm

It just got worse...

I'm currently fighting a real problem on some legacy code:

I need:

EditItemCommand firing which requires the DataBind to occur in PreRender because it wipes the event.

I also need:

PageChanged to fire which requires the databind to occur in the PreRender for ASP.NET

However, for the current version of the webserver (over which I have no control) running on MONO -

I need to databind in the load method for the PageChangedIndex to fire properly. Which screws the edititemcommand.

What do i do? Code an IfMono then -> else statement?

#

re: DataGrid Paging Events not firing
by Arun August 09, 2007 @ 11:02 pm

Hi All,
same problem was here for me. I was binding the fields of the dataset to the datagrid's columns at runtime. I was in a hurry and Chris's "black magic" solution really worked for me. I just added an empty column. Thanks Chris.

#

re: DataGrid Paging Events not firing
by Lou August 11, 2007 @ 11:01 pm

in the .aspx page make sure that there is OnItemCommand="dgDataGrid_ItemCommand" at the end of your <asp:DataGrid> tag.

For example, mine looked like this in the aspx page:

<asp:DataGrid ID="dgDistroLists" Width="100%" runat="server" AutoGenerateColumns="False" GridLines="Horizontal" OnItemCommand="dgDistroLists_ItemCommand">

Lou
AutoMagical Solutions

# re: DataGrid Paging Events not firing
by K.Raj August 30, 2007 @ 5:08 am

just check that you have taken care of the 'IsPostBack' thing in the page_load event properly and it should work fine then.. worked for me.

# re: DataGrid Paging Events not firing
by Bhavik September 06, 2007 @ 3:53 pm

Great page!! I tried different thing but withoutpostback the databind is working fine on pageload.!! Thanks guys

# re: DataGrid Paging Events not firing
by Kristin September 12, 2007 @ 10:40 am

Setting EnableViewState="false" did the trick for me. The paging worked for each page moving forward and back, except when clicking page one. The PageIndexChanged event wouldn't fire, so if I clicked page 5, then clicked back on page 1, I would see page 5's results remaining in the grid. Very aggravating. Glad I found this blog.

# re: DataGrid Paging Events not firing
by sandy December 03, 2007 @ 11:32 am

Good that I ran into this page. EnableViewState = false worked for me too.

#

re: DataGrid Paging Events not firing
by Fereshteh December 05, 2007 @ 5:43 am

Hi
Every time you refer to a page if u set "AutoPostBackOnSelect = true" the page move successfully.

#

re: DataGrid Paging Events not firing
by hiren sojitra February 18, 2008 @ 3:38 am

hay guys

I read your all comments but still i have problem to pageindexchagne event of datagrid i have 5 girds on on page they have different datasource coming via dataview from sql where in last grid i am using paging but i simply add allowpaging=true and below code on Pageindexchange event

Private Sub grdhonors_PageIndexChanged(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridPageChangedEventArgs) Handles grdhonors.PageIndexChanged
grdhonors.CurrentPageIndex = e.NewPageIndex
grdhonorsbind()
End Sub

and also i did on Page_load(..)
if not page.postback then
binding 5 grids here..
end if

also viewstate=true
tryed to bound blank coloumn
but still i am there please help me guys really apriciated
if you have any suggestion mail me:
hiren.sojitra@gmail.com

thanking you

# re: DataGrid Paging Events not firing
by Shon February 20, 2008 @ 11:44 am

For those people building columns dynamically, you don't have to rebind if you build columns in the init event.

Another good article:

http://www.codersource.net/published/view/286/creating_dynamic_bound_and_template_columns_in_datagrid.aspx

#

re: DataGrid Paging Events not firing
by Cam April 04, 2008 @ 10:49 am

I have a dynamically generated grid derived from DataGrid. It generates content on the fly with columns added during Page_Load. I've worked through paging problems and I've found that the biggest problem is that the paging elements are subject to name changes depending on how many rows in the datasheet and if there are any other controls in the pager. When the name changes between postbacks then the pager events won't fire.

The trick I found to make it more reliable was to set each pager control ID and each pager row ID so that the control id is consistent regardless of grid content. I do this during the ItemCreated event. Here's the code from my OnItemCreated() handler, where _pageRowIndex is used to differentiate between the top and bottom pager rows that are always present (even though I'm just using the bottom).

if (e.Item.ItemType == ListItemType.Pager)
{
e.Item.ID = "pager_" + _pagerRowIndex.ToString();
}

#

re: DataGrid Paging Events not firing
by Glen June 12, 2008 @ 11:01 pm

I haven't had a chance to read every bodies reply however my solution to solve "Events not firing" was (NB: it is identical to someone elses reply I read come to think of it) an avoids adding the dummy column:
HTML Snippet
...
<asp:DataGrid id="DataGrid1" runat="server" AutoGenerateColumns="False" AllowSorting="True"></asp:DataGrid>
...
C# Snippet
...
DataView mySource;
...
Page_Load(...) {
mySource = GetSource();
LoadBoundColumns(mySource);
if (!IsPostBack)
SortDataAndSaveToViewState(mySource, DefaultColumn, "ASC"); }
BindGrid(DataGrid1, mySource);
}
...

I hope this helps. Another words I load and bind the bound columns every time whether a post back or not, this seems to hook the event. I would only get the source and bind on IsPostBack=false in the case AutoGenerateColumns was true. As an aside - I use a Session variable to persist mySource for the first time (saves on reloading from database on post back or re-navigation to page) (and update the Session variable if I change it somewhere else) and also use ViewState for the sort-column and sort-direction (whether it is asc or desc).
...
void DataGrid1_SortCommand(...) {
string sortColumn = e.SortExpression;
string sortDir;
if (sortColumn == SortColumnFromViewState)
if (SortDirFromViewState == "ASC")
sortDir = "DESC";
else
sortDir = "ASC";
else
sortDir = "ASC";

SortDataAndSaveToViewState(mySource, sortColumn, sortDir);
BindGrid(DataGrid1, mySource);
}
...

# re: DataGrid Paging Events not firing
by Alessio Fiore July 04, 2008 @ 5:48 am

The same problem (pager event not firing) appeared for my datagrids. I've solved it thanks to the Wolf Logan post, back in this thread.
It seems like, if the datagrid still wasn't bound, the Page_Load event wouldn't give the control to the pager event. This happens expecially when the datagrid view state is disabled (since the datagrid data is not automatically kept and passed through subsequent requests by the view state hidden field). Which means that one must call the datagrid DataBind() method BEFORE the pager event takes control, possibly in the Page_Load event.

That's what I've done, with some optimizations just to avoid executing queries twice.

In my form there are two panels: the upper one contains search criteria, with a "search" button and a "(server-side) reset" button. The lower panel contains the search result, paged, datagrid:

<html>
<head>
...
<script language="javascript" type="text/javascript">

</script>
</head>
<body>

<input type="hidden" name="__datagridcmd__" value="" />

...

<asp:Button ID="btnSearch" OnClick="BtnSearch_Click" OnClientClick="beforeSearch()" Text="Search" Runat="server" /
<asp:Button ID="btnReset" OnClick="BtnReset_Click" OnClientClick="beforeReset()" Text="Reset" Runat="server" />

...

<asp:DataGrid ID="dgSearchResults" Visible="True" CssClass="formgrid" EnableViewState="false"
PagerStyle-HorizontalAlign="Right" PagerStyle-Mode="NumericPages" AllowPaging="True" PageSize="4"
Width="100%" CellSpacing="1" CellPadding="3" AutoGenerateColumns="False" BorderWidth="0px" OnPageIndexChanged="DgSearchResults_PageIndexChanged" Runat="server">

...

</asp:DataGrid>

...

</html>

The "__datagridcmd__" hidden field and the two js client functions are used to evaluate, in the Page_Load event, wether the postback was fired by the pager or not.

Here's part of my code-behind file (simplified):

protected DataGrid dgSearchResults;

private void Page_Load(object sender, System.EventArgs e)
{
if(!IsPostBack)
{
//do some initial setup
}
else
{
string sDatagridCmd = Request["__datagridcmd__"];
if(sDatagridCmd.Equals("")) //pager event
DoSearch();
}
}

private void DoSearch()
{
//Get a database connection

//Read search criteria

//Execute the search query

//Set the DataSet as the datagrid DataSource

dgSearchResults.DataBind();
}

protected void BtnSearch_Click(object sender, EventArgs e)
{
dgSearchResults.CurrentPageIndex = 0;

DoSearch();
}

protected void BtnReset_Click(object sender, EventArgs e)
{
//Reset search criteria widgets

dgSearchResults.DataSource = null;
dgSearchResults.DataBind();
}

protected void DgSearchResults_PageIndexChanged(object sender, DataGridPageChangedEventArgs e)
{
dgSearchResults.CurrentPageIndex = e.NewPageIndex;

//That's the point: I don't execute the query again
//since it was executed and the datagrid bound
//in the Page_Load event.
//Here I just call the DataBind() method again
//to apply the CurrentPageIndex change
//without re-executing the query on the database
dgSearchResults.DataBind();
}

Hope it helps.

Any other suggestion will be appreciated :)

#

re: DataGrid Paging Events not firing
by string sortDir; August 26, 2008 @ 8:21 am

string sortDir;
if (sortColumn == SortColumnFromViewState)
if (SortDirFromViewState == "ASC")
sortDir = "DESC";
else
sortDir = "ASC";
else
sortDir = "ASC";

SortDataAndSaveToViewState(mySource, sortColumn, sortDir);

# re: DataGrid Paging Events not firing
by Kavitha October 23, 2008 @ 2:38 am

Hi,
I have the same problem for which none of the workarounds mentioned above are working.
ViewState is enabled and I have even added a boundColumn. No luck trying them.
Can anyone suggest any other workaround

#

re: DataGrid Paging Events not firing
by Ben October 29, 2008 @ 7:15 am

Hello Rick and all

I admit didn't read all the comments. After half of the comments there wasn't "My" solution which is:
I had a asp:panel containing the datgrid. On the asp:panel was EnableViewState=false. Setting EnableViewState=true on the datagrid did not help. Only setting it on the panel helped.

Many thanks for your blog. Wanted to contribute something also. I always read so good tips here.

Best regards
Ben

# re: DataGrid Paging Events not firing
by Ganesh June 02, 2009 @ 1:28 pm

I was having this same problem. Deleting the control and putting it back did not fix it. The event was firing when I have the "autogenerate columns" option "on". I did not want it because I was creating the columns myself. Thanks to your post and the comments on it, I was able to get it working. I added a empty column to the datagrid (per a comment above) and it started working. Thanks again.