Hi,

You can simply uploads pdf using below article and make download button visible or enable if match found with selected candidate

Upload and Download files from SQL Server Database in ASP.Net

Gives an error while uploading a .pdf file in executeNonQuery..

String or binary data would be truncated. The statement has been terminated.

Error in ExecuteNonQuery

Hi,

Check the length of column in which you are passing data, it seems to be length data that you are passing is greater than column length