data adapter update

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

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.
 
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 address removed) <Remove word online. from address>

This posting is provided “AS IS”, with no warranties, and confers no rights.




--------------------
 
Back
Top