Click here to Skip to main content
15,920,688 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi,
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.
Posted
Comments
Abhinav S 21-Aug-11 4:44am    
Have you tried anything?
thatraja 21-Aug-11 11:24am    
[Comment from OP/Moved from Answer]
No, was not getting direction so ask the question.
thatraja 21-Aug-11 11:25am    
Never post your comment as a solution. Use Reply link on the comments

1 solution

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[&]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900