Bobby Heid
bheid at sc.rr.com
Mon Oct 8 21:16:41 CDT 2007
John, Yes it is easy. Look up "Create Table". Create Table ref: http://www.codeproject.com/useritems/adodotnetprogrammatically.asp Example: http://www.codeproject.com/useritems/adodotnetprogrammatically.asp Bobby -----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 www.ColbyConsulting.com _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com