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
– Nandhi, Commented Jun 28, 2012 at 16:28
Why don't you add IS_NULL in your SQL such that those fields then become bindable - msdn.microsoft.com/en-us/library/ms184325.aspx — Angshuman Agarwal
– Angshuman Agarwal, Commented Jun 28, 2012 at 16:34

Nandhi · Accepted Answer · 2012-07-07 19:53:35Z

2

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;
    }

}

answered Jul 7, 2012 at 19:53

Nandhi

4854 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

DataGridCell empty set DbNull.value

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related