Hi khanh dang,
Thank you for your patience.
You can get the unique items of particular column values. Please refer the below code,
|
private void button1_Click(object sender, EventArgs e)
{
IEnumerable<object> items = this.sfDataGrid1.View.Records.GetSource();
var column = this.sfDataGrid1.Columns[0];
IEnumerable<RecordValuePair> viewRecords = null;
var provider = this.sfDataGrid1.View.GetPropertyAccessProvider();
// Gets the distinct record that are in the view for the given column.
Invoke((Action)(() =>
{
viewRecords = items.Select((x) =>
{
return new RecordValuePair(provider.GetValue(x, column.MappingName), x);
}).Distinct(new RecordValueEqualityComparer<RecordValuePair>());
}));
List<int> uniqueCollection = new List<int>();
foreach(RecordValuePair recordValuePair in viewRecords)
{
var value = recordValuePair.Value;
uniqueCollection.Add(int.Parse(value.ToString()));
}
} |
Here, you can get the columns list from uniqueCollection list.
Please check the sample and let us know if you need further assistance on this.
Regards,
Susmitha S
