Windows FOrm Application

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008

I have created a windows appliction where we store login,logout and status(in or out) details of an employee depending on employee id.

Now my requirement is to send an email(local server) automatically for every half an hour consisting the employee details from DB where status value is "IN" .

Could any please help on how to proceed further.

Posted 13-Feb-13 0:26am

Harsha24

Add a Solution

2 solutions

Solution 2

Alternative if you want the email functionality separate from your UI ...

For sending an email you could use SMTP - System.Net.Mail This link[^] is a little old but covers various other methods too.

For the timing side of things (non-GUI) you could use System.Timers or System.Threading.Timer

or (if appropriate to your system) you could use the windows Task Scheduler http://msdn.microsoft.com/en-gb/library/windows/desktop/aa383614(v=vs.85).aspx[^] with your own code or a script e.g. http://www.petri.co.il/how-to-use-eventtriggersexe-to-send-e-mail-based-on-event-ids.htm[^]

Posted 13-Feb-13 0:48am

CHill60

Comments

Maciej Los 13-Feb-13 7:07am

Good idea! +5!

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

OriginalGriff · Accepted Answer · 2013-02-13T00:39:00

Solution 1

Add a Timer to your form, which fires every minute.
In the Timer Tick handler, check a counter - start with 30 and count it down. When it reaches zero, you need to send the email.
See here for a generic method to do that: Sending an Email in C# with or without attachments: generic routine.[^] then set the counter back to 30 ready for next time.

Posted 13-Feb-13 0:39am

OriginalGriff

Comments

Harsha24 13-Feb-13 6:43am

thank you for the post.. Using the timer is ok. But how about fetching the records from database and send them as an attachment basing on the condition where status = "in".

OriginalGriff 13-Feb-13 6:48am

Use your prefered DB access method (DataAdapter, or Connection/Command pair with a Reader) with the following query:
SELECT * FROM MyTable WHERE Status='IN'
You then rework them into an appropriate format - I don't know how you need the email organised so I can't suggest anything much at this stage.

CHill60 13-Feb-13 6:54am

Sorry about the cross-over comments - I really must refresh my screen more often

CHill60 13-Feb-13 6:53am

You could use StringBuilder to construct the body of the email rather than an attachment - or write the text to a temporary text file and attach that to the email e.g. filename = "\"" + Path.Combine(Path.GetTempPath(), Path.GetRandomFileName()).ToString() + "\"";

CHill60 13-Feb-13 11:00am

Sorry - all contact is via CP

Maciej Los 13-Feb-13 7:07am

A 5!