从数据库读取新闻和产品表生成站点地图

Question

请教,从数据库读取新闻和产品表生成.html格式的站点地图并分页.效果如下:
http://www.ck-wholesale.com/product6/ck-underwear-10.htm 
http://www.ck-wholesale.com/product6/ck-underwear-11.htm 
http://www.ck-wholesale.com/product6/ck-underwear-12.htm 
http://www.ck-wholesale.com/product6/ck-underwear-13.htm 
http://www.ck-wholesale.com/product6/ck-underwear-14.htm 
http://www.ck-wholesale.com/product6/ck-underwear-15.htm 
http://www.ck-wholesale.com/product5/underwear-01.htm 
http://www.ck-wholesale.com/product5/underwear-02.htm 
http://www.ck-wholesale.com/product5/underwear-04.htm 
http://www.ck-wholesale.com/product5/underwear-03.htm 
http://www.ck-wholesale.com/product5/underwear-05.htm 
http://www.ck-wholesale.com/product5/underwear-06.htm 
http://www.ck-wholesale.com/product5/underwear-07.htm 
http://www.ck-wholesale.com/product5/underwear-08.htm 
http://www.ck-wholesale.com/product5/underwear-09.htm 
http://www.ck-wholesale.com/product5/underwear-10.htm 
http://www.ck-wholesale.com/product5/underwear-11.htm 
http://www.ck-wholesale.com/product5/underwear-12.htm 
http://www.ck-wholesale.com/product5/underwear-13.htm 
【首页】-【上页】-【第1页】/【共79页】-【下页】-【尾页】 
怎么做?

Answer 1

GridViewDataListReapeter拼字符串N多招，除非你在倒分

Answer 2

可以考虑在新闻表加一个字段记录这条新闻生成静态页面后的URL

Answer 3

从两个表里取出所有的数据,存在两个dataset里的,问题的关键是怎么分页,每个.html只显示200条