How to open pdf and xls, doc file into browser .

Question

we are saving all kind of files into database in varbinary format then in the next page Retrive the data from database in binary form and display into browser. but pdf and jpg can open in browser/Window.open but xls and doc file not into browser its open in their reader excel or Ms word..

Jignesh Kumar · Answer

Hi, Please find below link which will help you, https://www.c-sharpcorner.com/article/how-to-export-data-in-excel-pdf-csv-word-json-xml-and-text-file/

Laxmidhar Sahoo · Answer

download the file protected void DownloadFile( object sender, EventArgs e) { int id = int .Parse((sender as LinkButton).CommandArgument); byte [] bytes; string fileName, contentType; string constr = ConfigurationManager.ConnectionStrings[ "constr" ].ConnectionString; using (SqlConnection con = new SqlConnection(constr)) { using (SqlCommand cmd = new SqlCommand()) { cmd.CommandText = "select Name, Data, ContentType from tblFiles where Id=@Id" ; cmd.Parameters.AddWithValue( "@Id" , id); cmd.Connection = con; con.Open(); using (SqlDataReader sdr = cmd.ExecuteReader()) { sdr.Read(); bytes = ( byte [])sdr[ "Data" ]; contentType = sdr[ "ContentType" ].ToString(); fileName = sdr[ "Name" ].ToString(); } con.Close(); } } Response.Clear(); Response.Buffer = true ; Response.Charset = "" ; Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.ContentType = contentType; Response.AppendHeader( "Content-Disposition" , "attachment; filename=" + fileName); Response.BinaryWrite(bytes); Response.Flush(); Response.End(); }

Farhan Ahmed · Answer

https://selleo.com/blog/how-to-preview-doc-and-pdf-files-in-browser https://stackoverflow.com/questions/45325383/open-files-in-browser-instead-of-downloading-including-files-like-doc-xls-et