Hi there,

I'm binding a llblGenDataSource2 to a GridView. Its doing everything automatically and paging is enabled. How do I retrieve the total row count so I can describe the results with a label?

Is it possible to get it off of the GridView?

Cheers, Ian.

Is paging is server-side, then you should set yourLLBLGenDS.LivePersistence = false, then intercept the events PerformSelect, PerformWork and PerformGetDBCount. At PerformGetDBCount handler you could catch the number you are looking for in a variable to show. (see this for more info).

If the pagination is client-side, a yourLLBLGenDS.EntityCollection.Count should be sufficient.

Its a read only grid so I can just set LivePersistence to false. But this seems like a strange design. Why should when I do db work have anything to do with how I get the row count? And what would I do if I wanted LivePersistence to be true and still page on the server? Does that mean that I wouldn't be able to retrieve the row count?

I currently have LivePersistance true with server side paging and I can see from the profiler that its doing a count(*) of the records. Surely there could just be a property to get this value?

Cheers, Ian.

If LivePersistence is set to false, fetching data and saving data isn't performed by the LLBLGenProDataSource2 control

Oh I see. Well I'm using the LLBLGenProDataSource2 to save me from doing the queries manually. So how can I get the row count when LivePersistence is set to true?

You could use adapter.GetDbCount with the same filter that the grid uses to get the count before you start.

Matt

Do you mean do my own seperate count?

If so then I think I will just forget the row count as a matter if principle.

Please could you add a row count property onto the LLBLGenProDataSource2 ?

It is in the code, but not public. It's one of the few small design glitches which need updating. The total number of rows is reported back to the caller of ExecuteSelect on the control, which is the bound grid.

At the moment, if you want it to, you have to write the few lines of code in the code behind to obtain the value and use livepersistence = false. How to do that is in the documentation (just a few lines of code, nothing special)

Ok its working.

Its really great being able to generate a list page by ultimately just specifying the entity factory to use.

I've also put my datagrid columns into a seperate user control for each entity. So when loading the list view page, I just give it a key which is uses to look up the user control and the entity factory to use.

Cheers, Ian.