- ES Version: 2007 - Trial version
-DB: MSSQL 2005 Express 

Here is what I want to accomplish:

• A page will display 3 DetailsView Controls bound to the same ESDataSource. These DetailsView Controls get their data from the same table. They are separated to facilitate formatting and printing. – Done and working fine.

•  Custom Paging – The 3 Controls must show the same record. – Done and working fine.

- Next” and “Back” buttons allow navigation. Gridview1.DataItemIndex is used to accomplish that.

// Code for the Next button:

 DetailsView1.PageIndex = DetailsView1.DataItemIndex + 1;

•  Each Individual DetailsView Control should have editing capability. – Done and working fine.
  

•  User should be able to type a record ID in a text box, click “find” and DetailView Controls should display the selected data. Here is where I need help…

 - I believe this is not possible through DetailsView: The properties SelectedValue, DataItem, DataKey and Page are read only.

• Here is my question: Can I accomplish this using the ES Collection? I have tried using collection.Filter and collection.Query methods. They will bring up the correct record, but they will mess with my customized paging.

1    // Code in ES_Select
2    
3    CustCustomersCollection CustColl = new CustCustomersCollection();
4    
5    // CustomerID value comes from Textbox and is added to EsDataSource state through "Find Button"
6    
7             if (EsDataSource1.State.ContainsKey("CustomerID"))
8             {
9                 
10                CustColl.Filter = "CustomerID=" +(int)EsDataSource1.State["CustomerID"];          
11    
12   // Tried Query.Where, search works fine, but messes with custom paging
13   
14   //            CustColl.Query.Where(CustColl.Query.CustomerID == (int)EsDataSource1.State["CustomerID"]);
15   
16                CustColl.Query.Load();
17                e.Collection = CustColl;
18                EsDataSource1.State.Clear();
19   
20            }
21   
22            else
23            {
24                CustColl.Query.Load();
25                e.Collection = CustColl;
26   
27            }

 I’m open to suggestions if you think there is a better way to accomplish this. Thanks and your help is appreciated.

Mike, thanks for your help.

I spent the morning trying to get this to work using FindByPrimaryKey() but not matter what I did, the entity value was always null...

Here is an example:

1    Customers entity = Collection.FindByPrimaryKey(21);

PK 21 does exist in my database... What am I doing wrong?

Mike, 

No sure I understand your post. I did use Find and yes, I am trying to find a particular entity in the collection.

I tried to use FindByPrimaryKey(), but was not able to pass that value to the DetailsView control.

I used it as described in this post: http://community.entityspaces.net/forums/thread/1601.aspx , then tried to pass the value of the entity to the query.load() method and bind it to the gridview. When debugging the application, VS2005 showed that null was passed to the entity from the FindByPrimaryKey() method.

Thanks.