How to retrieve video from database?

Question

1.00/5 (2 votes)

See more:

I want to store & retrieve video from SQL database. That video has to be play in vlc or windows media player with the help of C# coding.Tell me the solution....

What I have tried:

I tried with flow player......

Posted 24-Nov-16 0:02am

Developer29

Updated 24-Nov-16 22:41pm

OriginalGriff

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2016-11-24T00:17:00

Seriously? Don't do it.
The problem is that video files are big - and get very big, very quickly. When you write code to retrieve them from a DB and stream them to VLC or Media player, you are doubling the memory, the bandwidth, and everything else involved. Think about it: SQL Server has to retrieve the data into it's memory. It then feeds that to the network to pass to your application. Which allocates memory to store it, and passes it either to a third party app like VLC or to a (separate machine if this is an ASP.NET app that would be the client PC)
That's a huge amount of data being thrown around, and that uses resources like crazy - which means delays, buffering, and general nastiness.

A better solution is to store a path to the video file in the DB, and use that to access the actual video data. With luck, you can just pass the path to your movie player and it accesses the data or stream directly.

Daniel Jones · Answer 2 · 2016-11-24T17:33:00

Solution 2

Take a look at this link hope this will help: Upload Save Retrieve and Play MP4 Video files with live streaming from Database in ASP.Net using C# and VB.Net[^]

Posted 24-Nov-16 17:33pm

Daniel Jones

Updated 24-Nov-16 17:52pm

Member 9831003 · Answer 3 · 2016-11-24T22:04:00

Solution 3

Check filestream concept in sql server for BLOB.

Posted 24-Nov-16 22:04pm

Member 9831003

StackQ · Answer 4 · 2016-11-24T22:41:00

C#

if (openFileDialog1.FileName != null)   
{
 v_Filepath = FilePath;
System.IO.FileStream fs = new System.IO.FileStream(FilePath, System.IO.FileMode.Open, System.IO.FileAccess.ReadWrite);
System.IO.BinaryReader binaryReader = new System.IO.BinaryReader(fs);
long byteLength = new System.IO.FileInfo(FilePath).Length;
Attachmnt = binaryReader.ReadBytes((Int32)byteLength);  //This data u can save in table
fs.Close();
 fs.Dispose();
binaryReader.Close();
} 

//And to get it again from database 

string newName;
newName = saveFileDialog1.FileName;
File.WriteAllBytes(saveFileDialog1.FileName, objDoc.DocContent);
writeStream = new FileStream(saveFileDialog1.FileName, FileMode.Open);
BinaryWriter writeBinay = new BinaryWriter(writeStream);
writeBinay.Write(objDoc.DocContent);
writeBinay.Close();
writeStream.Close();

or check my Question link:-
how to save a byte[] code in pdf/rtf/xps/doc file.(Windows not asp)[^]

How to retrieve video from database?

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0