Project Description

 

                              

 

 

Source                                  Dll                                               Demo

            

 

Controls Inside WPF Controls

1:Extended DataGrid

 
This is extended version of WPF toolkit DataGrid control.

This grid has features like

  1. Column Choosers.
  2. AutoFilter Control.
  3. Export To Excel Feature.
  4. Copy Paste To Excel and Copy Paste From Excel To DataGrid.
  5. Three State Sorting.
  6. Displaying Sort Order If Multiple Sort is done.
  7. Export To PDF with formatting.
  8. Export To CSV.

 

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.

6: Export To Excel with formatting.

You can export to excel in 2003 and 2007 format . You can even apply excel in built themes for table (which you can find in office 2007).

7:Export To PDF with formatting.

You can export to pdf  format . You can even apply excel in built themes for table (which you can find in office 2007).

8:Export To CSV.

You can even export grid content in csv format.



Demo

WPF Extended DataGrid Demo Video

Page Rank

Last edited Nov 14, 2012 at 9:24 AM by bpoojary, version 11