datatable是用inner join 与select orderid as stroid这两种方式得到的,这时如何用CommandBuild提交更新?

[iyaozg]

SqlDataAdapter custDA = new SqlDataAdapter("select * from order R inner join detail D on R.id=D.id", nwindConn);
SqlCommandBuilder custCB = new SqlCommandBuilder(custDA);

DataSet custDS = new DataSet();

nwindConn.Open();
custDA.Fill(custDS, "Customers");

// Code to modify data in the DataSet here.

custDA.Update(custDS, "order");

这种写法在提交Update()时,好象不行?

[iyaozg]

谁来帮我看一下

[HNU]

过程没问题，但是你 Fill 的是"Customers"，为什么Update 的是"order" ？

[iyaozg]

这是笔误,但是我用custCB.GetUpdateCommand().CommandText时提示"对于多个基表不支持动态 SQL 生成"

[iyaozg]

帮忙看一下

[iyaozg]

1

[vivianxu]

我也碰到这个问题，哪位高手帮忙看一下