SQL Server :: Send Storedprocedure Results As Email Body

Mar 2, 2011

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?

View 11 Replies


Similar Messages:

SQL Server Email Stored Procedure Need To Send Table Like Output In The Body?

Jan 10, 2011

I am creating a nightly process using a stored procedure to check for expiring records and emailing myself and the folks that need to see the information. The trouble I am having is trying to send the data in table "like" view in the message body.Here is the Proc you can see the point at which i try to use a table vairble then use it as a parameter for calling the email proc but it doesn't seem to work.

View 5 Replies

Web Forms :: Send Email With Arabic (Persian) Text In Email Body

May 7, 2015

I followed this link, it works fine with English Text. [URL] ....

My problem is when I am adding Arabic text to the message body it displays ???? format.

View 1 Replies

Web Forms :: How To Embed Chart In Email Body And Send Email

May 7, 2015

how to display Chart in Email body and excel attachment.

View 1 Replies

Web Forms :: How To Send Chart In Email Body

May 7, 2015

Am using ur code for sending email asp chart ,

but image not showing properly

View 1 Replies

Web Forms :: Send GridView In Email Body

Jun 13, 2012

I am trying to send email using gmail smtp. I used to bind the grid view to mail body using GridViewToHtml(GridView1) this method. I defined the method in same source file as ...

View 1 Replies

Web Forms :: Send HTML Page As Email Body

Sep 30, 2012

protected void send_mail()
{
String genpass;
genpass = GeneratePassword();
lblResult.Text = genpass.ToString();
string mail_id = "xtream.hell97@gmail.com";
string mail_password = "XXXXXXX";

[Code] ....

I want to send this email in formated html with logo. So i want to chane only its body part with html page to send users auto generated password.

View 1 Replies

Web Forms :: Send Email With Image Or Pictures In Body?

Aug 31, 2012

 I have added an image while sending mail but it didn't displayed at all when i have opened the mail...

View 1 Replies

Data Controls :: Send Particular GridView Row As Email Body On Button Click

Feb 19, 2014

I am new to ASP.NET and have made a register page, 'get' which on submitting redirects to another page 'pick1' displaying the data in Gridview. In each row of the Gridview there are 'View' buttons which on clicking opens a pop-up page having 2 buttons 'send mail' and 'cancel'. On clicking 'send Mail' button, i want selected row of data to be sent by email instead of the entire gridview. Right now only the entire gridview data is coming to my mail. Also i want to attach a link to the email so that it redirects to the 'pick1' page again on clicking in email. How can I do it?

Below is my code for 'pick1' page:

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.BindData();

[Code] ....

And the image of my 'pick1' and 'popup' page: 

View 1 Replies

Data Controls :: Send Email With Data From Database In Email Body?

May 7, 2015

how to send email with database contents?

View 1 Replies

Web Forms :: Embed Binary Image From Database In Message Body And Send Email

May 7, 2015

I 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.

View 1 Replies

How To Run JavaScript On Server And Send DOM Results To Client

Nov 10, 2010

I've been stuck on this one for a while, so it's time to consult the pros. I've created a charting application that uses javascript to do heavy DOM manipulation/generation on the client (creating barcharts made of colored divs, etc).

Long story short, I want to avoid sending my js library to the client. Is there any way to create the content on the server, using my existing javascript library, and only send the javascript-generated HTML to the client?

View 2 Replies

Web Forms :: Send Net.mail Body As Web.mail Body?

Mar 30, 2010

In asp i tryed to send mail with images. so i used AlternateViews and LinkedResources from System.net.mail class. before sending the mail i would like to add email.Fields.Add [URL] here System.net.mail class doesn't contain Fields. System.web.mail only have Fields.

View 2 Replies

How To Send Email Without Smtp Server

May 11, 2010

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")....

View 5 Replies

Use SQL SERVER Trigger To Send Email In C#?

Jan 23, 2010

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

Send Email Using Godaddy Server

Oct 28, 2010

I try to use smtp relay-hosting [URL] and [URL] but both are not work fine in my vb.net site..

View 3 Replies

Use A Queue To Send Email To An Smtp Server?

Dec 9, 2010

module 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 Replies

Web Forms :: Email Doesn't Send On New Server

Jul 16, 2010

I 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

View 6 Replies

How To Send Email From Local Host On Server

Jan 13, 2011

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 Replies

Send Email From A Win2008 Dedicated Server?

Oct 24, 2010

I 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 ?

View 2 Replies

Configuration :: Way To Configure The Server To Send An Email

Mar 28, 2011

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 Replies

SQL Server :: Send Automatic Email To Customers?

Sep 7, 2010

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.

View 8 Replies

Web Forms :: Send Email Using SMTP Server?

Nov 21, 2011

I want to send emails using SMTP server in ASP.Net. I amusing C#

View 1 Replies

IIS Configuration :: How To Send Email From Domain Server

May 11, 2013

I 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] .....

View 1 Replies

Web Forms :: How To Send Email Through SMTP On Server 2008

Sep 1, 2010

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]....

View 9 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved