title: how to get distinct records in datatable?
body: <p>I am using C# + VS2008 + .Net + ASP.Net + IIS 7.0 + ADO.Net + SQL Server 2008. I have a ADO.Net datatable object, and I want to filter out duplicate/similar records (in my specific rule to judge whether records are duplicate/similar -- if record/row has the same value for a string column, I will treat them as duplicate/similar records), and only keep one of such duplicate/similar records.</p>
  
  <p>The output needs to be a datatable, may output the same datatable object if filter operation could be operated on the same datatable object.</p>
  
  <p>What is the most efficient solution?</p>