title: Removing duplicate rows from a datatable in c#
body: <p>I have a datatable with some data in it...
  The data is shown below.</p>
  
  <pre><code>____________________________________________________
  |    |                    |            |           |
  |mid |    usrnme          |   pname    |   prate   |
  |---------------------------------------------------
  |11  | demo1@gmail.com    |   sample1  |    2000   |
  |14  | demo2@live.com     |   sample2  |    5000   |
  |15  | demo3@yahoo.com    |   sample3  |    8000   |
  |11  | demo1@gmail.com    |   sample1  |    2000   |
  |18  | demo4@gmail.com    |   sample4  |    3000   |
  ====================================================
  </code></pre>
  
  <p>As you can see the there are two rows with same values in the datatable. So In my code, I need to check whether there is any duplicate rows in my datatable. If there is any duplicate rows, eliminate that particular row, and then move the next row to the eliminated row. In this case, row 1 and row 4 are same, so it has to be corrected. So row 4 has to be deleted and row 5 has to be inserted in 4 th row position. In this way if there are n rows, the n rows has to be checked and corrected like this way. How can this be acheived in c#.net. I'm new to world of c#. Any help from anyone will be a great help for me.. Thanks in advance. </p>