linking an sqlite video blob to videoview

[roberttdavey]

Hi... I have been able to save an image file to an sqlite blob and retrieve the image data again from sqlite for display, the documentation is helpful for that. But I haven't been able to do the same for video. I have saved a video file(very small... only about 100Kb) to sqlite in a similar way as the image file was saved, but I cannot get the video data again from sqlite and link this to videoview for playing.

I think the video data should be available using:
Buffer3 = Cursor1.GetBlob("video")
but the videoview only allows loading from a file(which I have been able to do ok) or loading from an http: web address(which I don't want).
Can the Buffer3 data be sent to videoview? How?

I tried this:
vv.LoadVideo("http", HttpUtils.GetInputStream.ReadBytes(Buffer3, 0, Buffer3.Length))
but it doesn't work for me.

At the moment the only way I can see of achieving my aim is to save the sqlite blob to a temporary video file on the sd card and then load from the sd card into videoview... a little bit roundabout.

Any help/code would be appreciated.
Thanks
Robert

 

[Erel]

You will need to save it to a temporary file. The video is played by the media service which expects a file.

 

[roberttdavey]

saving sqlite blob to a temporary file

Ok... I understand now, thanks. I have already done this with a temporary file... just wondered if there was a more direct route between sqlite and videoview.
Thanks for the prompt information
Robert