I'm new to this. I need create a master/details web page (using Visual Web Developer) that shows the master record in a DetailsView and related details records in a GridView and be able to add new detail records. New detail records should take the Primary key from the master record and write it to the detail record.

Anyone familiar with MS Access will know the sort of thing - Subforms.

If a slightly different strategy is used in web forms, that's fine - maybe a button or hyperlink that says add new, which would then show another details view (populated with primary key).

I've spent ages looking for an answer to this simple problem. Any help would be greatly appreciated.

I would prefer to use sqlDataSource, but happy going with ObjectDataSource/BLL.

Thanks

Daz

Hello,

Can anyone answer this query?

Have I posted this in the correct forum?

Thanks in anticipation


Daz

what i understand that you have grid and details view. all record are in Gridview and details are in details view. oyu want any body click on gridview's add button it takes primary key and your added details will be in details view. am i correct?

thanks......

Hi,

Sorry to take so long to get back to you. The scenario is that the details view is the 'master' record (for example customer) and the grid view shows the detail records (e.g. customer orders). Like this:

Customer: My Customer
Address: 23 the street, Town, County.
Tel: 01234 567890

Order No Product Cost
1 prod1 £20
2 Prod2 £22

I have seen a fair few examples the other way around, where clicking on the order (shown in a gridview at top of form) would show all details of the order.

Thanks for your post. Hope you can follow-up.


Daz

Dear Amsterdaz,
the primary key of the master record that you are looking for can be captured using the "SelectedValue" property of the DetailsView

string PK=DetailsView1.SelectedValue;

this statement will get the data key value of the current record in the detailsview