EDI/12_08_14_3/1407852794-22209/tutorial/249/objects/20/files/20_30.jpg' alt='Save File Dialog C# Text File' title='Save File Dialog C# Text File' />How to Save and Retrieve images in C WPF Application using SQL Server Database. Well yes you have finally found it A complete tutorial on how to save and retrieve images from the SQL Server 2. C WPF application. For Windows Forms application, check out this article written by Sumair. The database for this tutorial has been designed in SQL Server 2. Everything has been kept simple so that even beginners can understand. However, if posed with any problem, questions are always welcomedI have a requirement in WPFC to click on a button, gather some data and then put it in a text file that the user can download to their machine. I can get the first. Standard Editing Text editing in SciTE works similarly to most Macintosh or Windows editors with the added feature of automatic syntax styling. This article shall describe an approach to working with delimited text files. In general it will discuss the construction of the connection strings and schema. The content you requested has already been retired. It is available to download on this page. Learn how to plot a graph from the data in Excel sheet, and export a chart from Excel sheet through C and save it locally. Borland/BorlandKB/2257/22571.bmp' alt='Save File Dialog C# Text Writer' title='Save File Dialog C# Text Writer' />Save File Dialog C TextfieldparserSo lets start Create a new WPF Application using Visual Studio 2. Step 1 Create the two XAML based windows in WPF as follows Create the first window with. Image named imagebox Textbox named tbname Button named btnsave Button named btnnext The orange lines around the image and text box that you see are actually a border that i have added around the image. Its not at all necessary I just did to add beauty plus its not the focus of this tutorial. Create the second window with. Texblock with Text as Available Pictures Listbox named as lbpics Image named imagebox Button named btnexit  First we will work on the first window Step 2 Open dialog box, save the selected image to a File. Stream and read the File. Stream into a byte array Place the code for Step 2, Step 3 and Step 4 at the click event of btnsave. We use Open. File. Dialog class to let the user open the picture to be saved in the database. Filemode. Open opens a File. Stream on the pathfrom dlg. File. Name with read access. The stream object fs then reads itself into the data variable. Microsoft. Win. 32. Open. File. Dialog dlg new Microsoft. Win. 32. Open. File. Dialog dlg. Show. Dialog  File. Stream fs new File. Streamdlg. File. Name, File. Mode. Open, File. Access. Read byte data newbytefs. Length fs. Readdata, 0, System. Convert. To. Int. Length  fs. Close Step 3 Insert the picture into the database using the byte array as follows sql. Con. Open Sql. Command sc new Sql. Commandinsert into picturepic,name values p,n, sql. Con sc. Parameters. Add. With. Valuep, data sc. Parameters. Add. With. Valuen, tbname. Text sc. Execute. Non. Query sql. Con. Close Step 4 Show the selected image in the image box The Image. Source. Converter actually converts the path of the image dlg. File. Name. To. String to the type imagesource. The image is displayed in the image control through imagebox. Set. Value. With the first parameter being the property to be set, and the second being the new value for that property. Image. Source. Converter imgs new Image. Source. Converter imagebox. Set. ValueImage. Source. Property, imgs. Convert. From. Stringdlg. File. Name. To. String Also add the following line if you want the texbox to clear when the image is displayed in the imagebox Press F5 to test Enter the name of the picture that you want to save. The dialog box will appear. Select the picture and press Open. The picture will appear in the imagebox with the textbox cleared. Step 5 At the click event of btnext, type in the following code to open the next window privatevoid btnextClickobject sender, Routed. Event. Args e Window. Window. 2 obj. Show this. Close Step 6 Show the names already in the database in the listbox Place this code in the window load event. Select the column of the names of the pictures in the dataset. Run a loop through the dataset foreach row in the dataset create a listbox item and set its content to be the name. To. String for the corresponding row. Add the listbox item to the listbox. Con. Open ds new Data. Set  Sql. Data. Adapter sqa new Sql. Data. Adapterselect name from picture, sql. Con sqa. Fillds  sql. Con. Close foreach Data. Row data. Row in ds. Tables0. Rows List. Box. Item lb. Item new List. Box. Item lb. Item. Content data. Row0. To. String lbpics. Items. Addlb. Item           Click Next on the first window Step 7 Get the picture with the name selected in the listbox from the database Place the code in this and the following steps in the Selection. Changed event of the listbox. This gives a very nice effect as the picture will be displayed as soon as you select the name in the listbox. The as operator is used to perform conversion between the two compatible types. This is to get the selected item in the listbox. Select the picture from the database corresponding to the name selected in the listbox. List. Box. Item lb lbpics. Selected. Item as List. Box. Item sql. Con. Open ds new Data. Set Sql. Data. Adapter sqa new Sql. Data. AdapterSelect pic from picture where namelb. Content. To. String, sql. Con sqa. Fillds sql. Con. Close Step 8 Display the image in the imagebox. Convert the pic in the database into byte array named data. The stream strm writes data into itself. The position of the stream is set to 0, Create an image from stream. Create a Bitmap. Image and begin its initialization. Create another memory stream. Save the Image to the specified memory stream ms in the bitmap format through img. Save. Rewind the stream through ms. Seek. Make the streamsource of the bitmap image to be ms. End the initialization of bitmap and make it the source of the imagebox. Tables0. Rows00   Memory. Stream strm new Memory. Stream   strm. Writedata, 0, data. Length   strm. Position 0   System. Drawing. Image img System. Drawing. Image. From. Streamstrm   Bitmap. Image bi new Bitmap. Image   bi. Begin. Usb Flash Security Freeware. Init   Memory. Stream ms new Memory. Stream   img. Savems, System. Drawing. Imaging. Image. Format. Bmp  ms. Seek0, Seek. Origin. Begin   bi. Stream. Source ms   bi. End. Init   imagebox. Source bi Press F5 now to finally test the project, Press next in the first window. Select one of the names in the listbox to display the corresponding picture. Finally You are done Please let me know if you have any queriesRelated Stories. Subscribe to our RSS Feed Latest. NET C Articles. Dependency Injection, a goal in development, could be achieved by Construction Injection, Setter Injection, and Interface based Injection techniques.