Solved

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

Posted on 2013-11-15
5
369 Views
Last Modified: 2013-11-29
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
Comment
Question by:countrymeister
  • 3
  • 2
5 Comments
 
LVL 15

Expert Comment

by:unknown_routine
ID: 39652159
How did you define these lists? are these both list of Strings?
0
 
LVL 1

Author Comment

by:countrymeister
ID: 39652215
ID int
Date datetime
Value decimal


ID int
Date DateTime
Return decimal
0
 
LVL 15

Accepted Solution

by:
unknown_routine earned 500 total points
ID: 39659681
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
 
LVL 1

Author Comment

by:countrymeister
ID: 39660489
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
 
LVL 1

Author Closing Comment

by:countrymeister
ID: 39686089
Could not understand my question and did not povide a good solution
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now