In the last recipe, we saw how to save files of large size, or BLOB, into tables using ADO.NET. In this recipe we will focus on how to retrieve the saved files. Similar to the last recipe, we will work with high quality image files. We will be retrieving the data from the table and displaying it in a picture box. At the database side, we will use a stored procedure to retrieve the file data corresponding to the name. At the application level, we will make use of the
DataSet class of ADO.NET to pass the filename to the stored procedure and get the data.