Hi friends,
I have created a project, where i need to throw the remainders of msg which i stored in the database, based on the user login.
For example, i'am the user and when i login the system, i need the current date schedules to be thrown as a msg, where the msg already stored in the schedule table in the database.
I need a remainder msg, to be thrown in vb.net 2005 application based on the current user as OUTLOOK EXPRESS THROW THE REMAINDER.
If anybody worked on this concept, could u plz, guide me with an solution?
Any help much appreciated.
Thanks in Advance
|
| Author: Praveen 21 Nov 2008 | Member Level: Diamond | Rating:  Points: 4 |
while login user u'll have his user id right
After his successfull login check in database with that user name if any data is there then do what u want and write query like this
select s.* from schedule s left outer join login l where l.uid=s.uid and l.username='"&txtUserName.Text&"' and s.ScheduleDate='"&DateTime.Now.ToString("ur database Formate")&"'
hope this will help u
|