By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,740 Members | 844 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,740 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
a@a.com;b@b.com;;

But i want a@a.com;b@b.com;

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);

}
Jun 27 '08 #1
Share this Question
Share on Google+
11 Replies


P: n/a
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
a@a.com;b@b.com;;

But i want a@a.com;b@b.com;

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);

}
Jun 27 '08 #2

P: n/a
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
a@a.com;b@b.com;;

But i want a@a.com;b@b.com;

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);

}

Jun 27 '08 #3

P: n/a
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
a@a.com;b@b.com;;

But i want a@a.com;b@b.com;

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);

}

Jun 27 '08 #4

P: n/a
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
a@a.com;b@b.com;;

But i want a@a.com;b@b.com;

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);

}


Jun 27 '08 #5

P: n/a
"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

Jun 27 '08 #6

P: n/a
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

Jun 27 '08 #7

P: n/a
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

Jun 27 '08 #8

P: n/a
"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

Jun 27 '08 #9

P: n/a
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

Jun 27 '08 #10

P: n/a
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


Jun 27 '08 #11

P: n/a
"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

Jun 27 '08 #12

This discussion thread is closed

Replies have been disabled for this discussion.