Michael R Mattys
mmattys at rochester.rr.com
Mon Apr 28 15:14:01 CDT 2008
It is a method of the ADO.Recordset. I was ignorant of this, also, until I looked it up in a book. Ignorant<>something you can sound like Either you know or you don't know :) Michael R. Mattys MapPoint & Access Dev www.mattysconsulting.com ----- Original Message ----- From: "jwcolby" <jwcolby at colbyconsulting.com> To: "Discussion concerning Visual Basic and related programming issues." <dba-vb at databaseadvisors.com> Sent: Monday, April 28, 2008 3:57 PM Subject: Re: [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