This is a migrated thread and some comments may be shown as answers.

How to retrieve distinct value-converted or formatted column values

0 Answers 146 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Calvin
Top achievements
Rank 2
Calvin asked on 15 Jul 2011, 10:01 PM
Greetings,

How does one fetch the distinct values in a RadGridDataColumn as formatted via the binding's IValueConverter or StringFormat?  The rdGrid.GetDistinctValues(column, true, null) method returns the raw unformatted values.

Is there a clever or easy way to get the formatted values as displayed in the grid?

Thanks

I figured it out.  Here's how it can be done:

var distinctValues = uxGrid.GetDistinctValues(column, truenull);
var clip = string.Empty;
int count = 0;
Func<objectobject> formatter;
if (column.DataMemberBinding.Converter != null) {
    formatter = _ => column.DataMemberBinding.Converter.Convert(_, column.DataType, nullCultureInfo.CurrentUICulture);
} else if (!string.IsNullOrEmpty(column.DataMemberBinding.StringFormat)) {
    formatter = _ => string.Format(_.ToString(), column.DataFormatString);
} else {
    formatter = _ => _;
}
foreach (var value in distinctValues) {
    clip += formatter(value) + "\n";
    count++;
}
clip = clip.TrimEnd('\n');
Clipboard.SetText(clip);

No answers yet. Maybe you can help?

Tags
GridView
Asked by
Calvin
Top achievements
Rank 2
Share this question
or