How to check duplicate particular value in radgridview in vb.net winforms

[Nandan]

Hi

 

I am using raddatagridviews in vb.net. I want to check if particular item should  not be enter in raddatagridview.  So far I have done this but not working

  Private Sub ChkDuplicateItem()
        Dim Found As Boolean = False

        For i = 0 To Me.dgvCore.Rows.Count - 1
            If Convert.ToString(Me.dgvCore.Rows(i).Cells(3).Value.ToString.Contains("Core")) = txtItemName.Text.Trim() Then
                Found = True
                Exit For
            End If
        Next

        'Return Found

        If Not Found Then
            Me.fillGrid()
        End If
    End Sub

SrNo	Itemid	ItemName	Qty	Rate	Amount
1	10	KDM	5	10	50
2	10	KDM	10	10	100
3	20	Core	25	4	100
4	20	Core	15	3	75
	This  Core Item should not repeat again

 

[Dess | Tech Support Engineer, Principal]

Hi, Nandan,

RadGridView offers a convenient API for data validation while editing. The UserAddingRow event allows you to validate the entered data in the new row and prevent the new row from being committed as a data row by setting the GridViewRowCancelEventArgs.Cancel property to true:

https://docs.telerik.com/devtools/winforms/controls/gridview/rows/new-row#user-events

The CellValidating event allows you to validate the cell values separately so that you can check for duplicate values and cancel the editor's value: 

https://docs.telerik.com/devtools/winforms/controls/gridview/editors/data-validation 

As to the process of checking for duplicates, it is necessary to iterate all the rows and see whether the editor's value exists in any of the cells from the respective column. Thus, you will determine whether the new value is unique or a duplicate already exists. Please give it a try and see how it works on your end.

Regards,
Dess | Tech Support Engineer, Principal
Progress Telerik