dhtmlxConnector and dhtmlxTreeGRid

Suite and Optimus Suite 5
#1

Hi friends.
Has anyone generated treegrid’s content with dhtmlxConnector in c#.net. I couldn’t figure out this problem. I created an .ashx. file and it’s content like this;

dhtmlxTreeGridConnector connector = new dhtmlxTreeGridConnector(
“select Division, Make, Gallons, Miles from SomeTable”,
“”,
“”,
dhtmlxDatabaseAdapterType.SqlServer2005,
app.ConnectionString
);
connector.EnableDynamicLoading = true;
return connector;

There are over 60000 records in this table. but i couldn’t understand how can i handle expandable rows.

there are 2 unique Division’s and 5 unique Makes. here is what i want to create;

Title Gallons Miles

  • Division1
    .Make1 250 250
    .Make2 350 550
  • Division2
    .Make3 100 110
    .Make4 100 110
    .Make5 100 110

Thanks for your helps friends.

#2

Existing version of connector can’t produce valid XML data from such dataset ( it requires parent-id relation and can’t group value by some param), so the only way is to use your custom C# code to form xml for the grid.