Doing a small project in which data from warranty cards are entered into a database ie. warranty card number, salesman name and ID, etc etc......after all the data has been entered into the database I need to check and see if there are any duplicate warranty card numbers in the database.
The way I am thinking is that ill first load the table into a dataset and datatable and then loop through all the records using the datarow object. compare each each record with all the other records and if i find a duplicate ill probably set a flag to make both invalid. I understand the concept but i am not too comfortable using all these objects ie datatable, datarow. It would be great if you could give me a simple syntax on how to loop through all the records using a datarow object.