WPF Extended DataGrid

2011-12-29T12:47:00.000-08:00

Support This Project

Project Description

This is extended version of WPF toolkit DataGrid control.

This grid has features like

Column Choosers.
AutoFilter Control.
Export To Excel Feature.
Copy Paste To Excel and Copy Paste From Excel To DataGrid.
Three State Sorting.
Displaying Sort Order If Multiple Sort is done

Features in detail:

1: Column Chooser

In this you can do following things.

Column chooser with checkbox to make column visible and invisible.
Select All checkbox is added.
You can drag and drop a row from column chooser to move column in the main grid.
By double clicking on any cell of column chooser you can edit the column header values.

2: Auto Filter

In this you can do following things.

Auto Filter gives user ability to filter according to values by checking and unchecking checkbox.
Select All checkbox is added.
user can click on clear filter button to clear all filter.
ClearFilter method is given in the grid to clear filter of specific column programmatically.
AlowAutoFilter in extended column gives abilllty to show or hide autofilter.
detailed glyph is shown to user to show if any filters are applied on the that column.

3: Copy Paste To Excel and Copy Paste From Excel To DataGrid.

In this you can do following things.

User can select multiple cells and copy DataGrid contents to excel by pasting it in excel,.
User can copy multiple cell content from excel to Datagrid.

4: Three State Sorting.

In the original grid, when clicking on a column header it will change sorting of the column starting from ascending to descending. Unfortunately you cannot get back to the original state(which is no sorting) without adding your own custom logic for it. To get back to the original state you have to set the column.SortDirection back to null and clear out the SortDescriptions that were added when you click on the column header.Here when you use extended datagrid you don't have to write any code for it.

5:Displaying Sort Order If Multiple Sort is done

When user performs multiple column sort in original grid used to show only the sort indicator up or down which is ascending or descending.But here sort order is displayed.

If you don't want to show Sort Order just set the ShowSortOrder to False.

Support This Project:

Depends On:

.Net Framework 4.0 (Download)