title: FileStream download pulls page HTML
body: <p>I am trying to set up FileStream to work in my application.  I am pretty sure that the issue I am having is not within my Upload code.  If I view the properties of my test file, it shows being 46 bytes.  When I watch the debug step through my download command, it grabs a filelength of 46 bytes.</p>
  
  <p>On the very last step when the file is actually downloaded in the browser a bunch of data is added to the file, specifically the entire HTML of the page itself.  I have NO idea why this is happening.</p>
  
  <pre><code>protected void gvFilestream_RowCommand(object sender, GridViewCommandEventArgs e)
      {
          if (e.CommandName == "GetFile")
          {
  
              SqlConnection objSqlCon = new SqlConnection(CS);
              objSqlCon.Open();
              SqlTransaction objSqlTran = objSqlCon.BeginTransaction();
  
              SqlCommand objSqlCmd = new SqlCommand("FileGet", objSqlCon, objSqlTran);
              objSqlCmd.CommandType = CommandType.StoredProcedure;
  
              SqlParameter objSqlParam1 = new SqlParameter("@ID", SqlDbType.VarChar);
              objSqlParam1.Value = e.CommandArgument;
  
              objSqlCmd.Parameters.Add(objSqlParam1);
              string path = string.Empty;
              string fileType = string.Empty;
  
              using (SqlDataReader sdr = objSqlCmd.ExecuteReader())
              {
                  while (sdr.Read())
                  {
                      path = sdr[0].ToString();
                      fileType = sdr[1].ToString();
                  }
  
              }
  
              objSqlCmd = new SqlCommand("SELECT GET_FILESTREAM_TRANSACTION_CONTEXT()", objSqlCon, objSqlTran);
  
              byte[] objContext = (byte[])objSqlCmd.ExecuteScalar();
  
  
              SqlFileStream objSqlFileStream = new SqlFileStream(path, objContext, FileAccess.Read);
  
              byte[] buffer = new byte[(int)objSqlFileStream.Length];
              objSqlFileStream.Read(buffer, 0, buffer.Length);
              objSqlFileStream.Close();
  
              objSqlTran.Commit();
              Response.AddHeader("Content-disposition", "attachment; filename=" + Path.GetFileName(path) + fileType);
              // Here you need to manage the download file stuff according to your need
              Response.ContentType = "application/octet-stream";
  
              Response.BinaryWrite(buffer);
          }
      }
  </code></pre>
  
  <p>This is my code behind method for downloading the file.  And below is a snippet from the top of the text file that is downloaded.  I didn't put the whole thing in because it seems pointless.  The original document only contains "This document is a test document, for testing."</p>
  
  <pre><code>This document is a test document, for testing.
  &lt;!DOCTYPE html&gt;
  
  &lt;html xmlns="http://www.w3.org/1999/xhtml"&gt;
  &lt;head&gt;&lt;title&gt;
      View
  &lt;/title&gt;
  </code></pre>
  
  <p>I am using a guide I found on the Internet to set this FileStream stuff up, but it doesn't really explain what each part is doing so I don't know where my method is going wrong.  It seems like it would be in the comment area where I need to tailor it to my needs.</p>
  
  <p>Any suggestions?</p>