sorting on foreign key table by using ComboBox

[Administrator]

Hello:

In attempting to add a foreign key Description column to a GDBG v3.2.1.0 (from a strongly typed DataSet), I found this existing posting which helped me add the column.

http://www.syncfusion.com/Support/Forums/message.aspx?MessageID=1514

So I have successfully added a column displaying the CategoryDescription (from another table) instead of the CategoryID from the bound table for this grid. Great.

My problem is sorting. When I click the column header to sort on that column, it is sorting on the MappingName which is the CategoryID for the bound table. Is there any way I can click on the column and have it sort on the displayed information? (which is the foreign CategoryDescription)

Any help would be appreciated. Thanks.

[Administrator]

Hi Todd,

Please refer to the DataBoundSortByDisplayMember sample in the Syncfusion browser samples shipped with the product.

C:\Program Files\Syncfusion\Essential Studio\4.4.0.49\windows\Grid.Windows\Samples\DataBound\DataBoundSortByDisplayMember

The aboove sample has a solution for sorting a column by its display member instead of the value member of the column.

Thanks for using Syncfusion Products.

Best regards,
Haneef

[Administrator]

Hi Haneef,
Thanks for pointing me to that sample. My version 3 installation of the grid does have that sample. I've been trying to get this to work, but it's not working for me yet.

To be specific, I'm getting an exception inside gridDataBoundGrid1_CellClick():

If dv.Sort = sortName Then
dv.Sort = sortName + " DESC"
sortDir = ListSortDirection.Descending
Else
dv.Sort = sortName <-- Exception here
grid.Model(0, e.ColIndex).Tag = sortDir

The exception I'm getting at the line is
"Cannot find column 'CategoryName'."
(to use your example)

So it is to the point where it's recognizing that column as column.MappingName = "CategoryID", so that's good. It's just failing when trying to use that 'CategoryName'.

I have set up the GridBoundColumns exactly as you have in the example, so I'm not quite sure what the problem is yet. I have no doubt the solution works, since I have your example solution working fine. 8) But if you had any thoughts on an easy place I might be missing something, I'd appreciate it.

Thanks.

[Administrator]

I figured out what my problem was. I have this working just fine, for what the sample code intends. Thanks a ton.

My problem is this, and looks like a detail I should have mentioned up front. The GDBG that I'm using, is used not only for show, but for edit/update purposes also. When I perform a dataAdapterName.Update() on the adapter tied to this grid with this custom sorting code, I get this exception:

"Dynamic SQL generation is not supported against multiple base tables."

So my question is this I guess: Will this example only work on a grid that is meant for display only, since it involves joining of a couple tables to get the foreign key Description column?

Thanks.

[Administrator]

Just checking in if my last question made sense to anyone.

Thanks.

[Mark Atkinson]

It looks like I'm a few months too late, hopefully you've found a solution.
Anyways, I se your problem and I'm dealing with the same issue. I can't do any kind of inner join to prepare the table and add the description columns in.