Loading

File Path data type

Becky Bloomwood

15y15k

Hi guys, currently I am doing uploading of excel/pdf document into MS SQL Server 2008. May I know is Varbinary the best choice to use for File Path? Cause I cant make it display as like this: C:\temp\HP_data.txt

Thanks.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Becky Bloomwood15y ago
Thanks. If I make use of varchar to display the file path, and I have a download column, with the hyperlink download attached to it. Can I still be able to use stored procedure to upload and download the document in either excel or pdf format?
I am not sure of how to make use of' LINQ to SQL mapping and use the Binary type with the byte[] type containing your PDF file's content.'as i just started learning .net visual studio c#.

Thanks!
Suthish Nair15y ago
1. If just want to store the file path then use varchar.

2. You can use the VARBINARY(MAX) type in your database, create a LINQ to SQL mapping and use the Binary type with the byte[] type containing your PDF file's content.

refer a gud example