how can i retrieve binary data from sql server in file like word pdf and text .......WINDows APPLICation...

SqlConnection connection = new SqlConnection ("...");
 connection.Open ();
 // Select binary data from db
 SqlCommand command = new
   SqlCommand ("select PdfFile from Table", connection);
 byte[] buffer = (byte[]) command.ExecuteScalar ();
 connection.Close();
 // storing file to C drive
 FileStream fs = new FileStream(@"C:\test.pdf", FileMode.Create);
 fs.Write(buffer, 0, buffer.Length);
 fs.Close();