Syncfusion Essential Grid for ASP.NET

Please note: Syncfusion Essential Grid includes Windows Forms, ASP.NET, WPF, Silverlight and ASP.NET MVC components.

What's new in Essential Grid 2012 Vol 2?

• Merging cells - You can merge adjacent cells in a grid and still perform sorting and grouping on columns containing merged cells. All the support you find in a normal cell can be found in merged cells, giving you better control over the layout of information in a grid.
• Data Table Support - Essential Grid supports data tables in two modes: server and JSON. Both modes allow sorting, grouping, and all the other basic functions you would expect in a grid, but with JSON mode, data rendering occurs on the client side, greatly improving grid performance.

What’s new in Essential Grid 2012 Volume 1?

• JSON Suppot in ASP.NET - The AJAX Grid control allows you to increase grid performance. It has two modes: server and JSON. The JSON mode can be enabled to handle paging, sorting, grouping and filtering.
• Editing via Unbound Columns in ASP.NET MVC - Editing via unbound columns allows you to make changes to multiple fields in a grid at the same time. Editing, updating and deleting are controlled by buttons on the row itself. You can edit or delete fields associated with a single data record by using these buttons instead of the toolbar.

Syncfusion Essential Grid for ASP.NET Column Types
The columns in Syncfusion Essential Grid for ASP.NET provide various options for customization. The Table Descriptor available for Syncfusion Essential Grid for ASP.NET includes the Columns collection, which is auto-populated by the Fields and Expression Fields collection.

• Expression Fields - Expression Fields in Syncfusion Essential Grid for ASP.NET, refer to those fields which take into account the value of another field as an operand and perform arithmetic and relational operations on it. The grouping engine is equipped with its own formula engine for this purpose. Grouping, sorting, filtering, and summary creation can also be performed based on these expression fields.
• Templated Columns - The Grid's layout can be customized using templates. Item Template - Used to customize the appearance of items such as Headers, the row being edited, and Form Mode, among others.Control Template - Used to customize the appearance of the Row button and the Expand button.Column Template - Used to customize the appearance of the grid's columns.Button Template - Used to customize the appearance of buttons in the Button Bar.
• Unbound Fields - Unbound columns can be associated with a grouping grid. These unbound columns let you evaluate field values at run time similar to expression fields and also participate in all engine-related operations, such as grouping, sorting, summaries, and filters.

Syncfusion Essential Grid for ASP.NET AJAX Features
Syncfusion Essential Grid for ASP.NET comes with built-in AJAX support. By turning on the Enable Callback command, the grid operates in AJAX mode. Sorting, grouping, resizing, and other commands will then operate through AJAX callbacks instead of postbacks.

• Before and After Callback Event - There are additional grid functions that need to be processed before or after a callback request is sent to the server. These can be included in the Grid Grouping Control before or after processing the callback results by means of scripting. The Callback Return Event Handler on the client will execute this script.
• Load Image on Callback - When the callback is being processed, the grid supports the display of a Loading... indicator to the user. This keeps the user updated on the status.
• Refresh via AJAX - The grid has built-in support to use AJAX callbacks to refresh itself with new data while the user sorts, groups or pages. Enable this feature by checking the Enable Callback option. The grid also renders a professionally designed Loading Indicator when the callback is being processed.
• Update Panel Compatible - The grid contents can be refreshed via callback without the need for AJAX frameworks. However, if you want to update the grid along with the other controls, then host the grid inside the ASP.NET Essential Tools Callback Panel or ASP.NET AJAX Update Panel.

Syncfusion Essential Grid for ASP.NET Design-Time Features
Syncfusion Essential Grid for ASP.NET comes with fully-functional Design Time options that let you setup the grid's style and grid Behavior. Data binding can be easily setup and previewed and customized through the designer.

• AutoFormat
• Declarative Datasource Binding
• Smart Tag

Syncfusion Essential Grid for ASP.NET Events
Syncfusion Essential Grid for ASP.NET provides numerous events to aid you in the creation of interactive applications. Based on the location of the recreated grid data after the user actions, these events are classified as Server-Side and Client-Side events.

