have a RadGrid which has a main data source dsA. I have a foreign key column on this dsA called fColumn having integer values, on which I am getting the relevant text of this fColumn from a second table "tblB". The tblB has two columns (id and text) which the id is corresponding to fColumn.
I want to have the FilterCheckList values in the grid from this tblB, column named "text" which I did as:
and in the code.cs file:
sender, GridFilterCheckListItemsRequestedEventArgs e)
DataField = (e.Column
e.ListBox.DataSource = dsTblB;
What I am getting as error in alert when I am clicking on this filter:
fColumn is neither a DataColumn nor a DataRelation for table DefaultView.
So how this above scenario can be easily achieved with Telerik controls.
PS: I don't want to use SQL Joins for filling the Grid in the query.
Thanks in Advance!