Grid Foreign Key Column - Circular Reference

[Peter]

Dear,

ASP.NET Web Forms in VB.NET.

I get a Circular Reference Error on 

ASP._global_asax.

 when adding a Foreign Key Column.

.VB

dsGoods.SelectParameters("CustomerID").DefaultValue = oUser.CustomerID

Dim index = dgLoads.Columns.FindIndex(Function(col) col.Field = "GoodType")

dgLoads.Columns.ElementAt(index).DataSource = dsGoods

.ASPX

<ej:Grid ID="dgLoads">

     <ej:Column Field="GoodType" HeaderText="Type" ForeignKeyValue = "GoodDescription" ForeignKeyField = "GoodID" />

 </ej:Grid>

<asp:SqlDataSource ID="dsGoods" runat="server" ConnectionString='<%$ ConnectionStrings:PSWEB %>'

        SelectCommand="SELECT [GoodID], [GoodDescription] FROM [Goods] WHERE ([CustomerID] = @CustomerID)">

        <SelectParameters>

            <asp:Parameter Name="CustomerID" Type="Int32" />

        </SelectParameters>

</asp:SqlDataSource>

What's wrong?

[Farveen Sulthana Thameeztheen Basha]

Hi Peter, 

Thanks for contacting Syncfusion Support. 

We have checked your query and we have already discussed about this requirement “Circular reference error while using Entity Framework/Linq 2 SQL” in our Syncfusion Knowledge Base. Refer to the below KB link:- 

https://www.syncfusion.com/kb/6290/circular-reference-error-while-using-entity-framework-linq-2-sql 

 

Please get back to us if you need any further assistance. 

Regards, 

Fareen sulthana T