c# - aggregate through datatable data
i have a datatable:


    +----------+--------+
    | Rep Name | Volume |
    +----------+--------+
    | Alex     |      9 |
    | Alex     |      1 |
    | Alex     |      3 |
    | Liza     |     24 |
    | Liza     |     17 |
    | Pam      |      0 |
    | Pam      |      6 |
    +----------+--------+


i am sending ONE email for every UNIQUE person in `REP NAME`

example:

    Hi Alex, Today your volume was 9, and 1, and 3.

next email:

    Hi Liza, Today your valume was 24, and 17.

i would like to know the easiest way to loop through the datatable on unique values of `REPNAME`

something like:

    foreach (unique value in rep name)
         combine data;


    var query = from e in myDatatable("whatever")
c# - aggregate through datatable data
===

i have a datatable:


    +----------+--------+
    | Rep Name | Volume |
    +----------+--------+
    | Alex     |      9 |
    | Alex     |      1 |
    | Alex     |      3 |
    | Liza     |     24 |
    | Liza     |     17 |
    | Pam      |      0 |
    | Pam      |      6 |
    +----------+--------+


i am sending ONE email for every UNIQUE person in `REP NAME`

example:

    Hi Alex, Today your volume was 9, and 1, and 3.

next email:

    Hi Liza, Today your valume was 24, and 17.

i would like to know the easiest way to loop through the datatable on unique values of `REPNAME`

something like:

    foreach (unique value in rep name)
         combine data;


    var query = from e in myDatatable("whatever")