DataAdapter.Fill appends, but should replace?
69548Dec 15 2004 — edited Dec 20 2004I'm posting on behalf of the GUI guys so pardon me if I get any terminology wrong.
We're using ODP.NET 9.2.0.4 from VB.NET. We're calling DataAdapter.Fill. If we call Fill again, the DataSet is not automatically cleared; rather the new records are appended to the existing records. Apparently the Microsoft DP for Oracle automatically clears the DataSet. If we programatically clear the DataSet before Fill'ing, then we lose our binding.
Is this a bug? Expected behaviour? Why does the MS provider work differently? Is there a good workaround for this?
Thanks for any help.