if i have -2field in sqldb
1.Name-xyz
2.Today profit -10000
send automatically this information to client at 6 o'clock daily.
don't give me advice of window service .b/c i am unable to start my system regularly.
i want after website hosting. it should work automatically.
plz give me some help. please send me the code if possible of following any way..
1.global.asax.
2.webservice but not window services.
3. Timer event if possible on any porcess.
Loading

Steven ReidPosted Jul 14, 2014, 12:46 AM
Anupam SinghPosted Jul 2, 2014, 9:01 AM
Harshal ThakrePosted Jul 2, 2014, 8:54 AM
Anupam SinghPosted Jul 2, 2014, 8:36 AM
Try SQL mail and schedule it in SQL JOB. Just 2 steps you have to follow.
1.Read this to know how to configure sqlmail
http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/
2. Read this to send mail with data :
http://sqlmag.com/t-sql/use-cursor-send-customized-email
http://www.mssqltips.com/sqlservertip/2347/send-email-in-a-tabular-format-using-sql-server-database-mail/
Hope it will help.