DataGridCell empty set DbNull.value

Question

I am populating a datagrid with a dataset and I have my dataset verified for nullable values -

My problem is :

When the dataset is validating, it found empty rows and the errors are not displayed. I would like to define the empty cells with a DBNull.value. Is there any way to do it ?. I have found a property named TargetNullValue that could work ?

Empty cells I meand when the datagrid is populated and some field has empty string as value — Nandhi, Jun 28 '12 at 16:28
Why don't you add IS_NULL in your SQL such that those fields then become bindable - http://msdn.microsoft.com/en-us/library/ms184325.aspx — Angshuman Agarwal, Jun 28 '12 at 16:34

score 2 · Accepted Answer · answered Jul 07 '12 at 19:53

I found a way to do it, by making a convertion

 public class ConvertStringToDBNull : IValueConverter
{
    public object Convert(object value, Type targetType, object parameter, CultureInfo cufo)
    {

        if (value is string)
        {
            if (value.ToString() == string.Empty)
            {
                return DBNull.Value;
            }
        }
        return value;
    }

    public object ConvertBack(object value, Type targetType, object parameter, CultureInfo cufo)
    {

        if (value is string)
        {
            if (value.ToString() == string.Empty)
            {
                return DBNull.Value;
            }
        }
        return value;
    }

}

DataGridCell empty set DbNull.value

1 Answers1

Linked