Hi
Currently I am working on ASP.NET (.NET Framework 4.5) web application (using vb.net).We are using standard Microsoft asp.GridView control.I need to add filtering Excel stile to the grid. Latest requirements:1. Grid on the stand alone .aspx page (no master page)2. Data source for the Grid: DataTable with binding on the Server Side (code behind)3. Allow paging. 4. Allow filtering (Excel style). Some columns without filter.5. Allow sorting6. Allow scrolling 7. 2 command buttons. Button click should execute Server Side (code behind) procedure. One button opens a new window/tab. The second one opens next page in the same window.8. 2 hyperlinks. Hyperlink click should execute Server Side (code behind) procedure. One opens a new window/tab. The second one opens next page in the same window.9. Click on the row, but not on the button or hyperlink, should not execute post back or any other process.10. CSS styles
I am evaluating a WebDataGrid. Is it possible to provide working sample with required features.
Thank you,Igor
Hello,
Thank you for your post.
Here you can find all samples that you need about webDataGrid: http://www.infragistics.com/samples/aspnet/data-grid/overview. I will provide you the links that you need.
1. Data source for the Grid: DataTable with binding on the Server Side (code behind): http://www.infragistics.com/samples/aspnet/data-grid/binding-to-datatable.
2. Allow paging: http://www.infragistics.com/samples/aspnet/data-grid/paging-client-events.
3. Allow filtering (Excel style): http://www.infragistics.com/samples/aspnet/data-grid/filtering-excel-style.
4. Allow sorting: http://www.infragistics.com/samples/aspnet/data-grid/column-sorting-client-events.
5. Allow scrolling: http://www.infragistics.com/samples/aspnet/data-grid/configuring-virtual-scrolling.
6. Click on the row should not execute post back: http://www.infragistics.com/samples/aspnet/data-grid/row-selectors.
7. Css styling guide: http://www.infragistics.com/community/blogs/engineering/archive/2010/08/25/webdatagrid-css-styling-guide.aspx.
If you have further questions, please feel free to contact us.
Hi Aleksandar,
Thank you for the reply.I have following questions:Filtering: Filter Icons do not indicate if a column is filtered.Looks like you have open case:http://www.infragistics.com/community/forums/t/65667.aspxPlease let me know if this problem was resolved.
Paging: I am using: <ig:Paging PagerMode="NumericFirstLast" PageSize="20" PagerAppearance="Bottom" Enabled="true" />If grid has more pages that could fit in the footer, I don’t see << or >> and there is no way to navigate to the last page.Is there a Page Mode that make available <<,<,>,>> ?
I have investigated this issues, and I have asked our engineering staff to examine this further. To ensure that it will receive attention, I have logged this behaviors in our internal tracking system with a Development ID of 227964 and 228004. The next step will be for a developer to review my investigation and confirm my findings or to offer a fix, or other resolution.
I will leave this case open and update you with any new information after the review. You can also continue to send updates to this case at any time.
You can view the status of the development issue connected to this case by selecting the "Development Issues" tab when viewing this case on the web site.
Thank you for the update.
I don’t see the "Development Issues" tab when viewing this case on the page
http://www.infragistics.com/community/forums/t/108007.aspx
Please point out how to find it.
Is it possible to speed up this case?
Thank you,
Igor
Thank you for reporting this.
I have logged this behavior in our internal tracking system. A support case is created on your behalf with number CAS-178030-C5V8X1 , so that you can be notified when the bug is fixed. You can find your active cases under Account - Support Activity in our website. Select your ticket and go to Development Issues tab to view the status of related bugs.
We do everything possible for correcting the problems faster.
Let me know if I may be of further assistance.
I got email with the link: http://www.infragistics.com/my-account/support-case/CAS-178030-C5V8X1
History stating that ‘The first bug with ID 227964 was resolved by design, you can see the discussion for the bug.’
Please let me know how I can see it and what the resolution was.
What should be changed?
Thanks,
Igor,
The discussion for the development issue is internal and not actually available to you. This is the relevant detail for development issue 227964:
"When Excel filtering is enabled, there is a popup for each column containing the values of the unique cells in that column, so another request is made to the database to get those filter values. There are 2529 filter values just only for RequiredDate column. This happens on every post back and for every column. It is suggested to avoid using excel filtering for large data sets as it is also inconvenient for a user to look for values to filter on rather than typing it."
Let us know if you have any questions with this matter.