Send Email from SQL server

[Pankaj18]

Hi all,

I want to send mail attatchment from SQL server. I have a Image field and i have stored word documemts in it. I am designing a form where an Email has to been sent with(attatchment) the word documents in the image field.

So, i am looking for code or a solution where it should retrieve the word document from SQl server and send it as an attachment with Email.

Thanks !

Pankaj

[sknake]

Look in to xp_sendmail but I would advise using a program for this task.

http://www.google.com/search?hl=en&q=MSSQL+xp_sendmail+attachment&aq=f&oq=&aqi=
http://doc.ddart.net/mssql/sql70/xp_aa-sz_11.htm
http://www.bigresource.com/MS_SQL-Mail-Attachment-using-xp_sendmail-Yo72AFEm.html

[Ramesh S]

Refere these links:
http://articles.techrepublic.com.com/5100-10878_11-6164310.html
http://www.databasejournal.com/features/mssql/article.php/3626056/Database-Mail-in-SQL-Server-2005.htm

[Pankaj18]

hi,

I have fetched my documents in a variable(datatype byte[]). Now when i want to as an attatchment its generate an error.

My Code is(that retrieve documents from SQL server)::

string filename = drd.GetValue(27).ToString();

byte[] imagecontent = (byte[])(drd[28]);

My code for Attachment:: mail.Attachments.Add(new Attachment(imagecontent, filename)); Error::

1. Argument '1': cannot convert from 'byte[]' to 'string'

2. The best overloaded method match for 'System.Net.Mail.Attachment.Attachment(string, string)' has some invalid arguments

Please Help me.

Thanks !

Pankaj

[sknake]

Thats because you need to use a stream.

private void button3_Click(object sender, EventArgs e)
    {
      byte[] buffer = Guid.NewGuid().ToByteArray(); //This simulates your buffer
      using (MemoryStream ms = new MemoryStream(buffer))
      {
        ms.Position = 0;
        ms.Seek(0, SeekOrigin.Begin);
        using (Attachment att = new Attachment(ms, "FileName.txt"))
        {
          //Send your mail message here. You have to send the message before
          //the attachment is disposed. You could also remove the using() block
          //from above and dispose of it later.
        }
      }
    }
  }