我需要把本机上的一数据库DataBase1里的Table1表和Table2表放到本机上的另一数据库DataBase2里面去,用ADO.NET怎么实现?
解决方案 »
- 09年.net面试题
- 【求助】C# Winform 怎么在UserControl1里修改Form1的公共变量呢?
- C#在windows窗体应用程序与控制台应用程序编程有什么区别
- winform 如何设置国定大小、不能用鼠标拉和放大
- 关于列表显示多个任务
- 求一个优化的算法?
- remoting两问题!!!
- 如何在一个安装程序中安装windows service程序
- picturebox控件或panel控件
- 关于hashtable
- 关于往数据库中插入一条记录同时返回该记录ID的问题
- 用ADO.NET怎么实现从数据库A里面将Tab1表,Tab2表,Tab3表放到数据库B里面去?急用!在线等!高手帮忙呀!
Conn = new SQLServerConnection("host=nc-star;port=1433;
User ID=test01;Password=test01; Database Name=Test");
try
{
Conn.Open();
}
catch (SQLServerException ex)
{
// Connection failed
Console.WriteLine(ex.Message);
return;
}string[] DropTableSQL = {"drop table emp", "drop table dept"};
for (int x=0; x<=1; x++)
{
try
{
// Drop the tables, don't care if they don't exist
SQLServerCommand DBCmd = new SQLServerCommand(DropTableSQL[x], Conn);
DBCmd.ExecuteNonQuery();
}
catch (SQLServerException ex)
{
}// Create the tables
string CreateEmpTableSQL = "CREATE TABLE emp (empno INT PRIMARY KEY NOT NULL,"
+"ename VARCHAR(10) NOT NULL,"
+"job VARCHAR(9) NOT NULL,"
+"mgr INT,"
+"hiredate DATETIME NOT NULL,"
+"sal NUMERIC(7,2) NOT NULL,"
+"comm NUMERIC(7,2),"
+"dept INT NOT NULL)";string CreateDeptTableSQL = "CREATE TABLE dept ("
+"deptno INT NOT NULL,"
+"dname VARCHAR(14),"
+"loc VARCHAR(13))";
try
{
SQLServerCommand DBCmd = new SQLServerCommand(CreateEmpTableSQL, Conn);
DBCmd.ExecuteNonQuery();
DBCmd.CommandText = CreateDeptTableSQL;
DBCmd.ExecuteNonQuery();}
catch (Exception ex)
{
//Create tables failed
Console.WriteLine (ex.Message);
return;
}
select * from 数据库A.表B
into 数据库B.表C