|
Hello all,
I have 2 Datasets. I've already asked how to join 2 DataSets and didn't get any answers that helped me. So I feel the easiest way to associate them now is to create a dictionary(s) for DataSet2.
The 2 different DataSets have only 1 field in common, CompanyName. So enter dicitonary.
DataSet 2 contains only 16 total records (Company). Each record (Company) has 7 rows:
<company>
<companyname>Company1
<name>Carrington Mortgage Services, LLC
<maddress1>1610 E. Saint Andrew Place
<maddress2>B150
<mcity>Santa Ana
<mstate>CA
<mzip>92705
So when CompanyName matches, return value from Dictionary.
Do i need to create 16 Dicitonary entires with Key and Value? Do i create 1 Dictionary with variables populating on some kind of for loop? I was told that i could create my own class to store the information I need or simply set the dataset record as the value. No idea what any of those things mean.
|
|
|
|
|
If you do that (and I'm not saying you should or shouldn't) you probably ought to at least define a class to hold each entry and then have Dictionary<string,MyClass>
|
|
|
|
|
Do you mean like this?
public class Companies
{
public static String Company1 { get { return "Company1";}}
public static String Company1City { get { return "Company1City";}}
public static String Company1State { get { return "Company1State";}}
public static String Company2 { get { return "Company2";}}
public static String Company2City { get { return "Company2City";}}
public static String Company2State { get { return "Company2State";}}
}
or like this?
Public Class Company1
{
}
Public Class Company2
{
}
|
|
|
|
|
Maybe more like the latter, but do you really need two classes? If so, possibly add a third (abstract) one, and an Interface! Oooh! And an equality operator! And and and...
|
|
|
|
|
No idea how to achieve all of that. Sorry. Beginner here.
But your enthusiasm is, nice.
|
|
|
|
|
class Company
{
public string Name { get; set; }
public List<Loan> Loans { get; }
public Company()
{
this.Loans = new List<Loan>();
}
}
class Loan
{
public string CompanyName { get; set; }
}
static class Main()
{
Dictionary<string, Company> companies = new Dictionary<string, Company>();
foreach (DataRow row in companyDataSet.Tables["Company"].Rows)
{
Company current = new Company();
current.Name = row.CompanyName;
}
foreach (DataRow row in loanDataSet.Tables["Loan"].Rows)
{
Loan currentLoan = new Loan();
currentLoan.CompanyName = row.CompanyName;
companies[currentLoan.CompanyName].Loans.Add(currentLoan);
}
}
|
|
|
|
|
Huor,
Thank so much for your time. This is very helpful and at least sends me in the right direction!
It seems like most experienced programmers are too jaded to offer help here. Like giving a handout to a poor person that hasn't helped themselves.
Like I'm just looking for a handout because I'm too stupid to google or use the "search" features. "Oh please Mr programming constultant, help me for free, please, my family is dying from starvation and and...my dog has fleas...I need more code"
"Begone peasant!! I have no time for new coders! I'm solving much higher and more important recursion problems and pointer issues! Why don't you use the search feature."
Bah!
|
|
|
|