Category / Section
How to set a column format in GridDataBoundGrid?
To set the column format of the GridDataBoundGrid control, you can use the QueryCellInfo event. In this event handler, you can set the format for the particular column.
C#
//Hooks the event in Form_Load to set the format for the columns
this.gridDataBoundGrid1.Model.QueryCellInfo += new GridQueryCellInfoEventHandler(Model_QueryCellInfo);
void Model_QueryCellInfo(object sender, GridQueryCellInfoEventArgs e)
{
if (e.ColIndex > 0 && this.gridDataBoundGrid1.Binder.InternalColumns[e.ColIndex - 1].HeaderText == "Number")
{
//sets the cellvaluetype as double
e.Style.CellValueType = typeof(double);
//sets the format for the column
e.Style.Format = "#0.00%";
}
}
VB
'Hooks the event Form_Load to set the format for the columns Private Me.gridDataBoundGrid1.Model.QueryCellInfo += New GridQueryCellInfoEventHandler(AddressOf Model_QueryCellInfo) Private Sub Model_QueryCellInfo(ByVal sender As Object, ByVal e As GridQueryCellInfoEventArgs) If e.ColIndex > 0 AndAlso Me.gridDataBoundGrid1.Binder.InternalColumns(e.ColIndex - 1).HeaderText = "Number" Then 'sets the cellvaluetype as double e.Style.CellValueType = GetType(Double) 'sets the format for the column e.Style.Format = "#0.00%" End If End Sub
The following screenshot describes the format applied for the Number column.
Sample Links:
