Gridcontrol How to check or get all Duplicate Cell Values in a Column

[Nilofer]

Hi, 

I have been trying to check duplicate cell values in a column before saving.

Using Linq works with normal windows grid but with synfusion doesn't work.

Dim distinctsrno = From row As DataGridViewRow In dataGridViewDetailSheet.Rows Where Not row.Cells(11).Value = "" Select CStr(row.Cells(11).Value) Distinct

getting error :  
​Error BC36593 Expression of type 'GridModelRowColOperations' is not queryable. Make sure you are not missing an assembly reference and/or namespace import for the LINQ provider.

[Nilofer]

any one please? any way out ? 

[Balamurugan Thirumalaikumar]

Hi Nilofer, 

Thank you for contacting Syncfusion support. 

We have checked your query “Gridcontrol How to check or get all Duplicate Cell Values in a Column” at our end. We regret know you that as per the current implementation of GridControl(grid.Model.Rows) does not have Linq query support. In order to achieve your requirement we suggest you to get the specific column values in a list and find the duplicate values from that list. You can refer the following code snippet for your reference. 

Code Snippet 

//Event Subscription 

this.gridControl1.DrawCellDisplayText += new GridDrawCellDisplayTextEventHandler(grid_DrawCellDisplayText); 

 

//Event Customization 

private void grid_DrawCellDisplayText(object sender, GridDrawCellDisplayTextEventArgs e) 

{ 

//To add particular column(1) values to list 

if (e.ColIndex == 1 && e.RowIndex > 0 ) 

{ 

 list1.Add(e.DisplayText); 

} 

} 

 

//Load duplicate values to listbox 

private void button1_Click(object sender, EventArgs e) 

{ 

if (list1.Count > 0) 

{ 

 var duplicates = list1.GroupBy(x => x).Where(g => g.Count() > 1).Select(y => y.Key).ToList(); 

 

  listBox1.DataSource = duplicates; 

} 

} 

We have attached the tested sample for your reference and you can download the same from the following location. 

Sample link – https://www.syncfusion.com/downloads/support/directtrac/general/ze/GridDuplicateValues-900109877.zip 

If you want to use Linq support for records you can refer our SfDataGrid(Sfdatagrid.View.Records) control which support the linq query. 

Getting Started SfDataGrid- https://help.syncfusion.com/windowsforms/datagrid/gettingstarted 

You can refer following forum for your reference. 

https://www.syncfusion.com/forums/118046/sfdatagrid-find-data-with-linq 

Please let us know if you would require any other assistance. we will be happy to assist you. 

Regards, 

Balamurugan Thirumalaikumar