CASE NUMBER: SRX071207601166


To preface, all data access is done through ObjectDatasounces that are bound
to StronglyTyped Datasets (VS.NET generated). All UI controls are bound to
those ObjectDataSources through standard UI binding techniques (point/click).

I have a DetailsView used for inserting records (Companies). Inside that
DetailsView I have added a new column template, this template is going to be
used to add Officers of the company.

Behind the scenes there is a Companies table and a Officers table. The
relationships are N number of Officers to a single company.

My problem is that if I add a DataView in the template to show a list of
Officers, and a DetailsView to that template to allow inserting of new
Officers how do I allow users to insert new Officers of the Company, before
the Company record is actually inserted into the database? I need the
Officers associated with this company, and the user workflow would be
burdened if users had to first create a company, and then move to another
screen to enter Officers and other attributes.





==================CODE==================

<aspetailsView CssClass="CompanyInsertContainer" ID="CompanyDetailsView"
runat="server" AutoGenerateRows="False" DataSourceID="CompanyInfoDS"
DefaultMode="Insert" HeaderText="Add Company" Height="50px"
Width="500px" DataKeyNames="CompanyID" GridLines="Vertical"
HorizontalAlign="Left" OnItemCommand="CompanyDetailsView_ItemCommand"
OnItemInserted="CompanyDetailsView_ItemInserted" Visible="False">
<Fields>
<asp:BoundField DataField="ID" HeaderText="ID"
InsertVisible="False" ReadOnly="True"
SortExpression="ID" />
<asp:TemplateField HeaderText="Officers">
<InsertItemTemplate>
<asp:GridView ID="OfficersGridView" runat="server"
AutoGenerateColumns="False" DataKeyNames="OfficerID"
DataSourceID="OfficerDS" EmptyDataText="No
Officers Defined" GridLines="None" ShowFooter="True">
<Columns>
<asp:CommandField ShowDeleteButton="True"
ShowEditButton="True" />
<asp:BoundField DataField="OfficerID"
HeaderText="OfficerID" InsertVisible="False"
ReadOnly="True"
SortExpression="OfficerID" Visible="False" />
<asp:BoundField DataField="CompanyID"
HeaderText="CompanyID" SortExpression="CompanyID"
Visible="False" />
<asp:BoundField DataField="Name"
HeaderText="Name" SortExpression="Name" />
<asp:BoundField DataField="OfficerTitle"
HeaderText="OfficerTitle" SortExpression="OfficerTitle" />
<asp:BoundField DataField="MailingAddr1"
HeaderText="MailingAddr1" SortExpression="MailingAddr1" />
<asp:BoundField DataField="MailingAddr2"
HeaderText="MailingAddr2" SortExpression="MailingAddr2" />
<asp:BoundField DataField="MailingAddr3"
HeaderText="MailingAddr3" SortExpression="MailingAddr3" />
<asp:BoundField DataField="City"
HeaderText="City" SortExpression="City" />
<asp:TemplateField HeaderText="StateID"
SortExpression="StateID">
<EditItemTemplate>
<asp:TextBox ID="TextBox1"
runat="server" Text='<%# Bind("StateID") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1"
runat="server" Text='<%# Bind("StateID") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="PostalCode"
HeaderText="PostalCode" SortExpression="PostalCode" />
<asp:TemplateField HeaderText="CountryID"
SortExpression="CountryID">
<EditItemTemplate>
<asp:TextBox ID="TextBox2"
runat="server" Text='<%# Bind("CountryID") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2"
runat="server" Text='<%# Bind("CountryID") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<HeaderStyle BackColor="#5D7B9D"
ForeColor="White" />
</asp:GridView>
<asp:ObjectDataSource ID="OfficerDS" runat="server"
DeleteMethod="Delete" InsertMethod="Insert"
OldValuesParameterFormatString="original_{0}"
SelectMethod="GetDataByOfficer"
TypeName="DataObjects.CompanyDataSetTableAdapters. OfficerTableAdapter"
UpdateMethod="Update">
<DeleteParameters>
<asp:Parameter Name="Original_OfficerID"
Type="Int32" />
<asp:Parameter Name="Original_CompanyID"
Type="Int32" />
<asp:Parameter Name="Original_Name"
Type="String" />
<asp:Parameter Name="Original_OfficerTitle"
Type="String" />
<asp:Parameter Name="Original_MailingAddr1"
Type="String" />
<asp:Parameter Name="Original_MailingAddr2"
Type="String" />
<asp:Parameter Name="Original_MailingAddr3"
Type="String" />
<asp:Parameter Name="Original_City"
Type="String" />
<asp:Parameter Name="Original_StateID"
Type="Int32" />
<asp:Parameter Name="Original_PostalCode"
Type="String" />
<asp:Parameter Name="Original_CountryID"
Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="CompanyID" Type="Int32"
/>
<asp:Parameter Name="Name" Type="String" />
<asp:Parameter Name="OfficerTitle"
Type="String" />
<asp:Parameter Name="MailingAddr1"
Type="String" />
<asp:Parameter Name="MailingAddr2"
Type="String" />
<asp:Parameter Name="MailingAddr3"
Type="String" />
<asp:Parameter Name="City" Type="String" />
<asp:Parameter Name="StateID" Type="Int32" />
<asp:Parameter Name="PostalCode"
Type="String" />
<asp:Parameter Name="CountryID" Type="Int32"
/>
<asp:Parameter Name="Original_OfficerID"
Type="Int32" />
<asp:Parameter Name="Original_CompanyID"
Type="Int32" />
<asp:Parameter Name="Original_Name"
Type="String" />
<asp:Parameter Name="Original_OfficerTitle"
Type="String" />
<asp:Parameter Name="Original_MailingAddr1"
Type="String" />
<asp:Parameter Name="Original_MailingAddr2"
Type="String" />
<asp:Parameter Name="Original_MailingAddr3"
Type="String" />
<asp:Parameter Name="Original_City"
Type="String" />
<asp:Parameter Name="Original_StateID"
Type="Int32" />
<asp:Parameter Name="Original_PostalCode"
Type="String" />
<asp:Parameter Name="Original_CountryID"
Type="Int32" />
<asp:Parameter Name="OfficerID" Type="Int32"
/>
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="CompanyID" Type="Int32"
/>
<asp:Parameter Name="Name" Type="String" />
<asp:Parameter Name="OfficerTitle"
Type="String" />
<asp:Parameter Name="MailingAddr1"
Type="String" />
<asp:Parameter Name="MailingAddr2"
Type="String" />
<asp:Parameter Name="MailingAddr3"
Type="String" />
<asp:Parameter Name="City" Type="String" />
<asp:Parameter Name="StateID" Type="Int32" />
<asp:Parameter Name="PostalCode"
Type="String" />
<asp:Parameter Name="CountryID" Type="Int32"
/>
</InsertParameters>
<SelectParameters>
<asp:ControlParameter
ControlID="OfficersGridView" Name="OfficerID" PropertyName="SelectedValue"
Type="Int32" />
</SelectParameters>
</asp:ObjectDataSource>
<aspetailsView ID="OfficersDetailsView"
runat="server" AutoGenerateRows="False"
DataKeyNames="OfficerID"
DataSourceID="OfficerDS" DefaultMode="Insert" Height="50px"
Width="125px">
<Fields>
<asp:BoundField DataField="OfficerID"
HeaderText="OfficerID" InsertVisible="False"
ReadOnly="True"
SortExpression="OfficerID" />
<asp:BoundField DataField="CompanyID"
HeaderText="CompanyID" SortExpression="CompanyID" />
<asp:BoundField DataField="Name"
HeaderText="Name" SortExpression="Name" />
<asp:BoundField DataField="OfficerTitle"
HeaderText="OfficerTitle" SortExpression="OfficerTitle" />
<asp:BoundField DataField="MailingAddr1"
HeaderText="MailingAddr1" SortExpression="MailingAddr1" />
<asp:BoundField DataField="MailingAddr2"
HeaderText="MailingAddr2" SortExpression="MailingAddr2" />
<asp:BoundField DataField="MailingAddr3"
HeaderText="MailingAddr3" SortExpression="MailingAddr3" />
<asp:BoundField DataField="City"
HeaderText="City" SortExpression="City" />
<asp:BoundField DataField="StateID"
HeaderText="StateID" SortExpression="StateID" />
<asp:BoundField DataField="PostalCode"
HeaderText="PostalCode" SortExpression="PostalCode" />
<asp:BoundField DataField="CountryID"
HeaderText="CountryID" SortExpression="CountryID" />
<asp:CommandField ShowEditButton="True"
ShowInsertButton="True" />
</Fields>
</aspetailsView>
<asp:ImageButton ID="ImageButton1" runat="server"
ImageUrl="~/images/add.png" OnClick="ImageButton1_Click" />
</InsertItemTemplate>
</asp:TemplateField>
<asp:CommandField ShowDeleteButton="True"
ShowEditButton="True" ShowInsertButton="True" />
</Fields>
<RowStyle BackColor="#F7F6F3" />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True"
ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
<CommandRowStyle BorderStyle="None" Font-Bold="True" />
</aspetailsView>



