sending mail through sql server 2005

Hi,
Write all this under Submit button click event

write a select query and get the required values like this

  string selectquery = "";
  selectquery = "select RID, UserName, Email_Id, CONVERT(varchar, DOB, 103) AS DOB, CONVERT(varchar, DOJ, 103) AS DOJ, State, Pin_Code FROM  Registration where RID=" + hdnvalue;
  SqlConnection sqlcon = new SqlConnection(ConfigurationManager.AppSettings["SqlServer"]);

  SqlCommand sqlcomm = new SqlCommand();
  sqlcomm = sqlcon.CreateCommand();
  sqlcomm.CommandType = CommandType.Text;
  sqlcomm.CommandText = selectquery;
  sqlcon.Open();
  SqlDataReader sqlred = null;
  sqlred = sqlcomm.ExecuteReader();

  if (sqlred.Read())
  {
  if (sqlred["UserName"] != null)
  {
  String strFrom = sqlred["UserName"].ToString();
  }
  if (sqlred["Email_Id"] != null)
  {
  string strTo= sqlred["Email_Id"].ToString();
  }

  if (sqlred["DOJ"] != null)
  {
  string strSubject= sqlred["DOJ"].ToString();
  }

  if (sqlred["Pin_Code"] != null)
  {
  string strbodytext= sqlred["Pin_Code"].ToString();
  }
  }
  sqlcomm.Dispose();
  sqlcon.Close();

  SmtpMail.Send(strFrom, strTo, strSubject, strbodytext);
  Response.Write("Message was sent to" + strTo);


Modify this to your requirement..............

still i am got stuck in to it....can not find the solution

i do not get the proper idea to follow do not mistaken me
 

Hi
refer

http://msdn.microsoft.com/en-us/library/ms378108%28v=sql.90%29.aspx

http://vstoolsforum.com/blogs/sqlserver/archive/2007/04/20/creating-a-stored-procedure-with-output-parameters.aspx

 get the values using output variables in Stored procedure and
write a sendmail method in code-behind...There use these values...

Refer Create SP's and how to send mail articles

thanks for posting.......!

the coding which i created was

use master
go
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE sendemail1 @subjectText varchar(5000), @bodytext varchar(5000), @to varchar(150)
AS
       BEGIN exec master.dbo.sp_sendmail
                        @recipients='[email protected]',
                        @copy_recipients='[email protected]',
                        @subject ='hi',
                        @body = 'sample',
                        @body_format = 'HTML' ;  
     END
GO

 

but i am getting those errors

can u guide me

Hi,
Create Stored procedure and use that code in that SP....

Ya, jagan thanks for posting!!!

i too tried the same code but got error such as

Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'master.dbo.sp_sendmail'. The stored procedure will still be created. 

Hi,

The following script will send an e-mail with an attached file named FileAttachment.txt, which is located on my C: drive. You will need to make sure that this file exists so that the procedure does not error.

EXEC msdb.dbo.sp_send_dbmail
@recipients=N'[email protected]',
@body='Message Body', 
@subject ='Message Subject',
@profile_name ='Database-mailProfile',
@file_attachments ='C:\FileAttachment.txt';