批量插入数据 C# SqlBulkCopy使用

来源：互联网发布：mac 固定便签在桌面上编辑：程序博客网时间：2024/05/20 06:42
        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.                                           }                }                   }                    }
0 0