Basically.. I am wanting a way to:
When a user logs in, automatically his company (a field in the database) is found and only people from the same company are shown to that user.
Example of what i am looking for.. "if a users companyID is 'Wizards', i want data on the database to be filtered automatically so that he can only see people with a companyID =="
Please any help with this would be much appreciated. Also please not i am doing this using C# and Forms Authentication.
query = From h In query
From ch In h.CustomersHardwaresCollection
Where ch.Customer.Id <> CustomerId.Value
So I try to query where the values are not equal, but I wind up with an empty query when I know there is data there