Nested Arrays!!

  • hegdesuchi

    Hall of Fame

    Points: 3047

    Hi All,

    I am new to c# and I am stuck with logic for nested arrays.

    Below is my example and I am not sure how to do it. The value is getting overridden with the last value.

    So my requirement is,

    I have an array which has name, age, kids and kids is again an array.

    Example:

    array=name,age,kids

    array[0]=alex,29,kid[0]=Gerber,kid[1]=Brian

    array[1]=ginger,26,kid[0]=Mike

    how do I write a code to get this result?

    Any help is appreciated!!

  • Jeff Moden

    SSC Guru

    Points: 994289

    You would probably do much better posting your C# question on a C# forum.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems
    Create a Tally Function (fnTally)

  • hegdesuchi

    Hall of Fame

    Points: 3047

    Thank you 🙂

  • Sean Lange

    SSC Guru

    Points: 286411

    hegdesuchi (9/19/2016)


    Hi All,

    I am new to c# and I am stuck with logic for nested arrays.

    Below is my example and I am not sure how to do it. The value is getting overridden with the last value.

    So my requirement is,

    I have an array which has name, age, kids and kids is again an array.

    Example:

    array=name,age,kids

    array[0]=alex,29,kid[0]=Gerber,kid[1]=Brian

    array[1]=ginger,26,kid[0]=Mike

    how do I write a code to get this result?

    Any help is appreciated!!

    Why are you using arrays in the first place. A generic collection would be much better. And your object would have a kids property that is a generic collection. This way you can instantiate each object and not get lost in hell of trying to keep it straight by index number.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • hegdesuchi

    Hall of Fame

    Points: 3047

    Hi,

    Thank you!!

    My reference file also has array format and not generic collection format. I am not sure if I can use list when we have output as an array

  • Sean Lange

    SSC Guru

    Points: 286411

    hegdesuchi (9/21/2016)


    Hi,

    Thank you!!

    My reference file also has array format and not generic collection format. I am not sure if I can use list when we have output as an array

    I have no idea what you mean about your reference file but if you need to output as an array you might want to look a little deeper are the generics in dotnet. Any object which implements the IList interface has the ToArray method. This means you can convert a collection to an array with a single method call and you will be returned an array of objects with the type of your generic collection. So if the type was a Person you would get an array of Person objects.

    To be honest, arrays are rather archaic in their behavior. Once the generic collection came into existence the classic array has been a dying breed.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply