DataAdapter.Update() doesn't work

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: zRaze (abuse_at_msn.com)
Date: 05/05/04 

Date: Wed, 05 May 2004 18:51:17 +0100

I have created a Dataset containing two tables "Table1" and "Table2"
If I make a change to a field in "Table1", I call the AcceptChanges()
on the DataTable. This changes my local copy of the table

However, when I run the Adapter's Update, it doesn't error but doesn't
make the changes in my database. Am I missing something, all the tutes
I've read on ADO.Net is all about downloading and playing with the
data, nothing about updating the server with the changes.

 Cheers...

Relevant Pages

  • Re: MS SQL copy new and modified rows from TABLE1 to TABLE2
    ... However Table1 is dynamic it has new rows added and some old rows ... How can I continue to keep Table2 up to date without always having to ... If the tables are on the same server, a trigger would be the best way ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Tricky Visual Basic Code help...
    ... moves the current record into a new record in table2. ... this with a little VBA code and a couple custom queries. ... Set a "pushFlag" column in the record in table1 to a specific ... If a duplicate is not found, ...
    (microsoft.public.access.formscoding)
  • Re: Help needed with importing XML
    ... You could add a gratuitous identity column to #temp and use ... Those examples showed how to decompose arbitrary XML in multiple ... table1 and table2. ... But there has to be something in the relational schema tying table1 ...
    (microsoft.public.sqlserver.xml)
  • Re: 2 column pulldown
    ... Allen Browne - Microsoft MVP. ... these field heading names come from Table2 since it is a lookup and so ... Table1 of course only has a single column name ... fieldX from Table1 is pulldown revealing candidate values of Table2. ...
    (microsoft.public.access.forms)
  • Re: Sliding and page breaks
    ... but I still have one nagging formatting problem. ... each entry in table1. ... simply pulls the first match in table2 instead of showing all the ... Otherwise I was thinking along the lines of your 2nd suggestion of using some calcs to consolidate the data down to a smaller number of tables used in the layout. ...
    (comp.databases.filemaker)