FileUpload in EditItemtemplate in Formview RSS

• • Reply
  

  dave13

  Member

  29 Points

  30 Posts

  FileUpload in EditItemtemplate in Formview

  May 04, 2012 08:59 PM|LINK

  I want to allow user to change the image(Stored as varbinary(max)) in the edit template in Formview.

  This works when the fileupload is populated but I want to allow the user to leave the old image as is and just update the other fields. Have seen a lot of similar threads but they don't seem to show how to achive this when image is stored as binary. 

  Edit item template and data source from form

  <EditItemTemplate>
      <div class="ContentHead">
      <asp:TextBox ID="txtName" runat="server" Text='<%# Bind("ProductName")%>'/>
      </div>
        <table  border="0">
          <tr>
              <td style="vertical-align: top;">
                  <asp:Image
                  id="picAlbum" Height = "200" Width = "200" runat="server" AlternateText='Image Missing'
                  ImageUrl='<%# Bind("ProductID", "~/ImageHandler.aspx?ProductID={0}")%>'/>
              </td>
              <td style="vertical-align: top"><asp:FileUpload ID="FileUploadImage" runat="server" Filebytes ='<%# Bind("ProductID", "~/ImageHandler.aspx?ProductID={0}")%>' />
            </td>
              <br />
              <td style="vertical-align: top"> <b>Description:</b>&nbsp;<asp:TextBox ID="TxtDesc" runat="server" Text='<%# Bind("Description")%>'/>
                  <br /><br />
              </td>
              <td style="vertical-align: top"><b>Archived:</b>&nbsp;<asp:CheckBox ID="ChkArchive" runat="server" Checked='<%# Bind("Archived") %>'/>
                  <br /><br /><br />
              </td>
              <asp:DropDownList id="CategoryList" datasourceid="CategorySQLDataSource"
  			datatextfield="CategoryName"  DataValueField="CategoryID"
  			SelectedValue='<%# Bind("CategoryID") %>'   runat="server"/>
                  <br /><br /><br />
          </tr>
        </table>
       <%-- Need to change price format here to remove currency signs so updating can complete--%>
        <span class="UnitCost"><b>Your Price:</b>&nbsp;<asp:TextBox ID="TxtPrice" runat="server" Text='<%# Bind("Price", "{0:0.00}")%>' /><br /><span class="ModelNumber"><b>Current Stock:</b>&nbsp;<asp:TextBox ID="TxtStock" runat="server" Text='<%# Bind("Stock")%>' /></span>
        <br />
        <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
                      Text="Update" />
              &nbsp;
              <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False"
              CommandName="Cancel" Text="Cancel" />
              
  </EditItemTemplate>

  <asp:SqlDataSource ID="ShopDatabase" runat="server" 
  ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
  SelectCommand="SELECT * FROM [Product] WHERE ([ProductID] = @ProductID)"
  UpdateCommand="UPDATE [Product] SET [ProductName] = @ProductName, [Description] = @Description, [Stock] = @Stock, [Price] = @Price, [Archived] = @Archived, [CategoryID] = @CategoryID,
  [ImageData] =@ImageData ,
  [ImageName] =@ImageName ,
  [ImageType] =@ImageType )
  WHERE [ProductID] = @ProductID">
  <%--In below code need to use full name of textbox as it is inside the edit template--%>
  <UpdateParameters>
  <asp:ControlParameter Name="ProductName" Type="String" ControlId="ctl00$Head$FormView1$txtName" PropertyName="Text"/>
  <asp:ControlParameter Name="Description" Type="String" ControlId="ctl00$Head$FormView1$TxtDesc" PropertyName="Text"/> 
  <asp:ControlParameter Name="Price" Type="Decimal" ConvertEmptyStringToNull="true" ControlId="ctl00$Head$FormView1$TxtPrice"/>
  <asp:ControlParameter Name="Stock" Type="String" ControlId="ctl00$Head$FormView1$TxtStock" PropertyName="Text"/>
  <asp:ControlParameter Name="Archived" Type="Boolean" ControlId="ctl00$Head$FormView1$ChkArchive" PropertyName="Checked"/>
  <asp:ControlParameter Name="CategoryID" Type="Int32" ControlId="ctl00$Head$FormView1$CategoryList" PropertyName="SelectedValue"/>
  <asp:Parameter Name="ImageName" />
  <asp:Parameter Name="ImageType" />
  <asp:Parameter Name="ImageData" type="Byte" />
  <asp:Parameter Name="original_ImageName" />
  <asp:Parameter Name="original_ImageType" />
  <asp:Parameter Name="original_ImageData" type="Byte" />
  
  </UpdateParameters>
  <SelectParameters>
  <asp:QueryStringParameter Name="ProductID" QueryStringField="ProductID" 
  Type="Int32" />
  </SelectParameters>
  
  </asp:SqlDataSource>

  
  
  

  I tried to achieve this in the form updating but my image keeps getting overwritten by a null value

  Protected Sub FormView1_ItemUpdating(sender As Object, e As System.Web.UI.WebControls.FormViewUpdateEventArgs) Handles FormView1.ItemUpdating
  
          Try
              Dim FileUpload2 As FileUpload = DirectCast(FormView1.FindControl("FileUploadImage"), FileUpload)
              If FileUpload2.HasFile Then
  
                  e.NewValues("ImageName") = FileUpload2.FileName
                  e.NewValues("ImageType") = FileUpload2.PostedFile.ContentType
                  e.NewValues("ImageData") = FileUpload2.FileBytes
  
              Else
                  e.NewValues("ImageName") = e.OldValues("ImageName")
                  e.NewValues("ImageType") = e.OldValues("ImageType")
                  e.NewValues("ImageData") = e.OldValues("ImageData")
  
              End If
  
          Catch ex As Exception
              lblStatus.Text = "Error Updating Picture"
          End Try
  
      End Sub

  Can anyone point me in the right direction please?
  
  
  

