Como faz para ocultar colunas no grid grouping control e depois buscar o valor dessa coluna oculta?

Hi Tomio,

Thanks for using Syncfusion products.

Query #1 "Hiding and fetching data from clientside"

Your requirement to get the value of hidden column can be achieve by hiding the Column in client side using HideColumn() method and get the data from the childNodes of CurrentRow.Please refer the below code snippet.

[Javascript]

Sys.Application.add_load(Pageload);
function Pageload()
{
var gridTable = GetEGridTable($get('<%= GridGroupingControl1.ClientID %>'));
// Hiding column in client side.
gridTable.HideColumn(2);
}
function ClientChange(Odata)
{
//Fetching the hidden column value.
var company = Odata.currentRow.tableRows[0].childNodes[3].innerHTML;
alert("Hidden column value" + company);
}


For your convenience, we have created sample and the same can be downloaded from the following link.

Forum 98859 - client-46502681.zip

Query #2 "Hiding and fetching data from server side"


Your requirement to get the value of hidden column can be achieve by hiding the Column in server side using VisibleColumns.Remove method and get the data using GetValue method.Please refer the below code snippet.

[Codebehind - C#]

protected void Page_Load(object sender, EventArgs e)
{
this.GridGroupingControl1.DataSourceControlRowUpdating += new GridDataSourceControlRowUpdateEventHandler(GridGroupingControl1_DataSourceControlRowUpdating);
this.GridGroupingControl1.SelectedRecordsChanged += new Syncfusion.Grouping.SelectedRecordsChangedEventHandler(GridGroupingControl1_SelectedRecordsChanged);
//Hiding the columns in server side
this.GridGroupingControl1.TableDescriptor.VisibleColumns.Remove("Name");
}
void GridGroupingControl1_SelectedRecordsChanged(object sender, Syncfusion.Grouping.SelectedRecordsChangedEventArgs e)
{
if (e.SelectedRecord != null)
{
//Fetching the hidden column values
string name = e.SelectedRecord.Record.GetValue("Name").ToString();
Textvalue.Text = name;
}
}
For your convenience, we have created sample and the same can be downloaded from the following link.

Forum 98859 - server103088920.zip

Please let me know if you have any other questions or concerns.

Regards,
Sridhar.N