Asp.net Create/send email template

[Sammy145]

I have a email page template and i need to send this via asp.net (vb)
but i need to loop the my query (im using northwind --> orders table i have added a url field) URL, products, price as i can order n amount of items and send this out.

How can this be achieved i know how to send the email but dont know how to loop through and populate the template can someone show me some sample code on how to loop through n amount of times.

any sample code that i can use will help a greate deal

Thank you for any help

S

 

[ca8msm]

You can loop through a datareader and simply call your email function for each record.


____________________________________________________________
Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]

Need help finding an answer? Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[Sammy145]

Hmm ok if you have a look at this example

http://www.microsoft.com/belux/msdn/nl/community/columns/ceulemans/sendhtmlemail.mspx

near the end where it says "Making use of parsing to send e-mail"

HtmlFile.TemplateFileName = HttpContext.Current.Server.MapPath(“Templates/HtmlTemplate.htm”);

Now if i use tokens in my html page so
##URL##
##Product##
##price##

will the method u suggest work?

thank you

S

 

[Sammy145]

Please remember that the html need to know about teh loop so how do i define this
this need to loop depending on the no.of items ordered.
##URL##
##Product##
##price##