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(); }