Using FileUpload To Store Image In SQL Database

Hi

I have a asp:FileUpload conponent that I am trying to use to retrieve a picture file from the clients pc and store it in a SQL database.

The table is called PropertyImage and it contains the following fields:

imgID (type = int - autoincrement); imgData (type = Image); imgTitle (type = VarChar); imgType (type = VarChar); imgLength (type = BigInt);

I have a button (Button1) which when clicked calls Button1_Click()

--------------------------------------------------protected void Button1_Click(object sender, EventArgs e)

{byte[] fileData = null;

Boolean status = false;if (FileUpload1 != null)

{

// Make sure the file has data.if ((FileUpload1.PostedFile != null) && (FileUpload1.PostedFile.ContentLength > 0))

{

// Get the filename.string fn = System.IO.Path.GetFileName(FileUpload1.PostedFile.FileName);

try

{

// Access the file stream and begin the upload. Store the file in a memory byte array.Stream MyStream = FileUpload1.PostedFile.InputStream;

long iLength = MyStream.Length;fileData = new byte[(int)MyStream.Length];MyStream.Read(fileData, 0, (int)MyStream.Length);

MyStream.Close();

}catch (Exception ex)

{ }

}

}SqlConnection connection = new SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\heidihomes.mdf;Integrated Security=True;User Instance=True");

try

{

connection.Open();SqlCommand sqlCmd = new SqlCommand("INSERT INTO PropertyImage (imgData, imgaTitle, imgType, imgLength) VALUES(@data,@title,@type,@length)");

SqlParameter param = new SqlParameter();

// String connectionString = new SqlConnection(sqlCmd, connection);

 param = new SqlParameter("@data", SqlDbType.Image);

param.Value = fileData;

sqlCmd.Parameters.Add(param);param = new SqlParameter("@title", SqlDbType.VarChar);

param.Value = fileData;

sqlCmd.Parameters.Add(param);param = new SqlParameter("@type", SqlDbType.VarChar);

param.Value = fileData;

sqlCmd.Parameters.Add(param);param = new SqlParameter("@length", SqlDbType.BigInt);

param.Value = fileData;

sqlCmd.Parameters.Add(param);

sqlCmd.ExecuteNonQuery();

connection.Close();status = true;

}catch (Exception ex){ }if (status)

{

UploadStatus.Text = "File Uploaded Successfully";Server.Transfer("Admin_PropertyView.aspx");

}

else

{UploadStatus.Text = "Uploaded Failed";

}

}

}

--------------------------------------------------

But when I click on the button, nothing happens.

Please could someone help me out here.  I have tried this a few times and still haven't come right.

Also, if there is something else wrong with the code, please let me know.

Thanking you in advance.