how to convert any type of File to binary and save it in database.....

See more:

C#

C#4.0

I want to save any type of file,choosen and save it to database in a column with its content converted to binary.
i am having problem with pdf file..while saving it to database,data gets currput.

this is how i convert the file to binary::

public byte[] FileToByteArray(string _FileName) 
{
   byte[] _Buffer = null;
   try
   {
      // Open file for reading 
      System.IO.FileStream _FileStream = new System.IO.FileStream(_FileName,    System.IO.FileMode.Open, System.IO.FileAccess.Read);
      // attach filestream to binary reader 
      System.IO.BinaryReader _BinaryReader = new System.IO.BinaryReader(_FileStream);
      // get total byte length of the file 
      long _TotalBytes = new System.IO.FileInfo(_FileName).Length;
      // read entire file into buffer 
      _Buffer = _BinaryReader.ReadBytes((Int32)_TotalBytes);
      // close file reader 
      _FileStream.Close();
      _FileStream.Dispose();
      _BinaryReader.Close();
   }
   catch (Exception _Exception)
   {
      // Error 
      Console.WriteLine("Exception caught in process: {0}", _Exception.ToString());
   }
   return _Buffer;
}