471,319 Members | 1,632 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,319 software developers and data experts.

sending email in .Net

Somebody knows how I queue email using .Net?

thanks a lot
Nov 19 '05 #1
6 2160
Somebody doesn't know how to Google.
That has got to be the most-often-answered question here.

http://www.google.com/search?as_q=as...h=&safe=images


Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

"Eduardo Rosa" <ed*****@clas.com.br> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
Somebody knows how I queue email using .Net?

thanks a lot

Nov 19 '05 #2
ok then...
I wrote queue not for ornament, because I've work a lot with ASP and it need
third-party component to do that.
I was hurry and maybe should wrote the word in uppercase because what I
found in google it most 3rd-party too. So I'll ask again, most precise ok
Juan?

A loop with a many e-mail list works in ASP.Net, unlike classic ASP?
Somebody know how I queue e-mail in ASP.Net without 3rd-party component?
"Juan T. Llibre" <no***********@nowhere.com> escreveu na mensagem
news:eV**************@TK2MSFTNGP14.phx.gbl...
Somebody doesn't know how to Google.
That has got to be the most-often-answered question here.

http://www.google.com/search?as_q=as...h=&safe=images


Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

"Eduardo Rosa" <ed*****@clas.com.br> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
Somebody knows how I queue email using .Net?

thanks a lot


Nov 19 '05 #3
Eduardo,

when you say "queue", do you mean getting a list of email
addresses from a database and sending emails to all of them ?

If so, here's a sample :

<%@ Page Language="VB" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Web.Mail" %>
<script runat="server">

Sub Page_Load(Src as object, E as EventArgs)

Dim P, U, Em As String
Dim connectionString As String = "server='YourSQLServerName'; trusted_connection=true; database='YourSQLServerDatabase"
Dim dbConnection As IDbConnection = New SqlClient.SqlConnection(connectionString)

Dim queryString As String = "SELECT UserName, Password, Email FROM Users"
Dim dbCommand As IDbCommand = New SqlClient.SqlCommand
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection

dbConnection.Open
Dim dataReader As IDataReader = dbCommand.ExecuteReader(CommandBehavior.CloseConne ction)

While dataReader.Read()
U = dataReader("Username").ToString()
P = dataReader("Password").ToString()
Em = dataReader("Email").ToString()

' Build a MailMessage
Dim mail As System.Web.Mail.MailMessage = New System.Web.Mail.MailMessage
mail.From = "yo******@yourmailserver.com"
mail.To = Em
mail.Subject = "Your Email's subject."
mail.BodyFormat = System.Web.Mail.MailFormat.Html

mail.Body="Hello, " & U & ".<p>Your Username is " & U & " and your password is " & P & ".<p>
And the rest of your HMTL message goes here..."

System.Web.Mail.SmtpMail.SmtpServer = "your.smtp.server"
System.Web.Mail.SmtpMail.Send(mail)
End While

End Sub
</script>
<html>
<head>
</head>
<body>
</body>
</html>

When you open that page, an email with the contents you specify
will be sent to every email address in the Email column in the Users
table in your SQL Server Database.


Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

"Eduardo Rosa" <ed*****@clas.com.br> wrote in message news:ub**************@TK2MSFTNGP12.phx.gbl...
ok then...
I wrote queue not for ornament, because I've work a lot with ASP and it need
third-party component to do that.
I was hurry and maybe should wrote the word in uppercase because what I
found in google it most 3rd-party too. So I'll ask again, most precise ok
Juan?

A loop with a many e-mail list works in ASP.Net, unlike classic ASP?
Somebody know how I queue e-mail in ASP.Net without 3rd-party component?


"Juan T. Llibre" <no***********@nowhere.com> escreveu na mensagem
news:eV**************@TK2MSFTNGP14.phx.gbl...
Somebody doesn't know how to Google.
That has got to be the most-often-answered question here.

http://www.google.com/search?as_q=as...h=&safe=images


Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

"Eduardo Rosa" <ed*****@clas.com.br> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
Somebody knows how I queue email using .Net?

thanks a lot


