title: retrieve varbinary datafield from SQLdatabase
body: <p>i am storing files in database and this is the code i am using and it works in adding the data, but now i want to retrieve it back. how can i do that?</p>
  
  <pre><code>string filename = FileUploader.PostedFile.FileName;
      string filecontent = FileUploader.PostedFile.ContentType;
      int filesize = FileUploader.PostedFile.ContentLength;
  
      string filepath = System.IO.Path.GetFileName(filename);
  
  
      FileUploader.PostedFile.SaveAs("c:\\try\\" + filepath);
  
      byte[] fileData = new byte[FileUploader.PostedFile.ContentLength];
      FileUploader.PostedFile.InputStream.Read(fileData, 0, fileData.Length);
      string originalName = Path.GetFileName(FileUploader.PostedFile.FileName);
  
  
      con.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["FAQ"].ToString();
  
      con.Open();
  
      using (SqlCommand cmd = new SqlCommand("INSERT INTO Files(FileData) VALUES (@binaryValue)", con))
      {
          // Replace 8000, below, with the correct size of the field
          cmd.Parameters.Add("@binaryValue", SqlDbType.VarBinary, fileData.Length).Value = fileData;
          cmd.ExecuteNonQuery();
          con.Close();
      }
  </code></pre>