[dba-VB] ADO.Net Update SQL Server

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




More information about the dba-VB mailing list