Formatting Columns in GridGrouping Control

[Administrator]

Hi,
I am trying to format various columns in the GridGrouping Control but have not been able to. In the sample code enclosed I have a ViewGrid working the way I would like it to work (via code). I basically remove all the columns first in the grid, create a datatable and populate the data, then I go through the colums and create a BoundColumn for each column in the grid. In the BoundColumn I can specify the DataFormatString and quickly format the data. Does the GridGrouping Control handle something like this. I found an sample on the web site but it was not too clear to me how the columns were being formatted.

Thanks.
David.

FillGrid.zip

[Gokul B]

Hi David,

Sorry for the delay in getting back to you.

Attached is the sample which is the modified version of "FillGrid.zip"

FormattingGrid_Forum56753.zip

* In our sample we bind the GridGroup with the Datatable.
* We format the data and display name of the column header using QuerycellStyleInfo event. Could you please update us is this the one you are mentioning?

Please have a look at our attached sample for your references.

Let us know if you have any other queries.

Thanks for using Syncfusion product.

Regards,
Gokulkumar.B

[David A. Gonzales]

Thanks. This works like a charm.

David.

[David A. Gonzales]

Well, I tried to use the QueryCellStyleInfo to add formatting but now all my buttons will stop firing any events. Anybody have this type of problem? If I take the code out that does the formatting the buttons work again.

Thanks.
David.

[David A. Gonzales]

After playing around I came up with a solution to my problem with using the QueryCellStyleInfo event. Instead of defining the formats at that stage I did the following:

protected void SetGridColumnFormat()
{
NotitiaLoginManager l = new NotitiaLoginManager(cConnect);
NotitiaUser nu = l.GetUser(sUser);
NotitiaDataManager nDM = new NotitiaDataManager(nu);
Guid g = new Guid(gStr);

GridEngine engine = GridGroupingControl1.Engine;
GridTableDescriptor parent = (GridTableDescriptor)engine.TableDescriptor;

String sField;
String sFormat;

sFormat = "N4"; // default format
for (int i = 0; i < parent.Columns.Count; i++)
{
sField = parent.Columns[i].MappingName.ToString();
if (sField != "RowID")
{
sFormat = nDM.GetFieldInfo(g, sField, "Format");
parent.Columns[i].Appearance.AnyCell.Format = sFormat;
}

}

}

This is called after I set the DataSource but before I call GridGroupingControl.DataBind().

Works with our custom paging, client-side work and all the rest. Plus it's 3 or 4 times faster than the other method.

David.

[Gokul B]

Hi David,

Glad that you got it working!.

Let us know if you have any other concerns.

Regards,
Gokulkumar.B