SDXGrid, is a comprehensive data grid component for Microsoft.NET web application developers, easing the exhausting process of implementing the necessary code for sorting, navigation, grouping, searching and real time data editing in a simple data representation object.
By just dragging and dropping this intelligent grid control on a web form, all the functionality is implemented right away by SDXGrid for you, hence allowing greatest possible time to concentrate on other innovative software aspects.
SDXGird also comes with extesively customizable formatting options, which is a must in appealing web pages.
You can customize this grid control's almost every visual property just as you would do with ordinary Visual Studio.NET controls.
Visual Studio 2005 is required.
1) Copy sdxgrid folder which is located in Necessary Files zip file into your project
2) Open a Web Project.
3) Drag your SDXGrid Control to your page.
3) Add SDXGridControl.dll file to Toolbox.
4) Drag your SDXGrid Control to your page.
5) Set ResourcePath property in grid control to sdxgrid folder location which you copied into your project
Or you can use the Demo
Project instead of using new project.
Using the code
SDXGrid is inherited from System.Web.UI.WebControls.GridView control. So
using this control is almost same with the GridView control.
SDXGrid allows you to instantly group with your selected field. To activate grouping
ability for your grid, you only need set AllowGroupBy property yo true(default is
<cc1:sdxgrid id="SDXGrid1" runat="server" AllowGroupBy="true">
To activate paging functionality in your grid, you need to set AllowPaging property to true(default is true) and change PageSize(The number of rows from the datasource to display per page) property to your preference.
<cc1:sdxgrid id="SDXGrid1" runat="server" AllowPaging ="true" PageSize="50">
|To activate sorting functionality in your grid, you need to set AllowSorting property to true. When user click a column title it automatically sorts in the client depends on your column type. If the column type is integer it will do a number sorting. If it is a string it will do string sorting.|
<cc1:sdxgrid id="SDXGrid1" runat="server" AllowSorting ="true">
|To activate searching functionality in your grid, you need to set AllowSearch property to true. It uses the like '%keyword%' pattern for searching. The keyword word is refering to user input. User can either search for all fields or a specific field.|
<cc1:sdxgrid id="SDXGrid1" runat="server" AllowSearch ="true">
All style objects are inherited from TableItemStyle or TableStyle objects.
Available TableItemStyle Objects: SearchStyle, GroupByTableItemStyle, GroupByItemStyle, SelectorItemStyle,
HeaderStyle, RowStyle, AlternatingRowStyle, PagerStyle and SelectedRowStyle.
Available TableStyle Objects: GroupByTableStyle, NavigatorStyle, SearchStyle
Check the example page.
As it is shown is keyboard navigation section you can edit a cell either double
click the cell or press F2 button.
To delete a row after you select rows, you can click delete button from keyboard
or delete button from left bottom of the grid.
The add button from left bottom of the grid allows to add a row in to grid.
not carry GridView events.
SDXGrid has OnUpdate event. You can catch changed
dataset and see the difference. If you write a DataAdapter, you can easily
update your data with this dataset.
<cc1:sdxgrid id="SDXGrid1" runat="server" ononupdate="SDXGrid1_OnUpdate">
// SDXGrid Update Event
protected void SDXGrid1_OnUpdate(object sender, SDXGridControl.OnUpdateEventArgs e)
Row Editing Template(New):
To activate template editing, you need to set AllowEditTemplate property to true.
After this, right click to your grid control in designer and in popup menu go to
Edit Template and select EmptyDataTemplate ( sorry i dont have a time to find howto
change this name :( ). And write your own design and set controls bindings(Contol's
name must be #FieldName(datasource column name)). And you need also two button for
Ok and Cancel( Put them with below properties).
Check the example page.
SDXGrid allows you to use usual keyboard features.
Arrows: You can navigate by using arrows beetwen cells.
F2: It is editing the current cell.
Enter: It accepts the change you have mad in the current cell.
ESC: It rejects the change you have mad in the current cell.
Delete: It deletes the selected rows.
CTRL: While pressing CTRL you are able to select mutiple rows.
The save button on left bottom of the grid postbacks the changes to the gridcontrol. To retrieve changes you only need to implement ononupdate property on your grid.EventArgs object returns the changes dataset(just changes, not the whole data). Then you can play with that data.
Almost all System.Web.UI.WebControls.GridView properties are supported by SDXGrid.
After you set SDXGrid datasource with your datasource object, you have to select your DataFields and set their properties. SDXGrid takes field types from their types in their DataTable objects. You should also set page size and page index for page navigation. There is no need to setup anything for sorting and groupping.