Hi there,
This is my table in MySQL dB where the number of accesses per year and month for each registered user are grouped.
+------------------+------------+-----------------+
| number_of_access | users | Year_Month |
+------------------+------------+-----------------+
| 1 | 1809550 | 2025 - january |
| 2 | 1809550 | 2025 - february |
| 2 | 2809557 | 2025 - april |
| 5 | 2809557 | 2025 - may |
| 1 | 7809559 | 2025 - february |
| 6 | 7809559 | 2025 - march |
| 13 | 7809559 | 2025 - april |
| 5 | 4809556 | 2025 - may |
| 3 | 4809556 | 2025 - january |
| 5 | 4809554 | 2025 - march |
+------------------+------------+-----------------+
Now I need to send an email message for each user using ASP.Net C#
e. g
First message email:
+------------------+------------+-----------------+
| number_of_access | users | Year_Month |
+------------------+------------+-----------------+
| 1 | 1809550 | 2025 - january |
| 2 | 1809550 | 2025 - february |
+------------------+------------+-----------------+
Second message email:
+------------------+------------+-----------------+
| number_of_access | users | Year_Month |
+------------------+------------+-----------------+
| 2 | 2809557 | 2025 - april |
| 5 | 2809557 | 2025 - may |
+------------------+------------+-----------------+
Third message email:
+------------------+------------+-----------------+
| number_of_access | users | Year_Month |
+------------------+------------+-----------------+
| 1 | 7809559 | 2025 - february |
| 6 | 7809559 | 2025 - march |
| 13 | 7809559 | 2025 - april |
+------------------+------------+-----------------+
Fourth email message:
+------------------+------------+-----------------+
| number_of_access | users | Year_Month |
+------------------+------------+-----------------+
| 5 | 4809556 | 2025 - may |
| 3 | 4809556 | 2025 - january |
| 5 | 4809554 | 2025 - march |
+------------------+------------+-----------------+
Can you help me?
Thanks in advance for any suggestion
