I don't know if there is a neat way of displaying the code, or at least I don't know where to host it.  I say that because I believe part of the problem I'm having is how the data is presented to the grid.  The data is coming from a json ServiceStack call, See below:

<table id="hierarchicalGrid"></table>

    <script type="text/javascript">

        var data = @UserInformation.AsRawJson()

        $("#hierarchicalGrid").igHierarchicalGrid({

            datasourcetype: 'json',

            dataSource: data,

            odata: true,

            initialDataBindDepth: 0,

            autoGenerateLayouts: false,

            autoGenerateColumns: false,

            columns:

               [{ key: "Username", dataType: "string", headerText: "Username" },

                { key: "EmplID", dataType: "string", headerText: "EmplID"  },

                { key: "Comment", dataType: "string", headerText: "Comment" }],

            columnLayouts: [

                    {

                        key: "GroupInformation",

                        childrenDataProperty: "GroupInformation",

                        autoGenerateLayouts: false,

                        columnLayouts: 

                            [{  key: "GroupName",

                                autoGenerateColumns: true}]

                    }]

        });

    </script>

That is what my code looks like in its current format.  Running this code gives me exactly what I want on the parent band.  The child band errors out with the message:

"Microsoft JScript runtime error: Unable to get value of the property 'dataType': object is null or undefined"

The data is now give to the grid as rawjson is from a list from a class that has fields "UserName, EmplID, Comment, and a property as a list that has fields "GroupName and GroupDescription" for my child band which will have multiple rows per one row of parent band.  The name of the list that holds the child band information is "mygroup"

Thank you so much for your help Martin!

What I tried to do (not knowing what I needed to do) was try to test the c# code with static values so i knew how to format the data coming from the database through json.  My hard code examples in c# within a razor page are below:

 @{

List<SomeClassForTheSecondBand> MyGroup = new List<SomeClassForTheSecondBand>();
List<SomeClassForTheFirstBand> UserInformation = new List<SomeClassForTheFirstBand>();

MyGroup.Add(new SomeClassForTheSecondBand() { GroupName = "GroupOne", GroupDescription = "Testing of GroupDescription" });

UserInformation.Add(new SomeClassForTheFirstBand() { Username = "Jason", EmplID = "999999", Comment = "This is a comment for Jason", GroupInformation = MyGroup });
UserInformation.Add(new SomeClassForTheFirstBand() { Username = "Jeff", EmplID = "888888", Comment = "This is a comment for Jeff", GroupInformation = MyGroup });

   }

<table id="hierarchicalGrid"></table>

<script type="text/javascript">

var data = @UserInformation.AsRawJson()

[the rest of the below is the same as what is posted above]

Definition of class for SomeClassForTheFirstBand and SomeClassForTheSecondBand

public class SomeClassForTheFirstBand
{

public string Username { get; set; }
public string Fullname { get; set; }
public string Comment { get; set; }
public string Acctlocked { get; set; }
public string EmplID { get; set; }
public List<SomeClassForTheSecondBand> GroupInformation = new List<SomeClassForTheSecondBand>();

}

public class SomeClassForTheSecondBand

{
public string GroupName { get; set; }
public string GroupDescription { get; set; }
}

Using your syntax above for the data, I don't understand how I would be able prepare multiple rows for the second band. I understand how I can query a table and put that information in the list for the first band, but I don't quite understand how I can organize that information for the second band in what seems to be without a "List of a List", which is what I tried and didn't work.

For example, using the example of my code I posted, it seems like what you are telling me to try is equivalent to:

public class SomeClassForTheFirstBand
{

public string Username { get; set; }
public string Fullname { get; set; }
public string Comment { get; set; }
public string Acctlocked { get; set; }
public string EmplID { get; set; }

class SomeClassForTheSecondBand

     {

      public string GroupName { get; set; }
      public string GroupDescription { get; set; }

      }

}

UserInformation.Add(new SomeClassForTheFirstBand() { Username = "Jason", EmplID = "999999", Comment = "This is a comment for Jason", New SomeClassForTheSecondBand() {GroupName = "FirstGroupForJason", GroupDescription = "Description of First Group "})

UserInformation.Add(new SomeClassForTheFirstBand() { Username = "Jason", EmplID = "999999", Comment = "This is a comment for Jason", New SomeClassForTheSecondBand() {GroupName = "SecondGroupForJason", GroupDescription = "Description of Second Group "})

<table id="hierarchicalGrid"></table>

<script type="text/javascript">

var data = @UserInformation.AsRawJson()

[the rest of the below is the same as what is posted above]

So, For each child band information that is different within what would be the same parent band, the parent information repeats in the rest of the row.   Am I understanding you correctly?  

<script type="text/javascript">

var data = @UserInformation.AsRawJson()

$("#hierarchicalGrid").igHierarchicalGrid({

dataSourceType:'json',

dataSource: data,

primaryKey:"EmplID",

autoGenerateLayouts: false,

autoGenerateColumns: false,

//responseDataKey: data,

columns:[{ key:"Username", dataType: "string", headerText: "Username" },

{ key:"EmplID", dataType: "string", headerText: "EmplID" },

{ key:"Comment", dataType: "string", headerText: "Comment" }],

autoGenerateLayouts: false,

columnLayouts: [

{

key:

"MyGroup",

responseDataKey:

"data",

autoGenerateColumns:

false,

primaryKey:"GroupName",

foreignKey: "GroupMembers",

columns: [{ key:

"GroupName", headerText: "UserName", dataType: "string" },

{ key:"GroupDescription", headerText: "GroupDescription", dataType: "string" }]

}]

var data = [{"Username":"Jason","Comment":"This is a comment for Jason","EmplID":"999999"},{"Username":"Jeff","Comment":"This is a comment for Jeff","EmplID":"888888"}]

Thank you for your help Martin, I really appreciate your time.  You and Jon Hogue really helped a lot.  Take care.

Hello Jason,

Let me know if you need further assistance regarding this subject.

Best regards,
Martin Pavlov
Infragistics, Inc.

Jason,

  Thanks for posting the sample data.  As Martin had mentioned, and as we discussed on the phone, the issue is with your child collection not being serialized from the .Net to the client.  If you get that data into your data from the server, then you should have a working grid.  Just make sure the name of the property with the child collections matches the key for the columnLayout.

Cheers,

  Jon