Android Question How can play an mp4 video file stored in my database

[Makumbi]

Using br As New BinaryReader(FileUpload1.PostedFile.InputStream)
            Dim bytes As Byte() = br.ReadBytes(CInt(FileUpload1.PostedFile.InputStream.Length))
            Dim strConnString As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
            Using con As New SqlConnection(strConnString)
                Using cmd As New SqlCommand()
                    cmd.CommandText = "insert into tblFiles(Name, ContentType, Data) values (@Name, @ContentType, @Data)"
                    cmd.Parameters.AddWithValue("@Name", Path.GetFileName(FileUpload1.PostedFile.FileName))
                    cmd.Parameters.AddWithValue("@ContentType", "video/mp4")
                    cmd.Parameters.AddWithValue("@Data", bytes)
                    cmd.Connection = con
                    con.Open()
                    cmd.ExecuteNonQuery()
                    con.Close()
                End Using
            End Using
        End Using

i have this code which saves the video into the sqlserver database
now i wanted to retrieve that byte file and play it using the example in exo player please help

 

[Erel]

Download the file and play it. What exactly is the question?

 

[Makumbi]

Download the file and play it. What exactly is the question?

The file is currently saved in an sqlserver database table as a byte so i wanted a way of getting it and then play it

 

[Erel]

Search for jRDC2.

 

[asales]

The file is currently saved in an sqlserver database table as a byte so i wanted a way of getting it and then play it

Why do you don't save the video file in a folder and reference only the path of the video in the database table?

 

[Makumbi]

Why do you don't save the video file in a folder and reference only the path of the video in the database table?

Do you have any example of how that can be effected

 

[asales]

Not for the video files, but I think that you can use this codes below (that upload a image file) and change it to upload the video file.

You can search too in the forum to "upload file" and "upload image", etc. and find several threads that can made it a direction.

Upload image to server, PostMultipart and PHP

A small example like loading an image with PostMultipart and PHP, I have been useful, you can adapt it needs. Code B4A Sub CargaImagen Dim j As HttpJob Dim img As String = "IMG_20178108230.jpg" j.Initialize("", Me) Dim mp As MultipartFileData mp.Initialize mp.Dir =...

www.b4x.com

Image upload with PHP and PostMultipart

Hi all. I found this example in some old folders on my pc and decided to share here. it is a simple image upload example with postmulipart and PHP. Download Here 700kb

www.b4x.com

OkHttp - Replaces the Http library

OkHttpUtils2 source code: [B4X] OkHttpUtils2 / iHttpUtils2 / HttpUtils2 source code It is included as an internal library. Usage: [B4X] OkHttpUtils2 with Wait For The current Http library is based on the Android version of Apache HttpClient. Google has stopped updating this SDK a long time ago...

www.b4x.com

[Server] Upload files from your B4A app to your B4J server over the internet

This example shows how to make your B4J server application accessible over the internet. The implemented server is a simple file server that allows you to upload files from your B4A application to the server over the internet. The following steps are required in order to make your server...

www.b4x.com