How to Download files from Database sever in VB.NET

Question

hi Many web applications provide the download option.i want to known about how work in data server.

Scott Lysle · Answer

If the document is stored in the database, it would be stored as binary data. You would have to know the file type of the file so that you could reconstruct it and return it to the user. In general you would want to know the file name and the file type for that purpose. If the file were just stored in a folder, you could use something as simple as this: protected void LinkButton1_Click( object sender, EventArgs e) { DownloadFile( "c:\temp\somefiletodownload.docx" ); } protected void DownloadFile( string sFile) { string file = sFile; UriBuilder uBuild = new UriBuilder (); System.Net. WebRequest wReq = System.Net. WebRequest .Create(file); System.Net. WebResponse wResponse = (System.Net. WebResponse )wReq.GetResponse(); Response.AppendHeader( "Content-Disposition" , "attachment;filename=" + file); Response.ContentType = wResponse.ContentType; Stream fStream = wResponse.GetResponseStream(); byte [] buff = new byte [4096]; Response.Clear(); int bytes; while ((bytes = fStream.Read(buff, 0, buff.Length)) > 0) { Response.OutputStream.Write(buff, 0, bytes); } fStream.Close(); wResponse.Close(); Response.Flush(); Response.End(); }

How to Download files from Database sever in VB.NET

Answers (1)