Some question about GridGroupingControl

[ligyste]

1、When I click the left and top cell,how to select all the records

2、I binds the column to a List<string>

List<string> list=new List<string>();

list.add("11111");

list.add("22222");

data_GridGroupingControl.TableDescriptor.Columns["col1"].Appearance.AnyRecordFieldCell.CellType = GridCellTypeName.GridListControl;

data_GridGroupingControl.TableDescriptor.Columns["col1"].Appearance.AnyRecordFieldCell.DataSource = list;

I want to prevent the other people from editing the cell's value except they use the dropdown list,how should I set the cell into readonly.

3、I have handled the TableControlCurrentCellShowingDropDown  event 

data_GridGroupingControl.TableControlCurrentCellShowingDropDown += new GridTableControlCurrentCellShowingDropDownEventHandler(data_GridGroupingControl_TableControlCurrentCellShowingDropDown);

  private void data_GridGroupingControl_TableControlCurrentCellShowingDropDown(object sender, GridTableControlCurrentCellShowingDropDownEventArgs e)

        {

            if (e.TableControl.CurrentCell.Renderer is GridDropDownGridListControlCellRenderer)

            {

                GridDropDownGridListControlCellRenderer renderer = e.TableControl.CurrentCell.Renderer as GridDropDownGridListControlCellRenderer;

             }

         }

How to change the "Object"  text

4、The DropDownList's border  is dotted line,how to change it into solid?

5、How to hide a column?

Thanks!

Attachment: pic_1dae32bc.rar

[Amal Raj U]

Hi ligyste, 

 

Thanks for using Syncfusion products. 

 

Query	Response
When I click the left and top cell,how to select all the records	In order to select all records in the click of TopLeftHeaderCell, TableControlCellClick can be handled. Table.Records.SelectAll() method is used to select all records. Please make use of the below code.    Code Snippet  //Event hookup.  this.gridGroupingControl1.TableControlCellClick += new GridTableControlCellClickEventHandler(gridGroupingControl1_TableControlCellClick);    void gridGroupingControl1_TableControlCellClick(object sender, GridTableControlCellClickEventArgs e)  {      GridTableCellStyleInfo style = e.TableControl.GetTableViewStyleInfo(e.Inner.RowIndex, e.Inner.ColIndex);      if (style.TableCellIdentity.TableCellType== GridTableCellType.TopLeftHeaderCell)      {          this.gridGroupingControl1.Table.Records.SelectAll();      }  }    UG Link  https://help.syncfusion.com/windowsforms/gridgrouping/select-collection-of-records-in-gridgroupingcontrol
I want to prevent the other people from editing the cell's value except they use the dropdown list,how should I set the cell into readonly.	To prevent editing, the dropdownstyle must be set to Exclusive for that columns. Please make use of the below code.    Code Snippet  //to prevent editing and only select options from dropdown.  this.gridGroupingControl1.TableDescriptor.Columns["CategoryID"].Appearance.AnyRecordFieldCell.DropDownStyle = GridDropDownStyle.Exclusive;
How to change the "Object"  text in dropdown gridlistcontrol.	Column header text in GridListControl can be changed in PrepareViewStyleInfo event of GridListControl. Please make use of the below.    Code Snippet  //to get GridListControl renderer.  GridDropDownGridListControlCellRenderer renderer = this.gridGroupingControl1.TableControl.CellRenderers["GridListControl"] as GridDropDownGridListControlCellRenderer;  renderer.ListControlPart.Grid.PrepareViewStyleInfo += new GridPrepareViewStyleInfoEventHandler(Grid_PrepareViewStyleInfo);    //to change GridListControl header text.  void Grid_PrepareViewStyleInfo(object sender, GridPrepareViewStyleInfoEventArgs e)  {      if (e.ColIndex == 1 && e.RowIndex == 0)          e.Style.Text = "Text";  }
The DropDownList's border  is dotted line,how to change it into solid?	Dropdown list border can be changed using PrepareViewStyleInfo event of GridListControl. Please make use of the below code.    Code Snippet  //to get GridListControl renderer.  GridDropDownGridListControlCellRenderer renderer = this.gridGroupingControl1.TableControl.CellRenderers["GridListControl"] as GridDropDownGridListControlCellRenderer;  renderer.ListControlPart.Grid.PrepareViewStyleInfo += new GridPrepareViewStyleInfoEventHandler(Grid_PrepareViewStyleInfo);    //to change GridListControl header text.  void Grid_PrepareViewStyleInfo(object sender, GridPrepareViewStyleInfoEventArgs e)  {      e.Style.Borders.All = new GridBorder(GridBorderStyle.Solid, Color.LightGray);  }
How to hide a column?	Solution 1  Columns can be hided using Cols.Hidden property.Please make use of the below code.    //to hide a column.  this.gridGroupingControl1.TableModel.Cols.Hidden["Description"] = true;    Solution 2  Columns can also be hidden by making width of that column = 0.    //to hide a column.  this.gridGroupingControl1.TableDescriptor.Columns["Description"].Width = 0;    Solution 3  Columns can be hidden using VisibleColumns.Remove() method also.    //to hide a column.  this.gridGroupingControl1.TableDescriptor.VisibleColumns.Remove("Description");    https://help.syncfusion.com/windowsforms/gridgrouping/faq/general/how-to-hide-or-unhide-the-columns-in-a-grouping-grid     Solution 4  Columns can be hidden using ColHiddenEntries.Add() method also.    //to hide a column.  GridColHidden hiddenColumn = new GridColHidden(2);  this.gridGroupingControl1.TableModel.ColHiddenEntries.Add(hiddenColumn);    Solution 5  If you want to hide an column in runtime, you can hide that particular column by resizing using the Resize indicator.    KB Links  https://www.syncfusion.com/kb/4181/how-to-hide-a-range-of-rows-and-columns-in-gridgroupingcontrol   https://www.syncfusion.com/kb/628/how-do-i-hide-unhide-the-columns-in-a-gridgroupingcontrol     UG Links  https://help.syncfusion.com/windowsforms/gridgrouping/managing-records-and-columns#hiding-records-and-columns   https://help.syncfusion.com/windowsforms/gridgrouping/managing-records-and-columns#hiding-columns-and-rows-by-resizing

 

Sample Link 

https://www.syncfusion.com/downloads/support/forum/125282/ze/Sample-1943368097 

 

Regards, 

Amal Raj U. 

[ligyste]

It is very usefull for me,Thank you very much!

[Amal Raj U]

Hi ligyste, 

Thanks for your update. 

We are glad to know that the given solution has solved your query. Please let us know, If you need any further assistance. 

Regards, 

Amal Raj U. 

[Ranjani Prabhakaran]

From: ligyste2 [mailto:[e-mail]]
Sent: Friday, August 5, 2016 9:36 PM
To: Syncfusion Support <[e-mail]>
Subject: Re:Syncfusion support community forum 125282, Some question about GridGroupingControl, has been updated. 

Thank you very much!

[Ranjani Prabhakaran]

Hi Ligyste, 

 

Please do contact us if you need any technical assistance in future. 

 

Regards, 

 

Ranjani