Syncfusion Essential Grid for ASP.NET Grouping and Sorting
Syncfusion Essential Grid for ASP.NET when bound to a datasource can be used to performing engine related operations such as grouping and sorting. Grouping allows you to categorize the records based on a specific column. Through sorting, you can arrange the table data either in ascending or in descending order of values in the selected column.

• Group by Columns
• Sorting Columns

Syncfusion Essential Grid for ASP.NET Paging and Filtering
The Paging function available in Syncfusion Essential Grid for ASP.NET comes in handy when the grid rows exceed the limits of a single page. The default setting pulls all rows and columns irrespective of the data displayed. The paging function can be used to limit the dimensions of the displayed data. Filters in the Grid Grouping Control, enable users to select and display a subset of records based on user-defined criteria. The criteria can be set using a Filter Bar at run time as well as in Design Time.

• Filters with Filter Bar Support
• Paging with Pagerbar Support

Syncfusion Essential Grid for ASP.NET Summary Rows and Columns
The Syncfusion Essential Grid for ASP.NET provides options for the inclusion of summary rows for each group. The grid summaries are displayed in the summary rows. The summary rows can be added and defined using the Grid Summary Row Descriptor collection editor available in the Grid Grouping Control. Options for specifying the summary format and summarized columns are also available.

• Automatic Summaries
• Programmatic Summary Access
• Summaries in Group Captions
• Page Level Summary

Syncfusion Essential Grid for ASP.NET Appearance
A variety of styling options are available for various sections of the Syncfusion Essential Grid for ASP.NET Control such as group, filter, header, footer, summary and nested cells, and different states such as adding new record, alternate record, and group indent cells.

• Alternating Row Styles
• Area Selection
• Automatic Image Handling
• Built-in Skins
• Column Resizing and Reordering
• Conditional Formatting
• Customization Events
• Customization via CSS and Styles
• Frozen Rows and Columns
• Grid Outlook Style
• Listbox Mode
• Multi-Row Records
• Templates Support
• ToolTip

Syncfusion Essential Grid for ASP.NET Data Binding
Binding data to the grid has been simplified to a single line of code. The grid supports all kinds of "lists" from IList to Datasource Control derived types. The grid automatically discovers the schema of the datasource at run time, including the relationships setup between tables in a datasource and renders the grid contents automatically. The grid's schema can be altered to hide columns and include unbound columns. The default setting pulls all the records to the server irrespective of the number of records displayed on the page. Alternatively, you can use the Pass-Through Grouping feature to selectively query records from the datasource based on the grid's current view.

• AutoGenerated Schema
• Datasource Caching Mode
• Datasource Options
• Foreign Key Constraints
• LINQ Support
• Pass-Through Grouping
• Support for Hierarchies

Syncfusion Essential Grid for ASP.NET Editing
Syncfusion Essential Grid for ASP.NET supports editing of records at run time. It offers different editing modes such as In-place Editing and Editing via Forms to make the editing more user-friendly. Options to add new records and delete existing records are also available. If the datasource can be updated, the grid will automatically save the changes on the underlying datasource.

• Automatic Datasource Update
• Built-in Editing Modes
• Edit Columns Support

Syncfusion Essential Grid for ASP.NET Export Options
Syncfusion Essential Grid for ASP.NET provides different export options that let you save its contents in a number of output formats including Excel.

Syncfusion Essential Grid for ASP.NET Navigation Options
Syncfusion Essential Grid for ASP.NET offers complete navigational support for navigating between the grid cells, rows and pages. This is accomplished with the help of the Navigation and Pager Bars, that can be added in Design Time, using the Button Bars collection.

• Customized Button Bars
• Grid Keyboard Navigation
• Navigation Bar
• PagerBar

Syncfusion Essential Grid for ASP.NET Printing
Syncfusion Essential Grid for ASP.NET offers comprehensive support to print complete records including groups, summaries, preview rows, and others.