Nov 19 '05 #4
Using classic ASP that page will execute until all e-mail had be sended, if that number e-mails are big the script can execed the timeout, some components give to server manage the e-mail sendind, so the script runs fast. My doubt is: some class in default .Net library can do that or I need a 3rd party?

exemple of components for classic ASP

AspQMail (http://www.serverobjects.com/comp/AspQMail.htm)

ASPEmail (www.persits.com), por exemplo o o método queue:
Enables message queuing.
False by default. If set to True, specifies that a subsequent call to Send will place the message in a message queue to be processed by EmailAgent.
This is a premium feature.
thanks a lot Juan

"Juan T. Llibre" <no***********@nowhere.com> escreveu na mensagem news:eG**************@tk2msftngp13.phx.gbl...
Eduardo,

when you say "queue", do you mean getting a list of email
addresses from a database and sending emails to all of them ?

If so, here's a sample :

<%@ Page Language="VB" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Web.Mail" %>
<script runat="server">

Sub Page_Load(Src as object, E as EventArgs)

Dim P, U, Em As String
Dim connectionString As String = "server='YourSQLServerName'; trusted_connection=true; database='YourSQLServerDatabase"
Dim dbConnection As IDbConnection = New SqlClient.SqlConnection(connectionString)

Dim queryString As String = "SELECT UserName, Password, Email FROM Users"
Dim dbCommand As IDbCommand = New SqlClient.SqlCommand
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection

dbConnection.Open
Dim dataReader As IDataReader = dbCommand.ExecuteReader(CommandBehavior.CloseConne ction)

While dataReader.Read()
U = dataReader("Username").ToString()
P = dataReader("Password").ToString()
Em = dataReader("Email").ToString()

' Build a MailMessage
Dim mail As System.Web.Mail.MailMessage = New System.Web.Mail.MailMessage
mail.From = "yo******@yourmailserver.com"
mail.To = Em
mail.Subject = "Your Email's subject."
mail.BodyFormat = System.Web.Mail.MailFormat.Html

mail.Body="Hello, " & U & ".<p>Your Username is " & U & " and your password is " & P & ".<p>
And the rest of your HMTL message goes here..."

System.Web.Mail.SmtpMail.SmtpServer = "your.smtp.server"
System.Web.Mail.SmtpMail.Send(mail)
End While

End Sub
</script>
<html>
<head>
</head>
<body>
</body>
</html>

When you open that page, an email with the contents you specify
will be sent to every email address in the Email column in the Users
table in your SQL Server Database.


Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

"Eduardo Rosa" <ed*****@clas.com.br> wrote in message news:ub**************@TK2MSFTNGP12.phx.gbl...
ok then...
I wrote queue not for ornament, because I've work a lot with ASP and it need
third-party component to do that.
I was hurry and maybe should wrote the word in uppercase because what I
found in google it most 3rd-party too. So I'll ask again, most precise ok
Juan?

A loop with a many e-mail list works in ASP.Net, unlike classic ASP?
Somebody know how I queue e-mail in ASP.Net without 3rd-party component?


"Juan T. Llibre" <no***********@nowhere.com> escreveu na mensagem
news:eV**************@TK2MSFTNGP14.phx.gbl...
Somebody doesn't know how to Google.
That has got to be the most-often-answered question here.

http://www.google.com/search?as_q=as...h=&safe=images


Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

"Eduardo Rosa" <ed*****@clas.com.br> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
Somebody knows how I queue email using .Net?

thanks a lot


Nov 19 '05 #5
re:
if that number e-mails are big the script can execed the timeout
You can increase the timeout, so that the page has time to complete.
Check web.config's <httpRuntime executionTimeout="90" ... />

and set it to however long you need.

Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

"Eduardo Rosa" <ed*****@clas.com.br> wrote in message
news:uP**************@TK2MSFTNGP10.phx.gbl...
Using classic ASP that page will execute until all e-mail had be sended, if that number
e-mails are big the script can execed the timeout, some components give to server manage
the e-mail sendind, so the script runs fast. My doubt is: some class in default .Net
library can do that or I need a 3rd party?

exemple of components for classic ASP

AspQMail (http://www.serverobjects.com/comp/AspQMail.htm)

ASPEmail (www.persits.com), por exemplo o o método queue:
Enables message queuing.
False by default. If set to True, specifies that a subsequent call to Send will place
the message in a message queue to be processed by EmailAgent.
This is a premium feature.
thanks a lot Juan

"Juan T. Llibre" <no***********@nowhere.com> escreveu na mensagem
news:eG**************@tk2msftngp13.phx.gbl...
Eduardo,

when you say "queue", do you mean getting a list of email
addresses from a database and sending emails to all of them ?

If so, here's a sample :

<%@ Page Language="VB" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Web.Mail" %>
<script runat="server">

Sub Page_Load(Src as object, E as EventArgs)

Dim P, U, Em As String
Dim connectionString As String = "server='YourSQLServerName'; trusted_connection=true;
database='YourSQLServerDatabase"
Dim dbConnection As IDbConnection = New SqlClient.SqlConnection(connectionString)

Dim queryString As String = "SELECT UserName, Password, Email FROM Users"
Dim dbCommand As IDbCommand = New SqlClient.SqlCommand
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection

dbConnection.Open
Dim dataReader As IDataReader = dbCommand.ExecuteReader(CommandBehavior.CloseConne ction)

While dataReader.Read()
U = dataReader("Username").ToString()
P = dataReader("Password").ToString()
Em = dataReader("Email").ToString()

' Build a MailMessage
Dim mail As System.Web.Mail.MailMessage = New System.Web.Mail.MailMessage
mail.From = "yo******@yourmailserver.com"
mail.To = Em
mail.Subject = "Your Email's subject."
mail.BodyFormat = System.Web.Mail.MailFormat.Html

mail.Body="Hello, " & U & ".<p>Your Username is " & U & " and your password is " & P &
".<p>
And the rest of your HMTL message goes here..."

System.Web.Mail.SmtpMail.SmtpServer = "your.smtp.server"
System.Web.Mail.SmtpMail.Send(mail)
End While

End Sub
</script>
<html>
<head>
</head>
<body>
</body>
</html>

When you open that page, an email with the contents you specify
will be sent to every email address in the Email column in the Users
table in your SQL Server Database.


Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

"Eduardo Rosa" <ed*****@clas.com.br> wrote in message
news:ub**************@TK2MSFTNGP12.phx.gbl... ok then...
I wrote queue not for ornament, because I've work a lot with ASP and it need
third-party component to do that.
I was hurry and maybe should wrote the word in uppercase because what I
found in google it most 3rd-party too. So I'll ask again, most precise ok
Juan?

A loop with a many e-mail list works in ASP.Net, unlike classic ASP?
Somebody know how I queue e-mail in ASP.Net without 3rd-party component?
"Juan T. Llibre" <no***********@nowhere.com> escreveu na mensagem
news:eV**************@TK2MSFTNGP14.phx.gbl...
Somebody doesn't know how to Google.
That has got to be the most-often-answered question here.

http://www.google.com/search?as_q=as...h=&safe=images

Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

"Eduardo Rosa" <ed*****@clas.com.br> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
Somebody knows how I queue email using .Net?

thanks a lot

Nov 19 '05 #6
I don't think like that: if I can make that runs faster why let the user sit
front the machine waiting... With a bad server it could take more then 10
min.
That alread happened to me, the server was bad and the list was big
(newsletter for a portal), I don't know how much sending email was improved
in ASP.Net, maybe that works (I'll try) but I doubt...

thanks a lot


"Juan T. Llibre" <no***********@nowhere.com> escreveu na mensagem
news:eY*************@TK2MSFTNGP15.phx.gbl...
re:
if that number e-mails are big the script can execed the timeout


You can increase the timeout, so that the page has time to complete.
Check web.config's <httpRuntime executionTimeout="90" ... />

and set it to however long you need.

Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

"Eduardo Rosa" <ed*****@clas.com.br> wrote in message
news:uP**************@TK2MSFTNGP10.phx.gbl...
Using classic ASP that page will execute until all e-mail had be sended,
if that number e-mails are big the script can execed the timeout, some
components give to server manage the e-mail sendind, so the script runs
fast. My doubt is: some class in default .Net library can do that or I
need a 3rd party?

exemple of components for classic ASP

AspQMail (http://www.serverobjects.com/comp/AspQMail.htm)

ASPEmail (www.persits.com), por exemplo o o método queue:
Enables message queuing.
False by default. If set to True, specifies that a subsequent call to
Send will place the message in a message queue to be processed by
EmailAgent.
This is a premium feature.
thanks a lot Juan

"Juan T. Llibre" <no***********@nowhere.com> escreveu na mensagem
news:eG**************@tk2msftngp13.phx.gbl...
Eduardo,

when you say "queue", do you mean getting a list of email
addresses from a database and sending emails to all of them ?

If so, here's a sample :

<%@ Page Language="VB" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Web.Mail" %>
<script runat="server">

Sub Page_Load(Src as object, E as EventArgs)

Dim P, U, Em As String
Dim connectionString As String = "server='YourSQLServerName';
trusted_connection=true; database='YourSQLServerDatabase"
Dim dbConnection As IDbConnection = New
SqlClient.SqlConnection(connectionString)

Dim queryString As String = "SELECT UserName, Password, Email FROM Users"
Dim dbCommand As IDbCommand = New SqlClient.SqlCommand
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection

dbConnection.Open
Dim dataReader As IDataReader =
dbCommand.ExecuteReader(CommandBehavior.CloseConne ction)

While dataReader.Read()
U = dataReader("Username").ToString()
P = dataReader("Password").ToString()
Em = dataReader("Email").ToString()

' Build a MailMessage
Dim mail As System.Web.Mail.MailMessage = New System.Web.Mail.MailMessage
mail.From = "yo******@yourmailserver.com"
mail.To = Em
mail.Subject = "Your Email's subject."
mail.BodyFormat = System.Web.Mail.MailFormat.Html

mail.Body="Hello, " & U & ".<p>Your Username is " & U & " and your
password is " & P & ".<p>
And the rest of your HMTL message goes here..."

System.Web.Mail.SmtpMail.SmtpServer = "your.smtp.server"
System.Web.Mail.SmtpMail.Send(mail)
End While

End Sub
</script>
<html>
<head>
</head>
<body>
</body>
</html>

When you open that page, an email with the contents you specify
will be sent to every email address in the Email column in the Users
table in your SQL Server Database.


Juan T. Llibre
ASP.NET MVP
http://asp.net.do/foros/
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...
======================

"Eduardo Rosa" <ed*****@clas.com.br> wrote in message
news:ub**************@TK2MSFTNGP12.phx.gbl...
> ok then...
> I wrote queue not for ornament, because I've work a lot with ASP and it

need
> third-party component to do that.
> I was hurry and maybe should wrote the word in uppercase because what I
> found in google it most 3rd-party too. So I'll ask again, most precise

ok
> Juan?
>
> A loop with a many e-mail list works in ASP.Net, unlike classic ASP?
> Somebody know how I queue e-mail in ASP.Net without 3rd-party

component?
>
>
> "Juan T. Llibre" <no***********@nowhere.com> escreveu na mensagem
> news:eV**************@TK2MSFTNGP14.phx.gbl...
>> Somebody doesn't know how to Google.
>> That has got to be the most-often-answered question here.
>>
>> http://www.google.com/search?as_q=as...h=&safe=images >>
>>
>>
>>
>> Juan T. Llibre
>> ASP.NET MVP
>> http://asp.net.do/foros/
>> Foros de ASP.NET en Español
>> Ven, y hablemos de ASP.NET...
>> ======================
>>
>> "Eduardo Rosa" <ed*****@clas.com.br> wrote in message
>> news:%2****************@tk2msftngp13.phx.gbl...
>>> Somebody knows how I queue email using .Net?
>>>
>>> thanks a lot


Nov 19 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Paul Lamonby | last post: by
reply views Thread by praba kar | last post: by
3 posts views Thread by Ant | last post: by
2 posts views Thread by =?Utf-8?B?QWRl?= | last post: by
7 posts views Thread by bleachie | last post: by
10 posts views Thread by Markgoldin | last post: by
31 posts views Thread by happyse27 | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.