We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Formatting with window syncfusion grid

Thread ID:

Created:

Updated:

Platform:

Replies:

108781 May 13,2013 05:29 AM UTC May 20,2013 06:26 AM UTC WinForms 1
loading
Tags: GridControl
Nitin Varshneya
Asked On May 13, 2013 05:29 AM UTC

Hi,

We are using .NET framework as 4.0 with c# window application.We want below functionalities into the grid :
1) Parent & child grid (multiple bands)
2) Formatting :
     (a) copy data from any source (like mirosoft word) to grid column, its formatting(bold,italic,underline,font size,color etc) should not change and user should be able to save same data with same formatting into database i.e while retrieving same data from database to display into grid, it should display into same format (bold,italic,underline,font size,color etc)
(b) There can be multiple buttons on window form screen like (bold,italic,underline,font size,color etc) .
      User can select multiple row(s)/column(s)/single column of a row from grid and click on any button.Format should be apply on all 
       selected row(s)/column(s) .
(c) User can select some text from single column of a row and click on any button of the screen (like bold,italic,underline,font size,color etc).Formatting should be apply only on selected text

3) Automatic sorting,filtering ,grouping and hiding/unhiding the columns without writing any extra heavy code
4) Developer should be able to create all type of column (like checkbox,dropdown,editable/non-editable column etc ) by chaging the property of column without writing any extra heavy code
5) EditorControl property should be applicable for all column i.e. if there is date column in grid and user click on it.Calander should be display .Developer should be able to do this without writing any extra heavy code
6) show week no in calender control

Please let me know which above functionalities can be implemented/ not implemented by using syncfusion grid ?


Vinish Kumar K [Syncfusion]
Replied On May 20, 2013 06:26 AM UTC

Hi Nitin Varshneya,

 

Thank you your interest in Syncfusion  products.

 

Query

Response

Parent & child grid (multiple bands)

You can handle the parent and child table in GGC using the relation and other ways. Please refer the following sample regarding this. Relation And Hierarchy section of dashboard shows regarding this. Refer the sample from this.

 

<Install Location>\Syncfusion\EssentialStudio\<version>\Windows\Grid.Grouping.Windows\Samples\Relation And Hierarchy

Formatting

You can format the grid and can export this to excel and word using the excel export please refer the following sample for more details.

 

Formatting :

GroupingGridFormatCellDialog dialog = new GroupingGridFormatCellDialog(this.gridGroupingControl1);

 

Sample : <Install Location>\Syncfusion\EssentialStudio\<version>\Windows\Grid.Grouping.Windows\Samples\Styling and Formatting\Cell Formatting Demo\

 

For export to word : <Install Location>\Syncfusion\EssentialStudio\<version>\Windows\Grid.Grouping.Windows\Samples\Exporting\Word Converter Demo\

Automatic sorting,filtering ,grouping and hiding/unhiding the columns

GGC support the sorting. Please refer the following code for sorting.

 

this.gridGroupingControl1.Engine.TableDescriptor.SortedColumns.Add("Country", ListSortDirection.Ascending); 

 

Please refer the sample file also for this you can handle using this.

 

<Install Location>\Syncfusion\EssentialStudio\<version>\Windows\Grid.Grouping.Windows\Samples\Sorting\Sorting Demo\

 

Filtering:

 

For filter you can wire the grid into file. Please refer the below code and also check this in your application for this.

 

this.gridGroupingControl1.TopLevelGroupOptions.ShowFilterBar = true;

            

            //Change the appearance of the Filter Row.            

            this.gridGroupingControl1.TableDescriptor.Appearance.FilterBarCell.BackColor = Color.AliceBlue;

 

            //Enable the Filter for each Column.

            for(int i = 0 ; i< gridGroupingControl1.TableDescriptor.Columns.Count;i++ )

            gridGroupingControl1.TableDescriptor.Columns[i].AllowFilter = true; 

 

 

<Install Location>\Syncfusion\EssentialStudio\<version>\Windows\Grid.Grouping.Windows\Samples\Filters and Expressions\Filter Bar Demo

Developer should be able to create all type of column

Yes, you can use the cell type using the properties. CellType and GridCustomCellType. Please refer the following codes in your application and refer the sample file also.

 

this.gridGroupingControl1.Appearance.ColumnHeaderCell.CellType = "My Column Header"; 

 

Sample file:

<Install Location>\Syncfusion\EssentialStudio\<version>\Windows\Grid.Grouping.Windows\Samples\Getting Started\Custom Cell Type Demo\cs

EditorControl property should be applicable for all column

Yes, EditorControl property is applicable for all column. Just assign the cellType for the column and you can able to get the solution.

 

this.gridGroupingControl1.Appearance.ColumnHeaderCell.CellType = "My Column Header"; 

 

 

 

Please refer  the sample from our dashboard and let me know your suggestion. If you need more information regarding this we will provide proper response regarding this.

 

Regards,

Vinish


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;