I am using Xpo and have an Address table with Street, City, State, Zip fields. The State represents the FK to an Xpo State Table.
I have an XpoDataSource1 hooked up to the address table and an XpoDataSource2 hooked up to the State table.
With the bindings below, I get an exception:
{"DataBinding: 'DevExpress.Web.Data.WebCachedDataRow' does not allow indexed access."}
It doesn't seem to like Bind("State!Key").
How can I bind a simple state lookup combo to the gridview using xpo?
<dxwgv:GridViewDataTextColumn Caption="State" FieldName="State!Key" VisibleIndex="5">
<EditItemTemplate><asp:DropDownList
ID="DropDownList1" runat="server"
DataSourceID="XpoDataSource2" DataTextField="Name"
DataValueField="Abbreviation" SelectedValue="<%# Bind('[State!Key]') %>"
></asp:DropDownList>
</EditItemTemplate>
<PropertiesTextEdit NullDisplayText="Select a State">
</PropertiesTextEdit>
</dxwgv:GridViewDataTextColumn>