[dba-VB] ADO.Net Update SQL Server

ROTFL, Oh I think I succeed very well at sounding ignorant.  8-(

And yup, I don't know.  I have beaten my head against this all day with 
absolutely zero results.  I find it difficult to believe that I am doing 
anything unique but I'll be damned if I can find an article or code that 
just says "here is how you write back the updated table to the sql 
server... (data store)".

John W. Colby
www.ColbyConsulting.com


Michael R Mattys wrote:
> 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
> 
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
> 
>