Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 391
  • Last Modified:

update generic list with values from another generic list using multiple column join

I have two genric lists, I need to update the vlaues in one generic list with values fom another

List1
ID
DATE
Return


List2
ID
DATE
Value

There could be no values for List1 in list2 but I need to get default or empty values
0
countrymeister
Asked:
countrymeister
  • 3
  • 2
1 Solution
 
unknown_routineCommented:
How did you define these lists? are these both list of Strings?
0
 
countrymeisterAuthor Commented:
ID int
Date datetime
Value decimal


ID int
Date DateTime
Return decimal
0
 
unknown_routineCommented:
You can not put different types inside a "generic list".

By Generic, do you refer to a Generic list? For example:


 Dim lstItems As List(Of String) = New List(Of String)


You can however create a class with ID, Date, Value as its properties and add it to a generic list.

Please clarify your question.
0
 
countrymeisterAuthor Commented:
Maybe I did not put my question more clearly.
I need to update values in one list based on the values in the other

The ID is the join field and so is the Date, I want to update the Value field with that of the return
0
 
countrymeisterAuthor Commented:
Could not understand my question and did not povide a good solution
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now