Hi, i'm trying to use RadGrid for a master/detail grid with declarative binding, but when i try to expand a level i obtain only empty detailsviews.

I set ServerOnDemand mode. This is the code.

ConnectionString(s) are setted on the Init step:

Thank you for advices.

Hello,

I advise that you compare your setup with this demo and review the information from the demo description in detail: https://demos.telerik.com/aspnet-ajax/grid/examples/hierarchy/declarative-relations/defaultcs.aspx. Could you try renaming the fields in the SqlDataSource so they are not tableName.FieldName but only FieldName, as in our demo?

Regards,

Hi, I think the code reflects what is written on the page you suggested, which I had previously read.

Anyway I deleted references to the tables like you said. The second ds was based on a inner join and I had to replace it with a view that simplified it. But this did not solve the problem.

Could the behavior be affected by the lack of RadScriptManager and RadAjaxManager controls?

i don't inserted them in the page. 

but i changed the HierarchyLoadMode from "Cient" to "ServerOnDemand" wothout results.

Hello Emanuele,

To use IScriptControl instances (such as our controls) you must definitely have a script manager - either <telerik:RadScriptManager> or <asp:ScriptManager> at the beginning of the <form>, before any other controls.

A RadAjaxManager is not necessary, it facilitates partial page rendering like <asp:UpdatePanel> the control does, so it is not essential.

I am attaching here another example that also works fine. Could you try comparing that against what you get and see if this helps? If not, I advise that you open a ticket and send us a runnable example that illustrates the problem you have so we can offer a more concrete answer.

Regards,

Hi, 

i've made a little change on my code commenting some lines:

now, instead of having empty results, I get the whole table without filters for each parent row

i see your code, but it's quite different in datasources: 

in your case you have a big table and you give only a few records on the 1st level and on the 2nd level (detail) yoiu give all the records, is it right?
but I have 2 sets of different records linked by the IDgroup field

Hello Emanuele,

Perhaps I should have been clearer in my previous explanations. You can try binding the detail tables programmatically in a similar fashion to my example. The real code will not use a big hardcoded table, but will use your actual SQL table. You can see how to get the key from the parent item so you can use it in the query here: https://docs.telerik.com/devtools/aspnet-ajax/controls/grid/rows/accessing-cells-and-rows#accessing-raw-field-data-and-key-values.

Regards,

Hi, i've solved the first problem :-)

I left the first datasource for master grid; instead I have linked programmatically the data source of the detailsview

Now the code is 

Now i've to set the other behaviors. I need to order rows, but only details rows are running, the master rows are fixed: i press the header and the arrow reverses direction, but rows don't change their order. Nothing occurs if i specify a SortExpression properties for a field/column.

Thanks

Hi,

Could you try setting AllowMultiColumnSorting to true for the master table view, to mimic this demo: https://demos.telerik.com/aspnet-ajax/grid/examples/hierarchy/declarative-relations/defaultcs.aspx?

Also, since you are using the NeedDataSource event, I advise that you pass the DataSource to the main table programmatically as well, setting the DataSource property to the ID of a declarative data source should not produce proper results.

Regards,