Hello,

I have the following code that opens a file saved in db as varbinary(MAX): 

public void downloadFile(String appno, String file)
        {
            byte[] bytes;
            SqlConnection con = getConnection();
            try
            {
                using (SqlCommand cmd = new SqlCommand())
                    {
                        cmd.CommandType = CommandType.StoredProcedure;
                        cmd.CommandText = "sproc";
                        cmd.Parameters.Add("@Appno", SqlDbType.Int).Value = appno == "" ? Convert.DBNull : appno;
                  
                        cmd.Connection = con;
                        con.Open();
                        using (SqlDataReader sdr = cmd.ExecuteReader())
                        {
                            sdr.Read();
                            bytes = (byte[])sdr[file];
                        }
                        con.Close();
                    }
                HttpContext.Current.Response.ContentType = "application/pdf";
                HttpContext.Current.Response.Cache.SetCacheability(HttpCacheability.NoCache);
                HttpContext.Current.Response.BinaryWrite(bytes);
                HttpContext.Current.Response.Flush();
                HttpContext.Current.Response.End();

            }
            catch (Exception ex)
            {
                myMessageBox(ex.Message);
            }

How can I open the file with the correct extension if I don't know the type? The user can upload images and PDF files. In the example I can only open pdf files.

Thank you in advance.