Therefore, the Insert and Update methods do not include parameters for specifying the binary data for the category s picture. The DAL has auto-generated Insert, Update, and Delete methods, but these methods were generated based on the CategoriesTableAdapter s main query, which does not include the Picture column. Let s get started! Step 1: Updating the Data Access Layer

For the brochure, they can either choose to use the existing brochure, to upload a new brochure, or to indicate that the category no longer has a brochure associated with it. When editing a category, the user will be able to optionally upload a new picture or have the category continue to use the existing one. We have built web pages to present the binary data in a GridView a download link for the brochure, with the category s picture shown in an element and have added a DetailsView to allow users to add a new category and upload its brochure and picture data.Īll that remains to be implemented is the ability to edit and delete existing categories, which we'll accomplish in this tutorial using the GridView s built-in editing and deleting features. We also added Data Access Layer and Business Logic Layer methods to work with the Categories table s existing Picture column, which holds the binary content s of an image file. We started by adding a BrochurePath column to the Categories table and updated the architecture accordingly. Over the past three tutorials we ve added quite a bit of functionality for working with binary data.

In this tutorial we see how the GridView control also makes it possible to edit and delete binary data, whether that binary data is saved in the database or stored in the file system. In earlier tutorials we saw how the GridView control makes it simple to edit and delete text data.

Binary editor update