FileStream fs = new FileStream(path, FileMode.Open, FileAccess.Read);

protected void Button1_Click(object sender, EventArgs e)
        {
            DateTime now = DateTime.Today.Date;
            DateTime due_date = DateTime.Parse(txt_dueDate_uploadBrief.Text);
            DateTime return_date = DateTime.Parse(txt_ReturnDate_UploadBrief.Text);
            string modID = txt_HiddenModuleID_UplaodBrief.Text.ToString();
            int module_ID = Convert.ToInt32(modID);
            path = "File:" + FileUpload_uploadBrief.FileName;
            command = new SqlCommand("upload_upBrief", myConnection);
            command.CommandType = CommandType.StoredProcedure;
            myConnection.Open();

            FileStream fs = new FileStream(path, FileMode.Open, FileAccess.Read);             bblob = new byte[fs.Length];
            fs.Read(bblob, 0, bblob.Length);
            fs.Close();

            //Initialising new instances of SqlParameter that declares the data type, size and column name
            //for the data that is being passed in
            command.Parameters.Add(new SqlParameter("@assRefNo", SqlDbType.NVarChar, 50, "AssRefNo"));
            command.Parameters.Add(new SqlParameter("@AssignmentBrief", SqlDbType.VarBinary, -1, ParameterDirection.Input, false, 0, 0, "AssignmentBrief", DataRowVersion.Current, path));
            command.Parameters.Add(new SqlParameter("@releaseDate", SqlDbType.Date, 8, "ReleaseDate"));
            command.Parameters.Add(new SqlParameter("@dueDate", SqlDbType.Date, 10, "DueDate"));
            command.Parameters.Add(new SqlParameter("@returnDate", SqlDbType.Date, 8, "ReturnDate"));
            command.Parameters.Add(new SqlParameter("@moduleID", SqlDbType.Int, 4, "ModuleID"));

            ////Adds data based on the parameters passed in
            command.Parameters["@assRefNo"].Value = txt_AssRefNo_uploadBrief.Text.ToString();
            command.Parameters["@AssignmentBrief"].Value = bblob;//FileUpload_uploadBrief.ToString();//test;//value;
            command.Parameters["@releaseDate"].Value = now;
            command.Parameters["@dueDate"].Value = due_date;
            command.Parameters["@returnDate"].Value = return_date;
            command.Parameters["@moduleID"].Value = module_ID;
}

protected void Button1_Click(object sender, EventArgs e)
        {
            myConnection.Open();
 
            command = new SqlCommand("UPDATE Pub_info SET logo = @Picture WHERE CategoryName = 'me'", myConnection);
            fs = new FileStream("c:\\Builder.doc", FileMode.Open, FileAccess.Read);
            Byte[] blob = new Byte[fs.Length];
            fs.Read(blob, 0, blob.Length);
            fs.Close();
            param = new SqlParameter("@Picture", SqlDbType.VarBinary, blob.Length,
            ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, blob);
            command.Parameters.Add(param);
            command.ExecuteNonQuery();
 
        }

 Byte[] b = FileUpload_uploadBrief.FileBytes;
                        blob = b;