表结构
title
CreDate查询数据后要按CreDate分组显示
在前台页面显示的格式如下:Wed Dec 23
$499 / 2br - Their loss your gain we have Foreclosed homesc - (atlanta)
$1500 / 4br - FULLY FURNISHED -Awesome Community - Tennis/Swim - (Roswell)
Wed Dec 22
At Last Buying A home Is Easy and As Cheap as Renting!! - (Atlanta) img
$950 / 3br - 3Brd/2Bath, 3082 sqft home in a spectacular community - (otp west) pic 我现在的想法是,根据查询条件把分页的结果用一个DataTable返回给前台页面,再在前台把DataTable按CreDate分组(在asp.net不好实现),根据CreDate从DataTable取该天的数据,在asp.net要用两个Repeater嵌套。有没有简单好用的解决方案
title
CreDate查询数据后要按CreDate分组显示
在前台页面显示的格式如下:Wed Dec 23
$499 / 2br - Their loss your gain we have Foreclosed homesc - (atlanta)
$1500 / 4br - FULLY FURNISHED -Awesome Community - Tennis/Swim - (Roswell)
Wed Dec 22
At Last Buying A home Is Easy and As Cheap as Renting!! - (Atlanta) img
$950 / 3br - 3Brd/2Bath, 3082 sqft home in a spectacular community - (otp west) pic 我现在的想法是,根据查询条件把分页的结果用一个DataTable返回给前台页面,再在前台把DataTable按CreDate分组(在asp.net不好实现),根据CreDate从DataTable取该天的数据,在asp.net要用两个Repeater嵌套。有没有简单好用的解决方案
解决方案 »
- 一个名字叫做DB的数据库里面有20多张表,不知道具体那张表,但知道某张表有个字段叫'name'的存了一个叫'zhangsan'的名字,请问可以查出这张表的名字吗
- SQL Server 2005 Reporting Services启动失败的问题
- 小妹求 Float 科学计数法
- 在VB中我用access,下面的查询语句能正确执行,但升迁成SQL SERVER 2000后却报错。如何在SQL SERVER 2000也能实现下列语句的效果?select * from 书店 ORDER BY 类型='物理' , 类型='化学' ,
- 关于远程计算机DSN的问题
- 超级麻烦的递归查询,高手帮帮忙!!!!!
- View log reader agent status 无法中止--复制订阅的大难题
- 为什么我装了SQL桌面数据库后不能用啊???
- **********动态列查询***********
- “山谷在线”全新改版啦!http://www.chinavvv.com
- 怎样查询所有记录总数不是0的用户表?
- 触发器条件如何给出
这个SQL做不到,去前台编写代码完成.
from 表
order by CreDate desc就行了,显示的处理应该由你的ASP来处理。一般是dOldDate = 1900-01-01
rs.open select * from 表 order by CreDate desc
do while not rs.eof
if dOldDate <> rs.fields("CreDate").value then
...