RadGrid EditMode Generating invalid data

[Srujan]

Hi All ,

I am using grid control and enabled EditMode="EditForms" , when I try to edit a row numbers are displayed incorrectly as below 

Number on grid Display : ($267,641.00)
Number in Edit box : -,267,641.00

Comma between "-" and "2" , can anybody suggest to overcome this issue .

Thanks

[Princy]

Hi Srujan,

Please try the following code snippet to maintain the DataFormat in editmode.

ASPX:

<telerik:GridBoundColumn DataField="UnitPrice" HeaderText="UnitPrice" UniqueName="UnitPrice"
DataFormatString="{0:c}" />

C#:

protected void RadGrid1_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
{
    if (e.Item is GridEditableItem && e.Item.IsInEditMode)
    {
        GridEditableItem edit = (GridEditableItem)e.Item;
        TextBox txt = (TextBox)edit["UnitPrice"].Controls[0];
        string dataFormatString = (RadGrid1.MasterTableView.GetColumn("UnitPrice") as GridBoundColumn).DataFormatString;
        txt.Text = String.Format(dataFormatString, double.Parse(txt.Text));
    }
}

Thanks,
Princy