<asp:ObjectDataSource ID="CompanyInfoDS" runat="server"
DeleteMethod="Delete" InsertMethod="Insert"
OldValuesParameterFormatString="original_{0}" SelectMethod="GetData"

TypeName="DataObjects.CompanyDataSetTableAdapters. CompanyTableAdapter"
UpdateMethod="Update">
<DeleteParameters>
<asp:Parameter Name="Original_CompanyID" Type="Int32" />
<asp:Parameter Name="Original_ClientID" Type="Int32" />
<asp:Parameter Name="Original_FilerID" Type="Int32" />
<asp:Parameter Name="Original_FileNumber" Type="Int32" />
<asp:Parameter Name="Original_TaxType" Type="String" />
<asp:Parameter Name="Original_FederalID" Type="Int32" />
<asp:Parameter Name="Original_PhoneNumber" Type="String" />
<asp:Parameter Name="Original_InactivityFromDate"
Type="DateTime" />
<asp:Parameter Name="Original_InactivityToDate" Type="DateTime" />
<asp:Parameter Name="Original_RegulatedInvestAssetJan1"
Type="Int64" />
<asp:Parameter Name="Original_RegulatedInvestAssetDec31"
Type="Int64" />
<asp:Parameter Name="Original_FranchiseTax" Type="Decimal" />
<asp:Parameter Name="Original_Penalty" Type="Decimal" />
<asp:Parameter Name="Original_Interest" Type="Decimal" />
<asp:Parameter Name="Original_FilingFee" Type="Decimal" />
<asp:Parameter Name="Original_CheckCharge" Type="Decimal" />
<asp:Parameter Name="Original_CrOrPrePaid" Type="Decimal" />
<asp:Parameter Name="Original_AmountDue" Type="Decimal" />
<asp:Parameter Name="Original_AmountPaid" Type="Decimal" />
<asp:Parameter Name="Original_TaxYear" Type="Int16" />
<asp:Parameter Name="Original_NatureBusiness" Type="String" />
<asp:Parameter Name="Original_PrincipalMailingAddr1"
Type="String" />
<asp:Parameter Name="Original_PrincipalMailingAddr2"
Type="String" />
<asp:Parameter Name="Original_PrincipalMailingAddr3"
Type="String" />
<asp:Parameter Name="Original_PrincipalCity" Type="String" />
<asp:Parameter Name="Original_PrincipalStateID" Type="Int32" />
<asp:Parameter Name="Original_PrincipalPostalCode" Type="String"
/>
<asp:Parameter Name="Original_PrincipalCountryID" Type="Int32" />
<asp:Parameter Name="Original_PrincipalPhoneNumber"
Type="String" />
<asp:Parameter Name="Original_PrincipalPhoneExt" Type="String" />
<asp:Parameter Name="Original_PrincipalEMail" Type="String" />
<asp:Parameter Name="Original_RealEstateInDelaware" Type="Int32"
/>
<asp:Parameter Name="Original_TaxPaidOnRealEstate" Type="Int32" />
<asp:Parameter Name="Original_NumDirectors" Type="Int16" />
<asp:Parameter Name="Original_NoAppointedOfficer" Type="Boolean"
/>
<asp:Parameter Name="Original_NoElectedDirectors" Type="Boolean"
/>
<asp:Parameter Name="Original_DirectorsPDF" Type="String" />
<asp:Parameter Name="Original_Mark" Type="String" />
<asp:Parameter Name="Original_Title" Type="String" />
<asp:Parameter Name="Original_MarkMailingAddr1" Type="String" />
<asp:Parameter Name="Original_MarkMailingAddr2" Type="String" />
<asp:Parameter Name="Original_MarkMailingAddr3" Type="String" />
<asp:Parameter Name="Original_MarkCity" Type="String" />
<asp:Parameter Name="Original_MarkStateID" Type="Int32" />
<asp:Parameter Name="Original_MarkPostalCode" Type="String" />
<asp:Parameter Name="Original_MarkCountryID" Type="Int32" />
<asp:Parameter Name="Original_Date" Type="DateTime" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="ClientID" Type="Int32" />
<asp:Parameter Name="FilerID" Type="Int32" />
<asp:Parameter Name="FileNumber" Type="Int32" />
<asp:Parameter Name="TaxType" Type="String" />
<asp:Parameter Name="FederalID" Type="Int32" />
<asp:Parameter Name="PhoneNumber" Type="String" />
<asp:Parameter Name="InactivityFromDate" Type="DateTime" />
<asp:Parameter Name="InactivityToDate" Type="DateTime" />
<asp:Parameter Name="RegulatedInvestAssetJan1" Type="Int64" />
<asp:Parameter Name="RegulatedInvestAssetDec31" Type="Int64" />
<asp:Parameter Name="FranchiseTax" Type="Decimal" />
<asp:Parameter Name="Penalty" Type="Decimal" />
<asp:Parameter Name="Interest" Type="Decimal" />
<asp:Parameter Name="FilingFee" Type="Decimal" />
<asp:Parameter Name="CheckCharge" Type="Decimal" />
<asp:Parameter Name="CrOrPrePaid" Type="Decimal" />
<asp:Parameter Name="AmountDue" Type="Decimal" />
<asp:Parameter Name="AmountPaid" Type="Decimal" />
<asp:Parameter Name="TaxYear" Type="Int16" />
<asp:Parameter Name="NatureBusiness" Type="String" />
<asp:Parameter Name="PrincipalMailingAddr1" Type="String" />
<asp:Parameter Name="PrincipalMailingAddr2" Type="String" />
<asp:Parameter Name="PrincipalMailingAddr3" Type="String" />
<asp:Parameter Name="PrincipalCity" Type="String" />
<asp:Parameter Name="PrincipalStateID" Type="Int32" />
<asp:Parameter Name="PrincipalPostalCode" Type="String" />
<asp:Parameter Name="PrincipalCountryID" Type="Int32" />
<asp:Parameter Name="PrincipalPhoneNumber" Type="String" />
<asp:Parameter Name="PrincipalPhoneExt" Type="String" />
<asp:Parameter Name="PrincipalEMail" Type="String" />
<asp:Parameter Name="RealEstateInDelaware" Type="Int32" />
<asp:Parameter Name="TaxPaidOnRealEstate" Type="Int32" />
<asp:Parameter Name="NumDirectors" Type="Int16" />
<asp:Parameter Name="NoAppointedOfficer" Type="Boolean" />
<asp:Parameter Name="NoElectedDirectors" Type="Boolean" />
<asp:Parameter Name="DirectorsPDF" Type="String" />
<asp:Parameter Name="Mark" Type="String" />
<asp:Parameter Name="Title" Type="String" />
<asp:Parameter Name="MarkMailingAddr1" Type="String" />
<asp:Parameter Name="MarkMailingAddr2" Type="String" />
<asp:Parameter Name="MarkMailingAddr3" Type="String" />
<asp:Parameter Name="MarkCity" Type="String" />
<asp:Parameter Name="MarkStateID" Type="Int32" />
<asp:Parameter Name="MarkPostalCode" Type="String" />
<asp:Parameter Name="MarkCountryID" Type="Int32" />
<asp:Parameter Name="Date" Type="DateTime" />
<asp:Parameter Name="Original_CompanyID" Type="Int32" />
<asp:Parameter Name="Original_ClientID" Type="Int32" />
<asp:Parameter Name="Original_FilerID" Type="Int32" />
<asp:Parameter Name="Original_FileNumber" Type="Int32" />
<asp:Parameter Name="Original_TaxType" Type="String" />
<asp:Parameter Name="Original_FederalID" Type="Int32" />
<asp:Parameter Name="Original_PhoneNumber" Type="String" />
<asp:Parameter Name="Original_InactivityFromDate"
Type="DateTime" />
<asp:Parameter Name="Original_InactivityToDate" Type="DateTime" />
<asp:Parameter Name="Original_RegulatedInvestAssetJan1"
Type="Int64" />
<asp:Parameter Name="Original_RegulatedInvestAssetDec31"
Type="Int64" />
<asp:Parameter Name="Original_FranchiseTax" Type="Decimal" />
<asp:Parameter Name="Original_Penalty" Type="Decimal" />
<asp:Parameter Name="Original_Interest" Type="Decimal" />
<asp:Parameter Name="Original_FilingFee" Type="Decimal" />
<asp:Parameter Name="Original_CheckCharge" Type="Decimal" />
<asp:Parameter Name="Original_CrOrPrePaid" Type="Decimal" />
<asp:Parameter Name="Original_AmountDue" Type="Decimal" />
<asp:Parameter Name="Original_AmountPaid" Type="Decimal" />
<asp:Parameter Name="Original_TaxYear" Type="Int16" />
<asp:Parameter Name="Original_NatureBusiness" Type="String" />
<asp:Parameter Name="Original_PrincipalMailingAddr1"
Type="String" />
<asp:Parameter Name="Original_PrincipalMailingAddr2"
Type="String" />
<asp:Parameter Name="Original_PrincipalMailingAddr3"
Type="String" />
<asp:Parameter Name="Original_PrincipalCity" Type="String" />
<asp:Parameter Name="Original_PrincipalStateID" Type="Int32" />
<asp:Parameter Name="Original_PrincipalPostalCode" Type="String"
/>
<asp:Parameter Name="Original_PrincipalCountryID" Type="Int32" />
<asp:Parameter Name="Original_PrincipalPhoneNumber"
Type="String" />
<asp:Parameter Name="Original_PrincipalPhoneExt" Type="String" />
<asp:Parameter Name="Original_PrincipalEMail" Type="String" />
<asp:Parameter Name="Original_RealEstateInDelaware" Type="Int32"
/>
<asp:Parameter Name="Original_TaxPaidOnRealEstate" Type="Int32" />
<asp:Parameter Name="Original_NumDirectors" Type="Int16" />
<asp:Parameter Name="Original_NoAppointedOfficer" Type="Boolean"
/>
<asp:Parameter Name="Original_NoElectedDirectors" Type="Boolean"
/>
<asp:Parameter Name="Original_DirectorsPDF" Type="String" />
<asp:Parameter Name="Original_Mark" Type="String" />
<asp:Parameter Name="Original_Title" Type="String" />
<asp:Parameter Name="Original_MarkMailingAddr1" Type="String" />
<asp:Parameter Name="Original_MarkMailingAddr2" Type="String" />
<asp:Parameter Name="Original_MarkMailingAddr3" Type="String" />
<asp:Parameter Name="Original_MarkCity" Type="String" />
<asp:Parameter Name="Original_MarkStateID" Type="Int32" />
<asp:Parameter Name="Original_MarkPostalCode" Type="String" />
<asp:Parameter Name="Original_MarkCountryID" Type="Int32" />
<asp:Parameter Name="Original_Date" Type="DateTime" />
<asp:Parameter Name="CompanyID" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="ClientID" Type="Int32" />
<asp:Parameter Name="FilerID" Type="Int32" />
<asp:Parameter Name="FileNumber" Type="Int32" />
<asp:Parameter Name="TaxType" Type="String" />
<asp:Parameter Name="FederalID" Type="Int32" />
<asp:Parameter Name="PhoneNumber" Type="String" />
<asp:Parameter Name="InactivityFromDate" Type="DateTime" />
<asp:Parameter Name="InactivityToDate" Type="DateTime" />
<asp:Parameter Name="RegulatedInvestAssetJan1" Type="Int64" />
<asp:Parameter Name="RegulatedInvestAssetDec31" Type="Int64" />
<asp:Parameter Name="FranchiseTax" Type="Decimal" />
<asp:Parameter Name="Penalty" Type="Decimal" />
<asp:Parameter Name="Interest" Type="Decimal" />
<asp:Parameter Name="FilingFee" Type="Decimal" />
<asp:Parameter Name="CheckCharge" Type="Decimal" />
<asp:Parameter Name="CrOrPrePaid" Type="Decimal" />
<asp:Parameter Name="AmountDue" Type="Decimal" />
<asp:Parameter Name="AmountPaid" Type="Decimal" />
<asp:Parameter Name="TaxYear" Type="Int16" />
<asp:Parameter Name="NatureBusiness" Type="String" />
<asp:Parameter Name="PrincipalMailingAddr1" Type="String" />
<asp:Parameter Name="PrincipalMailingAddr2" Type="String" />
<asp:Parameter Name="PrincipalMailingAddr3" Type="String" />
<asp:Parameter Name="PrincipalCity" Type="String" />
<asp:Parameter Name="PrincipalStateID" Type="Int32" />
<asp:Parameter Name="PrincipalPostalCode" Type="String" />
<asp:Parameter Name="PrincipalCountryID" Type="Int32" />
<asp:Parameter Name="PrincipalPhoneNumber" Type="String" />
<asp:Parameter Name="PrincipalPhoneExt" Type="String" />
<asp:Parameter Name="PrincipalEMail" Type="String" />
<asp:Parameter Name="RealEstateInDelaware" Type="Int32" />
<asp:Parameter Name="TaxPaidOnRealEstate" Type="Int32" />
<asp:Parameter Name="NumDirectors" Type="Int16" />
<asp:Parameter Name="NoAppointedOfficer" Type="Boolean" />
<asp:Parameter Name="NoElectedDirectors" Type="Boolean" />
<asp:Parameter Name="DirectorsPDF" Type="String" />
<asp:Parameter Name="Mark" Type="String" />
<asp:Parameter Name="Title" Type="String" />
<asp:Parameter Name="MarkMailingAddr1" Type="String" />
<asp:Parameter Name="MarkMailingAddr2" Type="String" />
<asp:Parameter Name="MarkMailingAddr3" Type="String" />
<asp:Parameter Name="MarkCity" Type="String" />
<asp:Parameter Name="MarkStateID" Type="Int32" />
<asp:Parameter Name="MarkPostalCode" Type="String" />
<asp:Parameter Name="MarkCountryID" Type="Int32" />
<asp:Parameter Name="Date" Type="DateTime" />
</InsertParameters>
</asp:ObjectDataSource>

On 7 Dec, 19:56, Tyler Lynch <Tyler Ly... (AT) discussions (DOT) microsoft.com>
wrote:
The Officers table will contain a foreign key (e.g. CompanyID)
pointing to a unique record in the Companies table. When entering
records (or rows) into the Officers table, the foreign key to the
Companies table does not necessarily have to be entered at the same
time, but will need to be updated at some point after the new Officer
entry process. Other processes involving the new Officers could be
carried out if required pending the completion of Company data entry.

To facilitate this the Company ID field could be left null or contain
some default value to show it has not yet been allocated. A query
based on this could be used to present the operator with a list of
Officers with unallocated Companies, as part of a subsequent data
entry process carried out after the new Company records have been
entered.

Any use?