Sending Email with list of data to each Recepient

Question

Hi Let's say i've follow table tblData UsrMail | ItemCd | EndDte --------------------------------------- wnr@yahoo.com | 0023 | 4/13/2009 krs@yahoo.com | 0021 | 4/11/2009 wkm@yahoo.com | 0029 | 4/17/2009 krs@yahoo.com | 0114 | 4/16/2009 wkm@yahoo.com | 0189 | 4/12/2009 krs@yahoo.com | 0099 | 4/16/2009 wnr@yahoo.com | 0067 | 4/18/2009 krs@yahoo.com | 0077 | 4/11/2009 wkm@yahoo.com | 0027 | 4/14/2009 wkm@yahoo.com | 0649 | 4/13/2009 How my program will group Email content by UsrMail? So my program can mail UsrMail with a list of data. My expected result like In wnr@yahoo.com mailbox it will get ItemCd | EndDte --------------------- 0023 | 4/13/2009 0067 | 4/18/2009 In krs@yahoo.com mailbox it will get ItemCd | EndDte --------------------- 0021 | 4/11/2009 0114 | 4/16/2009 0099 | 4/16/2009 0077 | 4/11/2009 In wkm@yahoo.com mailbox it will get ItemCd | EndDte --------------------- 0029 | 4/17/2009 0189 | 4/12/2009 0027 | 4/14/2009 0649 | 4/13/2009 Really need techincal answer

James SN · Answer

Im using ASP.NET 2.0 with C#. Did u have sampleof code that i can follow?

James Tomar · Answer

Here is an idea: Create an array and fill the distinct UsrMail in it using DataSet SELECT DISTINCT Helper Class or LINQ. Then for each element in the array filter the ItemCd and EndDte to create the email content. hope this will help.