database - How to retrieve multi media stored in sql server using c#? -


i working on windows desktop application using c#. in project, want show video in windows media player component , stored video in sql server. (i inserted video files in varbinary(max) column , dont want stored file path in database!!!)

i want retrieve video database , play video in windows media player. how can retrieve video?

my inserted code:

private void btn_insert_click(object sender, eventargs e) {     openfiledialog openfiledlg = new openfiledialog();     openfiledlg.initialdirectory = directory.getcurrentdirectory();     if (openfiledlg.showdialog() == dialogresult.ok)      {         fileinfo fi = new fileinfo(openfiledlg.filename);         filestream fs = new filestream(fi.fullname, filemode.open, fileaccess.read);         binaryreader rdr = new binaryreader(fs);         byte[] filedata = rdr.readbytes((int)fs.length);         rdr.close();         fs.close();          context databse = new context();         tblvideo tv = new tblvideo();         tv.videoname = fi.name;         tv.video = filedata;         databse.tblvideos.add(tv);         databse.savechanges();         messagebox.show("inserted");     } } 

if application can ever accessed online, limiting option view video someones local machine, whereas if host on cdn (like maxcdn) can reference external link in code.


Comments