Welcome Guest Search | Active Topics | Sign In | Register

Grid with "Datasheet" Features + Grouping like in ASP.net ListView Options
pghcpa
Posted: Saturday, October 24, 2009 12:39:56 PM
Rank: Advanced Member
Groups: Member

Joined: 8/26/2009
Posts: 64
Datasheets (i.e. databound grids) in MS-Access and MS-Excel have:

1. Ability to filter column via click on column header.

2. Ability to see all values in column and check and uncheck those you want to filter by (via click on column header).

3. Subdatasheets where you see a plus sign (+) simlar to what you see in a tree control. When you click on it, it explodes below to show you a related table/fields within the grid. This may be a tall order, but it is one of Access' most useful features because the user does not have to look two places or deal with a dialog or pop-up to see header and related detail records.

4. Ability to bind datasheet to database (for add-edit-delete) ... though this can be done with EO now, it takes custom code and plenty of know-how to do it (but it works flawlessly -- just as fast as a bound datasheet on a local network).

If your grid control could be expanded into a Datasheet control, you would have the first one on the Web and it would sell very well. Please take a look at MS-Access datasheets if you have not already. Business application users everywhere are scrambling to find this kind of functionality. They want to create asp.net database applications with desktop-style UI's but are limited to simple/non-functional grids or ListView controls. Your grid is SO close to what is needed out there already.

Also, on ListView controls there is a group and subtotal function that is needed for your grid to be functionally equivalent, though it is already superior in other ways because a listview, among other things, doesn't have a live edit mode for the whole grid -- you have to edit one row at a time which gives grid controls like yours an enormous advantage.



Subdatasheets
eo_support
Posted: Saturday, October 24, 2009 12:54:50 PM
Rank: Administration
Groups: Administration

Joined: 5/27/2007
Posts: 24,217
Hi,

Thank you very much for your feedback. Filter/subsheet related features have been brought to our attention multiple times. We are in the process of evaluating what's the best ways to support these feature, or whether to support them at all. Various factors are considered, such as code size/complexity and the amount of flexibility we can provide should we choose to have these features built-in. Level of support and integration are also being evaluated. For example, one option is to have such feature completely built-in, another option is to provide various APIs for you to customize/access the headers so that you can implement your own custom filters (or other form of custom headers) using those APIs.

Thanks


You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.