关于从一个库表向另一个库表写入数据的问题
mbm 2002-04-09 10:43:37 我有两个数据库,db1和db2,它们都有表t,并且表架构完全一样,现在想把db1中t表的数据写入db2的t表中,下面的代码有何错误?
private void db1todb2()
{
string connstring1="data source=MBM;initial catalog=db1;user id=mbm;password=mbm";
string querysql1="select * from t";
SqlConnection conn1=new SqlConnection(connstring1);
conn1.Open();
SqlDataAdapter adapter1=new SqlDataAdapter(querysql1,conn1);
DataSet ds1=new DataSet();
adapter1.Fill(ds1,"t");
conn1.Close();
string connstring2="data source=MBM;initial catalog=db2;user id=mbm;password=mbm";
string querysql2="select * from t";
SqlConnection conn2=new SqlConnection(connstring2);
conn2.Open();
SqlDataAdapter adapter2 = new SqlDataAdapter();
adapter2.SelectCommand = new SqlCommand(querysql2, conn2);
SqlCommandBuilder mycb = new SqlCommandBuilder(adapter2);
DataSet ds2=new DataSet();
adapter2.Fill(ds2,"t");
ds2=ds1;
// ds2=ds1.copy();
// foreach(DataRow dr in ds1.Tables["t"].Rows)
// {
// ds2.Tables["t"].ImportRow(dr);
// }
adapter2.Update(ds2,"t");//这行不报错,但为什么不能将数据写入db2数据库呢?
conn2.Close();
DataGrid1.DataSource=ds2.Tables["t"].DefaultView;;
DataGrid1.DataBind();
}