Upload/Download Images to SQL Server

Download Source Code - 56 Kb

This C# ADO.NET application allows you to manage your pictures/images using a SQL Server database. The application uses a ListBox control, PictureBox control, Menu control, two Button controls, and a SQL Server database back-end to upload images from your hard drive and download images for display. You can display an image from the database by double-clicking the filename in the ListBox. This solution will also allow you to delete an image from the database as well as save an image to an external location on your hard drive. Before you can use this application, you must first run the MyPictures SQL script to create the MyPictures database, Images table, and the Stored Procedures needed for the application to interface with the database . The SQL script must be executed against a SQL Server or SQLExpress database. The SQL script is included in the Source Code Zip file, which can be downloaded by selecting the link. Finally, the solution includes a DBInterface.cs class. This class manages the connections and operations against the SQL Server database using ADO.NET. You can get the full source code for this application by selecting the Download Source Code link.