EntityDataSource WhereParameters not working while AllowFilteringByColumn="true"

[Dhamodharan]

Hi All,

I am using EntityDataSource whereParameter working fine while AllowFilteringByColumn="false". but i want to set AllowFilteringByColumn="true" it returns error like "WhereParameters cannot be specified unless AutoGenerateWhere==true or Where is specified.". i set to AutoGenerateWhere==false in entitydatasource it returns error while filter like "AutoGenerateWhereClause cannot be true if Where is defined. ".

How do i solve this issue. Please let me know ASAP.

Thanks in advance,
Dhamodharan.S

[Maria Ilieva]

Hello,

I tried to replicate the problematic behavior by enabling the filtering in the online demo below but to no avail:
http://demos.telerik.com/aspnet-ajax/grid/examples/data-editing/manual-crud-operations/defaultcs.aspx

The mentioned example works properly on my side. Test it locally and verify what the difference in your case is.

Regards,
Maria Ilieva
Telerik

 

 

[Dhamodharan]

Hi,

I am using "EntitySetName" and "Include" in entitydatasource. without "Include" filtering working fine. while including another table we got this issue. Please let me know how we fix this issue

[Dhamodharan]

sorry, this is not issue. while using AllowFilteringByColumn="True" i am not able to give Where="it.grp_ins_id=@grp_ins_id" in Entitydatasource. this is the problem. please let me know how to fix this issue

[Jochen]

Same problem here. What I try to achieve is to combine the standard radgridview filter functionality with another filter, e. g. a Dropdown. How to do that with a entity data source?

[Jochen]

Update: I found the MasterTableView Filterexpression property. I set that onInit in CodeBehind. Works fine in my case. But still interested in a solution with combined filters.

[Dhamodharan]

Can you explain with sample code please?

[Jochen]

Sure. This is what i figured out:

In codebehind you hook in OnInit (I guess OnLoad would be early enough too):

protected override void OnInit(EventArgs e)
{
// Registrieren der Events
c_Maingrid.ItemInserted += c_Maingrid_ItemInserted;

// Defaultfilter
c_Maingrid.MasterTableView.FilterExpression = "(it.[MANDNR] = " + Session["Mandant"] + ")";

// Basisklasse
base.OnInit(e);
}

The Radgrid (c_Maingrid) combines the MasterTableView.FilterExpression with the automatically generated filters in an "AND" manner. So you should achieve your goal.

You can hook in the EntityDataSource OnSelecting event to see how RadGrid is generating the filters.

Greets Jochen 

​

[Dhamodharan]

when i added onlnit function
c_Maingrid.MasterTableView.FilterExpression = "(it.[MANDNR] = " + Session["Mandant"] + ")";

it is working fine. the grid populate without error message. but i want to filter by column. it is not working. can you please find that one.

[Jochen]

Dhamodharan,

I do not really understand the question.

What I mean that you use the entity data source with default parameters like

<ef:EntityDataSource ID="c_DataSource" runat="server" ConnectionString="name=FELIXXEntities" DefaultContainerName="FELIXXEntities" EnableUpdate="true" EnableInsert="true" EnableDelete="true"
    EntitySetName="MANDANT">
</ef:EntityDataSource>

and you use the MasterTableView.FilterExpression INSTEAD of the EntityDataSource Where property to set a default filter. When yout enable the column filters of the RadGrid then the radgrid will handle the filtering by itself -> implicitly sets the EntityDataSource Where property and generates a combination of your default filter that you set in codebehind and the automatically generated column filter expressions. Unfortunately I can't attach the files here. 

[Dhamodharan]

 Hi,

I used Entitydatasource selecting event for where condtion. so first time that grid retrive record correcty based on where condition. but going to filter condtion based column "StartsWith". that time i have following error message
"Sys.WebForms.PageRequestManagerServerErrorException: The query syntax is not valid. Near keyword 'LIKE', line 6, column 6. "

Please check my code
<asp:EntityDataSource ID="EDSPlans" runat="server" ConnectionString="name=GrpEntities"
DefaultContainerName="GrpEntities" EnableDelete="True" EnableFlattening="False"
EnableInsert="True" EnableUpdate="True" EntitySetName="PLANS" Include="plan_types, plan_funding_types"
OrderBy="it.EFFECTIVE_DATE DESC" EntityTypeFilter=""
Select="">
</asp:EntityDataSource>


Protected Sub EDSPlans_Selecting(sender As Object, e As System.Web.UI.WebControls.EntityDataSourceSelectingEventArgs) Handles EDSPlans.Selecting

If e.DataSource.Where <> String.Empty Then
e.DataSource.Where += " AND "
End If
e.DataSource.Where += "it.grp_id=1"
        
End Sub

[Jochen]

Thats a lot more information than you initial question :)

Could you debug and post the Where condition itself? Maybe there's a bug generating the where statement?

Maybe you'll have to correct the Where condition manually within the event.

From now on I think I cannot deliver any valuable information...

[Dhamodharan]

Hi,

I have another Question. Can we insert data into 2 tables?. i am using EntityDataSource with
"Inclue" option. so i can display 2 tables data. but how we can insert
and update 2 tables?

[Jochen]

Good explanation for asp DataGrid here:

http://stackoverflow.com/questions/2284374/columns-of-two-related-database-tables-in-one-asp-net-gridview-with-entitydataso

Quite sure this is the same for RadGrid.

I think you have to solve that on entity level using foreign keys afaik - we are also researching this right at the moment. But post your solution when you have it... I'm interested :)

[Dhamodharan]

Thanks for your help. i need another help. i need case inSensitive while filtering. but now it is filtering like caseSensitive. i set the property like  "<GroupingSettings CaseSensitive="False" />". but not working. i am using Oracle database. can we set any additional property please let me know ASAP.