how To Insert Video File In DB Sql server

Question

How Can I insert Video File like *.avi to DB by using vb.net 2008

Answer 1

Below is an example that demonstrates how to write BLOB data to a SQL Server database:

How To Read and Write BLOB Data by Using ADO.NET with Visual Basic .NET

 

---

Paul ~~~~ Microsoft MVP (Visual Basic)

Answer 2

In essence, you can't store the file itself into your db, however, you can store the reference to that file in your db.

Store the full file extension in your db record and store that particular video file locally to your project. The best way to present the video file would be through a WPF window (mostly because it has a nifty media control)

Answer 3

In essence, you can't store the file itself into your db, however, you can store the reference to that file in your db.

Store the full file extension in your db record and store that particular video file locally to your project. The best way to present the video file would be through a WPF window (mostly because it has a nifty media control)

Actually, you most certainly can store the file in the database.

---

Paul ~~~~ Microsoft MVP (Visual Basic)

Answer 4

Hello KhaLeeL,

Thanks for your post.

Why do you want to store Video file to DB? I don't think it is a good idea to store large files to database. You could save a link that could open the video file. If I misunderstood, please feel free to follow up.

Best regards,
Liliane
MSDN Subscriber Support in Forum
If you have any feedback on our support, please contact [e-mail]

---

Please mark the replies as answers if they help and unmark them if they provide no help. Welcome to the All-In-One Code Framework! If you have any feedback, please tell us. Thanks

Answer 5

Hi, Here I got a reference for inserting vdo files into SQL DB. Hope u better understand! Link: http://www.dotnetblogbir.blogspot.com Thanks