求助 datagrid`````DataSet```

[Dcboy]

怎样把两个
SqlCommand 查询出来的记录Fill在一个DataSet中的一个table中???


谢谢```

[saucer]

assume those two tables have same structures, use DataSet's Merge method or use DataTable's ImportRow

[sgsh51]

SqlDataAdapter才可以将Fill到一个Table中

[Dcboy]

To: sgsh51()

可以详细点吗??

谢谢``

[Dcboy]

请教一个分页的问题``

如果ID不连续``用什么分页方法好```
如果用.NET 默认分页我怕记录多的时候会很慢```
但是用select top n from table where id<Maxid 的方法 又不行``因为ID不是连续的``

头痛中`````````````

[saucer]

>>>但是用select top n from table where id<Maxid 的方法 又不行``因为ID不是连续的``

remember the first and last id on each page and do

//previous page
select * from (select top n from table where id< firstID order by id desc) t order by id

or

//next page
select top n from table where id> lastID order by id

[Dcboy]

To:saucer(思归)
这个方法只能
用NEXT PREVIOUS

不能用
[1] [2] [3] [4] [5]....
这种分页方法```

[saucer]

try to use a stored procedure and create a temporary table, see

http://www.4guysfromrolla.com/webtech/062899-1.shtml