[dba-VB] ADO.Net Update SQL Server

I hate to sound ignorant but what is the UpdateBatch a method of?

I have a connection, command, dataset and datatable and AFAICT none of 
those things have an UpdateBatch method.

John W. Colby
www.ColbyConsulting.com


Charlotte Foust wrote:
> UpdateBatch should work.
> 
> Charlotte Foust 
> 
> -----Original Message-----
> From: dba-vb-bounces at databaseadvisors.com
> [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Monday, April 28, 2008 11:50 AM
> To: VBA
> Subject: [dba-VB] ADO.Net Update SQL Server
> 
> Does ANYBODY know how to write a table back out to SQL Server?
> 
> All of my books show cute little examples of building up a data table
> manually then BINDING it to a control or whatever.  I am not finding
> anything with code example that shows how to WRITE changed data back to
> SQL Server.
> 
> I have managed to load a data table, write changes to the rows and
> now... I have to write it back out to SQL Server.  The table has the PK,
> NameToSplit, LName, FName etc etc.  What am I missing?
> 
> I desperately need help (yea, yea, not MENTAL help) and I need it
> quickly.  I have been trying to do this last piece for DAYS and I am not
> succeeding.
> 
> --
> John W. Colby
> www.ColbyConsulting.com
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
> 
> 
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
> 
>