As long as you have the primary key for the table in the update it should work with just those fields... Never tried it myself but it works with straight SQL so it should work here.
Want to know more? Check out the MSDN Library at
http://msdn.microsoft.com or the Microsoft Knowledge Base at
http://support.microsoft.com
Scot Rose, MCSD
Microsoft Visual Basic Developer Support
Email :
(E-Mail Removed) <Remove word online. from address>
This posting is provided “AS IS”, with no warranties, and confers no rights.
--------------------
>Content-Class: urn:content-classes:message
>From: "Adam" <(E-Mail Removed)>
>Sender: "Adam" <(E-Mail Removed)>
>Subject: data adapter update
>Date: Wed, 30 Jul 2003 08:31:18 -0700
>Lines: 13
>Message-ID: <006f01c356af$9f56fe90$(E-Mail Removed)>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Thread-Index: AcNWr59WmIVrg4dLRJW7zPDZSFiheA==
>X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
>Newsgroups: microsoft.public.dotnet.general
>Path: cpmsftngxa06.phx.gbl
>Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.general:102857
>NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
>X-Tomcat-NG: microsoft.public.dotnet.general
>
>This is kind of a tough question, but, I'm working on a
>program now and using sql data adapters with sql server to
>generate data tables.
>
>I'm updating the tables and then using the
>dataadapter.update method to send the table back.
>The problem is, the tables have about 30 fields and I'm
>only changing 2 (it's a holding file).
>
>Can I make an update statement that will only send back
>the 2 fields that I'm changing? Because I noticed that the
>dataadpter update statement uses pointers that I don't
>know if I can use.
>
Similar Threads
