批量复制

usingSystem;

usingSystem.Collections.Generic;

usingSystem.ComponentModel;

usingSystem.Data;

usingSystem.Drawing;

usingSystem.Linq;

usingSystem.Text;

usingSystem.Windows.Forms;

usingSystem.Data.SqlClient;

usingSystem.Configuration;



namespace_8888

{

publicpartialclassForm1:Form

{

publicForm1()

{

InitializeComponent();

}

intFlag=0;

privatevoidbtnCopy_Click(objectsender,EventArgse)

{

SqlConnectionconnection=newSqlConnection();

stringconnstr=ConfigurationManager.ConnectionStrings["DataBase"].ToString();

connection.ConnectionString=connstr;

connection.Open();

SqlCommandcmd=newSqlCommand("selectclassID,name,numberfromClass",connection);

SqlDataReaderreader=cmd.ExecuteReader();

SqlConnectionaimconnection=newSqlConnection();

stringaimconnstr=ConfigurationManager.ConnectionStrings["DataBase"].ToString();

aimconnection.ConnectionString=aimconnstr;

aimconnection.Open();

SqlBulkCopybulkcopy=newSqlBulkCopy(aimconnection);

bulkcopy.DestinationTableName="temp_class";

try

{

bulkcopy.WriteToServer(reader);

}

catch(Exceptionex)

{

Flag=1;

MessageBox.Show(ex.Message);

}

finally

{

reader.Close();

}

connection.Close();

aimconnection.Close();

if(Flag==0)

{

MessageBox.Show("Datahasbeensuccessfullycopied");

}

}

}

}