RESET COLUMN FORMAT AFTER DATA BINDING

Thread ID:	Created:	Updated:	Platform:	Replies:
144692	May 17,2019 02:00 PM UTC	May 20,2019 11:51 AM UTC	WinForms	1

Subscribe to this post

Tags: SfDataGrid

Deepak

Asked On May 17, 2019 02:05 PM UTC

Dear Sir,

1. How to Set Numeric Column Format in SFDATAGRid after binding the data.

I have one Column in Decimal format which want to convert it to Integer(Numeric) Format. Please reply me at the earliest.

2. In SFDATAGRID, how to change the column format from text to dropdown list after data binding ?

Please send me code for the same

Thanks

Deepak

Reply | Reply with quote

Jagadeesan Pichaimuthu [Syncfusion]

Replied On May 20, 2019 11:51 AM UTC

Hi Deepak,

Thanks for using Syncfusion products.

Query

Solution

I have one Column in Decimal format which want to convert it to Integer(Numeric) Format. Please reply me at the earliest.

If you want to change the decimal format of the numeric column after assigning the datasource, you can use the NumberFormatInfo property of the numeric column. Refer to the following code snippet,

Code Snippet:

var decimalColumn = this.sfDataGrid1.Columns["UnitPrice"] asGridNumericColumn;

//Set the decimal digits as zero to display the numeric values.

decimalColumn.NumberFormatInfo = newSystem.Globalization.NumberFormatInfo() { NumberDecimalDigits = 0 };

In SFDATAGRID, how to change the column format from text to dropdown list after data binding ?

If you want to change the text column as combobox column after binding the datasource, you need to remove the existing text column from the Columns collection and add it as the ComboBox column. Refer to the following code snippet,

Code Snippet:

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

countries.Add("Austria");

countries.Add("Canada");

countries.Add("Brazil");

countries.Add("Argentina");

var columnIndex =this.sfDataGrid1.Columns.IndexOf(this.sfDataGrid1.Columns["ShipCountry"]);

//Remove the existing text column in the given index.

this.sfDataGrid1.Columns.RemoveAt(columnIndex);

//Insert the combo box column at the given index.

this.sfDataGrid1.Columns.Insert(columnIndex, new GridComboBoxColumn() { MappingName = "ShipCountry", DataSource = countries });

Sample: http://www.syncfusion.com/downloads/support/forum/144692/ze/Columns-2087878840

Let us know whether this helps also if you need any further assistance on this.

Regards,

Jagadeesan

Reply | Reply with quote

RESET COLUMN FORMAT AFTER DATA BINDING

Thread ID:

Created:

Updated:

Platform:

Replies:

Please sign in to access our forum

CONTACT US