hi , i'm having problem with radgrid in my n-tier applicatin
i'm assigning radgrid datasource to a List<Product> and i need radgrid provide me filterexpression in form of entity sql format eg: "it.CustomerID = ALFKI" but its format is like "(Convert.ToString(it[\"CustomerID\"]) = \"ALFKI\")"
how i can please radgrid to create entity sql filterexpression without using EntityDataSource ?
i'm assigning radgrid datasource to a List<Product> and i need radgrid provide me filterexpression in form of entity sql format eg: "it.CustomerID = ALFKI" but its format is like "(Convert.ToString(it[\"CustomerID\"]) = \"ALFKI\")"
how i can please radgrid to create entity sql filterexpression without using EntityDataSource ?
1 Answer, 1 is accepted
0
Hi Ali,
If you are using .net 3.5/4.0 version of RadGrid filter expressions are in different format. RadGrid internally use Dynamic LINQ in order to perform filtering. The format of the expression depends on what is the source that will be filtered.
In case of SqlDataSource format is as follow: it["FieldName"] = "Value". Thus the expressions like: Login_Name='Patrik' should look as follow: it["Login_Name"] = "Patrik".
On the following link you could find more information about how to operate with the FilterExpression of Telerik RadGrid Manually:
http://www.telerik.com/help/aspnet-ajax/grid-operate-with-filter-expression-manually.html
I hope this helps.
Regards,
Radoslav
the Telerik team
If you are using .net 3.5/4.0 version of RadGrid filter expressions are in different format. RadGrid internally use Dynamic LINQ in order to perform filtering. The format of the expression depends on what is the source that will be filtered.
In case of SqlDataSource format is as follow: it["FieldName"] = "Value". Thus the expressions like: Login_Name='Patrik' should look as follow: it["Login_Name"] = "Patrik".
On the following link you could find more information about how to operate with the FilterExpression of Telerik RadGrid Manually:
http://www.telerik.com/help/aspnet-ajax/grid-operate-with-filter-expression-manually.html
I hope this helps.
Regards,
Radoslav
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now