Uploading Image File to a DataBase

Question

Somebody know how to upload a Image File to a DataBase. The file is selceted by the user by a OpenFileDialog. if (OpenFileDialog1.Show()==DialogResult.Ok) { Image img = Image.FromFile(OpenFileDialog1.FileName) //Uploading img to the DataBase } I have the next wrong code to Upload img to the DataBase: SqlCommand InsertCommand = new SqlCommand(INSERT TO MyTable (ImageColumn) VALUES (@Image)MyConnacetion); InsertCommand.Parameters.Add(@Imageimg); //This line throws an error MyConnection.Open(); InsertCommand.ExecutQuery(); MyConnection.Close(); When I add the paremeter the next exception is thrown: Index (zero based) must be greater than or equal to zero and less than the size of the argument list. Any Idea? Thanx in advance.

Carlos Sanchez · Answer

I founf the next code to upload the image: FileStream imgStream = new FileStream(ImagePathFileMode.Open); long DataLength = imgStream.Length; byte[] imgData = new byte[DataLength]; SqlCommand InsertCommand = new SqlCommand(INSERT TO MyTable (ImageColumn) VALUES (@Image)MyConnacetion); InsertCommand.Parameters.Add(@ImageimgData); MyConnection.Open(); InsertCommand.ExecutQuery(); MyConnection.Close(); Before I upload the image I show it in a PictureBox And now throws the next exception: The process cannot access the file C:\SipidermanFace.bmp because it is being used by another process. Somebody help me plase!!