Using a datatable with primary key

Dim dt As New DataTable

dt.Columns.Add(New DataColumn("id", GetType(Integer)))

dt.PrimaryKey = New DataColumn() {dt.Columns("id")}

dt.Columns.Add(New DataColumn("name", GetType(String)))

dt.Columns.Add(New DataColumn("address", GetType(String)))

'check if there is a row where the primary key = ID = 1

If dtVerschillen.Rows.Contains(1) Then

… do stuff

End If

Best way to remove rows in datatable

'remove row with id=1 (if it exists)

If dtVerschillen.Rows.Contains(1) Then

dt.Rows.RemoveAt(dt.Rows.IndexOf(dt.Rows.Find(1)))

End If