I'm stumped. I'm using a masterpage and my only content area has a grid view ('gridview1'). I'm using the gridview1_rowdatabound to create a summary total field. The issue is that it cycles through this sub twice???? So my total reflects twice the amount. My master page does not have any grid controls, etc. Mostly cosmetic.

Help.

Hi ya,

probably you could paste some code here ? I'm pretty sure that the event is fired only once but you are processing it twice.

Cheers,

Yani 

Thanks,


Yani Dzhurov

I've found an article that explains that you can do this in one of two ways.

1.) since I have the values already in the dataview just total them during creation. This is where, when I put my stops in the code, I see it cycling through the sub twice. I have it commented currently. The GridView1_RowDataBound executes twice.

' End If

The second option is:

2.) to create another select command and use that single value that is the total. Creating another trip to the db. More overhead though. But how would I then put the output value to a label? This is a single value so I ouldn't use dataview, etc.?

I know it is pretty stupid solution for this problem, but for the time being until you find the source for the problem, you could simply devive totalSubTotal by 2:

 'Protected Sub GridView1_DataBound(ByVal sender As Object, ByVal e As System.EventArgs)

' lblSubTotal.Text = "<h5>Total: " & (totalSubTotal/2).ToString() & "</h5>" 'End Sub

Or sth like that.

Cheers,

Yani 

Thanks,


Yani Dzhurov

Yea, I thought about that. I also saw an obscure posting that suggested a microsoft defect in VS 2005 for Master Pages and Gridviews?

I've also used below to first get row count then cycle through them using that.

 On top of all this, I also have pagination, and I've found that I would get rows.count = whatever was on the page, etc. You'd think that this would be simpilier.

I saw another postings discussing a solution but I wouldn't be able to use callbacks.

Thanx.

Here is what I see happening now, I hope someone can figure out why. I'm using pagination and I have it set to 4 records. There are a total of 7 records. So as I watch the rowdatabound sub I see it go through the 7 rows then start again at the first page which has 4. So my Total ends up being 11 items totals, not the complete 7. The gridview is displaying correctly. I'm using allowcallbacks, but see this when that is turned on. The grid is also in a masterpages content area, but is the only grid.

If I select the pagination button for page 2, the total now shifts to only those 3 records. Then when I return to the first page it now only totals the four????????????? 

defect is 2.0? Thanx.

Hi,

i experienced similar problem recently. While debugging i found out that the additional row weren't data bound ones, but footer and header.

It is quite possible that it is the same for your scenario. You have two pages for these 7 records , so probably there are two headers and two footers ? Or there could be a pager row ?

You could trace and see the type of each row to see what exactly is going on, but i don't think it is a defect/bug in 2.0 :)

Cheers,

Yani 

Thanks,


Yani Dzhurov

I thought that but traced it and found all were what I call "body" rows.

I'm using 'e.Row.RowType = DataControlRowType.DataRow' so I can clearly see non-footer and header data.

hmm, quite strange .

So probably you could trace either some value of these rows, some ids probably? So you could identify which exactly are this fields. I think you mentioned that the repeated rows are the rows on the first page, right ?

My assumption is that you have only 7 rows, but the event DataRowBound is fired twice for some of them, or you have registered twice for this event ?

Cheers,

Yani 

Thanks,


Yani Dzhurov