I am building service failure notification system which notifies customers and management whenever there is a delay in the service. How can I use SQL SERVER trigger to send an email to a group of people when I add an alert in the alert database table using c#.
View 3 Replies
i have a gprs device that logs data to a webpage.i am using get method for the data transfer from device to web application. This function is working perfectly. what i want to do now is by clicking a button to send a get method from server to device in order to triggger it to do some actions. the device is correctly receiving the get method and sends a responce. The problem is that the http responce the device is sending might be wrong because the browser is waiting until timeout and then it displays the responce. does anyone knows what is the http responce format?
View 1 Replies I want to send email without declare username and password in smtp server. I am using asp.net c#, this is possible in asp below is the code , anybody tell me how can i use this code in asp.net.
<%
Dim ObjSendMail
Dim iConf
Dim Flds
Set ObjSendMail = Server.CreateObject("CDO.Message")
Set iConf = CreateObject("CDO.Configuration")....
I try to use smtp relay-hosting [URL] and [URL] but both are not work fine in my vb.net site..
View 3 Repliesmodule thats available for asp.net that uses a queue to send email to an smtp server? the queue being the operative word here.. we need a proper fallback mechanism for storing any messages that can't be sent so that the send can be re-attempted later
View 1 RepliesI have been using a C# asp.net email form for a while on an old server (administered by a friend who has moved away) and now I have my own server. The problem is the form appears to send but the message never turns up in the mail box. Because the form used to work, I suspect its my server settings. The code behind for the form is:
[Code]....
I have set the web site up as ASP.NET and the pages load ok etc. So I go to the form, fill it out and it is processed and I get the confirm message. What do I need to check at the server end? Sorry if its a dumb question I am quite new to the finer points of server management
I am using gmail smtp server and email account to send email from my asp.net site. It works fine when I use it on some hosing server but it is strange it do not work on local machine. Plz guide me what should I do ? Do I need to install some smtp server (if yes plz mention the name as I am not aware of it) .
View 14 RepliesI know how to send email from asp.net using my pc and my provider smtp server. But doing the same thing from a Win2008 dedicated server is confusing for me. I have installed the smtp server and configure for my virtual web as explained here :
[URL]
But I'm confused by these two lines
serv.DeliveryMethod = SmtpDeliveryMethod.PickupDirectoryFromIis;
serv.Credentials = new NetworkCredential(ConfigurationManager.AppSettings["SmtpServerUserName"], ConfigurationManager.AppSettings["SmtpServerPassword"]);
1°) Why PickupDirectoryFromIis since in configuration localhost smtp server has been chosen and not pickup directory ?
2°) When setting up the smtp server no login / password has been asked so is the same as the computer login / password ?
is there a way to configure the server / something else to send me an email every time asp.net crashes (with the error - just like the "yellow" screen it shows)
View 3 RepliesI 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 want to send emails using SMTP server in ASP.Net. I amusing C#
View 1 RepliesI have read several articles to send emails in Asp.net C# major are by using Gmail, I want to send email from a email id from mydomain name.The code that I am using is:
The code works properly would like to know whether the code is correct as I have have tested it by sending mails to gmail and rediffmail, it works properly, would also like to know the reason for using client.Port = 25;
MailMessage Msg = new MailMessage();
Msg.From = new MailAddress("sales@mydomain.com", "Testing");
Msg.To.Add(TxtEmail.Text);
Msg.Subject = "Send Mail with HTML File";
Msg.Body = "Checking";
[Code] .....
I have the following form and trying to click a button and email through an SMTP server.
[Code]....
Code behind:
[Code]....
Web.config file:
[Code]....
I have configured gmail's free smtp server for my web app and previously I was using smtp server configured at the server.
So I have changed my smtp settings accordingly but my app isn't sending any email and giving me error connection time out, third party tool isn't responding after many retrials.
Here are my settings-
SmtpClient smtpClient = new SmtpClient("mail.MyWebsiteDomainName.com", 25);
smtpClient.Credentials = new System.Net.NetworkCredential("info@MyWebsiteDomainName.com", "myIDPassword");
smtpClient.UseDefaultCredentials = true;....
SMTP is a whole new ballgame for me, but I am reading up on it.
I am attempting to send email from my EC2 instance using GoDaddy's SMTP server. My domain name is registered through GoDaddy and I have 2 email accounts with them.
I can successfully send the email from my dev box no problem.
my web.config
[code]....
I have a feeling I'm just missing something fundamental. I also have a feeling someone is going to recommend I use AuthSmtp or something similar, I'll agree, and have had wasted the past 6 hours
my problem that i have 2 website on godaddy and i need to creat a web form for feedback just fill some fileds and send it by email message.
i tray several ways in code but no one work if there is any one have a website on godaddy and have a web form to send e-mail explain to me or put your code
I am developing an web application using VB.NET in which user have to confirm the email address they provide to activate the account, in short I have to send an email for activating there account. I am all set with the logic and codes, the only trouble is I just realise that i need a mail server and domain to be able to send email.
To be honest with you all i need now is something to try if the application is working and obviously for demo. I havent got any domain yet and no intention of buying one.
I have 3 procedures.
1. SP_General - Gives the output with 3 columns like: ID NAME DOB with multiple rows
2. SP_HTML - Gives the HTML formatted output like: <table><tr><td>ID</td><td>NAME</td><td>DOB</td></tr></table>
3. SP_Email - Sends email (written by using extended stored procedures). Input parameters: Body, etc
When I DO:
1. EXEC SP_Email @Body = 'Hello this is testing'. I recieve the email saying: Hello this is testing
2. EXEC @Results = SP_General
EXEC SP_Email @Body = @Results. I recieve the email saying: 0
3. SELECT @Results = EXEC SP_HTML
EXEC SP_Email @Body = @Results. I recieve the email saying: 0
4. SELECT @Results = '<table><tr><td>ID</td><td>NAME</td><td>DOB</td></tr></table>' (If hardcoded like this)
EXEC SP_Email @Body = @Results. I recieve the email with correct output in a nice formatted table: ID NAME DOB
Its working in 1 and 4 cases but not 2 and 3. As I cannot hardcode like that, can anyone tell me where I'm doing mistake in 2 or 3 cases?
Data from the server subscription cannot trigger table trigger
View 2 Repliesi want to send an email using authenticate smtp server with port number(For Example SMTP Server is :
192.168.0.8 and port : 587).
i got lots of example but failed to find smtp server with port number using authentication.
I'm a newbie in asp.net (and vb.net)..
I have an application which will sent an automatic email from my company mail server to all the client/employee in my company every week. how to make this happen... everytime i applied the codes that i'm searching in google always give me some errors cause it always discuss how to send email to outside the company...
How can i achieve this goal ? what codes should i use ?
Note : i'm using vb.net 2005 and microsoft office outlook
Previously I had thread Send Mail? That helps me to send mail through Gmail credential account. Now I want to send Email through my server (suppose my server name is [URL]) so what should I do?
View 3 RepliesI hava a web form to fill a pdf, add attachments and send it through email. I need to fisically delete the attachments after send the email. I have some problems (exception) that says "the file has been used by another process". This code is in a function that create the message with the attach.
[Code]....
Has anyone ever wroye a script that will execute a stored procedure and a function with the .Net Framework that sends email?
View 6 RepliesI have to create a page in C# where i have to call a column from sql which has email addresses and on button click it should whatever mail account a user wants to use to send a mail to all users.
View 4 Replies
