guedestorm
Member
- Joined
- Apr 26, 2011
- Messages
- 6
- Programming Experience
- Beginner
I need to get the difference between two tables
First I tried this
Dim DBinserir
'.AsEnumerable()
DBinserir = From e In dbExcel, m In DbMTR Where e.Field(Of String)("Ticket") <> m.Field(Of String)("Ticket") Select e
Dim coisas As List(Of String)
For Each coisa In DBinserir
coisas.Add(coisa)
Next
And throws a InvalidCastException
Saying it is not possible to convert double to String
So I tried this
Dim DBinserir
'.AsEnumerable()
DBinserir = From e In dbExcel, m In DbMTR Where e.Field(Of Double)("Ticket") <> m.Field(Of Double)("Ticket") Select e
Dim coisas As List(Of String)
For Each coisa In DBinserir
coisas.Add(coisa)
Next
Again throws a InvalidCastException
Any idea?
First I tried this
Dim DBinserir
'.AsEnumerable()
DBinserir = From e In dbExcel, m In DbMTR Where e.Field(Of String)("Ticket") <> m.Field(Of String)("Ticket") Select e
Dim coisas As List(Of String)
For Each coisa In DBinserir
coisas.Add(coisa)
Next
And throws a InvalidCastException
Saying it is not possible to convert double to String
So I tried this
Dim DBinserir
'.AsEnumerable()
DBinserir = From e In dbExcel, m In DbMTR Where e.Field(Of Double)("Ticket") <> m.Field(Of Double)("Ticket") Select e
Dim coisas As List(Of String)
For Each coisa In DBinserir
coisas.Add(coisa)
Next
Again throws a InvalidCastException
Any idea?