[dba-VB] VB.Net - ADO - add table to SQL Server

Bobby Heid bheid at sc.rr.com
Mon Oct 8 21:16:41 CDT 2007


Yes it is easy.  Look up "Create Table".

Create Table ref:

Example: http://www.codeproject.com/useritems/adodotnetprogrammatically.asp


-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Monday, October 08, 2007 8:08 AM
To: dba-vb at databaseadvisors.com
Subject: [dba-VB] VB.Net - ADO - add table to SQL Server

Does ADO have methods to cause a table built up the dataset to be saved to
SQL Server if the table is not already in SQL Server?

I am reading XML into a dataset, but the table created does not already
exist in SQL Server.  I need to cause the table to be written to a specified
database in SQL Server.  Is this possible?  I have been googling around but
am finding nothing like this.

John W. Colby
Colby Consulting

dba-VB mailing list
dba-VB at databaseadvisors.com

More information about the dba-VB mailing list