Detailsview Update Doesn't Update Database RSS

• • Reply
  mavila

  Member

  11 Points

  89 Posts

  Detailsview Update Doesn't Update Database

  Jun 15, 2016 04:55 AM|mavila|LINK

  I've done this a number of times, but I can't figure out why I can't get it to work on this one. I have a gridview control that the user can select one of the items and then a detailsview control is populated with the item's details for editing/updating.  I have some templatefields in the detailsview with some dropdownlists and textbox controls.  In the detailsview control's itemupdating event, I assign some values to the parameters for the templatefield controls.

  Everything seems to run fine.  When I check the values in the itemupdating event, everything is just as it should be.  There are no errors generated but the database is not updated.  Any help is greatly appreciated.

  Here's the detailsview control:

  <asp:DetailsView ID="dvUAHAComponent" runat="server" AutoGenerateRows="False" BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" DataKeyNames="ID" DataSourceID="sdsUAHAComponent" DefaultMode="Edit" EmptyDataText="No AHA item has been selected." Font-Size="X-Small" Height="50px" Width="400px">
      <AlternatingRowStyle BackColor="Gainsboro" />
      <EditRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
      <FieldHeaderStyle HorizontalAlign="Right" Width="150px" />
      <Fields>
          <asp:BoundField DataField="ID" HeaderText="ID" SortExpression="ID" Visible="False" />
          <asp:TemplateField HeaderText="User ID:" visible="false">
              <EditItemTemplate>
                  <asp:TextBox ID="txtUUserNm" runat="server" Width="250px" Text='<%# Session("LoggedInUserNm") %>'></asp:TextBox>
              </EditItemTemplate>
          </asp:TemplateField>
          <asp:TemplateField HeaderText="Access:" SortExpression="Access">
              <EditItemTemplate>
                  <asp:DropDownList ID="ddlUAccess" runat="server" DataSourceID="sdsAccessType" DataTextField="TypeNm" DataValueField="ID" Width="300px">
                  </asp:DropDownList>
              </EditItemTemplate>
          </asp:TemplateField>
          <asp:TemplateField HeaderText="Operation:">
              <EditItemTemplate>
                  <asp:DropDownList ID="ddlUOp" runat="server" DataSourceID="sdsOp" DataTextField="Op" DataValueField="ID" Width="300px">
                  </asp:DropDownList>
                  <asp:CheckBox ID="chkUOp" runat="server" AutoPostBack="True" OnCheckedChanged="chkUOp_CheckedChanged" Text="Enter a New Operation" />
                  <asp:TextBox ID="txtUOp" runat="server" Visible="false" width="300px"></asp:TextBox>
              </EditItemTemplate>
          </asp:TemplateField>
          <asp:BoundField ControlStyle-Width="300px" DataField="Chrono" HeaderText="Chronology Value:" SortExpression="Chrono">
          </asp:BoundField>
          <asp:BoundField ControlStyle-Width="300px" DataField="Activity" HeaderText="Activity:" SortExpression="Activity">
          </asp:BoundField>
          <asp:BoundField DataField="A_Order" HeaderText="Activity Order:"/>
          <asp:TemplateField HeaderText="Hazard:">
              <EditItemTemplate>
                  <asp:DropDownList ID="ddlUHazard" runat="server" DataSourceID="sdsHazards" DataTextField="Hazard" DataValueField="ID" Width="300px">
                  </asp:DropDownList>
                  <asp:Label ID="lblURAC" runat="server" Text="US Army Corps of Engineers requires that AHAs have a Risk Assessment Code for each hazard:"></asp:Label>
                  <asp:DropDownList ID="ddlURAC" runat="server" Width="300">
                      <asp:ListItem>L - Low</asp:ListItem>
                      <asp:ListItem>M - Medium</asp:ListItem>
                      <asp:ListItem>H - High</asp:ListItem>
                      <asp:ListItem>E - Extremely High</asp:ListItem>
                  </asp:DropDownList>
              </EditItemTemplate>
          </asp:TemplateField>
          <asp:BoundField ControlStyle-Width="300px" DataField="Control" HeaderText="Control:" SortExpression="Control"></asp:BoundField>
          <asp:BoundField ControlStyle-Width="300px" DataField="PPE" HeaderText="PPE:" SortExpression="PPE"></asp:BoundField>
          <asp:TemplateField HeaderText="Codes:">
              <EditItemTemplate>
                  <asp:DropDownList ID="ddlUCodeSource" runat="server" DataSourceID="sdsICodeSource" DataTextField="CodeTypeNm" DataValueField="ID" width="300px"></asp:DropDownList>
                  <asp:TextBox ID="txtUCodeNum" runat="server" width="300px"></asp:TextBox>
                  <asp:Button ID="btnUAddCode" runat="server" OnClick="btnUAddCode_Click" Text="Add to List" />
                  <asp:ListBox ID="lstCodes" runat="server" width="300px"></asp:ListBox>
                  <asp:Button ID="btnClearCodes" runat="server" OnClick="btnClearCodes_Click" Text="Clear List" />
                  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                  <asp:Button ID="btnUDeleteItem" runat="server" OnClick="btnUDeleteItem_Click" Text="Delete Item" />
              </EditItemTemplate>
          </asp:TemplateField>
          <asp:TemplateField HeaderText="Trade:">
              <EditItemTemplate>
                  <asp:DropDownList ID="ddlUTrade" runat="server" DataSourceID="sdsITrade" DataTextField="TradeNm" DataValueField="ID" Width="300px"></asp:DropDownList>
              </EditItemTemplate>
          </asp:TemplateField>
          <asp:TemplateField HeaderText="Jurisdiction">
              <EditItemTemplate>
                  <asp:DropDownList ID="ddlUJurisdiction" runat="server" AutoPostBack="True" DataSourceID="sdsIAHAJurisdiction" DataTextField="Jurisdiction" DataValueField="ID" OnSelectedIndexChanged="ddlUJurisdiction_SelectedIndexChanged" Width="300px"></asp:DropDownList>
              </EditItemTemplate>
          </asp:TemplateField>
          <asp:CommandField ButtonType="Button" ShowEditButton="True" ShowCancelButton="false" />
      </Fields>
      <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
      <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" Width="100%" />
      <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
      <RowStyle BackColor="#EEEEEE" ForeColor="Black" />
  </asp:DetailsView>
  

  Here is the SqlDataSource control:

  <asp:SqlDataSource ID="sdsUAHAComponent" runat="server" ConnectionString="<%$ ConnectionStrings:SafetyDesignsConnectionString %>" SelectCommand="SELECT * FROM [AHA_Main] WHERE ([ID] = @ID)" UpdateCommand="UPDATE [AHA_Main] SET [UserID] = @UserID, [Access] = @Access, [Op] = @Op, [Chrono] = @Chrono, [Activity] = @Activity, [A_Order] = @A_Order, [Hazard] = @Hazard, [Control] = @Control, [PPE] = @PPE, [Trade] = @Trade, [Jurisdiction] = @Jurisdiction, [RAC] = @RAC WHERE [ID] = @ID">
      <SelectParameters>
          <asp:ControlParameter ControlID="gvAHAMain" Name="ID" PropertyName="SelectedValue" Type="Int32" />
      </SelectParameters>
      <UpdateParameters>
          <asp:Parameter Name="UserID" Type="String" />
          <asp:Parameter Name="Access" Type="String" />
          <asp:Parameter Name="Op" Type="String" />
          <asp:Parameter Name="Chrono" Type="String" />
          <asp:Parameter Name="Activity" Type="String" />
          <asp:Parameter Name="A_Order" Type="Int32" />
          <asp:Parameter Name="Hazard" Type="String" />
          <asp:Parameter Name="Control" Type="String" />
          <asp:Parameter Name="PPE" Type="String" />
          <asp:Parameter Name="Trade" Type="String" />
          <asp:Parameter Name="Jurisdiction" Type="String" />
          <asp:Parameter Name="RAC" Type="String" />
          <asp:Parameter Name="ID" Type="Int32" />
      </UpdateParameters>
  </asp:SqlDataSource>
  

  Here is the ItemUpdating event:

      Protected Sub dvUAHAComponent_ItemUpdating(sender As Object, e As DetailsViewUpdateEventArgs) Handles dvUAHAComponent.ItemUpdating
          Call Delete_Code_References()
          Call UpdateCodeReferences()
          Dim ddl1 As DropDownList = DirectCast(Me.dvUAHAComponent.FindControl("ddlUAccess"), DropDownList)
          Dim ddl2 As DropDownList = DirectCast(Me.dvUAHAComponent.FindControl("ddlUOp"), DropDownList)
          Dim ddl2B As DropDownList = DirectCast(Me.dvUAHAComponent.FindControl("ddlUHazard"), DropDownList)
          Dim chk1 As CheckBox = DirectCast(Me.dvUAHAComponent.FindControl("chkUOp"), CheckBox)
          Dim txt1 As TextBox = DirectCast(Me.dvUAHAComponent.FindControl("txtUOp"), TextBox)
          Dim lst1 As ListBox = DirectCast(Me.dvUAHAComponent.FindControl("lstCodes"), ListBox)
          Dim ddl3 As DropDownList = DirectCast(Me.dvUAHAComponent.FindControl("ddlUTrade"), DropDownList)
          Dim ddl4 As DropDownList = DirectCast(Me.dvUAHAComponent.FindControl("ddlUJurisdiction"), DropDownList)
          Dim ddl5 As DropDownList = DirectCast(Me.dvUAHAComponent.FindControl("ddlURAC"), DropDownList)
          e.NewValues("ID") = CInt(gvAHAMain.SelectedDataKey.Value) 'Gets the ID# for the AHA Item from the AHA gridview control
          e.NewValues("Access") = ddl1.SelectedItem.Text
          If chk1.Checked = True Then 'It's a new Operation that has been entered into the textbox control
              e.NewValues("Op") = txt1.Text
          ElseIf chk1.Checked = False Then 'It's an existing Operation that has been entered into the textbox controll
              e.NewValues("Op") = ddl2.SelectedItem.Text
          End If
          e.NewValues("Hazard") = ddl2B.SelectedItem.Text
          e.NewValues("Trade") = ddl3.SelectedItem.Text
          e.NewValues("Jurisdiction") = ddl4.SelectedItem.Text
          e.NewValues("RAC") = ddl5.SelectedItem.Text
      End Sub
  

• • Reply
  Mikesdotnett...

  All-Star

  194030 Points

  28033 Posts

  Moderator

  Re: Detailsview Update Doesn't Update Database

  Jun 15, 2016 07:15 AM|Mikesdotnetting|LINK

  Have you tried using Sql Profiler to see a) if any SQL commands are executed and b) what they contain?

  ASP.NET Tutorials | Learn Entity Framework Core | Learn Razor Pages | Learn Dapper
• • Reply
  mavila

  Member

  11 Points

  89 Posts

  Re: Detailsview Update Doesn't Update Database

  Jun 15, 2016 06:00 PM|mavila|LINK

  Thank you. I'm not familiar with that.  I will check it out.