[Solved] How to set the datasource of amstertableview and detailsview to same thing?

[matt]

The problem is normally the details takes a collection object from the parent which is fine in most cases but in this case I have an object for example

class person
{
string name
string job
string description
}

And I want each row to show NAME and JOB and when I expand that row
to should the details I want to show DESCRIPTION.

Is there any easy way to have the detailstable have access to get the DESCRIPTION? 

Hoping there is a cleaner way that using onDataBinding and reassign the datasource?

[Veli]

Hi Matt,

The easiest way is to bind the DetailTableView in the DetailTableDataBind method of RadGrid, using a new data source control (or data object) with the same parameters, except for a modified SELECT statement to select only the record associated with the parent item. Please find an attached sample project demonstrating this functionality:

protected void RadGrid1_DetailtableDataBind(object source, GridDetailTableDataBindEventArgs e)
{
    AccessDataSource detailSource = new AccessDataSource(AccessDataSource1.DataFile, AccessDataSource1.SelectCommand + " WHERE SupplierID = " + e.DetailTableView.ParentItem["SupplierID"].Text);
    e.DetailTableView.DataSource = detailSource;
}

Regards,
Veli
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center