如何使用数据集实现批量复制 [英] how to achieve bulkcopy using dataset

问题描述

批量复制只能通过使用datareader来完成，或者我们可以使用数据集来完成批量复制...

bulkcopy can done only by using datareader or we can use data set to done bulkcopy...

public static void PerformBulkCopy()
    {
        string connectionString = "Server=CBMWEBREN15;Database=jahan;Trusted_Connection=true";
        {
            try
            {
                SqlConnection sourceConnection = new SqlConnection(connectionString);
               
                    SqlCommand myCommand = new SqlCommand("select * from j22", sourceConnection);
                    sourceConnection.Open();
                    SqlDataReader myReader = myCommand.ExecuteReader();
                    SqlConnection destinationConnection = new SqlConnection(connectionString);
                 
                        destinationConnection.Open();
                        SqlBulkCopy bulkCopy = new SqlBulkCopy(destinationConnection.ConnectionString);
                  
                            bulkCopy.BatchSize = 40;
                            bulkCopy.NotifyAfter = 30;
                            bulkCopy.SqlRowsCopied += new SqlRowsCopiedEventHandler(bulkCopy_SqlRowsCopied);
                            bulkCopy.DestinationTableName = "j2";
                            bulkCopy.WriteToServer(myReader);
                    
                        destinationConnection.Close();
                   
                    myReader.Close();
                    sourceConnection.Close();
                
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

the above code is working but is there any possible to get dataset from arraylist and store it to database using bulkcopy... if u know means tel me

推荐答案

mySqlDataAdapter.Update(myDataSet,"TableName");

这篇关于如何使用数据集实现批量复制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！