[dba-VB] ADO.Net Update SQL Server

Hi John,

The answer is in the code I published today on my site related to 'Re:
[dba-VB] ADO.Net':

http://smsconsulting.spb.ru/samples/Module.vb.txt

- Strategy 3 - trace in single threaded mode and you'll find what to do.

    Public Function SQLTDSGetDataTablePaged(ByVal startRow As Integer, ByVal
pageSize As Integer, ByRef adapter As SqlDataAdapter, ByRef dataSet As
DataSet) As DataTable
...

And

    Public Sub SQLTDSUpdate(ByVal adapter As SqlDataAdapter, ByVal dataSet
As DataSet)
....


HTH,

--
Shamil

-----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 10:50 PM
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