This is a migrated thread and some comments may be shown as answers.

GridDropDownColumn & Binding to Non-foreign Key Columns

3 Answers 114 Views

Grid

This is a migrated thread and some comments may be shown as answers.

Richard Weeks asked on 13 May 2011, 01:12 AM

Hello,

Imagine two tables, each with two columns.

Operations

UserId

StartedBy

Users

Id

UserName

Operations.UserId is a FK to Users.Id. All columns are integers.

This works:

<telerik:GridDropDownColumn

DataField="UserId"

DataSourceID="UsersDataSource"

HeaderText="UserId"

ListTextField="UserName"

ListValueField="Id"

UniqueName="UserId">

</telerik:GridDropDownColumn>

This doesn't:

<telerik:GridDropDownColumn

DataField="StartedBy"

DataSourceID="UsersDataSource"

HeaderText="Started By"

ListTextField="UserName"

ListValueField="Id"

UniqueName="StartedBy">

</telerik:GridDropDownColumn>

Here's the DataSource:

<asp:EntityDataSource

ID="UsersDataSource"

runat="server"

ConnectionString="name=MyEntities"

DefaultContainerName="MyEntities"

EnableFlattening="False"

EntitySetName="Users"

EntityTypeFilter="User"

OrderBy="it.[UserName]">

</asp:EntityDataSource>

I know the UserId works because it is a foreign key but the second "StartedBy" is just a normal Int32 column in the Db that I have no control over (i.e. no relationship is or will be defined).

Normally, I'd just shrug and roll some code-behind but I'd much rather solve this in the declarative manner.

What is the simplest way I can get my StartedBy dropdown to bind via the value recorded in Operations.StartedBy?

Richard

3 Answers, 1 is accepted

Accepted