Applying Like Filter To An IQueryable?
Oct 7, 2010
I'm trying to write a custom filter for Dynamic data that will allow me to run like type queries on entity columns. For example searching for john on name field to returen johnson, johns etc.
I'm trying to override the IQueryable GetQueryable(IQueryable source) method on the QueryableFilterUserControl class. To filter my results. Does anyone know the best way of achieving this?
If this were and IQueryable<T> it would be easy as I could return the results of a .Where() clause.
There is an ApplyEqualityFilter(IQueryable source, string Column.Name, object value) method on the QueryableFilterUserControl class but this performs a direct comparison.
View 1 Replies
Similar Messages:
Mar 27, 2011
I am implementing paging in my GridView. From this article, I need two methods:
public IQueryable BindEmployees(int startRowIndex, int maximumRows)
{
EmployeeInfoDataContext dbEmp = new EmployeeInfoDataContext();
var query = from emp in dbEmp.Employees
join dept in dbEmp.Departments
on emp.DeptID equals dept.DeptID
select new
{
EmpID = emp.EmpID,
EmpName = emp.EmpName,
Age = emp.Age,
Address = emp.Address,
DeptName = dept.DepartmentName
};
return query.Skip(startRowIndex).Take(maximumRows);
}
And
public int GetEmployeeCount()
{
// How can I not repeat the logic above to get the count?
}
How can I get the value of the second method GetEmployeeCount from the first method BindEmployees ? I mean without repeating the logic (the query)?
View 3 Replies
Oct 31, 2010
I need good css for Gridview just like the mac css
can we provide the filter functionality to gridview like the excel filter.
View 3 Replies
Jan 1, 2010
In securing actions/controllers, do I have to create a custom filter or use MVC built-in filter?
To use the built-in attribute Authorize() on an action/controller or create a separate class that inherits the ActionFilterAttribute which has a method (OnActionExecuting) to override and do the authentication there?
View 2 Replies
Aug 23, 2010
Is there option to convert from Linq.IQueryable to DataTable with some sort of CopyToDataTable() function. I am trying this.
View 2 Replies
Feb 11, 2011
I have a series of parameters stored in rows in the database, and I'd like to return rows that satisfy both input parameters. The parameters come through in the URL, like "&msg_type=20560&status=101"
I have code that works fine, but only if there's one parameter. If there are two, it empties out the results. Here's my code:
[code]....
View 1 Replies
Jul 4, 2010
I'm creating a repository and service layer in my app, and my repo has a very simple function
Public Function GetRegions() As IQueryable(Of Region) Implements IRegionRepository.GetRegions
Dim region = (From r In dc.Regions
Select r)
Return region.AsQueryable
End Function
Now in my Service layer I've got a function like this
Public Function GetRegionById(ByVal id As Integer) As Region Implements IRegionService.GetRegionById
Return _RegionRepository.GetRegions().Where(Function(r) r.ID = id).FirstOrDefault
End Function
But i can't figure out how to add And r.isActive = True
how to have multiple operators in this query?
View 3 Replies
Dec 23, 2010
the problem i am having is passing in multple parameters are part of my Function(p) call... i'll explain further..
This is my interface: it might have errors further though through this is still in development..
IRepository:
[Code]....
This is my repository, inheriting the interface above
[Code]....
And finally in my code-behind i am calling the SingleEntity - this is where i must be going wrong....?
If i call it with a single parameter then it's fine.. multiple and it goes awry..
I have put comments in the section i can't seem to figure...
[Code]....
When i run the code i get the following error:
[Code]....
View 7 Replies
Mar 3, 2011
I currently have a number of lists in my solution, here is an example
[Code]....
and then in the repository
[Code]....
how would i do the same thing with an interface and an Iqueryable rather than a class and a list?
View 1 Replies
Mar 9, 2010
In my organization we use nested groups. For a particular usage, we have a group (let's assume that the group name "kuku"), and the names of all the nested groups under it contains "kuku" as well.
We may assume that no other group in the LDAP has "kuku" in the name.
I need to create a filter which will return all the users which belong to one of the "kuku"s group.
Obviously, using this filter will bring only the head kukus
(&(&(objectclass=user)(objectclass=person))(memberOf=CN=kuku,cn=...rest of the group DN...))
How can I use wild card to fetch all users which belong to any kuku?
For example: (&(&(objectclass=user)(objectclass=person))(memberOf=CN=.*kuku.*))
View 1 Replies
Mar 17, 2010
I have decorated my base controller with a couple of action filters. They work fine.
One of those filters sets up the request - does things like set the culture based on the domain, etc.
I also have a handful of actions that require authorization using the Authorize attribute.
My problem is that when an user attempts to request a page they are not authorized to access, the authorization filter kicks in and redirects them to a page telling them that they cannot vie the page.
The issue is that the action filters never run so the culture and other request data is never set. This effectively causes language to be wrong in the view and other data to be missing.
I know that authorization filters run first but my question is this: How can I design this such that I can ensure that certain methods are always run before the view is returned, regardless of the authorization.
View 1 Replies
Feb 2, 2010
I have a Iqueryable problem
<%= Article.Replies.OrderBy(r => r.Created).First().Member.Username %>
I want to get the most recent Replies that is part of the Article
"Article.Replies" gets all the replies
So now I want to Order by Replies.Created by descending And then just take the first one from which i can get the members username fine. Im having a syntax problem with doing the orderby descending and by picking the first.
View 2 Replies
Jan 3, 2011
i want to store IQueryable value to ViewState. my code is as below:
Private
Property _Query()
As IQueryable
Get
Return
CType(ViewState("_Query"), IQueryable)
End
Get
Set(ByVal value
As IQueryable)
ViewState("_Query") = value
End
Set
but when i run my page i get following error:
Type 'System.Data.Linq.DataQuery`1[[DynamicQueries.VW_EmployeeProfile_Filter, DynamicQueries, ersion=1.0.0.0, Culture=neutral, PublicKeyToken=null]]' in Assembly 'System.Data.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' is not marked as serializable
what should i do to get rid of this error. previously i was doing like this:
Private Shared _Query As IQueryable
but problem is that in Multi users environament, Shared variable is making problem, that is why i want to store it in ViewState.
View 4 Replies
Nov 10, 2010
I am passed an IQueryable that might be already be ordered and that therefore might be an OrderedQueryable. I need to apply it a new ordering via reflection, anb before choosing if calling either OrderBy or ThenBy I need to now if the Queryable is IOrderedQueryable.
Now comes the problem! To see if may variable say query is an IOrderedQueryable I do:
IOrderedQueryable orderedQuery = query as IOrderedQueryable;
One might expect orderedQuery be null in case query is not an IOrderedQueryable ! INSTEAD orderedQuery is NEVER NULL. It takes the value of a different type!
I understand that this might happen because of deferred execution...
I tried also: query is IOrderedQueryable and it is always true!
How can I verify if query is actually an IOrderedQueryable before getting an exception when calling ThenBy?
The IQueryable comes from the Entity Framework 4.0
I am able to see it if I access the object that is behind the interface, but this way I would loose the benefif of using interface, and my class might not work with a different implementation of the IQueryable.
View 2 Replies
May 18, 2010
How do I select multiple columns into IQueryable<Employee>?
View 2 Replies
May 26, 2010
I am using System.Linq.Dynamic to create the following query at runtime:
[Code]....
I can then successfully display vMediaQ in a GridView.But I need to be able to access the individual fields (column headers and data) in vMediaQ, which is of type System.Linq.IQueryable.
View 11 Replies
Aug 25, 2010
does a action filter override a controller filter?
View 2 Replies
Aug 4, 2010
I have a query that joins two tables (in Linq) so I usethe result as an Iqueryable. I want the Query result to be displayed in a gridview, but for some reason I see nothing on the gridview.(I also tried without the join and just using the IQueryable result -and still nothing)
[Code]....
why is doesn't work, or link me to an examlple that is similar - (Also is there another way to use the result of a "join" not as IQueryable)
View 2 Replies
Aug 25, 2010
If I have below code, how to make it work as it has below compile error:
Error: cannot implicitly convert type 'System.Linq.Iqueryable<system.data.DataSet> to 'System.Data.Dateset'. An explicit conversion exists.
public DataSet GetProductList()
{
using (var sdatabase = new DatabaseDataContext())
{
IQueryable<DataSet> result = wmsdatabase.ExecuteQuery<DataSet>(@"SELECT productid, productname from product group by productid, productname").AsQueryable();
return result; // Compile error here
}
}
View 1 Replies
Jan 11, 2011
My situation is as follows:
I do some filtering on the IQueryable<MyType> object using the Contains() function in Linq, which in effect adds: MyColumn LIKE '%@MyParameter%' to the linq requestI want to make the function more generic, which could operate on a IQueryable object of an unknown type. In such case I do not know the type yet, therefore I can not add a standard .Contains() function. All I have present are the IQueryable object, the MyColumn and MyParameter as a string text. I need to be able to add "MyColumn LIKE '%@MyParameter%'" to the Linq object, dynamically ...
How can I write a piece of code that would run the Contains() on the IQueryable, knowing the Column name (as string) and the parameter value (as a string too) - I basically want to add this: MyColumn LIKE '%@MyParameter%' to the Linq where clause.
I have found something doing the .Where() function dynamically, but I do not entirely understand what is happening in there, so I struggle to convert it to Contains():
[Code]....
adding dynamic .Contains() to the IQueryable object only using the string column name and the string value
View 3 Replies
Jan 28, 2010
I would like to know how to change the languages for web project. Because my project should need to meet the requirement of language need to be changing according to the selection of languages from dropdown. How it is interacting with many of languages.
View 5 Replies
Jan 24, 2011
I use ASP.NET C# in a Web Application Project (not web site).
I would like use ASP.NET Theme feature for my Web Application.
From the root of my project I am able to create a special folder App_Themes
Root/App_Themes --WORKS
but I need have App_Themes folder in a different level, in my case:
Root/Cms/App_Themes --DOES NOT WOEK
I notice that Visual Studio does not allow insert an App_Themes in a sub folder.
View 2 Replies
Jul 21, 2010
So, most of the MVC examples I find are C#, so I seem to have trouble finding samples ....(bear with me, I'm a newbie) with that said, if anyone can point me in the right direction,
I simply want to be able to apply htmlattributes / styles to my select box
[Code]....
View 4 Replies
Feb 16, 2011
I have a root folder college when you type in server/college/science it will ask for the user name and password.
(The usename and password are stored in controlpanel->administartivetools->computermanagement->localusersandgroups->users
userid is Test and password is PWD
Now I addea a folder in college
so when I type in college/english it is not asking me for the user id and password. It is showing the content directly.
How can I make english folder ask for the userrid and pasword stored in users (Test)
View 1 Replies
Dec 7, 2010
I am trying to apply themes to my site using profiles. So in my web.config file I need to write the code so that once that user logs in, then the theme of the site changes. Right now I just have color themes; yellow, blue, and orange.
If this isn't in the right section feel free to move it.
View 2 Replies
