Esempi in C# (CSharp) per System.Data.SqlClient SqlBulkCopy.set_DestinationTableName

Esempio n. 1

File: DALSql.cs Progetto: u4097/SQLScript

 public static void BulkCopy(string tableName, System.Data.DataTable insertData)
 {
     try
     {
         System.Data.SqlClient.SqlBulkCopy copy = new System.Data.SqlClient.SqlBulkCopy(Connection);
         copy.set_DestinationTableName(tableName);
         foreach (System.Data.DataColumn column in insertData.Columns)
         {
             copy.ColumnMappings.Add(column.get_ColumnName(), column.get_ColumnName());
         }
         copy.WriteToServer(insertData);
     }
     catch (System.Data.SqlClient.SqlException exception)
     {
         throw WrapDatabaseException(exception);
     }
 }