sqlbulkcopy 批量更新 数据库

转载： http://blog.csdn.net/wangzh300/article/details/7382506

private static void DataTableToSQLServer( DataTable dt)  
{  
    string connectionString = GetConnectionString();  
  
    using (SqlConnection destinationConnection =new SqlConnection(connectionString))  
    {  
        destinationConnection.Open();  
  
        using (SqlBulkCopy bulkCopy =new SqlBulkCopy(destinationConnection))  
        {  
  
  
            try  
            {  
  
                bulkCopy.DestinationTableName = "T_EIInformation";//要插入的表的表明  
                bulkCopy.ColumnMappings.Add("Email", "Email");//映射字段名 DataTable列名 ,数据库 对应的列名  
                bulkCopy.ColumnMappings.Add("author", "author");  
                bulkCopy.ColumnMappings.Add("Title", "Title");  
                bulkCopy.ColumnMappings.Add("Type", "Type");  
                bulkCopy.ColumnMappings.Add("confName", "confName");  
                bulkCopy.ColumnMappings.Add("Language", "Language");  
                bulkCopy.ColumnMappings.Add("Publicationyear", "Publicationyear");  
                bulkCopy.ColumnMappings.Add("Conferencelocation", "Conferencelocation");  
                bulkCopy.WriteToServer(dt);  
            }  
            catch (Exception ex)  
            {  
                Console.WriteLine(ex.Message);  
            }  
            finally  
            {  
                // Close the SqlDataReader. The SqlBulkCopy  
                // object is automatically closed at the end  
                // of the using block.  
                 
            }  
        }  
  
  
    }  
      
}