wxcVqFen

1Converting a DataTable to an CREATE TABLE   INSERT script for SQL in C#
2public static void BulkInsertDataTable(string connectionString, string tableName, DataTable table)
3        {
4            using (SqlConnection connection = new SqlConnection(connectionString))
5            {
6                SqlBulkCopy bulkCopy =
7                    new SqlBulkCopy
8                    (
9                    connection,
10                    SqlBulkCopyOptions.TableLock |
11                    SqlBulkCopyOptions.FireTriggers |
12                    SqlBulkCopyOptions.UseInternalTransaction,
13                    null
14                    );
15
16                bulkCopy.DestinationTableName = tableName;
17                connection.Open();
18
19                bulkCopy.WriteToServer(table);
20                connection.Close();
21            }
22        }
23	
24IF NOT EXISTS (Select 1 from Table1 WHERE Col1='Col1' AND Col2='Col2')
25INSERT INTO Table1 (Col1,Col2,Col3,Col4) VALUES (1,'abc',null,'2012-01-01')