'数据库为SQL: select * from tablename where 日期字段 between '2007-9-1' and '2007-9-30' '数据库为ACCESS: select * from tablename where 日期字段 between #2007-9-1# and #2007-9-30#
显示在窗体上就要用datagrid 控件吧 添加microsoft datagrid control 然后设置 set datagrid1.datasource=recordset recordset就是上面select的结果集 其实如果是新手,最好是结合ado控件使用 设置datasource属性直接为ado控件即可
select * from tablename where 日期字段 between '2007-9-1' and '2007-9-30'
'数据库为ACCESS:
select * from tablename where 日期字段 between #2007-9-1# and #2007-9-30#
添加microsoft datagrid control
然后设置
set datagrid1.datasource=recordset
recordset就是上面select的结果集
其实如果是新手,最好是结合ado控件使用
设置datasource属性直接为ado控件即可