How to assign multi level property in C# list?

Question

0.00/5 (No votes)

See more:

C#

public class country {
    public int id {get;set;}
    public string name {get;set;}
    public int Lats {get;set;}
    public int Longs {get;set;}
    public List<states> states {get;set;}
}

public class states {
    public int id {get;set;}
    public string name {get;set;}
    public int Lats {get;set;}
    public int Longs {get;set;}
    public id countryid {get;set;}
    public List<citys> citys {get;set;}
}


public class citys {
    public int id {get;set;}
    public string name {get;set;}
    public id countryid {get;set;}
    public id stateid {get;set;}
}


//-------------

//Data Access

public DataTable getCountry(){
    DataTable dt = new DataTable();
    _conn = new Connetion();
    using(_cmd = new SqlCommand()){
        ------param------------
        using(SqlDataAdepter da = new SqlDataAdepter(_cmd)){
            da.Fill(dt)
        }
    }
    return dt;
}


public DataTable getStates(){
    DataTable dt = new DataTable();
    _conn = new Connetion();
    using(_cmd = new SqlCommand()){
        ------param------------
        using(SqlDataAdepter da = new SqlDataAdepter(_cmd)){
            da.Fill(dt)
        }
    }
    return dt;
}


public DataTable getCity(){
    DataTable dt = new DataTable();
    _conn = new Connetion();
    using(_cmd = new SqlCommand()){
        ------param------------
        using(SqlDataAdepter da = new SqlDataAdepter(_cmd)){
            da.Fill(dt)
        }
    }
    return dt;
}

//-------------

//Method

public void AllLists() {
    DataTable dt = new DataTable();
    country c = new country();
    dt = getCountry();
    country = (from DataRow dr in dt.Rows
        select new country(){
            countryid = dr["id"],
            states = ------how to add a states----,
            states.citys = ------------how to add citys-----
        });
}

below is format how i want the Data
in json format

Java

country: {
    id : "",
    name : "",
    Lats : "",
    Longs : "",
    states : {
        id : "",
        name : "",
        Lats : "",
        Longs : "",
        citys : {
            id : "",
            name ; "",
            countryid : "",
            stateid : ""
        }
    },
country: {
    id : "",
    name : "",
    Lats : "",
    Longs : "",
    states : {
        id : "",
        name : "",
        Lats : "",
        Longs : "",
        citys : {
            id : "",
            name ; "",
            countryid : "",
            stateid : ""
        }
    }
}

}

What I have tried:

C#

public class country {
    public int id {get;set;}
    public string name {get;set;}
    public int Lats {get;set;}
    public int Longs {get;set;}
    public List<states> states {get;set;}
}

public class states {
    public int id {get;set;}
    public string name {get;set;}
    public int Lats {get;set;}
    public int Longs {get;set;}
    public id countryid {get;set;}
    public List<citys> citys {get;set;}
}


public class citys {
    public int id {get;set;}
    public string name {get;set;}
    public id countryid {get;set;}
    public id stateid {get;set;}
}


//-------------

//Data Access

public DataTable getCountry(){
    DataTable dt = new DataTable();
    _conn = new Connetion();
    using(_cmd = new SqlCommand()){
        ------param------------
        using(SqlDataAdepter da = new SqlDataAdepter(_cmd)){
            da.Fill(dt)
        }
    }
    return dt;
}


public DataTable getStates(){
    DataTable dt = new DataTable();
    _conn = new Connetion();
    using(_cmd = new SqlCommand()){
        ------param------------
        using(SqlDataAdepter da = new SqlDataAdepter(_cmd)){
            da.Fill(dt)
        }
    }
    return dt;
}


public DataTable getCity(){
    DataTable dt = new DataTable();
    _conn = new Connetion();
    using(_cmd = new SqlCommand()){
        ------param------------
        using(SqlDataAdepter da = new SqlDataAdepter(_cmd)){
            da.Fill(dt)
        }
    }
    return dt;
}

//-------------

//Method

public void AllLists() {
    DataTable dt = new DataTable();
    country c = new country();
    dt = getCountry();
    country = (from DataRow dr in dt.Rows
        select new country(){
            countryid = dr["id"],
            states = ------how to add a states----,
            states.citys = ------------how to add citys-----
        });
}

below is format how i want the Data
in json format

country: {
id : "",
name : "",
Lats : "",
Longs : "",
states : {
id : "",
name : "",
Lats : "",
Longs : "",
citys : {
id : "",
name ; "",
countryid : "",
stateid : ""
}
}
}

Posted 8-Oct-16 17:53pm

nik varma

Updated 9-Oct-16 6:11am

v4

Add a Solution

Comments

Patrice T 8-Oct-16 23:59pm

What is "multi level property" ?

nik varma 9-Oct-16 0:03am

inside the class the their are two list, in which i want to bond the data, as shown in the property nested list, please check the output that i want

please help if you know

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

David_Wimbley · Answer 1 · 2016-10-09T06:11:00

So for one, your expected JSON is malformed. Here is an example of your expected output

JavaScript

{ "country": {
    "id" : "",
    "name" : "",
    "Lats" : "",
    "Longs" : "",
    "states" : [{
        "id" : "",
        "name" : "",
        "Lats" : "",
        "Longs" : "",
        "citys" : {
            "id" : "",
            "name" : "",
            "countryid" : "",
            "stateid" : ""
            }
        },{
        "id" : "",
        "name" : "",
        "Lats" : "",
        "Longs" : "",
        "citys" : {
            "id" : "",
            "name" : "",
            "countryid" : "",
            "stateid" : ""
            }
        }]
    },
"country": {
    "id" : "",
    "name" : "",
    "Lats" : "",
    "Longs" : "",
    "states" : [{
        "id" : "",
        "name" : "",
        "Lats" : "",
        "Longs" : "",
        "citys" : {
            "id" : "",
            "name" : "",
            "countryid" : "",
            "stateid" : ""
            }
        },{
        "id" : "",
        "name" : "",
        "Lats" : "",
        "Longs" : "",
        "citys" : {
            "id" : "",
            "name" : "",
            "countryid" : "",
            "stateid" : ""
            }
        }]
    }
}

Then your class structure needs to be as follows

C#

public class Citys
{
    public string id { get; set; }
    public string name { get; set; }
    public string countryid { get; set; }
    public string stateid { get; set; }
}

public class State
{
    public string id { get; set; }
    public string name { get; set; }
    public string Lats { get; set; }
    public string Longs { get; set; }
    public Citys citys { get; set; }
}

public class Country
{
    public string id { get; set; }
    public string name { get; set; }
    public string Lats { get; set; }
    public string Longs { get; set; }
    public List<state> states { get; set; }
}

public class RootObject
{
    public Country country { get; set; }
}
</state>

I suggest you use JSON.NET library (newtonsoft) to serialize/deserialize your json.

For more info on JSON.net see this link: Json.NET - Newtonsoft[^]

From there you can just use the C# classes, assign values to whatever properties you want and when you are ready to convert that to JSON you just use

C#

string json = JsonConvert.SerializeObject(model);