Hierarchy DataSource Issue

[Mark]

Hi All,

I have an entirely code-behind C# Radgrid solution, living in SharePoint.  I have implemented a detail table within my mastertable and the hierarchy (parent-child) functionality of the grid works well.  However, this is only when I use RadGrid.DataSource = SQLDataSource.  Doing this breaks column sorting though. 

Changing my code to RadGrid.DataSourceID = SQLDataSource.ID allows me to sort the columns but breaks the hierarchy.  Does anyone have any suggestions on how to fix this?

Thanks,
Mark

[Mark]

OK, it looks like I need to create a new SQLDataSource for the DetailTable to work, but unfortunately, I'm getting a "must declare the scalar variable '@EmployeeID' for example from this link:

http://demos.telerik.com/aspnet-ajax/grid/examples/hierarchy/hierarchy-with-templates/defaultcs.aspx

It's all code-behind. . .

Thanks,
Mark

[Shinu]

Hi Mark,

Please make sure that you have set the DataKeyNames as EmployeeID.

ASPX:

<MasterTableView  DataKeyNames="EmployeeID">

Thanks,
Shinu

[Mark]

Thanks Shinu!

It's all in code behind though, so it looks like this:

RadGrid.MasterTableView.DataKeyNames = new string[] {"EmployeeID"};

It still doesn't work though . . .  :-(

[Shinu]

Hi Mark,

I couldn't replicate the issue, can you please provide your full code snippet.

Thanks,
Shinu

[Wendy Prince]

_