DataSet contains duplicate records based on the SQL outer join query Explains that the DataTable may contain two copies of each record if you call the Fill method twice on a DataTable in a DataSet that is based on a SQL outer join statement. You can clear the DataTable before you reload the data to resolve this issue.