Upload an image file and save it to SQL Server (Without using aspx file)

01-12-2009 7:59 PM |

Hello Gurus,

      I hope you can help me on. How to upload an image by using a dialog box and then, save it to SQL Server Database.  I tried to search and never find any solution.

   

Sincerely,

Cris 

 

Re: Upload an image file and save it to SQL Server (Without using aspx file)

01-12-2009 8:59 PM |

You have to have some logic on the server side (be it aspx or ashx). Something has to accept the upload and write it to the database. The uploader I like best is Silverlight File Upload. You could easily customize the FileUpdate.ashx.cs to write the file to the database instead of a file.

Re: Re: Upload an image file and save it to SQL Server (Without using aspx file)

01-12-2009 10:21 PM |

Hello Bryant,

          Below is my initial code to  open a filedialog box and then accept any .jpg file (Just try to read and convert it to a byte array for saving it to the database). After that this line of code will create an error (It means that we can't execute the code to convert into byte array). Do you know why it can't open the file or read (provided we select the correct .jpg file from the dialog box) ? 

FileStream fs = new FileStream(file.File.Name, FileMode.OpenOrCreate, FileAccess.Read);

 

 

 

using System;

using System.Collections.Generic;

using System.Linq;

using System.Net;

using System.Windows;

using System.Windows.Controls;

using System.Windows.Documents;

using System.Windows.Input;

using System.Windows.Media;

using System.Windows.Media.Animation;

using System.Windows.Shapes;

using System.IO;

using System.Xml.Serialization;

using System.IO.IsolatedStorage;

 

   

OpenFileDialog file = new OpenFileDialog();

file.Filter = "Image File (*.jpg;*.bmp;*.gif)|*.jpg;*.bmp;*.gif";

file.Multiselect = false;

if ((bool)file.ShowDialog())

{

 

FileStream fs = new FileStream(file.File.Name, FileMode.OpenOrCreate, FileAccess.Read); // this line of code will create an ERROR...

byte[] byteImage = new byte[fs.Length];

fs.Read(byteImage, 0, System.Convert.ToInt32(fs.Length));

fs.Close();

}

 

Thanks,
Cris

 

Re: Re: Re: Upload an image file and save it to SQL Server (Without using aspx file)

01-12-2009 10:36 PM |

Follow up..

     Please try this code in the code behind of .xaml file. Not in the Windows Form.

 

 

Re: Re: Re: Re: Upload an image file and save it to SQL Server (Without using aspx file)

01-13-2009 9:32 AM |

For the three Gurus who help me.

 

Thanks a lot it works now.