How we can upload and play a video file in asp.net

Question

Hi How we can upload and play a video file in asp.net 2.0. If anybody have a solution to make clone like you tube vedio integration & uploading vedos then plz let me know . i have urgent need for the code in asp.net 2.0 Thanks Pawan

paul daniel · Answer

Hi you can have a blob type declared for the column and store the video files ass blob types in sql server... string filePath = @ D:\Movies\sample.avi ;//get the file name here FileStream fs = new FileStream (filePath FileMode .Open FileAccess .Read); BinaryReader reader = new BinaryReader (fs); byte [] BlobValue = reader.ReadBytes(( int )fs.Length); fs.Close(); reader.Close(); SqlConnection BlobsDatabaseConn = new SqlConnection ( Data Source = .; Initial Catalog = BlobsDatabase; Integrated Security = SSPI ); SqlCommand SaveBlobeCommand = new SqlCommand (); SaveBlobeCommand.Connection = BlobsDatabaseConn; SaveBlobeCommand.CommandType = CommandType .Text; SaveBlobeCommand.CommandText = INSERT INTO BlobsTable(BlobFileName BlobFile) + VALUES (@BlobFileName @BlobFile) ; SqlParameter BlobFileNameParam = new SqlParameter ( @BlobFileName  SqlDbType .NChar); SqlParameter BlobFileParam = new SqlParameter ( @BlobFile  SqlDbType .Binary); SaveBlobeCommand.Parameters.Add(BlobFileNameParam); SaveBlobeCommand.Parameters.Add(BlobFileParam); BlobFileNameParam.Value = filePath.Substring(filePath.LastIndexOf( \ ) + 1); BlobFileParam.Value = BlobValue; try { SaveBlobeCommand.Connection.Open(); SaveBlobeCommand.ExecuteNonQuery(); MessageBox .Show(BlobFileNameParam.Value.ToString() +  saved to database.  BLOB Saved  MessageBoxButtons .OK MessageBoxIcon .Information); } catch ( Exception ex) { MessageBox .Show(ex.Message Save Failed  MessageBoxButtons .OK MessageBoxIcon .Error); } finally { SaveBlobeCommand.Connection.Close(); } Retrieve the video from the server... string SavePath = @ D:\DownMovies ;//save in this path SqlConnection SaveConn = new SqlConnection ( Data Source = .; Initial Catalog = BlobsDatabase; Integrated Security = SSPI ); SqlCommand SaveCommand = new SqlCommand (); SaveCommand.CommandText = Select BlobFileName BlobFile from BlobsTable where BlobFileName = @BlobFileName ; SaveCommand.Connection = SaveConn; SaveCommand.Parameters.Add( @BlobFileName  SqlDbType .NVarChar).Value = My Movie.wmv ; long CurrentIndex = 0; int BufferSize = 100; long BytesReturned; byte [] Blob = new byte [BufferSize]; SaveCommand.Connection.Open(); SqlDataReader reader = SaveCommand.ExecuteReader( CommandBehavior .SequentialAccess); while (reader.Read()) { FileStream fs = new FileStream (SavePath + \ + reader[ BlobFileName ].ToString() FileMode .OpenOrCreate FileAccess .Write); BinaryWriter writer = new BinaryWriter (fs); CurrentIndex = 0; BytesReturned = reader.GetBytes( 1 //the BlobsTable column index CurrentIndex // the current index of the field from which to begin the read operation Blob // Array name to write tha buffer to 0 // the start index of the array to start the write operation BufferSize // the maximum length to copy into the buffer ); while (BytesReturned == BufferSize) { writer.Write(Blob); writer.Flush(); CurrentIndex += BufferSize; BytesReturned = reader.GetBytes(1 CurrentIndex Blob 0 BufferSize); } writer.Write(Blob 0 ( int )BytesReturned); writer.Flush(); writer.Close(); fs.Close(); } reader.Close(); SaveCommand.Connection.Close(); Thanks Paul daniel

Santhosh N · Answer

You can actually embed a div with proper video type and play the video with object tag.. you can check here on how to upload and play streaminf videos.. http://forums.asp.net/t/1170655.aspx