Help with Linq to Dataset

  • Thread starter Thread starter BlackSun
  • Start date Start date
B

BlackSun

Hi,
I have a problem with Linq to Dataset that have N rows and 13 columns,
the first colums represents a bank and the other 12 are the months.
What I need is to get rows that have the same bank and one chosen
month.

Dim months() As String() ={"Jan","Feb".......}
Dim banks= From q In dtTempDataTable _
Where q.Field(Of String)(0) = bank_
Group By CC = q.Field(Of String)(0), DD =
q.Field(Of Double)((Array.IndexOf(months, singleMonth) + 1)) _
Into Group _
Select New With {.BanckName = CC, _
.Dollar = DD _
}

I can't get all the duplicates but just the first.

Thank you in advance if you would like to help me!

Cheers,
BlackSun
 
BlackSun said:
Hi,
I have a problem with Linq to Dataset that have N rows and 13 columns,
the first colums represents a bank and the other 12 are the months.
What I need is to get rows that have the same bank and one chosen
month.

Dim months() As String() ={"Jan","Feb".......}
Dim banks= From q In dtTempDataTable _
Where q.Field(Of String)(0) = bank_
Group By CC = q.Field(Of String)(0), DD =
q.Field(Of Double)((Array.IndexOf(months, singleMonth) + 1)) _
Into Group _
Select New With {.BanckName = CC, _
.Dollar = DD _
}

I can't get all the duplicates but just the first.

Thank you in advance if you would like to help me!
Click to expand...

You sure you don't have to have a Tolist() at end of that 'From' statement.
 
Back
Top