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.                               }          }          }        }