title: ASP.NET Parent-Child DropDownList Controls with DetailsView
body: <p>After fixed from previous issue about paren-child dropdownlist, I wanted to make detailsview display result after when child dropdownlist(databasename) is selected. I tried to add control in sqldatasource in detailview, it seem doesn't work and it show blank. I added @Database in SelectCommand on SQLDataSource.
   Here is Parent-Child dropdownlist code,</p>
  
  <pre><code>&lt;asp:Label ID="Label9" runat="server" Text="Select Server:"&gt;&lt;/asp:Label&gt;
      &lt;br /&gt;
      &lt;asp:DropDownList ID="DropDownServerName" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource2" DataTextField="ServerName" DataValueField="ServerName"&gt;
      &lt;/asp:DropDownList&gt;
      &lt;asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="&lt;%$ ConnectionStrings:Database_Shared_NotebookConnectionString %&gt;" SelectCommand="SELECT [ServerName] FROM [tblServer]"&gt;&lt;/asp:SqlDataSource&gt;
      &lt;br /&gt;
      &lt;br /&gt;
      &lt;br /&gt;
      &lt;asp:Label ID="Label10" runat="server" Text="Select Database:"&gt;&lt;/asp:Label&gt;
      &lt;br /&gt;
      &lt;asp:DropDownList ID="DropDownDatabase" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource3" DataTextField="DatabaseName" DataValueField="DatabaseName"&gt;
      &lt;/asp:DropDownList&gt;
      &lt;asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="&lt;%$ ConnectionStrings:Database_Shared_NotebookConnectionString %&gt;" SelectCommand="SELECT [DatabaseName] FROM [tblDatabase] WHERE [ServerName] = @ServerName"&gt;
          &lt;SelectParameters&gt;
              &lt;asp:ControlParameter ControlID="DropDownServerName" Name="ServerName" PropertyName="SelectedValue" /&gt;
          &lt;/SelectParameters&gt;
      &lt;/asp:SqlDataSource&gt;
  </code></pre>
  
  <p>Then DetailsView codes,</p>
  
  <pre><code>&lt;asp:DetailsView ID="DetailsView1" runat="server" AllowPaging="True" AutoGenerateRows="False" DataKeyNames="DatabaseName,ServerName,Instance" DataSourceID="SqlDataSource1" Height="50px" Width="125px" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="3"&gt;
          &lt;EditRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" /&gt;
          &lt;Fields&gt;
              &lt;asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ShowInsertButton="True" /&gt;
              &lt;asp:TemplateField HeaderText="ServerName" SortExpression="ServerName"&gt;
                  &lt;EditItemTemplate&gt;
                      &lt;asp:Label ID="Label1" runat="server" Text='&lt;%# Eval("ServerName") %&gt;'&gt;&lt;/asp:Label&gt;
                  &lt;/EditItemTemplate&gt;
                  &lt;InsertItemTemplate&gt;
                      &lt;asp:DropDownList ID="DropDownList15" runat="server" DataSourceID="servername" DataTextField="ServerName" DataValueField="ServerName" SelectedValue='&lt;%# Bind("ServerName") %&gt;'&gt;
                      &lt;/asp:DropDownList&gt;
                      &lt;asp:SqlDataSource ID="servername" runat="server" ConnectionString="&lt;%$ ConnectionStrings:Database_Shared_NotebookConnectionString %&gt;" SelectCommand="SELECT [ServerName] FROM [tblServer]"&gt;&lt;/asp:SqlDataSource&gt;
                  &lt;/InsertItemTemplate&gt;
                  &lt;ItemTemplate&gt;
                      &lt;asp:Label ID="Label8" runat="server" Text='&lt;%# Bind("ServerName") %&gt;'&gt;&lt;/asp:Label&gt;
                  &lt;/ItemTemplate&gt;
              &lt;/asp:TemplateField&gt;
              &lt;asp:BoundField DataField="Instance" HeaderText="Instance" ReadOnly="True" SortExpression="Instance" /&gt;
              &lt;asp:BoundField DataField="DatabaseName" HeaderText="DatabaseName" ReadOnly="True" SortExpression="DatabaseName" /&gt;
              &lt;asp:BoundField DataField="InstanceOccurence" HeaderText="InstanceOccurence" SortExpression="InstanceOccurence" /&gt;
              &lt;asp:BoundField DataField="OccurenceNormalState" HeaderText="OccurenceNormalState" SortExpression="OccurenceNormalState" /&gt;
              &lt;asp:BoundField DataField="SupportedFuntionalArea" HeaderText="SupportedFuntionalArea" SortExpression="SupportedFuntionalArea" /&gt;
              &lt;asp:TemplateField HeaderText="Primary_DBA" SortExpression="Primary_DBA"&gt;
                  &lt;EditItemTemplate&gt;
                      &lt;asp:DropDownList ID="DropDownList2" runat="server" DataSourceID="userid" DataTextField="UserID" DataValueField="UserID" SelectedValue='&lt;%# Bind("Primary_DBA") %&gt;'&gt;
                      &lt;/asp:DropDownList&gt;
                      &lt;asp:SqlDataSource ID="userid" runat="server" ConnectionString="&lt;%$ ConnectionStrings:Database_Shared_NotebookConnectionString %&gt;" SelectCommand="SELECT [UserID] FROM [tblDBA]"&gt;&lt;/asp:SqlDataSource&gt;
                  &lt;/EditItemTemplate&gt;
                  &lt;InsertItemTemplate&gt;
                      &lt;asp:DropDownList ID="DropDownList8" runat="server" DataSourceID="userid" DataTextField="UserID" DataValueField="UserID" SelectedValue='&lt;%# Bind("Primary_DBA") %&gt;'&gt;
                      &lt;/asp:DropDownList&gt;
                      &lt;asp:SqlDataSource ID="userid" runat="server" ConnectionString="&lt;%$ ConnectionStrings:Database_Shared_NotebookConnectionString %&gt;" SelectCommand="SELECT [UserID] FROM [tblDBA]"&gt;&lt;/asp:SqlDataSource&gt;
                  &lt;/InsertItemTemplate&gt;
                  &lt;ItemTemplate&gt;
                      &lt;asp:Label ID="Label2" runat="server" Text='&lt;%# Bind("Primary_DBA") %&gt;'&gt;&lt;/asp:Label&gt;
                  &lt;/ItemTemplate&gt;
              &lt;/asp:TemplateField&gt;
              &lt;asp:BoundField DataField="Quarter_Close_Vital" HeaderText="Quarter_Close_Vital" SortExpression="Quarter_Close_Vital" /&gt;
              &lt;asp:BoundField DataField="Business_Importance" HeaderText="Business_Importance" SortExpression="Business_Importance" /&gt;
              &lt;asp:BoundField DataField="Application_Number" HeaderText="Application_Number" SortExpression="Application_Number" /&gt;
              &lt;asp:BoundField DataField="Portfolio_Lookup" HeaderText="Portfolio_Lookup" SortExpression="Portfolio_Lookup" /&gt;
              &lt;asp:BoundField DataField="Description" HeaderText="Description" SortExpression="Description" /&gt;
              &lt;asp:TemplateField HeaderText="WorkProcess" SortExpression="WorkProcess"&gt;
                  &lt;EditItemTemplate&gt;
                      &lt;asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="workprocess" DataTextField="WorkProcess" DataValueField="WorkProcess" SelectedValue='&lt;%# Bind("WorkProcess") %&gt;'&gt;
                      &lt;/asp:DropDownList&gt;
                      &lt;asp:SqlDataSource ID="workprocess" runat="server" ConnectionString="&lt;%$ ConnectionStrings:Database_Shared_NotebookConnectionString %&gt;" SelectCommand="SELECT [WorkProcess] FROM [tblWorkProcess]"&gt;&lt;/asp:SqlDataSource&gt;
                  &lt;/EditItemTemplate&gt;
                  &lt;InsertItemTemplate&gt;
                      &lt;asp:DropDownList ID="DropDownList9" runat="server" DataSourceID="workprocess" DataTextField="WorkProcess" DataValueField="WorkProcess" SelectedValue='&lt;%# Bind("WorkProcess") %&gt;'&gt;
                      &lt;/asp:DropDownList&gt;
                      &lt;asp:SqlDataSource ID="workprocess" runat="server" ConnectionString="&lt;%$ ConnectionStrings:Database_Shared_NotebookConnectionString %&gt;" SelectCommand="SELECT [WorkProcess] FROM [tblWorkProcess]"&gt;&lt;/asp:SqlDataSource&gt;
                  &lt;/InsertItemTemplate&gt;
                  &lt;ItemTemplate&gt;
                      &lt;asp:Label ID="Label1" runat="server" Text='&lt;%# Bind("WorkProcess") %&gt;'&gt;&lt;/asp:Label&gt;
                  &lt;/ItemTemplate&gt;
              &lt;/asp:TemplateField&gt;
              &lt;asp:BoundField DataField="Data_Owner_1" HeaderText="Data_Owner_1" SortExpression="Data_Owner_1" /&gt;
              &lt;asp:BoundField DataField="Data_Owner_2" HeaderText="Data_Owner_2" SortExpression="Data_Owner_2" /&gt;
              &lt;asp:TemplateField HeaderText="TMASGroupNumber" SortExpression="TMASGroupNumber"&gt;
                  &lt;EditItemTemplate&gt;
                      &lt;asp:DropDownList ID="DropDownList3" runat="server" DataSourceID="TMAS" DataTextField="TMASGroupNumber" DataValueField="TMASGroupNumber" SelectedValue='&lt;%# Bind("TMASGroupNumber") %&gt;'&gt;
                      &lt;/asp:DropDownList&gt;
                      &lt;asp:SqlDataSource ID="TMAS" runat="server" ConnectionString="&lt;%$ ConnectionStrings:Database_Shared_NotebookConnectionString %&gt;" SelectCommand="SELECT [TMASGroupNumber] FROM [tblTM_AS]"&gt;&lt;/asp:SqlDataSource&gt;
                  &lt;/EditItemTemplate&gt;
                  &lt;InsertItemTemplate&gt;
                      &lt;asp:DropDownList ID="DropDownList10" runat="server" DataSourceID="TMAS" DataTextField="TMASGroupNumber" DataValueField="TMASGroupNumber" SelectedValue='&lt;%# Bind("TMASGroupNumber") %&gt;'&gt;
                      &lt;/asp:DropDownList&gt;
                      &lt;asp:SqlDataSource ID="TMAS" runat="server" ConnectionString="&lt;%$ ConnectionStrings:Database_Shared_NotebookConnectionString %&gt;" SelectCommand="SELECT [TMASGroupNumber] FROM [tblTM_AS]"&gt;&lt;/asp:SqlDataSource&gt;
                  &lt;/InsertItemTemplate&gt;
                  &lt;ItemTemplate&gt;
                      &lt;asp:Label ID="Label3" runat="server" Text='&lt;%# Bind("TMASGroupNumber") %&gt;'&gt;&lt;/asp:Label&gt;
                  &lt;/ItemTemplate&gt;
              &lt;/asp:TemplateField&gt;
              &lt;asp:TemplateField HeaderText="TMLASGroupNumber" SortExpression="TMLASGroupNumber"&gt;
                  &lt;EditItemTemplate&gt;
                      &lt;asp:DropDownList ID="DropDownList4" runat="server" DataSourceID="TMLAS" DataTextField="TMLASGroupNumber" DataValueField="TMLASGroupNumber" SelectedValue='&lt;%# Bind("TMLASGroupNumber") %&gt;'&gt;
                      &lt;/asp:DropDownList&gt;
                      &lt;asp:SqlDataSource ID="TMLAS" runat="server" ConnectionString="&lt;%$ ConnectionStrings:Database_Shared_NotebookConnectionString %&gt;" SelectCommand="SELECT [TMLASGroupNumber] FROM [tblTM_LAS]"&gt;&lt;/asp:SqlDataSource&gt;
                  &lt;/EditItemTemplate&gt;
                  &lt;InsertItemTemplate&gt;
                      &lt;asp:DropDownList ID="DropDownList11" runat="server" DataSourceID="TMLAS" DataTextField="TMLASGroupNumber" DataValueField="TMLASGroupNumber" SelectedValue='&lt;%# Bind("TMLASGroupNumber") %&gt;'&gt;
                      &lt;/asp:DropDownList&gt;
                      &lt;asp:SqlDataSource ID="TMLAS" runat="server" ConnectionString="&lt;%$ ConnectionStrings:Database_Shared_NotebookConnectionString %&gt;" SelectCommand="SELECT [TMLASGroupNumber] FROM [tblTM_LAS]"&gt;&lt;/asp:SqlDataSource&gt;
                  &lt;/InsertItemTemplate&gt;
                  &lt;ItemTemplate&gt;
                      &lt;asp:Label ID="Label4" runat="server" Text='&lt;%# Bind("TMLASGroupNumber") %&gt;'&gt;&lt;/asp:Label&gt;
                  &lt;/ItemTemplate&gt;
              &lt;/asp:TemplateField&gt;
              &lt;asp:TemplateField HeaderText="IIASGroupNumber" SortExpression="IIASGroupNumber"&gt;
                  &lt;EditItemTemplate&gt;
                      &lt;asp:DropDownList ID="DropDownList5" runat="server" DataSourceID="IIAS" DataTextField="IIASGroupNumber" DataValueField="IIASGroupNumber" SelectedValue='&lt;%# Bind("IIASGroupNumber") %&gt;'&gt;
                      &lt;/asp:DropDownList&gt;
                      &lt;asp:SqlDataSource ID="IIAS" runat="server" ConnectionString="&lt;%$ ConnectionStrings:Database_Shared_NotebookConnectionString %&gt;" SelectCommand="SELECT [IIASGroupNumber] FROM [tblII_AS]"&gt;&lt;/asp:SqlDataSource&gt;
                  &lt;/EditItemTemplate&gt;
                  &lt;InsertItemTemplate&gt;
                      &lt;asp:DropDownList ID="DropDownList12" runat="server" DataSourceID="IIAS" DataTextField="IIASGroupNumber" DataValueField="IIASGroupNumber" SelectedValue='&lt;%# Bind("IIASGroupNumber") %&gt;'&gt;
                      &lt;/asp:DropDownList&gt;
                      &lt;asp:SqlDataSource ID="IIAS" runat="server" ConnectionString="&lt;%$ ConnectionStrings:Database_Shared_NotebookConnectionString %&gt;" SelectCommand="SELECT [IIASGroupNumber] FROM [tblII_AS]"&gt;&lt;/asp:SqlDataSource&gt;
                  &lt;/InsertItemTemplate&gt;
                  &lt;ItemTemplate&gt;
                      &lt;asp:Label ID="Label5" runat="server" Text='&lt;%# Bind("IIASGroupNumber") %&gt;'&gt;&lt;/asp:Label&gt;
                  &lt;/ItemTemplate&gt;
              &lt;/asp:TemplateField&gt;
              &lt;asp:BoundField DataField="Backup_Nodes" HeaderText="Backup_Nodes" SortExpression="Backup_Nodes" /&gt;
              &lt;asp:BoundField DataField="ConnectionString" HeaderText="ConnectionString" SortExpression="ConnectionString" /&gt;
              &lt;asp:BoundField DataField="Notes" HeaderText="Notes" SortExpression="Notes" /&gt;
              &lt;asp:BoundField DataField="Role_Based_Security_Doc" HeaderText="Role_Based_Security_Doc" SortExpression="Role_Based_Security_Doc" /&gt;
              &lt;asp:BoundField DataField="Alias" HeaderText="Alias" SortExpression="Alias" /&gt;
              &lt;asp:TemplateField HeaderText="Architecture" SortExpression="Architecture"&gt;
                  &lt;EditItemTemplate&gt;
                      &lt;asp:DropDownList ID="DropDownList6" runat="server" SelectedValue='&lt;%# Bind("Architecture") %&gt;'&gt;
                          &lt;asp:ListItem&gt;BSN EAP&lt;/asp:ListItem&gt;
                          &lt;asp:ListItem&gt;BSN NEA&lt;/asp:ListItem&gt;
                          &lt;asp:ListItem&gt;BSNConnect.com&lt;/asp:ListItem&gt;
                          &lt;asp:ListItem&gt;BSNDMZ.COM&lt;/asp:ListItem&gt;
                          &lt;asp:ListItem&gt;Dow EAP&lt;/asp:ListItem&gt;
                          &lt;asp:ListItem&gt;Dow NEA&lt;/asp:ListItem&gt;
                      &lt;/asp:DropDownList&gt;
                  &lt;/EditItemTemplate&gt;
                  &lt;InsertItemTemplate&gt;
                      &lt;asp:DropDownList ID="DropDownList13" runat="server" SelectedValue='&lt;%# Bind("Architecture") %&gt;'&gt;
                          &lt;asp:ListItem&gt;BSN EAP&lt;/asp:ListItem&gt;
                          &lt;asp:ListItem&gt;BSN NEA&lt;/asp:ListItem&gt;
                          &lt;asp:ListItem&gt;BSNConnect.com&lt;/asp:ListItem&gt;
                          &lt;asp:ListItem&gt;BSNDMZ.COM&lt;/asp:ListItem&gt;
                          &lt;asp:ListItem&gt;Dow EAP&lt;/asp:ListItem&gt;
                          &lt;asp:ListItem&gt;Dow NEA&lt;/asp:ListItem&gt;
                      &lt;/asp:DropDownList&gt;
                  &lt;/InsertItemTemplate&gt;
                  &lt;ItemTemplate&gt;
                      &lt;asp:Label ID="Label6" runat="server" Text='&lt;%# Bind("Architecture") %&gt;'&gt;&lt;/asp:Label&gt;
                  &lt;/ItemTemplate&gt;
              &lt;/asp:TemplateField&gt;
              &lt;asp:BoundField DataField="Max_Users" HeaderText="Max_Users" SortExpression="Max_Users" /&gt;
              &lt;asp:BoundField DataField="Projected_Growth" HeaderText="Projected_Growth" SortExpression="Projected_Growth" /&gt;
              &lt;asp:BoundField DataField="Storage_Requirements" HeaderText="Storage_Requirements" SortExpression="Storage_Requirements" /&gt;
              &lt;asp:BoundField DataField="SID" HeaderText="SID" SortExpression="SID" /&gt;
              &lt;asp:TemplateField HeaderText="Version" SortExpression="Version"&gt;
                  &lt;EditItemTemplate&gt;
                      &lt;asp:DropDownList ID="DropDownList7" runat="server" SelectedValue='&lt;%# Bind("Version") %&gt;'&gt;
                          &lt;asp:ListItem&gt;Oracle 11g&lt;/asp:ListItem&gt;
                          &lt;asp:ListItem&gt;Oracle 11g R2&lt;/asp:ListItem&gt;
                          &lt;asp:ListItem&gt;SQL Server 2008&lt;/asp:ListItem&gt;
                          &lt;asp:ListItem&gt;SQL Server 2008 R2&lt;/asp:ListItem&gt;
                          &lt;asp:ListItem&gt;SQL Server 2012&lt;/asp:ListItem&gt;
                          &lt;asp:ListItem&gt;SQL Svr 2008 R2 SS%S&lt;/asp:ListItem&gt;
                          &lt;asp:ListItem&gt;SQL Svr 2012 SS%S&lt;/asp:ListItem&gt;
                      &lt;/asp:DropDownList&gt;
                  &lt;/EditItemTemplate&gt;
                  &lt;InsertItemTemplate&gt;
                      &lt;asp:DropDownList ID="DropDownList14" runat="server" SelectedValue='&lt;%# Bind("Version") %&gt;'&gt;
                          &lt;asp:ListItem&gt;Oracle 11g&lt;/asp:ListItem&gt;
                          &lt;asp:ListItem&gt;Oracle 11g R2&lt;/asp:ListItem&gt;
                          &lt;asp:ListItem&gt;SQL Server 2008&lt;/asp:ListItem&gt;
                          &lt;asp:ListItem&gt;SQL Server 2008 R2&lt;/asp:ListItem&gt;
                          &lt;asp:ListItem&gt;SQL Server 2012&lt;/asp:ListItem&gt;
                          &lt;asp:ListItem&gt;SQL Svr 2008 R2 SS%S&lt;/asp:ListItem&gt;
                          &lt;asp:ListItem&gt;SQL Svr 2012 SS%S&lt;/asp:ListItem&gt;
                      &lt;/asp:DropDownList&gt;
                  &lt;/InsertItemTemplate&gt;
                  &lt;ItemTemplate&gt;
                      &lt;asp:Label ID="Label7" runat="server" Text='&lt;%# Bind("Version") %&gt;'&gt;&lt;/asp:Label&gt;
                  &lt;/ItemTemplate&gt;
              &lt;/asp:TemplateField&gt;
          &lt;/Fields&gt;
          &lt;FooterStyle BackColor="White" ForeColor="#000066" /&gt;
          &lt;HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" /&gt;
          &lt;PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" /&gt;
          &lt;RowStyle ForeColor="#000066" /&gt;
      &lt;/asp:DetailsView&gt;
      &lt;asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues" ConnectionString="&lt;%$ ConnectionStrings:Database_Shared_NotebookConnectionString %&gt;" DeleteCommand="DELETE FROM [tblDatabase] WHERE [DatabaseName] = @original_DatabaseName AND [ServerName] = @original_ServerName AND [Instance] = @original_Instance AND [WorkProcess] = @original_WorkProcess AND [Primary_DBA] = @original_Primary_DBA AND [TMLASGroupNumber] = @original_TMLASGroupNumber AND [TMASGroupNumber] = @original_TMASGroupNumber AND [IIASGroupNumber] = @original_IIASGroupNumber AND (([Architecture] = @original_Architecture) OR ([Architecture] IS NULL AND @original_Architecture IS NULL)) AND (([Version] = @original_Version) OR ([Version] IS NULL AND @original_Version IS NULL)) AND (([Quarter_Close_Vital] = @original_Quarter_Close_Vital) OR ([Quarter_Close_Vital] IS NULL AND @original_Quarter_Close_Vital IS NULL)) AND (([Business_Importance] = @original_Business_Importance) OR ([Business_Importance] IS NULL AND @original_Business_Importance IS NULL)) AND (([Application_Number] = @original_Application_Number) OR ([Application_Number] IS NULL AND @original_Application_Number IS NULL)) AND (([Description] = @original_Description) OR ([Description] IS NULL AND @original_Description IS NULL)) AND (([Role_Based_Security_Doc] = @original_Role_Based_Security_Doc) OR ([Role_Based_Security_Doc] IS NULL AND @original_Role_Based_Security_Doc IS NULL)) AND (([Max_Users] = @original_Max_Users) OR ([Max_Users] IS NULL AND @original_Max_Users IS NULL)) AND (([Storage_Requirements] = @original_Storage_Requirements) OR ([Storage_Requirements] IS NULL AND @original_Storage_Requirements IS NULL)) AND (([Projected_Growth] = @original_Projected_Growth) OR ([Projected_Growth] IS NULL AND @original_Projected_Growth IS NULL)) AND (([Data_Owner_1] = @original_Data_Owner_1) OR ([Data_Owner_1] IS NULL AND @original_Data_Owner_1 IS NULL)) AND (([Data_Owner_2] = @original_Data_Owner_2) OR ([Data_Owner_2] IS NULL AND @original_Data_Owner_2 IS NULL)) AND (([SID] = @original_SID) OR ([SID] IS NULL AND @original_SID IS NULL)) AND (([Alias] = @original_Alias) OR ([Alias] IS NULL AND @original_Alias IS NULL)) AND (([Backup_Nodes] = @original_Backup_Nodes) OR ([Backup_Nodes] IS NULL AND @original_Backup_Nodes IS NULL)) AND (([Portfolio_Lookup] = @original_Portfolio_Lookup) OR ([Portfolio_Lookup] IS NULL AND @original_Portfolio_Lookup IS NULL)) AND (([Notes] = @original_Notes) OR ([Notes] IS NULL AND @original_Notes IS NULL)) AND (([ConnectionString] = @original_ConnectionString) OR ([ConnectionString] IS NULL AND @original_ConnectionString IS NULL)) AND (([InstanceOccurence] = @original_InstanceOccurence) OR ([InstanceOccurence] IS NULL AND @original_InstanceOccurence IS NULL)) AND (([OccurenceNormalState] = @original_OccurenceNormalState) OR ([OccurenceNormalState] IS NULL AND @original_OccurenceNormalState IS NULL)) AND (([SupportedFuntionalArea] = @original_SupportedFuntionalArea) OR ([SupportedFuntionalArea] IS NULL AND @original_SupportedFuntionalArea IS NULL))" InsertCommand="INSERT INTO [tblDatabase] ([DatabaseName], [ServerName], [WorkProcess], [Primary_DBA], [TMLASGroupNumber], [TMASGroupNumber], [IIASGroupNumber], [Architecture], [Version], [Quarter_Close_Vital], [Business_Importance], [Application_Number], [Description], [Role_Based_Security_Doc], [Max_Users], [Storage_Requirements], [Projected_Growth], [Data_Owner_1], [Data_Owner_2], [SID], [Alias], [Instance], [Backup_Nodes], [Portfolio_Lookup], [Notes], [ConnectionString], [InstanceOccurence], [OccurenceNormalState], [SupportedFuntionalArea]) VALUES (@DatabaseName, @ServerName, @WorkProcess, @Primary_DBA, @TMLASGroupNumber, @TMASGroupNumber, @IIASGroupNumber, @Architecture, @Version, @Quarter_Close_Vital, @Business_Importance, @Application_Number, @Description, @Role_Based_Security_Doc, @Max_Users, @Storage_Requirements, @Projected_Growth, @Data_Owner_1, @Data_Owner_2, @SID, @Alias, @Instance, @Backup_Nodes, @Portfolio_Lookup, @Notes, @ConnectionString, @InstanceOccurence, @OccurenceNormalState, @SupportedFuntionalArea)" OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [tblDatabase] WHERE [DatabaseName] = @DatabaseName" UpdateCommand="UPDATE [tblDatabase] SET [WorkProcess] = @WorkProcess, [Primary_DBA] = @Primary_DBA, [TMLASGroupNumber] = @TMLASGroupNumber, [TMASGroupNumber] = @TMASGroupNumber, [IIASGroupNumber] = @IIASGroupNumber, [Architecture] = @Architecture, [Version] = @Version, [Quarter_Close_Vital] = @Quarter_Close_Vital, [Business_Importance] = @Business_Importance, [Application_Number] = @Application_Number, [Description] = @Description, [Role_Based_Security_Doc] = @Role_Based_Security_Doc, [Max_Users] = @Max_Users, [Storage_Requirements] = @Storage_Requirements, [Projected_Growth] = @Projected_Growth, [Data_Owner_1] = @Data_Owner_1, [Data_Owner_2] = @Data_Owner_2, [SID] = @SID, [Alias] = @Alias, [Backup_Nodes] = @Backup_Nodes, [Portfolio_Lookup] = @Portfolio_Lookup, [Notes] = @Notes, [ConnectionString] = @ConnectionString, [InstanceOccurence] = @InstanceOccurence, [OccurenceNormalState] = @OccurenceNormalState, [SupportedFuntionalArea] = @SupportedFuntionalArea WHERE [DatabaseName] = @original_DatabaseName AND [ServerName] = @original_ServerName AND [Instance] = @original_Instance AND [WorkProcess] = @original_WorkProcess AND [Primary_DBA] = @original_Primary_DBA AND [TMLASGroupNumber] = @original_TMLASGroupNumber AND [TMASGroupNumber] = @original_TMASGroupNumber AND [IIASGroupNumber] = @original_IIASGroupNumber AND (([Architecture] = @original_Architecture) OR ([Architecture] IS NULL AND @original_Architecture IS NULL)) AND (([Version] = @original_Version) OR ([Version] IS NULL AND @original_Version IS NULL)) AND (([Quarter_Close_Vital] = @original_Quarter_Close_Vital) OR ([Quarter_Close_Vital] IS NULL AND @original_Quarter_Close_Vital IS NULL)) AND (([Business_Importance] = @original_Business_Importance) OR ([Business_Importance] IS NULL AND @original_Business_Importance IS NULL)) AND (([Application_Number] = @original_Application_Number) OR ([Application_Number] IS NULL AND @original_Application_Number IS NULL)) AND (([Description] = @original_Description) OR ([Description] IS NULL AND @original_Description IS NULL)) AND (([Role_Based_Security_Doc] = @original_Role_Based_Security_Doc) OR ([Role_Based_Security_Doc] IS NULL AND @original_Role_Based_Security_Doc IS NULL)) AND (([Max_Users] = @original_Max_Users) OR ([Max_Users] IS NULL AND @original_Max_Users IS NULL)) AND (([Storage_Requirements] = @original_Storage_Requirements) OR ([Storage_Requirements] IS NULL AND @original_Storage_Requirements IS NULL)) AND (([Projected_Growth] = @original_Projected_Growth) OR ([Projected_Growth] IS NULL AND @original_Projected_Growth IS NULL)) AND (([Data_Owner_1] = @original_Data_Owner_1) OR ([Data_Owner_1] IS NULL AND @original_Data_Owner_1 IS NULL)) AND (([Data_Owner_2] = @original_Data_Owner_2) OR ([Data_Owner_2] IS NULL AND @original_Data_Owner_2 IS NULL)) AND (([SID] = @original_SID) OR ([SID] IS NULL AND @original_SID IS NULL)) AND (([Alias] = @original_Alias) OR ([Alias] IS NULL AND @original_Alias IS NULL)) AND (([Backup_Nodes] = @original_Backup_Nodes) OR ([Backup_Nodes] IS NULL AND @original_Backup_Nodes IS NULL)) AND (([Portfolio_Lookup] = @original_Portfolio_Lookup) OR ([Portfolio_Lookup] IS NULL AND @original_Portfolio_Lookup IS NULL)) AND (([Notes] = @original_Notes) OR ([Notes] IS NULL AND @original_Notes IS NULL)) AND (([ConnectionString] = @original_ConnectionString) OR ([ConnectionString] IS NULL AND @original_ConnectionString IS NULL)) AND (([InstanceOccurence] = @original_InstanceOccurence) OR ([InstanceOccurence] IS NULL AND @original_InstanceOccurence IS NULL)) AND (([OccurenceNormalState] = @original_OccurenceNormalState) OR ([OccurenceNormalState] IS NULL AND @original_OccurenceNormalState IS NULL)) AND (([SupportedFuntionalArea] = @original_SupportedFuntionalArea) OR ([SupportedFuntionalArea] IS NULL AND @original_SupportedFuntionalArea IS NULL))"&gt;
          &lt;SelectParameters&gt;
              &lt;asp:ControlParameter ControlID="DropDownDatabase" Name="DatabaseName" PropertyName="SelectedValue"/&gt;
          &lt;/SelectParameters&gt;
              &lt;UpdateParameters&gt;
              &lt;asp:Parameter Name="WorkProcess" Type="String" /&gt;
              &lt;asp:Parameter Name="Primary_DBA" Type="String" /&gt;
              &lt;asp:Parameter Name="TMLASGroupNumber" Type="Int32" /&gt;
              &lt;asp:Parameter Name="TMASGroupNumber" Type="Int32" /&gt;
              &lt;asp:Parameter Name="IIASGroupNumber" Type="Int32" /&gt;
              &lt;asp:Parameter Name="Architecture" Type="String" /&gt;
              &lt;asp:Parameter Name="Version" Type="String" /&gt;
              &lt;asp:Parameter Name="Quarter_Close_Vital" Type="String" /&gt;
              &lt;asp:Parameter Name="Business_Importance" Type="String" /&gt;
              &lt;asp:Parameter Name="Application_Number" Type="String" /&gt;
              &lt;asp:Parameter Name="Description" Type="String" /&gt;
              &lt;asp:Parameter Name="Role_Based_Security_Doc" Type="String" /&gt;
              &lt;asp:Parameter Name="Max_Users" Type="String" /&gt;
              &lt;asp:Parameter Name="Storage_Requirements" Type="String" /&gt;
              &lt;asp:Parameter Name="Projected_Growth" Type="String" /&gt;
              &lt;asp:Parameter Name="Data_Owner_1" Type="String" /&gt;
              &lt;asp:Parameter Name="Data_Owner_2" Type="String" /&gt;
              &lt;asp:Parameter Name="SID" Type="String" /&gt;
              &lt;asp:Parameter Name="Alias" Type="String" /&gt;
              &lt;asp:Parameter Name="Backup_Nodes" Type="String" /&gt;
              &lt;asp:Parameter Name="Portfolio_Lookup" Type="String" /&gt;
              &lt;asp:Parameter Name="Notes" Type="String" /&gt;
              &lt;asp:Parameter Name="ConnectionString" Type="String" /&gt;
              &lt;asp:Parameter Name="InstanceOccurence" Type="Decimal" /&gt;
              &lt;asp:Parameter Name="OccurenceNormalState" Type="String" /&gt;
              &lt;asp:Parameter Name="SupportedFuntionalArea" Type="String" /&gt;
              &lt;asp:Parameter Name="original_DatabaseName" Type="String" /&gt;
              &lt;asp:Parameter Name="original_ServerName" Type="String" /&gt;
              &lt;asp:Parameter Name="original_Instance" Type="String" /&gt;
              &lt;asp:Parameter Name="original_WorkProcess" Type="String" /&gt;
              &lt;asp:Parameter Name="original_Primary_DBA" Type="String" /&gt;
              &lt;asp:Parameter Name="original_TMLASGroupNumber" Type="Int32" /&gt;
              &lt;asp:Parameter Name="original_TMASGroupNumber" Type="Int32" /&gt;
              &lt;asp:Parameter Name="original_IIASGroupNumber" Type="Int32" /&gt;
              &lt;asp:Parameter Name="original_Architecture" Type="String" /&gt;
              &lt;asp:Parameter Name="original_Version" Type="String" /&gt;
              &lt;asp:Parameter Name="original_Quarter_Close_Vital" Type="String" /&gt;
              &lt;asp:Parameter Name="original_Business_Importance" Type="String" /&gt;
              &lt;asp:Parameter Name="original_Application_Number" Type="String" /&gt;
              &lt;asp:Parameter Name="original_Description" Type="String" /&gt;
              &lt;asp:Parameter Name="original_Role_Based_Security_Doc" Type="String" /&gt;
              &lt;asp:Parameter Name="original_Max_Users" Type="String" /&gt;
              &lt;asp:Parameter Name="original_Storage_Requirements" Type="String" /&gt;
              &lt;asp:Parameter Name="original_Projected_Growth" Type="String" /&gt;
              &lt;asp:Parameter Name="original_Data_Owner_1" Type="String" /&gt;
              &lt;asp:Parameter Name="original_Data_Owner_2" Type="String" /&gt;
              &lt;asp:Parameter Name="original_SID" Type="String" /&gt;
              &lt;asp:Parameter Name="original_Alias" Type="String" /&gt;
              &lt;asp:Parameter Name="original_Backup_Nodes" Type="String" /&gt;
              &lt;asp:Parameter Name="original_Portfolio_Lookup" Type="String" /&gt;
              &lt;asp:Parameter Name="original_Notes" Type="String" /&gt;
              &lt;asp:Parameter Name="original_ConnectionString" Type="String" /&gt;
              &lt;asp:Parameter Name="original_InstanceOccurence" Type="Decimal" /&gt;
              &lt;asp:Parameter Name="original_OccurenceNormalState" Type="String" /&gt;
              &lt;asp:Parameter Name="original_SupportedFuntionalArea" Type="String" /&gt;
          &lt;/UpdateParameters&gt;
      &lt;/asp:SqlDataSource&gt;
  </code></pre>