Compare non-PK in two datasets

[Tommy Malone]

I'm attempting to import data from an external source into a database. My
question is how can I compare the value of a specified column that is not a
primary key before adding the row to my dataset (and then into the db)?

My process is this:

1. Read data into a dataset from external source (xml or excel)
2. Compare with existing dataset column ("Title")
3. If "Title" does not exist, add the new row from external data source
4. If "Title" does exist, go to next row in external data source

My difficulty is doing this comparison without the benefit of the FindBy
method since "Title" is not a PK.

 

[Miha Markic [MVP C#]]

Hi Tommy,

You might use DataView, sorted by title.
Its Find method will search by sorted field(s).