SqlBulkCopy类,学习
名称 | 说明 |
---|---|
SqlBulkCopy (SqlConnection) | |
SqlBulkCopy (String) | |
SqlBulkCopy (String, SqlBulkCopyOptions) | |
SqlBulkCopy (SqlConnection, SqlBulkCopyOptions, SqlTransaction) |
下面的例子,用到了SqlBulkCopy (SqlConnection, SqlBulkCopyOptions, SqlTransaction)
不多说,贴代码
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.IO;
namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
try
{
Console.WriteLine("制作:IT-AI与自然合成版");
Console.WriteLine("功能:从本地A服务器导外B服务器");
Console.WriteLine("操作:IT-自然");
Console.WriteLine("确认导入吗?(Y/N)");
string confirm = Console.ReadLine();
if (confirm == "Y" || confirm == "y")
{
string strConn_one = "server=192.168.2.106;uid=****;pwd=***;database=IKOKK;";//本地
SqlConnection conn1 = new SqlConnection(strConn_one);
string strSql_one = "select * from 上海2";
SqlDataAdapter adp = new SqlDataAdapter(strSql_one, conn1);
DataTable dt = new DataTable();
adp.Fill(dt);
string strSql_two = "server= 192.168.2.101;uid=***;pwd=**;database=TEST;";//内网
SqlConnection conn2 = new SqlConnection(strSql_two);
conn2.Open();
SqlTransaction t = conn2.BeginTransaction();
SqlBulkCopy sqlbulkcopy = new SqlBulkCopy(conn2,SqlBulkCopyOptions.Default,t );
sqlbulkcopy.DestinationTableName = "上海2";
sqlbulkcopy.WriteToServer(dt);
t.Commit();
Console.WriteLine("导入成功!");
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
Console.ReadLine();
}
}
}