Inserting Images to the Database

This is the code to insert image into a database and also copy the image into the Folder on the server.


string strFileName = File1.PostedFile.FileName;
string c = System.IO.Path.GetFileName(strFileName);
try
{
File1.PostedFile.SaveAs(@"C:\ServerFolder\"+c);
Response.Write(@"C:\ServerFolder\"+c);
}
catch(Exception ex)
{
Response.Write(ex.Message);
}
FileStream o = null;
StreamReader r = null;
string jpgFile = @"C:\ServerFolder\"+c;
o = new FileStream(jpgFile,FileMode.Open,FileAccess.Read,FileShare.Read);
r = new StreamReader(o);
try
{
byte[] FileByteArray = new byte[o.Length-1];
OleDbCommand CmdObj = new OleDbCommand("InsertImage",myConnection);
CmdObj.CommandType = CommandType.StoredProcedure;
CmdObj.Parameters.Add("@ImageUrl",OleDbType.VarChar,50);
CmdObj.Parameters["@ImageUrl"].Value = jpgFile;
CmdObj.Parameters.Add("@Image",OleDbType.Binary);
CmdObj.Parameters["@Image"].Value = FileByteArray;
myConnection.Open();
CmdObj.ExecuteNonQuery();
myConnection.Close();

}
catch(Exception ex)
{
Response.Write(ex.Message);
}