Hello Friends, I'm storing Video files into the database and when required, i retrieve them and store them on the folder. Issue: Before storing the video file in to the database, the size is 2 mb and after retrieving , its 10mb. This is the method i use to retrieve the files, Dim fs As New FileStream(path, FileMode.CreateNew) fs.Write(bimagedata, 0, bimagedata.Length) Dim bw As New BinaryWriter(fs) Dim i As Integer For i = 0 To bimagedata.Length bw.Write(CInt(i)) Next i Can someone please tell me a better way to retrieve and store the video files in a folder. Thanks in advance. hkk

can you post your code in a formated way....

go to editprofile...siteoptions ..... content editor ..... select Standerd...

 

Why do you want to store video files in DB? Storing them as binary data within the DB will put a very heavy load on your DB server. I would prefer to store them in file system and store URLs in your DB.

True.. doing it right away. Thanks.

I assume that you are storing and retrieving video files in SQL Server 2005 database. 

Try the code given in the following link: 

http://support.microsoft.com/default.aspx?scid=kb;en-us;326502

 

Check this link also:

http://weblogs.sqlteam.com/randyp/archive/2008/11/20/60771.aspx

Hey, I stored the path in the database and the file on the file system. I read it using the filestream.. FileUpload.PostedFile.InputStream.Read(arrContent, 0, intLength) I write it using fs.write Dim fs As New FileStream(imagepath, FileMode.CreateNew) fs.Write(arrContent, 0, intLength) Dim bw As New BinaryWriter(fs) Dim j As Integer For j = 0 To intLength bw.Write(CInt(i)) Next j bw.Close() fs.Close() issues still persists.. A 2MB .MPG4 file get converted to 10MB .MPG4 file. It palys well but the size is the issue. P.S : Oracle 10g is the database i'm using. Any ways, i'm not storing it in the database so, should not be of any newz now.

Why do you want to store your files multiple path?

if you want to copy files then you can use like this

File.Copy("sourcefilepath", "destinationfilepath");

 Hi,

It is not Adivceable for Storing Video in database..

Rather than use .. Path of  Video file.. and Acess on <embed. or object tag

Hi, I'm not storing the files in the database, i'm storing the path of the file in the database. When a users logs on to my website, he has an option to upload video. So, what i'm doing is reading the file stream and storing it on the filesystem, in a folder. Issue is, when i'm storing it, the file size increases. from 2 mb to 10 mb. How would i be able to use file.copy, its not a desktop application rt. The file is location on the clients computer and i would have to read it any ways to store it rt?

 I assume your using file upload control right?

You can save it like this

fileupload1.save("destination path");

 http://www.dreamincode.net/forums/showtopic42190.htm

http://www.codeproject.com/KB/cs/simple_movie_database.aspx

 http://forums.asp.net/p/1215419/2179708.aspx#2179708

i hope it helps you