How to check duplicate in row using c#?

Raja

10y2.5k.NET

I have 45 Columns and 30 rows in Data table. in First row second colum is item number(1 item number:)'1' is serial number and the values are continue from third row

(1 Item Number 1 5 6 8 9)upto 25 column. after the 25 th column another values are stored.like

(1 Itemnumber: 1 5 6 7 9 8 .......25 Description 36 96 96 96 58 87 98 .......)up to 45th column. now i want to check duplicate for item number.how to do it.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jisny Av10y ago
Accepted answer
Hi,
Try this
for (int i = 0; i < dt.Rows.Count; i++) //dt is the datatable
{
   for (int j = 0; j < dt.Columns.Count; j++)
   {
      string first = dt.Rows[i][j].ToString();
      for (int k = j + 1; k < dt.Columns.Count; k++)
      {
         if (first == dt.Rows[i][k].ToString())
            Response.Write(" The value " + first + " in the row " + (i + 1) + " column " + (j + 1) + " already       exists in the column " + (k + 1));
      }
   }
}
Raja10y ago
Jisny Av
Sorry for late.this is working fine.
Thank you
Rajeesh Menoth10y ago
Hi,

Check the following examples :

http://stackoverflow.com/questions/10806309/find-duplicate-entries-c-sharp

http://stackoverflow.com/questions/8939516/how-to-find-duplicate-record-using-linq-from-datatable

http://stackoverflow.com/questions/664021/compare-all-rows-in-datatable-identify-duplicate-records

http://stackoverflow.com/questions/4415519/best-way-to-remove-duplicate-entries-from-a-data-table