Hi,
We have web application which is store and retrieve files from database, we using sql server for store data. i want to store file like video file which size almost above 2 gb, when i read using filestrema and store i bytes , it show error like
"Arithmetic operation resulted in an overflow"
bcz byte support maximum 255 length.
What I have tried:
This is my code which i used to read in file stream and pass to bytes
Dim fs As System.IO.FileStream
fs = File.Open(fpath, FileMode.Open, FileAccess.Read, FileShare.None)
Dim filelen As Long = fs.Length
Dim buffer As Byte()
fs.Read(buffer, 0, filelen)
fs.Close()
I tried chunks to read big files, but how to store in table, bcz table support binary value to store in table
Any way to store large size in file stream table ?
Thanks and regards
Aravind