sqlbulkcopy
public static void PerformBulkCopy() { string connectionString = "Data Source=localhost;database=test;Trusted_Connection=true"; { using (SqlConnection sourceConnection = new SqlConnection(connectionString)) { SqlCommand myCommand = new SqlCommand("select * from odi", sourceConnection); sourceConnection.Open(); SqlDataReader myReader = myCommand.ExecuteReader(); using (SqlConnection destinationConnection = new SqlConnection(connectionString)) { destinationConnection.Open(); using (SqlBulkCopy bulkCopy = new SqlBulkCopy(destinationConnection.ConnectionString)) { bulkCopy.BatchSize = 50; bulkCopy.NotifyAfter = 50; bulkCopy.SqlRowsCopied += new SqlRowsCopiedEventHandler(bulkCopy_SqlRowsCopied); bulkCopy.DestinationTableName = "odi1"; bulkCopy.WriteToServer(myReader); } destinationConnection.Close(); } myReader.Close(); sourceConnection.Close(); } } }
string connectionString = "Data Source=localhost;database=test;user id= xxxxxx; password = yyyyyy";
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)