i wnat to sechdule message on asp.net. Like if i create a messge reminder to registerd members so they recive messge on paricular date time.
View 1 Repliesf i send email to first member, everything is ok ,, but next member will have 2 email .. email for him and the message for first one !and i have another problem with ( send to all ) All members received the Message , But without the subject and textthis a contol page .aspx code
[Code]...
I use MS Visual Web Developer 2008 Express edition with VB and SQL Server Express.I have an SQL database of over 300 club members details which contain(amongst other things) the following details:Forename, Surname, Email address, Full postal addressI want to send an email to each member showing their forename, Surname, and postal address so that they can confim that these are correct.
View 6 RepliesI'm using ASP.Net with VB (Visual Web Developer 2010) and SQL(Management Studio Express 2008) to create a website that keeps track of employee subscriptions.A date is entered into my database whenever an employee makes a subscription.I need to find a way to send an automatic email to each employee when the current date exceeds the subscription date by one year.
I am unable to use an SQL job as I only have SQL MS express.From other posts I have read it seems the best way to do this is to create a webservice to send emails but I am unsure of how to get the email address for each employee from the database to the web service?Do you guys think a web service is the best way to do this?
I want to send email on particular Date & Time. How to achieve this? I am using Sql 2005 for storing Date & time for sending emails.
View 3 RepliesAs indicated in the Subject, I have a web application (say APP) that should feature an e-Mail Notification Service (ENS). Activation of the Service is controlled by a Button in a dedicated page where some parameters are also included to set running Period (FromTime - ToTime), Interval, Recipients, etc.
When said button is clicked, it should maintain those parameters into database then launch ENS. Since ENS is expected to run for good according to set parameters, it logically should run as an external application/service, independent from APP.
When ENS starts, it needs to consult database to fetch parameters, then schedules its Timer to periodically check database for some transactions that when found, should trigger ENS to dispatch e-Mails to concerned Recipient(s).
CHALLENGES:
1. Launch ENS as an external application on button click from APP.Achieved by using System.Diagnostics.Process class. However, I encountered a problem in verifying if the process is already running before starting it. The root of the problem lies in
ProcessName property. Since ALL web applications must be launched via IE, hence, have
iexplore as their ProcessName, which is also applicable to all processes started through IE, it is very likely to have multiple processes utilising IE. How to check which is which? I couldn't figure out that.
Eventually, I ended up with a workaround: when the Process is started from APP, capture its ID and save it to database, then use this ID with GetProcessById() method for later verification. When the Process is terminated, reset stored ID in database.
2. What sort of application should ENS be: Windows Application or Web Application?
In either way however, ENS will always run invisible in the background being a Process. If this is the case, how about creating it as a Windows Service instead?
I did a lot of reading but still confused. However, the choice is limited now to either Web Application or Windows Service. Which one is more convenient to the task in hand?
3. What Timer to use?
I tried System.Timers.Timer in a test web application but it didn't fire! Then I used ASP AJAX Timer and it worked pretty well (I still need though to try running it from APP to judge its functionality). I came across some recommendations to use System.Threading.Timer but haven't tested that yet. Would it worth the trial?
4. ENS as a Windows Service.
If I create ENS as a Windows Service, would I be able to communicate with database? How would this influence the Timer to use?
How can i send an email certain days from now in C# (Win Forms). Say today is January 1 2010. Now i fix an appointment with doctor on January 10 2010. But i wish that a reminder email (regarding appointment) needs to be sent 3 days before (i.e. January 7 2010). I am having an email code with me.
My requirements: Visual Studio 2005, C# (vb would also do), WinForms (Windows based applications)
Let me know if anything from me is needed.
I would like to achieve the following.
1- if a user goes to a web page in a web application hosted on the Internet and selects a FUTURE date from a "Calendar control" the date selected and the URL for the page are stored in the database (I know how to do this step)
2- when the date selected arrives the URL will be embedded in an email that is sent out AUTOMATICALLY to the user. How can I trigger the email to go out AUTOMATICALLY on the selected date??????
Does the link below help me answer this question?? I just need a high level steps on how to do this. .
http://msdn.microsoft.com/en-us/magazine/cc163821.aspx
i have made application...that can have numbers of Event on Specified Date, So i want to code tat when time for event is arrived so tat automatically the participant get information about the event..so i want to send email to all participant before a day.
View 3 RepliesI am a .net developer. I am developing an application in which i need to send scheduled sms to users mobile number which is stored in database(SQl Server 2008) automatically.
I have already buy sms gateway. How can I do this. Is there any way to call a asp.net page automatically periodically.?
Im about to develop a site which will need 2 types of email function: the first will be simple enough, just a realtime email using system.net.mail when certain conditions are met in the underlying DB. the second is to send out an email at the end of each day covering everything that happened during the day. WOuld that have to be set up as a scheduled task?
View 3 RepliesIs there a way to send an email to a certain email address and have the message inserted into a database? The subject would be intered into "Subject" table field and the message body would be inserted into the "Message" table field.
View 4 Repliesi'm attempting to insert cx information into a database and then mail that information to the sales team. I'm using the DetailsView Control to accomplish the SQL Insert Command -- Success I'm using a SendMail command when the Insert button is Clicked to send a hard coded email to the sales team -- Success I can not send the User inputed information into the email -- FAIL
Example Code:
[Code]....
To be redundant -- If I send "body" by itself the system works, it falls apart when I try to add Name.Text where Name is the ID of my textbox in the form.
I have users table in database that contain their Email address and I have 2 textbox
1-txtSubject
2-txtBody
and 1 button btnsend in my page...
I want when I click on Send button it send to all users email that contain txtsubject and txtbody ...
how I can do it?
Actually i am developing a web application for leave,,if the employee wants to take a leave,the employee working under the senior people,if the employee 001 wants to take a leave,if the employee 001 logins in the web application,if he is working in sales dept,automatically this mail is forwarded to sales manager..like wise for all the employee..if the employee works in accounts dept,whenever the employee logins in the web application,to email address automatically change to the accounts manager..i dont no how to do this
View 1 RepliesAfter pressing forgot password ,I redirect to page having textbox for email id.When I enter mail id and click on send button I want to send the saved password from database to that mail id. How can I achieve that?
My database contains userid(not auto incremented and specific to user),mailId,password fields.My login page contains UserId nd Password and link of forgot password.
i bought a hosting plan that allows me to send about 500email/per hour but my client wish to send about 2000 or 3000 email at a time. is there a way to split them and 500 email per a time automaticly without the need of reloging again every hour. my hosting plan doesn't allow me to create a sql jop or send mails via Sql Server.
View 6 RepliesI want to send clients remainder automatically when he set remainder for particular date. mail automatically send to his mail on that day.
View 1 RepliesI have been trying to add BLOB Image from Oracle Database table to Email content as HTML table elemnt.
<table style='width: 100%; font-weight: bold;'>
<tr style="border-style: groove; font-size: 14px; font-weight: bold; background-color: #45a297;">
<td colspan="2" style="font-size: 8px; font-family: Verdana; font-weight: bold; padding-left: 0px; color: white; font-size: 16px; text-align: center">Flight</td>
</tr>
[CODE]..
I am getting my data in Email except Image in mail content.
I have a form that sends an email when the submit button is clicked. The email functionality works great. I also need it to save the information to the Database. I have attempted to get it to work but it gets hung at a certain point when trying to write to the DB. Even when the DB error happens, the email is still sent. I have attached the code that I am using as well as the error that I am getting.
I am using MS SQL 2005 and VB in my code behind.
how to send email with database contents?
View 1 RepliesI have above 50 user email id stored in my database i want to send email, As a admin, I typed some message, when i press send button. It will send to to all user email Id which is stored in My Database. I am using asp.net and c#.
View 6 Replieshow to send email when you submit a new request into the database.
View 6 RepliesI'm doing a project where I need to send email.
But i need to grab the name and email address from the database to send email.
How do I grab the particulars from the database?
I have a .net 3.5 application in c# with sql server 2008 at back end. The application is about assigning jobs to supervisors and then these supervisors have to write remarks about the job progress from time to time.
There are two tables ; a JobAssign table with JobOrderNo and Supervisor columns, and a JobUpdate table with jobOrderNo,Date And Remarks(nvarchar) column.
When a supervisor is assinged a job he is sent an email but sometimes the supervisors do not write remarks about a job for some time. Is there some way in which if the remarks of a job are not written for say 5 days an email is sent to the supervisor to do so?
All the front end backend communication is through parametrized queries and the email sending is through System.net.mail.