数据集中生成表

[jsntsam]

在数据集中有两个表，想根据这两个表生成第三个表，完成相当于SQL语句：

select table1.* ,table2.* from table1 left join table2 on table1.id=table2.id

的功能。

如何做？

[jsntsam]

原来我是想将这两个表绑定的datagrid。可是datagrid好象不能对两个表梆定。

看来还得从数据层，直接返回一个合并的表了。

谢谢！

[qiushuiwuhen]

try
select into table3 from table1 left join table2 on table1.id=table2.id

[saucer]

There is no built-in mechanism to do that, unless you create a corresponding DataAdapter with this SQL and fill a new DataTable

but you can create a relationship between the first table and second table, and then iterate through the first table, process each row and get row's corrresponding row in the second table through DataRow.GetChildRows(...) method