asked
How can i send Email carrying an attachment from datagridview??
I have a table in my database namely EmpAttendance. This table has some columns likely empid,c_Date,intime,outtime,status. How can is send these details as an attachment via email for every half an hour(i have created a windows application in c#). also how can i calculate difference between outtime AND INTIME.
You can calculate the difference between `outtime` and `intime` using the `datediff` function. For the email, do you want your C# application to send the email? If so, that's a bit off topic and I would refer you to
stackoverflow.com (maybe [this question][1]). If you want to send the email from SQL Server, you can set up a SQL Agent job that executes `sp_send_dbmail` - [
http://msdn.microsoft.com/en-us/library/ms190307.aspx][3] [1]:
http://stackoverflow.com/questions/4379532/asp-net-c-sharp-converting-data-in-a-dataset-into-body-of-an-email [2]:
http://stackoverflow.com/questions/4379532/asp-net-c-sharp-converting-data-in-a-dataset-into-body-of-an-email [3]:
http://msdn.microsoft.com/en-us/library/ms190307.aspx
12 People are following this question.
