about hierarchy table column

[hy1990]

I am right now working on creating a grid with hierarchy column. By saying hierarchy, I mean by default I will show contents in the first column and leave column 2 and 3 blank. Column one is my wildest category(e.g. nations), column two narrower category(e.g. states) and column three the narrowest(e.g. city). After clicking on one cell in column one, column two will show all states in that selected nation and column three will show all cities if any cell is selected in column 2.
In which way I can achieve this? I've been looking through the demos and documentation and didn't find anything in grid panel that can do this. I don't think tree structure is the way to go, either.
I appreciate your help. Thanks!

[Daniil]

Hi @hy1990,

Welcome to the Ext.NET forums!

Probably, a TreeGrid is the way to go.
https://examples1.ext.net/#/TreePane...nced/TreeGrid/

[hy1990]

Hello @Daniil

Thank you for your reply!
I looked through the documentation and found Has-Many Association in 2.5 is exactly what I want. However I am running 1.X and can't use the association. Is there a similar way to achieve this?
Here is my layout:


My goal is to choose a drug name and pops up different forms under that drug and pops up dosage under that form after choosing form.
I am thinking organizing my data like this: list<drug name>contains list<form>, list<form> contains list<dosage>. However, I am having trouble putting this data into a store. Which kind of store or field should I use? And how can I achieve the popping up without using association?

Thanks!

Addition:
I figured using a dictionary to organizing my data is easier. Here goes: dictionary 1 contains drug name and form dictionary2, dictionary 2 contains form name and dosage dictionary3. Can I bind this data to store? If so, how can I do it?

[Daniil]

There are no Associations in Ext.NET v1.x, but you can put any data into a Store, for example, an array of entities. Please look at

<ext:RecordField Name="Customers" IsComplex="true" />

in this example:
https://examples1.ext.net/#/DataView/Advanced/Report/

The IsComplex="true" setting means that you bind some non-primitive data to a RecordField. This data will be fully serialized.

[hy1990]

I guess I will attach my code behind.

List<DataRow> drug = dt.AsEnumerable().ToList();
Dictionary<string, Dictionary<string, Dictionary<string, DataRow>>> drugtree = new Dictionary<string, Dictionary<string, Dictionary<string, DataRow>>>();

            //*************************************start grouping values*******************************************
            foreach (DataRow dg in drug)
            {
                string DN = dg["BN"].ToString();
                string form = dg["TitleName"].ToString();
                string dos = dg["strength"].ToString();
                //List<string> res = drugName.Find(DN);
                Dictionary<string, Dictionary<string, DataRow>> temp;
                if (drugtree.TryGetValue(DN, out temp))
                {
                    Dictionary<string, DataRow> temp2;
                    if (temp.TryGetValue(form, out temp2))
                    {
                        DataRow temp3;
                        if (!temp2.TryGetValue(dos, out temp3))
                        {
                            //add drug
                            temp2.Add(dos, dg);
                        }
                    }
                    else
                    {
                        //add drug
                        Dictionary<string, DataRow> ele = new Dictionary<string, DataRow>();
                        ele.Add(dos, dg);
                        temp.Add(form, ele);
                    }
                }
                else
                {
                    //add drug

                    Dictionary<string, DataRow> ele = new Dictionary<string, DataRow>();
                    ele.Add(dos, dg);
                    Dictionary<string, Dictionary<string, DataRow>> ele2 = new Dictionary<string, Dictionary<string, DataRow>>();
                    ele2.Add(form, ele);
                    drugtree.Add(DN, ele2);
                }
            }
            this.Store1.DataSource = new object[]{"Name 1",drugtree};
            this.Store1.DataBind();

Here is what I did to create dictionary inside dictionary inside dictionary to group my data.
When I was writing store, I tried this.

 <ext:Store ID="Store1" runat="server" IgnoreExtraFields="false" AutoLoad="true"
        RemoteSort="true" groupfield ="BN">
        <Proxy>
            <ext:PageProxy />
        </Proxy>
        <Reader>
            <ext:ArrayReader>
                <Fields>
                    <ext:RecordField Name="BN" />
                    <ext:RecordField Name="strength" Type="String" />
                    <ext:RecordField Name="TitleName" Type="String" />

                </Fields>
            </ext:ArrayReader>
        </Reader>
    </ext:Store>

I guess this won't work because there is no way for reader to tell which key for dictionary is BN, strength and Title. So I am stuck here to create a reader and recordfield. Any idea how to write the store?

[Daniil]

Well, there are two ways. Either you modify/prepare the data on server, or serialized everything to client and retrieve everything that you need on client. With the second way, as I mentioned, you will probably need to use IsComplex="true" and, probably, a RecordField's Convert.

There is a sample of a RecordField's Convert handler.
https://examples1.ext.net/#/GridPane.../Data_Prepare/