Rex,

>I have an application that I want to maintain detail records for a header record in a datatable and to save the entire entity (both header and detail) at the same time. I have the details in a GridView and want to edit the information in a series of input controls populated from the GridView datatable having the detail information returned to the GridView database when I select another record or click the Save button
>
>How can I populate the input controls from the selected record in the GridView? I know I can get the primary key and populate the controls from a separate Select, but how does this for a newly added record? How do I get the changed/added information from the controls back into the DataRecord?

I recommend using two different data tables...one that populates a list for the GridView (possibly returning just a few columns) and another that retrieves an individual record with all columns you can use to bind to the other input controls. The easiest way to get the data back into the GridView is to re-retrieve the data.

Best Regards,