Intersoft Community - WebCombo - webCombo and LinqDataSource problem

webCombo and LinqDataSource problem

technical@intersoftpt.com — Thu, 21 Jan 2010 00:11:17 GMT

Hi George,

After analyzing your issue further, we found that the issue is not a bug in WebCombo. It's more to the LINQ limitation in which new select projection will cause underlying datasource's schema to be invalid. This caused WebCombo to unable to filter the "conditions" clause because the target members are no longer existed in the datasource after the new projection.

Unlike WebGrid which processes all data after data retrieval, WebCombo requires pre-databound filtering process. As such, WebCombo requires the fields used in DataTextField and DataValueField to remain the same after the new projection.

The following code shows the working version of WebCombo bound to LINQ DataSource.

<ISWebCombo:WebCombo ID="WebCombo1" runat="server" 
        DataSourceID="ISLinqDataSource1" DataTextField="ProductName" 
        DataValueField="ProductName" Height="20px" 
        UseDefaultStyle="True" 
        Width="200px">
    </ISWebCombo:WebCombo>
    <ISLinqDataSource:ISLinqDataSource ID="ISLinqDataSource1" runat="server" 
        ContextTypeName="NorthwindDataContext" 
        Select="new (ProductName, UnitPrice)" 
        TableName="Products">
    </ISLinqDataSource:ISLinqDataSource>

Let me know if you have any questions.

Hope this helps.

webCombo and LinqDataSource problem

handy@intersoftpt.com — Mon, 07 Dec 2009 01:21:44 GMT

Ok, I have forwarded this to our developer. Thank you.

webCombo and LinqDataSource problem

GeorgeB — Wed, 02 Dec 2009 20:44:28 GMT

for the sample use the Ten Most Expensive products stored procedure that is in NorthWind. I don't know if i have the name correct but it is easy to find.

webCombo and LinqDataSource problem

handy@intersoftpt.com — Tue, 01 Dec 2009 21:43:17 GMT

Hi George,

Is it a normal StoreProcedure or something more complexs? Could you guide me?

Regards,
Handy

webCombo and LinqDataSource problem

GeorgeB — Tue, 01 Dec 2009 09:46:07 GMT

Handy

Please have them check the use of a stored procedure, too.

George

webCombo and LinqDataSource problem

handy@intersoftpt.com — Tue, 01 Dec 2009 00:03:37 GMT

Hi George,

It seems this is a bug in our WebCombo which WebCombo could not recognize an alias. I have submitted this to our developer. They are checking it right now and i will let you know the result.

Regards,
Handy

webCombo and LinqDataSource problem

GeorgeB — Mon, 30 Nov 2009 14:53:11 GMT

I've been trying to set up a WebCombo with a LinqDataSource that uses a stored procedure. I can do this with a WebGrid. Since I couldn't get the WebCombo to work I decided to first try a WebCombo and a WebGrid with a simple select statement in the LinqDataSource. The WebGrid works but the WebCombo fails with a fatal error.

I've attached the sample. You need the northWind SQL db. An example of a stored procedure that will load the WebCombo and WebGrid is "Ten Most Expensive Products".

Looking forward to your response.

George