modify value of index in array on basis of another unique index in C#

Question

I am working with 2 object types array in C#, One of my array is populated from MS Access and other in being filled from MySql.

object[] Product = [{123, "Tea"},{234, "Coffee"},{345, "Drinks"}]; // from MySql

object[] ProductDetails = [{123, "T", 23.00},{234, "C", 25.02},{345, "D", 11.88}]; // from MS Access

I need to loop through its all ProductDetails to match with its ID in Product array , where ID matches it replace the name from product array to productsdetails array,

OR any other approach do it efficiently in c# code. Records may be in thousands.

Provide compiling code and the code where you show what you have tried — Tim Schmelter
– Tim Schmelter, Commented Mar 19, 2018 at 10:11
Enumerate throught Ms Access and find match by ID in SQL. Just ensure you have indexes on ID column in SQL. If you want to work in-memory use Dictionary as said by @mjwills — Evgeny Gorbovoy
– Evgeny Gorbovoy, Commented Mar 19, 2018 at 10:11
you can convert the arrays to your own class or a Dictionary using List<T> , then you can use .Find() to test if your condition is true — styx
– styx, Commented Mar 19, 2018 at 10:13

Tim Schmelter · Accepted Answer · 2018-03-19 10:33:55Z

3

Here you see a good reason why you should not use multi-dimensional object arrays. Instead you should use a Dictionary<TKey, TValue>. I'd suggest to implement a custom class Product. Then the dictionary would be a Dictionary<int, Product>. This would be very efficient and readable.

However, to answer your question and show the mess:

object[,] Product = { { 123, "Tea" }, { 234, "Coffee" }, { 345, "Drinks" } }; // from MySql
object[,] ProductDetails = { { 123, "T", 23.00 }, { 234, "C", 25.02 }, { 345, "D", 11.88 } };

for (int k = 0; k < ProductDetails.GetLength(0); k++)
{
    object id = ProductDetails[k, 0];
    string longName = null;
    bool idFound = false;
    for (int l = 0; l < Product.GetLength(0); l++)
    {
        if (id.Equals(Product[l, 0]))  // Equals necessary because boxing of int to object
        {
            idFound = true;
            longName = Product[l, 1] as string; 
            break;
        }
    }

    if (idFound)
    {
        ProductDetails[k, 1] = longName; 
    }
}

edited Mar 19, 2018 at 10:33

answered Mar 19, 2018 at 10:26

Tim Schmelter

462k79 gold badges719 silver badges980 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Abdul Over a year ago

can you please re-write this in dictionary way

Tim Schmelter Over a year ago

@user6594294: Sorry, no, i would have to show you a new class, the way i initialize the dictionary with sample objects and the code to access each elements. You can easily find tutorials for all of this. If you struggle somewhere you can ask another question

gausselem · Accepted Answer · 2018-03-19 10:15:59Z

0

If you're using linq you could just join the two arrays on the ID (I am unsure if you have to convert them to List() first), and then create a new array where you select want you want from each array.

var result = (from p in Products join pd in ProductDetails where p.Id equals pd.Id select new ...).ToList()

answered Mar 19, 2018 at 10:15

gausselem

136 bronze badges

1 Comment

fubo Over a year ago

@Agent_Orange because?

Collectives™ on Stack Overflow

modify value of index in array on basis of another unique index in C#

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related