is it possible to send an automatic email to a certain user through sql express? im using sql express to handle my auction so i need to email the winner when endate =Now.
View 1 Replies
I need to write a stored procedure to schedule a job that will send automatic email to customers based on some condition as follows:
1. I have two tables. One table is table1 like the following:
Name Date1 Date2 Date3 Rahim, Khan 29'10 30'11 25'08 Karim,Abedin 12'10 28'11 26'09 Fahad, Alam 26'10 12'11 25'10 Another Table is table 2 like the following:
Name Email Rahim,Khan rahim@yahoo.com Karim,Abedin karim@yahoo.com Fahad, Alam falam@yahoo.com In table 1 the date format is in format where 30'11 mean work week is 30 and 11 means last two digits of the year.
2. Now , I need to write a stored procedure that will check :
a) What is current work week and current year?
b) It will then determine the difference between the current work week (now 37) and work week mentioned in date (Date1, Date2 and Date3) columns from table1 and if for current year(it's 2010) at least one difference in each row is>=8 then it should send an automatic email to the corresponding email address of Name column using the relation between Table1 and table2. For example: For first record in Table1 the three difference is: 37-29=8, 37-30=7 and 37-25=12. There are two differences >=8, but only first difference is for year 2010 and third one is not for current year. But, since at least one difference in this row satisfies condition (That means >=8 for year 2010)hence email message should be sent to the address rahim@yahoo.com using relation of table1 and table2.
I know how to set a schedule job in SQL mail but I need this stored procedure to run this job on daily basis.
I have a requirement like, I need to send an emails to all clients at 9:00 pm every day. I have the code for email send. I just want to know how do we schedule program to run at certain time in asp.net application. Do we need to open that website all the time ?
View 1 RepliesI have a web site in asp.net(C#). And want to add an automatic email sending functionality in it, i.e. an email will be send daily and weekly(both on a particular time) to all the stock holders about the orders details placed by registered users. How can I do this in asp.net(C#)?
View 21 Replieswhen user click forgot password it asked user name and email and send his password on his email.
How implement this task in asp.net. with datbase sql server.
I'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 have a registration from which have a field email-id , which user select paid or free (for 15 days) registration . when user registration is going to expire then they get a automatic mail regarding registration. and i also want to send some particular msg to all user ., i want to take all email from data base . i am using asp.net c#
View 2 RepliesUsing Create user wizard enter email address send mail to that email address when click submit button and redirect login page
View 1 RepliesHow can I send email with User password(as suppose user forgot password and as a administrator I have to mail his password), or any other data using asp .net with C#????
View 1 RepliesI am developing ecommerce website and i have some page where to send automatic mails , How to assign mail templates with particular module with mail templates , how to use dynamic email templates for sending automatic emails in asp.net ?
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 Repliesto send email to user who is creating new account. i am using following code but it is not working well for me.
[Code]....
I am developing a website where I need to send confirmation link to the user's e-mail account when he/she signs-up.
When user clicks this link then a field userEnable in database changes from "false" to "true".
How do I send a confirmation e-mail to a user when user clicks on the signup button.
When user clicks on this confirmation link then how would the field UserEnable change from "false" to "true"
I am using asp.net 4.0 with VB.NET as the language and SQL Server 2008 for my database.
ser enters email addressafter submit, an email is sent to the user The email will include a link that will take the user to a reset password page.Now, how do I fetch user's ID based on the email address and encrypt it? Then what should link be? Like, what I want is fetch the User ID then encrypt it somehow so that the link doesn't contain the actual ID and that link will take the user to a page that will have textboxes to reset the password. I am just confused how to go about it.Also is this the secure way? To reset a password like this?
View 2 RepliesI 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.
i have very big form in my page (alot text boxes some chkboxes abd more. after the user fill his form he click a submit button. after that i want to get all the form (i mean with all the style and exactly the way it look ) so i have a function that i have build to send mail. i want the msg body will be the form how can i do that? just to get the form and get it as a string (with values )
View 4 Repliesadmin can change values in table which consists of
customer_id and other columns
when changes are made
a mail must be sent to customer,
the mail address is available in customerdetails table
After a user creates their account with the create new user wizard, I would like to have a confirmation email sent that requires them to click on a link in the email to confirm their account and verify their email address before account is activated.
View 4 RepliesThere has to be a simple way to send a confirmation email to new users. Every article that I've read really doesent tell me how to use the sendingmail event. In addition when I had it working, it wouldnt send emails to places like gmail or aol.
asp.net 3.5 - VB language - godaddy hosing, sql server database host membership information
This is the current response I get when is set custom errors mode to Off
A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 131.238.75.25:25
[Code]....
I used this above sample to send Verification link but it didn't work ! it gives the error on this line;
[Code]....
I am creating a "Request for Quote" web form for my company so that when user enters his:
name,address,email,phone etc fields and clicks the submit button,all the data of the webform should be sent to my email address.
I have create user wizard control on my page as below with mail definition setup to send a welcome email to new registerd user.
<asp:CreateUserWizard ID="CreateUserWizard1" runat="server"
requiresQuestionAndAnswer= "false"
oncreateduser="CreateUserWizard1_CreatedUser" LoginCreatedUser="False">
<MailDefinition BodyFileName="~/EmailTemplates/CreateUserWizard.txt"
From="myemailaddress" Subject="New User">
</MailDefinition>
<WizardSteps>
<asp:CreateUserWizardStep ID="CreateUserWizardStep1" runat="server" >
<ContentTemplate>
layout content here
</
ContentTemplate>
</WizardSteps
>
</asp:CreateUserWizard
>
Problem is I am not receiving the welcome email.
To test it, I placed another create user wizard on another page in its default form
as below
<asp:CreateUserWizard ID="CreateUserWizard1" runat="server">
<MailDefinition BodyFileName="~/EmailTemplates/CreateUserWizard.txt"
From="myemailaddress" Subject="New User">
</MailDefinition>
<WizardSteps>
<asp:CreateUserWizardStep runat="server" />
<asp:CompleteWizardStep runat="server" />
</WizardSteps>
</asp:CreateUserWizard>
This one worked and I got welcome email. The setup in Web Config is correct. Is it because I have the oncreateduser="CreateUserWizard1_CreatedUser" or some other conflict issue.
I want to send a confirmation email to the user after they register to my website. I am using CreateUserWizard of .NET and I use C#.
My idea is after users register they get an email with a link. If they click the link, they will come to an activation page. I have done this so far:
Register.aspx:
[Code]....
[Code]....
After Guid userId = (Guid)user.ProviderUserKey;
I am very confused and not sure what to do. I understand that i need to email an url with the userID to user's email upon registration, but how to do this, and when user clicks that url in that email, how that url will automatically come to activation page?
how can i implement new user Email verification in regsitration form. It should be like, when user clicks on Submit button, an email sent to the user email id with an autogenerated code and a redirect link ..
View 1 Repliesiam new to sending automatic email reminders can anyone tell me how to do that, and plus i have never used sms technology , but i want to implement this one in my current project can you give me any idea how to do this together, sending automatic email n sms by checking today's date , you kno the reminder part,
View 3 Replies
