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

Pradeep Rawat

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..

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar6y ago
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 Sahoo6y ago
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 Ahmed6y ago
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