Filtering RadGrid with EntityDataSource

[orim]

Hi,
i bind my RadGrid to an EntityDataSource.
First i want fill it with a where statement.
In T-SQL like so:  Select Status,Cti,CreatedDate from Table1 where CreatedUser = @LoggedInUser
This works fine. But when i want to filter some columns i get this error
AutoGenerateWhereClause can not be 'true', if Where is defined
My EntityDatasource look like so

<asp:EntityDataSource ID="EntityDataSource1" runat="server" ConnectionString="name=TestEntities"
    DefaultContainerName="TestEntities" EntitySetName="Table1" OrderBy="it.CreatedDate DESC"
    Select="it.[Status], it.[CreatedDate], it.[CTI]"  AutoGenerateWhereClause="True"
    Where="it.CreatedUser = @LoggedInUser">
    <WhereParameters>
        <asp:Parameter DefaultValue="Test\User1" Name="CreatedUser" DbType="String" />
    </WhereParameters>
</asp:EntityDataSource>

How can i achive this. Fill Grid with where statement and also filtering should work
Thanks

[Andrey]

Hi,

This is a limitation of the EntityDataSource, when you are using Where parameters you could not use AutoGeneratedWhereClause. If you want to use the built-in filtering support of RadGrid you do not need to enable the AutoGenerateWhereClause as shown in this online demo application.

Please elaborate a bit more on your requirements.

Regards,
Andrey
the Telerik team

[virender]

Hi,

Orim, You got your solutions ?

[Yunuen Sanchez]

Remove the Where clause from your EntityDatasource and move it to a QueryExtender.

Filtering by column should work this way.