private void CopyBlockData()
{
///获取链接字符串
ConnectionStringSettings css = ConfigurationManager.ConnectionStrings["SQLCONNECTIONSTRING"];
///创建源数据链接和目的数据链接
SqlConnection srcCon = new SqlConnection(css.ConnectionString);
SqlConnection dirCon = new SqlConnection(css.ConnectionString);
///创建执行命名的Command
SqlCommand cmd = new SqlCommand("Select * From Catalog",srcCon);//从源表中读取数据
///打开链接
srcCon.Open();
dirCon.Open();
///读取数据
SqlDataReader dr = cmd.ExecuteReader();
///定义处理大块数据拷贝的类
SqlBulkCopy bc = new SqlBulkCopy(dirCon);
///定义目的表
bc.DestinationTableName = "CatalogTemp";//复制到目标表
///拷贝数据
bc.WriteToServer(dr);
dr.Close();
///关闭数据库的链接
srcCon.Close();
dirCon.Close();
///显示执行结束的信息
Response.Write("拷贝大块数据成功!……");
}
//web.Config
<connectionStrings>
<add
name="SQLCONNECTIONSTRING"
connectionString="Data Source=CHINA-7505E73AE;Initial Catalog=cmsdb;User ID=sa ;pwd=123456"
providerName="System.Data.SqlClient"
/>
</connectionStrings>