Datagrid does not accept comma's

[Maqsood Ahmed]

Hello,
Here is the scenario:
I have a datagrid on a winform and a datatable is set as its
datasource. I have added DataGridTableSt yle in datagrid's TableStyles
property. Some of Gridstyles are numeric (doubles) and I have set their
format to #,0.0000 since I want to display the values to comma seperated
(at thousands) and till four decimal places. User can also edit values
in the grid. So far so good.

The Problem:
Edited cell value reverts back to the previous value when the user
enters a comma formatted value. For example: original value was 52.0000
and user entered 1,000,000. IMO i should be displayed as 1,000,000.0000
but the value reverts back to 52.0000. I have tried to consume
CurrentCellChan ged event of datagrid and also RowChanging/ColumnChanging
events.
- CurrentCellChan ged event does not give me the new value from the
CurrencyManager .
- RowChanging/ColumnChanging events do not raise at all in the above
mentioned scenario.

Any thoughts/workarounds?

TIA.
Maqsood Ahmed - MCAD.net
Kolachi Advanced Technologies
http://www.kolachi.net

*** Sent via Developersdex http://www.developersdex.com ***

[Cor Ligthert [MVP]]

Maqsood,

Are you using DataGridColumnS tyles

http://msdn.microsoft.com/library/de...classtopic.asp

I hope this helps,

Cor

[Maqsood Ahmed]

Hello,
Yes I am using the DataGridColumnS tyles (DataGridTextBo xColumn). I have
associated double with the DataGridTextBox Column and set its format to
"#,0.0000". Actual problem is that it does not accept formatted input.
It works fine otherwise.

TIA
Maqsood Ahmed - MCAD.net
Kolachi Advanced Technologies
http://www.kolachi.net

*** Sent via Developersdex http://www.developersdex.com ***

[Cor Ligthert [MVP]]

Ahmed,

I can do the behaviour you describe when I use the "c" format and don't
delete the currency sign.

With this it goes in my opinion fine.

\\
DataTable dt = new DataTable();
dt.Columns.Add( "decimal",Type. GetType("System .Double"));
dt.LoadDataRow( new Object[] { 111111.11 }, true);
dataGrid1.DataS ource = dt;
DataGridTableSt yle ts = new DataGridTableSt yle();
ts.MappingName = dt.TableName;
DataGridTextBox Column tb = new DataGridTextBox Column();
tb.MappingName = "decimal";
tb.Format = "d";
ts.GridColumnSt yles.Add(tb);
dataGrid1.Table Styles.Add(ts);
///

I hope this helps,

Cor

"Maqsood Ahmed" <ma***********@ gmail.com> schreef in bericht
news:Oa******** ******@TK2MSFTN GP15.phx.gbl...

Hello,
Yes I am using the DataGridColumnS tyles (DataGridTextBo xColumn). I have
associated double with the DataGridTextBox Column and set its format to
"#,0.0000". Actual problem is that it does not accept formatted input.
It works fine otherwise.

TIA
Maqsood Ahmed - MCAD.net
Kolachi Advanced Technologies
http://www.kolachi.net

*** Sent via Developersdex http://www.developersdex.com ***