Solved

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

Posted on 2013-11-15
5
368 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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Introduction Hi all and welcome to my first article on Experts Exchange. A while ago, someone asked me if i could do some tutorials on object oriented programming. I decided to do them on C#. Now you may ask me, why's that? Well, one of the re…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

758 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

17 Experts available now in Live!

Get 1:1 Help Now