• • Reply
  

  basheerkal

  Star

  10672 Points

  2426 Posts

  Re: FileUpload in EditItemtemplate in Formview

  May 05, 2012 01:50 AM|LINK

  If you dont want to change the image why you need code in ItemInserting event.  Delete it.

  Kindly mark this post as "Answer", if it helped you.
  
  (Talk less..Work more)
• • Reply
  

  dave13

  Member

  29 Points

  30 Posts

  Re: FileUpload in EditItemtemplate in Formview

  May 05, 2012 10:27 AM|LINK

  Hi

  I want the image to update when the user selects a new file but not when it is left blank.

  At the moment when its left blank it wipes the old image data and gives error "Unable to cast object of type 'System.DBNull' to type 'System.Byte[]" when the page tries to reload as it has nulled the data in the image field

• • Reply
  

  basheerkal

  Star

  10672 Points

  2426 Posts

  Re: FileUpload in EditItemtemplate in Formview

  May 05, 2012 04:33 PM|LINK

  Else
                  e.NewValues("ImageName") = e.OldValues("ImageName")
                  e.NewValues("ImageType") = e.OldValues("ImageType")
                  e.NewValues("ImageData") = e.OldValues("ImageData")

  Remove this from Item Updating event and in else clause  change the Update Command of the DataSource such a way that it will update only other fields except Iamgename . ImageType and ImageData

  Kindly mark this post as "Answer", if it helped you.
  
  (Talk less..Work more)
  • Edited by basheerkal on May 06, 2012 12:35 PM
  • Marked as answer by dave13 on May 06, 2012 12:49 PM
• • Reply
  

  dave13

  Member

  29 Points

  30 Posts

  Re: FileUpload in EditItemtemplate in Formview

  May 06, 2012 12:50 PM|LINK

  Thanks very much, worked perfectly

• • Reply
  

  dave13

  Member

  29 Points

  30 Posts

  Re: FileUpload in EditItemtemplate in Formview

  May 06, 2012 02:17 PM|LINK

  After all that I have a new Iconvertible error when I do try to upload a file. It used to work so must be something i screwed up while trying to resolve previous error

  It occures after the ItemUpdated event but the dump isn't very clear as to what is the problem

  [InvalidCastException: Object must implement IConvertible.]
     System.Convert.ChangeType(Object value, TypeCode typeCode, IFormatProvider provider) +4058933
     System.Web.UI.WebControls.Parameter.GetValue(Object value, String defaultValue, TypeCode type, Boolean convertEmptyStringToNull, Boolean ignoreNullableTypeChanges) +126
     System.Web.UI.WebControls.Parameter.GetValue(Object value, Boolean ignoreNullableTypeChanges) +63
     System.Web.UI.WebControls.SqlDataSourceView.AddParameters(DbCommand command, ParameterCollection reference, IDictionary parameters, IDictionary exclusionList, String oldValuesParameterFormatString) +550
     System.Web.UI.WebControls.SqlDataSourceView.ExecuteUpdate(IDictionary keys, IDictionary values, IDictionary oldValues) +346
     System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary values, IDictionary oldValues, DataSourceViewOperationCallback callback) +95
     System.Web.UI.WebControls.FormView.HandleUpdate(String commandArg, Boolean causesValidation) +1154
     System.Web.UI.WebControls.FormView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +445
     System.Web.UI.WebControls.FormView.OnBubbleEvent(Object source, EventArgs e) +95
     System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
     System.Web.UI.WebControls.FormViewRow.OnBubbleEvent(Object source, EventArgs e) +112
     System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
     System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +125
     System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +169
     System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +9
     System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
     System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +176
     System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563

  I assume it has to do with the values inserted from the fileupload.

  I tried changing the update parameters to the below but error still exists

  <asp:Parameter Name="ImageName" Type="String" />
  <asp:Parameter Name="ImageType" Type="String" />
  <asp:Parameter Name="ImageData" type="Byte" />

  
  
  

• • Reply
  

  basheerkal

  Star

  10672 Points

  2426 Posts

  Re: FileUpload in EditItemtemplate in Formview

  May 06, 2012 02:55 PM|LINK

  Can you tell which line generates error?

  (In page directive Put  Debug="True")

  Kindly mark this post as "Answer", if it helped you.
  
  (Talk less..Work more)
• • Reply
  

  dave13

  Member

  29 Points

  30 Posts

  Re: FileUpload in EditItemtemplate in Formview

  May 06, 2012 03:06 PM|LINK

  Still didn't pinpoint it.

  I removed the  type="Byte" from the parameter declaration and it seems to work.

  Not sure why, is a type not required

• • Reply
  

  superguppie

  All-Star

  48225 Points

  8679 Posts

  Re: FileUpload in EditItemtemplate in Formview

  May 11, 2012 02:18 PM|LINK

  If you don't declare type, it will determine type by itself. Declaration is best used only when it is necessary to force a type.

  Superguppie.
  Please remember to click “Mark as Answer” on the post that helps you. This can be beneficial to other community members reading the thread.
  When all you've got is a Hammer, Every Problem looks like a Nail. Michael Swain.