View Single Post
  #1 (permalink)  
Old July 29th, 2012, 01:36 PM
sophia sophia is offline
Friend of Wrox
Points: 1,469, Level: 15
Points: 1,469, Level: 15 Points: 1,469, Level: 15 Points: 1,469, Level: 15
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2009
Posts: 341
Thanks: 14
Thanked 3 Times in 3 Posts
Smile filter data based on logged in user's Id using EntityDataSource

Greetings to all,
I have a table named DailyCollection. On a page I have GridView, DetailsView and EntityDataSource. Both data bound controls are bound to EntityDataSource.

While inserting record I am saving logged in user's Id in table DailyCollection, but while retrieving records in GridView I have no Idea about how to filter data based on logged in user's id which is stored with every record in DailyCollection table.
So how I write where clause for EntityDataSource so that it filters data based on logged in user's Id?

Please suggest

Thanks
Reply With Quote