DataTable 的一个问题???(50分)

J

jing1zhi15

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-24

• #1

DataTable dt1;
DataTable dt2;
//dt1,dt2的列数一样,但列名不一样，并且dt1为空，dt2有记录;
试问：如何把dt2的记录拷贝到dt1中?

 

X

xiongyi

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-24

• #2

用batchmove,设置MAPPINGS

 

L

louhong

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-24

• #3

比如dt1有a1,a2,a3三列，dt2有b1,b2,b3三列，那么只要这样：
insert into dt1 (a1,a2,a3)
select b1,b2,b3 from dt2
如果不行的话，换成这样：
insert into dt1 (a1,a2,a3)
select b1 a1,b2 a2,b3 a3 from dt2

 

S

smallbs

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-25

• #4

还可以这样
insert into dt1 select b1 as a1,b2 as a2,b3 as a3 from dt2
注意字段顺序和类型
关键字 into 在有的数据库中可以不用

 

J

jing1zhi15

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-25

• #5

DataTable 是 c#上的,而不是sql server

 

H

hryyx

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-25

• #6

insert into dt1 select * from dt2

 

Y

yu_gao

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-30

• #7

for (int i=0;i<dt2.Rows.Count;i++)
{
DataRow dr = dt1.NewRow();
dr["a1"]=dt2.Rows["b1"].ToString();
dr["a2"]=dt2.Rows["b2"].ToString();
dr["a3"]=dt2.Rows["b3"].ToString();
dt1.Rows.Add(dr);
}