How to save and retrive the Video file in SQL 2005 through Visual c#.NET 2005?

Small Video file i want to save in SQL 2005


Then i have to retrive


Please sent the codeing

How to save and retrive the Video file in SQL 2005 through Visual c#.NET 2005?
You'll want to store the video in an varbinary(max) type column in your database table.





Then, in your c# ADO.Net code, you'll want to use a SqlParameter of type SQLDbType.Image to insert the video (BLOB).





Please see the following MSDN help. There is VB and C# code available:





http://msdn2.microsoft.com/en-us/library...