how to get the correct email format when sending email using sqldatareader

[rote]

I'm getting the email address from an excel sheet.
But i need to send the email to multiple people
When printing the below i get
[e-mail];[e-mail];;

But i want [e-mail];[e-mail];

i don't need the extra semicolon

Thanks

code below
------

while (oledr.Read())

{

smail = oledr[0].ToString() + ";" + "<br>";

//smail += oledr[0].ToString() & ";";

//mail.To.Add(smail);

//this.Label1.Text = smail;

Response.Write(smail);

}

[=?Utf-8?B?QnJhdWxpbyBEaWV6?=]

Well, here you have a work around (it could be better coded, but this will
work for you), just add the semicolon before and in the first ocurrence don't
do the concat:

bool firstTime = true;

while (oledr.Read())
{
smail ="";
if(!firstTime) smail = ";"
smail += oledr[0].ToString();
}

--
/// ------------------------------
/// Braulio Diez
///
/// http://www.tipsdotnet.com
/// ------------------------------


"rote" wrote:

I'm getting the email address from an excel sheet.
But i need to send the email to multiple people
When printing the below i get
[e-mail];[e-mail];;

But i want [e-mail];[e-mail];

i don't need the extra semicolon

Thanks

code below
------

while (oledr.Read())

{

smail = oledr[0].ToString() + ";" + "<br>";

//smail += oledr[0].ToString() & ";";

//mail.To.Add(smail);

//this.Label1.Text = smail;

Response.Write(smail);

}

[Eliyahu Goldin]

This code will always produce only the last email. It can be a bit corrected
as:

smail ="";
while (oledr.Read())
{
if(smail.Length 0) smail += ";"
smail += oledr[0].ToString();
}

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
"Braulio Diez" <br**************@yahoo.eswrote in message
news:23**********************************@microsof t.com...

Well, here you have a work around (it could be better coded, but this will
work for you), just add the semicolon before and in the first ocurrence
don't
do the concat:

bool firstTime = true;

while (oledr.Read())
{
smail ="";
if(!firstTime) smail = ";"
smail += oledr[0].ToString();
}

--
/// ------------------------------
/// Braulio Diez
///
/// http://www.tipsdotnet.com
/// ------------------------------


"rote" wrote:

>I'm getting the email address from an excel sheet.
But i need to send the email to multiple people
When printing the below i get
[e-mail];[e-mail];;

But i want [e-mail];[e-mail];

i don't need the extra semicolon

Thanks

code below
------

while (oledr.Read())

{

smail = oledr[0].ToString() + ";" + "<br>";

//smail += oledr[0].ToString() & ";";

//mail.To.Add(smail);

//this.Label1.Text = smail;

Response.Write(smail);

}

[rote]

Thanks but
Tried what you suggested like this
bool firstTime = true;

while (oledr.Read())

{

string smail;

smail = "";

if (!firstTime)smail = ";";

//smail = oledr[0].ToString();

smail += oledr[0].ToString();
//mail.To.Add(smail);

Response.Write(smail);

}

But didn't solve the problem

"Braulio Diez" <br**************@yahoo.eswrote in message
news:23**********************************@microsof t.com...

Well, here you have a work around (it could be better coded, but this will
work for you), just add the semicolon before and in the first ocurrence
don't
do the concat:

bool firstTime = true;

while (oledr.Read())
{
smail ="";
if(!firstTime) smail = ";"
smail += oledr[0].ToString();
}

--
/// ------------------------------
/// Braulio Diez
///
/// http://www.tipsdotnet.com
/// ------------------------------


"rote" wrote:

>I'm getting the email address from an excel sheet.
But i need to send the email to multiple people
When printing the below i get
[e-mail];[e-mail];;

But i want [e-mail];[e-mail];

i don't need the extra semicolon

Thanks

code below
------

while (oledr.Read())

{

smail = oledr[0].ToString() + ";" + "<br>";

//smail += oledr[0].ToString() & ";";

//mail.To.Add(smail);

//this.Label1.Text = smail;

Response.Write(smail);

}

[rote]

I'm getting multiple duplicate records using ur code?
any ideas

"Eliyahu Goldin" <RE**************************@mMvVpPsS.orgwrote in
message news:ef**************@TK2MSFTNGP02.phx.gbl...

This code will always produce only the last email. It can be a bit
corrected as:

smail ="";
while (oledr.Read())
{
if(smail.Length 0) smail += ";"
smail += oledr[0].ToString();
}

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
"Braulio Diez" <br**************@yahoo.eswrote in message
news:23**********************************@microsof t.com...

>Well, here you have a work around (it could be better coded, but this
will
work for you), just add the semicolon before and in the first ocurrence
don't
do the concat:

bool firstTime = true;

while (oledr.Read())
{
smail ="";
if(!firstTime) smail = ";"
smail += oledr[0].ToString();
}

--
/// ------------------------------
/// Braulio Diez
///
/// http://www.tipsdotnet.com
/// ------------------------------


"rote" wrote:

