明智地显示提醒. [英] Displaying reminder sort wise.

查看:85
本文介绍了明智地显示提醒.的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述


我想显示提醒.
数据库是msaccess
m使用datagrid显示数据.
在这里,我想以这种格式显示数据:

今天
...今天所有提醒
...
明天
...明天所有提醒
...
本周
...这周的所有提醒
...
本月
...这几个月的所有提醒
...
其他
...所有剩余的提醒
...



现在,此处的提醒显示不应在本周或本月条目中显示.

我正计划在数据网格名称TODAY中放置一个条目
然后编写sql语句以显示今天的提醒

然后在数据网格名称TOMORROW中放置一个条目
然后编写sql语句以显示明天提醒.


但是我找不到解决方法,而且还没有遵守限制,即今天交易中显示的条目不应在本月交易中显示.


i want to display reminder.
data base is msaccess
m displaying data using datagrid.
Here i want to show data in this format:

Today
...all today reminders
...
Tomorrow
...all tomorrow reminders
...
This Week
...all reminder of this week
...
This Month
...all reminders of this months
...
Others
...all remaining reminder
...



Now here the reminder display in today should not be displayed in this week or this month entry.

i was planning to put a entry in datagrid name TODAY
then write sql statement to display today reminder

then put a entry in datagrid name TOMORROW
then write sql statement to display tomorrow reminder.


but m not able to find how to do it and plus keeping the constraint that entry shown in today transaction should not be shown in this month transaction.

推荐答案

没有显示您尝试过的内容,建议您阅读以下 ^ ]

我建议您阅读2种技术/技巧,它们将为您提供在datsetsdatatables
中查询数据一次所需的工具.
1. 数据视图 [ LinQ到数据集 [
As you haven''t shown what you''ve tried I would suggest that you read up on the following ADO.NET Overview[^]

There are 2 technologies / techniques that I would suggest you read up on, these will give you the tools needed to query the data once in datsets or datatables

1. Dataview[^]

2. LinQ to dataset[&]


这篇关于明智地显示提醒.的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