Why won't Dataset reflect changes?

microsoft.public.dotnet.framework.adonet

30 Mar 2006 6:00 PM

Coty

I have a single page application that uses Web Service to fill a dataset
decending. When I add a new record to the database and re-fill dataset it
won't reflect the first record added until after I've added a second one.
Like wise the second record added won't show in dataset until a third is
added.

I've read 44 pages of this forum and tried about every solution to dataset
updating that I found. DataAdapter.Update, dsxxxx.AcceptChanges, totally
killing the dataset and recreating and still I get this same effect. I do
not use any caching or states on this page.

To check if it was the Web Service I added a direct sqlDataAdapter to the
page along with another dataset and these 2 preformed exactly the same as Web
Service supplied dataset.

I know the record is being written as I can time stamp the page post-back
and look at the SQL table and times are same down the 10ths of a second. I'm
using VS2003 with SQL2005 with C# coding.

Any idea's I would be willing to try.

Thanx