Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

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

1 view
Skip to first unread message

rote

unread,
Apr 16, 2008, 12:41:37 AM4/16/08
to
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);

}


Braulio Diez

unread,
Apr 16, 2008, 2:53:00 AM4/16/08
to
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
/// ------------------------------

Eliyahu Goldin

unread,
Apr 16, 2008, 4:40:15 AM4/16/08
to
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" <braulio1...@yahoo.es> wrote in message
news:23ABCE93-79BB-4B4B...@microsoft.com...

rote

unread,
Apr 16, 2008, 4:56:50 AM4/16/08
to
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" <braulio1...@yahoo.es> wrote in message
news:23ABCE93-79BB-4B4B...@microsoft.com...

rote

unread,
Apr 16, 2008, 5:34:37 AM4/16/08
to
I'm getting multiple duplicate records using ur code?
any ideas

"Eliyahu Goldin" <REMOVEALLCAPIT...@mMvVpPsS.org> wrote in
message news:efC6z25n...@TK2MSFTNGP02.phx.gbl...

Mark Rae [MVP]

unread,
Apr 16, 2008, 5:47:31 AM4/16/08
to
"rote" <naija...@hotmail.com> wrote in message
news:uBr0dw3n...@TK2MSFTNGP03.phx.gbl...

> Response.Write(smail);

Response.Write(smail.TrimEnd(';'));


--
Mark Rae
ASP.NET MVP
http://www.markrae.net

rote

unread,
Apr 16, 2008, 5:58:22 AM4/16/08
to
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.net> wrote in message
news:eusljb6n...@TK2MSFTNGP04.phx.gbl...

Eliyahu Goldin

unread,
Apr 16, 2008, 6:02:39 AM4/16/08
to
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.net> wrote in message
news:eusljb6n...@TK2MSFTNGP04.phx.gbl...

Mark Rae [MVP]

unread,
Apr 16, 2008, 6:12:49 AM4/16/08
to
"rote" <naija...@hotmail.com> wrote in message
news:%237sZeh6...@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

rote

unread,
Apr 16, 2008, 7:45:42 PM4/16/08
to
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.net> wrote in message
news:%23unJsp6...@TK2MSFTNGP05.phx.gbl...

rote

unread,
Apr 16, 2008, 10:14:48 PM4/16/08
to
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" <naija...@hotmail.com> wrote in message

news:uavDyvBo...@TK2MSFTNGP06.phx.gbl...

Mark Rae [MVP]

unread,
Apr 17, 2008, 5:00:40 AM4/17/08
to
"rote" <naija...@hotmail.com> wrote in message
news:u1aHGDDo...@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...

0 new messages