how to correct this?

[sathyan8294]

i want to send a mail from vb.net windows application.using the following code can't send mail.
cmd = New SqlCommand("select email from tblCompany", con)
dr = cmd.ExecuteReader
While dr.Read
sb.Append(dr.GetString(0) + ";")
End While
Response.Redirect("mailto:[e-mail]?Bcc=" + sb.ToString)

in this code sb is string builder,dr is sqldatareader.using above code,can't send mail,but didn't show any error.i have dout in response.redirect line.instead of response.write anything will come.plz help me.

[kenobewan]

Mailto is a client side code that won't work server side I believe.

[nateraaaa]

mailto is generally used to open a new email when a user clicks a hyperlink. If you want to create a new email in the code behind you will have to use to System.Web.Mail.MailMessage object.

try something like this.

System.Web.Mail.MailMessage mail = new System.Web.Mail.MailMessage();
mail.To = to;//Email;
mail.From = from;
mail.Subject = subject;
mail.BodyFormat = MailFormat.Html;
mail.Body = msg;
 
if(file != null)
{
mail.Attachments.Add(new MailAttachment(file));
}
 
SmtpMail.Send(mail);

Good luck

Nathan

[Frinavale]

Hi there,

Check out the article on how to send an email using .NET.
This article gives a quick example of how to send an email without depending on the client's email application.

-Frinny

[Frinavale]

i want to send a mail from vb.net windows application.using the following code can't send mail.
cmd = New SqlCommand("select email from tblCompany", con)
dr = cmd.ExecuteReader
While dr.Read
sb.Append(dr.GetString(0) + ";")
End While
Response.Redirect("mailto:[e-mail]?Bcc=" + sb.ToString)

in this code sb is string builder,dr is sqldatareader.using above code,can't send mail,but didn't show any error.i have dout in response.redirect line.instead of response.write anything will come.plz help me.

Just wanted to let you know that Response.Redirect("nameOfUrl") is generally used for redirecting the user to another web page that is located in a different location.

-Frinny