Hai all.....
I have a small doubt..I want to fetch a single row from the database and compare it with all other rows in the database whether they are equal or not.if equal simply i want to delete the row.......
and can i also fetch a complete row as a single object?
if yes how am i go about this.......
Loading
Vijaya KadiyalaPosted Feb 22, 2009, 2:43 PM
Hi
Are you trying to find the duplicate records with in a table or accross the tables???
Thanks -- Vijaya Kadiyala
http://dotnetvj.blogspot.com
Mahesh ChandPosted Feb 19, 2009, 1:48 PM
Absolutely.
What is the criteria of row selection? Any unique ID or keyword or name? You use ExecuteReader method of SqlCommand to fetch records but based on your selection criteria, you may get more than one record.
Best way to handle this is in your SP at database end. SP should also delete the duplicate row.