HI
I want to choose non-duplicate elements in DataTable
Where DataTable contains data as follows
TABLE A
COLUMN A
AM1
AM5
AM6
AM5
AM1
AM1
AM1
Where the final output is datatable= AM6
Blockquote
Public Function RemoveDuplicateRowsG(ByVal dTable As DataTable) As DataTable
For intI = dTable.Rows.Count - 1 To 0 Step -1
For intJ = intI - 1 To 0 Step -1
If dTable.Rows(intI)(0) = dTable.Rows(intJ)(0) Then
dTable.Rows.RemoveAt(intI)
dTable.Rows.RemoveAt(intJ)
Exit For
End If
Next
Next
dTable.AcceptChanges()
Return dTable
End Function