Silverlight / WPF - Clearing Value of the Column with DataType decimal in WPf DataGrid

Hi All,

I m facing a problem with WPF DataGrid.

I m using WPF DataGrid & DataGridTextColumns

i m using DataView as DataSource to grid

i have Columns in DataView that hold Decimal values.

i have set AllowDBNull Property of DataColumn to true to accept Null values but when user clears the Cell it doesnt clear the value & value is not altered.

I tried CellEditEnding event of datagrid & somehow managed to find that the value is cleared so i manually Updated the value of the DataView

 private void DataGrid_CellEditEnding(object sender, DataGridCellEditEndingEventArgs e)
      {
        if (e.EditingElement is TextBox)
        {
          TextBox tb = (TextBox)e.EditingElement;
          if (tb.Text == "")
          {
            ((DataRowView)DataGrid.CurrentCell.Item).Row[ColumnName] = DBNull.Value;
          }
        }
      }  

but then it sets the "value = 0" rather than "null"


I need to set that value to null & clear it as it will clear any string Field.

then try to use like this :)

((DataRowView)DataGrid.CurrentCell.Item).Row[ColumnName] ="" ;

It is a Decimal field as i mentioned before & it will not accept "" string value.

Well Thanx for the reply i actually managed to attained it.

there was no issue with DataTable & DataColumn it accepts DbNull.Value & even sets it but somewhere after that set statement the value of DataTable was getting set to 0, i m not able to find why & where this is happening but i did it using the follwing code :

private void DataGrid_CellEditEnding(object sender, DataGridCellEditEndingEventArgs e)
      {
        if (e.EditingElement is TextBox)
        {
          TextBox tb = (TextBox)e.EditingElement;         
          if (tb.Text == "")
          {
            ((DataRowView)e.Row.DataContext).Row[e.Column.SortMemberPath] = DBNull.Value;            
            ((DataRowView)e.Row.DataContext).Row.AcceptChanges();
            ((DataRowView)e.Row.DataContext).Row.Table.AcceptChanges();           
          }
        }     
      }  

i know this is not the correct way to do this but in WPF DataGrid with Numeric Datatype Fields while clearing the values it sets it to 0 rather than DbNull.Value or null.

if anyone has any other Option to do this than pls reply

Thanx