DataAdapter.Update not working

I have been trying to get DataAdapter.Update(DataSet) to update a SQL
Server database. I have not been getting any errors but there is no
records in the database when I check Enterprise Manager.

Could someone please help!

*** Sent via Developersdex http://www.developersdex.com ***

Craig,

There are so many posibilities for your error, can you tell us a little bit
more. Did you use the designer, did you use a commandbuilder, did you write
the commands yourself, etc.

Cor

Hi Cor,

Long time no see !, how are you these days ?

Terry Burns
http://TrainingOn.net



"Cor Ligthert [MVP]" <notmyfirstname@planet.nl> wrote in message
news:%23NvfRwHLGHA.500@TK2MSFTNGP15.phx.gbl...
> Craig,
>
> There are so many posibilities for your error, can you tell us a little
> bit more. Did you use the designer, did you use a commandbuilder, did you
> write the commands yourself, etc.
>
> Cor
>

"Craig Hoy" <craigh@omnilink.com.au> wrote in message
news:egf1uDHLGHA.3944@tk2msftngp13.phx.gbl...
>I have been trying to get DataAdapter.Update(DataSet) to update a SQL
> Server database. I have not been getting any errors but there is no
> records in the database when I check Enterprise Manager.
>
> Could someone please help!
--Craig, two things come to mind. First, make sure that
yourdataSet.HasChanges(); if not , then nothing is going to happen with
your update. http://www.knowdotnet.com/articles/rowstateupdate.html . If you
don't have Changes then there's nothing for the adapter to update. Next, if
that's not the case, run Sql Profiler and call Update and verify what's
being sent to the db. That should shed some insight into the problem.
>
> *** Sent via Developersdex http://www.developersdex.com ***

Craig,

If no error, then most likely DataAdapter does not have anything to update
in a database. If you know for sure that you have made the changes in a
database, then make sure that your code does not call AcceptChanges \before
it calls Update. Also make sure that UPDATE statements or SP that does
updating has proper conditions for the WHERE clause, if it has any

Val Mazur
Microsoft MVP
http://xport.mvps.org


"Craig Hoy" <craigh@omnilink.com.au> wrote in message
news:egf1uDHLGHA.3944@tk2msftngp13.phx.gbl...
>I have been trying to get DataAdapter.Update(DataSet) to update a SQL
> Server database. I have not been getting any errors but there is no
> records in the database when I check Enterprise Manager.
>
> Could someone please help!
>
> *** Sent via Developersdex http://www.developersdex.com ***