Hi,
Let's say i've follow table,
tblData
UsrMail | ItemCd | EndDte
---------------------------------------
[email protected] | 0023 | 4/13/2009
[email protected] | 0021 | 4/11/2009
[email protected] | 0029 | 4/17/2009
[email protected] | 0114 | 4/16/2009
[email protected] | 0189 | 4/12/2009
[email protected] | 0099 | 4/16/2009
[email protected] | 0067 | 4/18/2009
[email protected] | 0077 | 4/11/2009
[email protected] | 0027 | 4/14/2009
[email protected] | 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 [email protected] mailbox, it will get
ItemCd | EndDte
---------------------
0023 | 4/13/2009
0067 | 4/18/2009
In [email protected] mailbox, it will get
ItemCd | EndDte
---------------------
0021 | 4/11/2009
0114 | 4/16/2009
0099 | 4/16/2009
0077 | 4/11/2009
In [email protected] 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 SNPosted Apr 7, 2009, 10:55 AM
Nipun TomarPosted Apr 7, 2009, 7:31 AM
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.