C# Send email, loop through SQL database to get content
Posted on 2009-05-18
I have an issue where I need to loop through SQL to get the following information for an Approve/reject email.
Approval Status, UserTitle, Date Created, and User Notes
The tricky part about this is that this email is generated after a .NET workflow completion and there are several approval stages. the email will need to have all of the above for each stage and at the same time it will have to properly format the notes with the break points
I am not sure where to begin in this. I know how to display it in a ASP.NET page by utilizing a dataview and a repeater inside the dataview, but I do not know how to do it in a string that will be processed as an email
thank you for all of your help in advance