Category / Section
How to set a column format in GridDataBoundGrid?
1 min read
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: