When you execute a new query and populate an existing dataset, the newly retrieved records are appended to the existing records in the dataset. If you wish to remove the earlier records from the dataset without creating a new dataset, simply use its Clear()
method. This will remove the earlier existing records and newly populated records will be added when you invoke the Fill
method on the data adapter.