插入sql数据库时处理大量数据

插入sql数据库时处理大量数据

您可以尝试

SqlBulkCopy

将数据表插入数据库表

像这样

using (SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlConnection, SqlBulkCopyOptions.KeepIdentity)){    bulkCopy.DestinationTableName = DestTableName;    string[] DtColumnName = YourDataTableColumns;    foreach (string dbcol in DbColumnName)//To map Column of Datatable to that of Database tabele    {        foreach (string dtcol in DtColumnName)        { if (dbcol.ToLower() == dtcol.ToLower()) {     SqlBulkCopyColumnMapping mapID = new SqlBulkCopyColumnMapping(dtcol, dbcol);     bulkCopy.ColumnMappings.Add(mapID);     break; }        }    }    bulkCopy.WriteToServer(YourDataTableName.CreateDataReader());    bulkCopy.Close();}

有关更多信息，请参见http://msdn.microsoft.com/zh-
cn/library/system.data.sqlclient.sqlbulkcopy.aspx