>>I'm getting the email address from an excel sheet.
But i need to send the email to multiple people
When printing the below i get
[e-mail];[e-mail];;

But i want [e-mail];[e-mail];

i don't need the extra semicolon

Thanks

code below
------

while (oledr.Read())

{

smail = oledr[0].ToString() + ";" + "<br>";

//smail += oledr[0].ToString() & ";";

//mail.To.Add(smail);

//this.Label1.Text = smail;

Response.Write(smail);

}

[Mark Rae [MVP]]

"rote" <na********@hotmail.comwrote in message
news:uB**************@TK2MSFTNGP03.phx.gbl...

Response.Write(smail);

Response.Write(smail.TrimEnd(';'));
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[rote]

Error
The specified string is not in the form required for an e-mail address.
is it "; "or ", "
tried all with no success
Using
using System.Net.Mail;

Anu ideas this is driving me nuts

Thanks Mark

[MVP]" <ma**@markNOSPAMrae.netwrote in message
news:eu**************@TK2MSFTNGP04.phx.gbl...

"rote" <na********@hotmail.comwrote in message
news:uB**************@TK2MSFTNGP03.phx.gbl...

>Response.Write(smail);

Response.Write(smail.TrimEnd(';'));
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Eliyahu Goldin]

Fantastic.Never paid attention to this method.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
"Mark Rae [MVP]" <ma**@markNOSPAMrae.netwrote in message
news:eu**************@TK2MSFTNGP04.phx.gbl...

"rote" <na********@hotmail.comwrote in message
news:uB**************@TK2MSFTNGP03.phx.gbl...

>Response.Write(smail);

Response.Write(smail.TrimEnd(';'));
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Mark Rae [MVP]]

"rote" <na********@hotmail.comwrote in message
news:%2****************@TK2MSFTNGP04.phx.gbl...

Error
The specified string is not in the form required for an e-mail address.
is it "; "or ", "
tried all with no success
Using
using System.Net.Mail;

Any ideas this is driving me nuts

Oh right - now I see what you're trying to do...

while (oledr.Read())
{
mail.To.Add(oledr[0].ToString());
}

http://www.systemnetmail.com/faq/3.2.3.aspx
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[rote]

Thanks but when i do that i get error:
The parameter 'addresses' cannot be an empty string.
Parameter name: addresses

"Mark Rae [MVP]" <ma**@markNOSPAMrae.netwrote in message
news:%2****************@TK2MSFTNGP05.phx.gbl...

"rote" <na********@hotmail.comwrote in message
news:%2****************@TK2MSFTNGP04.phx.gbl...

>Error
The specified string is not in the form required for an e-mail address.
is it "; "or ", "
tried all with no success
Using
using System.Net.Mail;

Any ideas this is driving me nuts

Oh right - now I see what you're trying to do...

while (oledr.Read())
{
mail.To.Add(oledr[0].ToString());
}

http://www.systemnetmail.com/faq/3.2.3.aspx
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[rote]

Actually got it to work.
This is very confusing between System.Web.Mail and System.Net.
I remembered when using System.Web.Mail i had to include a semi colon or
comma
But it seems System.Net. doesn't need it .
Does it add it automatically i need to get thhis right.
Thanks
"rote" <na********@hotmail.comwrote in message
news:ua**************@TK2MSFTNGP06.phx.gbl...

Thanks but when i do that i get error:
The parameter 'addresses' cannot be an empty string.
Parameter name: addresses

"Mark Rae [MVP]" <ma**@markNOSPAMrae.netwrote in message
news:%2****************@TK2MSFTNGP05.phx.gbl...

>"rote" <na********@hotmail.comwrote in message
news:%2****************@TK2MSFTNGP04.phx.gbl...

>>Error
The specified string is not in the form required for an e-mail address.
is it "; "or ", "
tried all with no success
Using
using System.Net.Mail;

Any ideas this is driving me nuts

Oh right - now I see what you're trying to do...

while (oledr.Read())
{
mail.To.Add(oledr[0].ToString());
}

http://www.systemnetmail.com/faq/3.2.3.aspx
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Mark Rae [MVP]]

"rote" <na********@hotmail.comwrote in message
news:u1**************@TK2MSFTNGP05.phx.gbl...

>>>Any ideas this is driving me nuts

Oh right - now I see what you're trying to do...

while (oledr.Read())
{
mail.To.Add(oledr[0].ToString());
}

http://www.systemnetmail.com/faq/3.2.3.aspx

Thanks but when i do that i get error:
The parameter 'addresses' cannot be an empty string.
Parameter name: addresses

Actually got it to work.
This is very confusing between System.Web.Mail and System.Net.Mail
I remembered when using System.Web.Mail i had to include a semi colon or
comma
But it seems System.Net.Mail doesn't need it .

That's right. In System.Net.Mail, the .To, .Cc and .Bcc properties are
collections, not strings, so they don't require anything to "separate" the
individual addresses... That's why the code I gave you above doesn't include
a semi-colon at the end of the addresses...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net