1、具体环境如下:在数据库中有两个表:Table1和Table2在Table1表中存有:用户名、Email两个字段;在Table2表中存有:用户名、地址两个字段;SQL关联语句:select 用户名,Email,地址 from Table1 t1 join Table2 t2 on t1.用户名=t2.用户名.2、给GridView的数据源为DataTable,DataView.那就拿DataTable来说,不管怎么弄,有多少个表,只要把这些表的数据都整合到一个DataTable中就都可以实现.语句如下:select a.id as aid,a.name as aname,b.id as bid,b.name as bname,c.id as cid,c.name as cnamefrom a,b,c where a.id = b.aidand a.id = c.aid
|