Products  
 
             SDXGrid        Company        Pictures    

  SDXGrid
  SDXCalendar
  ChartSX
  SDXWorkflow
  SDXPhotoAlbum
   Servis Ustasi
Google

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.

Installation

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. 

Group By:

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 true). 

Design Mode

   <cc1:sdxgrid id="SDXGrid1" runat="server" AllowGroupBy="true">
   </cc1:sdxgrid>

Paging:

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.

Design Mode
   <cc1:sdxgrid id="SDXGrid1" runat="server" AllowPaging ="true" PageSize="50">
   </cc1:sdxgrid>




Sorting:
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.
Design Mode
   <cc1:sdxgrid id="SDXGrid1" runat="server" AllowSorting ="true">
   </cc1:sdxgrid>

Search:
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.
Design Mode
   <cc1:sdxgrid id="SDXGrid1" runat="server" AllowSearch ="true">
   </cc1:sdxgrid>


Style:
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

Design Mode
Check the example page.


Data Editing:
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.

SDXGrid does 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.

Design Mode

   <cc1:sdxgrid id="SDXGrid1" runat="server" ononupdate="SDXGrid1_OnUpdate">
   </cc1:sdxgrid>

CodeBehind

  // SDXGrid Update Event 
   protected void SDXGrid1_OnUpdate(object sender, SDXGridControl.OnUpdateEventArgs e)
   {
    MyDataAdapter.Update(e.Dataset);
   }


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).
Design Mode
Check the example page.

 


Keyboard Navigation:
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.

Data Updating:
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.






NOTE:
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.
   
       1999-2008© All Rights Reserved. Serkant Inc.