Download file from database is not working in Firefox browser

Hi,

Which file format recognizes in other browsers?

Hello In the case that I tested, the PDF format is recognized by the Firefox browser, but the file format is not recognized by other browsers such as Google Chrome or Edge. Or, for example, the dwg file (application/acad) is not recognized at all in any browser.

We have verified in all browser. There is no issue with the code.

Plase share your implemented code.

HI

This is Function For Get ContentType:

private string GetContentType(string fileExtension)
{
    if (string.IsNullOrEmpty(fileExtension))
        return string.Empty;

    string contentType = string.Empty;
    switch (fileExtension)
    {
        case ".htm":
        case ".html":
            contentType = "text/HTML";
            break;

        case ".txt":
            contentType = "text/plain";
            break;

        case ".doc":
        case ".rtf":
        case ".docx":
            contentType = "application/msword";
            break;

        case ".xls":
        case ".xlsx":
            contentType = "application/x-msexcel";
            break;

        case ".jpg":
        case ".jpeg":
            contentType = "image/jpeg";
            break;

        case ".gif":
            contentType = "image/GIF";
            break;

        case ".pdf":
            contentType = "application/pdf";
            break;
        case ".dwg":
            contentType = "application/acad";
            break;
    }

    return contentType;
}

This is My Code For Download File:

Random myrandom = new Random();

int MyValue = myrandom.Next();
string FileName = "tmpFile_" + MyValue.ToString();
string ContentType = string.Empty;
byte[] FileData = null;
ConnectionString = CryptorEngine.Decrypt(ConfigurationManager.ConnectionStrings["Connection"].ConnectionString, true);
SqlConnection ConMain = new SqlConnection();
ConMain.ConnectionString = ConnectionString;
ConMain.Open();
SqlCommand CmdMain = new SqlCommand();
CmdMain.Connection = ConMain;
CmdMain.CommandType = CommandType.StoredProcedure;
CmdMain.CommandText = "SP_ShowSelectFile";
CmdMain.Parameters.AddWithValue("@File_ID", int.Parse(this.lbFileID.Text.Trim()));
SqlDataReader DrData = CmdMain.ExecuteReader();
DrData.Read();
ContentType = DrData["FileExtension"].ToString();
FileData = (byte[])DrData["FileData"];
DrData.Close();
ConMain.Close();
Response.Clear();
Response.Buffer = true;
Response.Charset = "";
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = GetContentType(ContentType);
Response.AppendHeader("Content-Disposition", "attachment; filename=" + FileName);
Response.AppendHeader("Content-Lenght", FileData.Length.ToString());
Response.BinaryWrite(FileData);
this.Context.ApplicationInstance.CompleteRequest();

Hi masoud1982ya,

Using below article i have created the example.

Download (Save) VARBINARY Data as File in ASP.Net using C# and VB.Net

Refer below example.

HTML

<asp:FileUpload ID="FileUpload1" runat="server" />
<asp:Button ID="btnUpload" runat="server" Text="Upload" OnClick="Upload" />
<hr />
<asp:GridView ID="GridView1" runat="server" HeaderStyle-BackColor="#3AC0F2" HeaderStyle-ForeColor="White"
    RowStyle-BackColor="#A1DCF2" AlternatingRowStyle-BackColor="White" AlternatingRowStyle-ForeColor="#000"
    AutoGenerateColumns="false">
    <Columns>
        <asp:BoundField DataField="Name" HeaderText="File Name" />
        <asp:TemplateField ItemStyle-HorizontalAlign="Center">
            <ItemTemplate>
                <asp:LinkButton ID="lnkDownload" runat="server" Text="Download" OnClick="DownloadFile"
                    CommandArgument='<%# Eval("Id") %>'></asp:LinkButton>
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>

Namespaces

C#

using System.IO;
using System.Data.SqlClient;
using System.Configuration;

VB.Net

Imports System.IO
Imports System.Data.SqlClient
Imports System.Configuration

Code

C#

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        this.BindGrid();
    }
}

private void BindGrid()
{
    string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(constr))
    {
        using (SqlCommand cmd = new SqlCommand())
        {
            cmd.CommandText = "SELECT Id, Name FROM tblFiles";
            cmd.Connection = con;
            con.Open();
            GridView1.DataSource = cmd.ExecuteReader();
            GridView1.DataBind();
            con.Close();
        }
    }
}

protected void Upload(object sender, EventArgs e)
{
    string filename = Path.GetFileName(FileUpload1.PostedFile.FileName);
    string contentType = FileUpload1.PostedFile.ContentType;
    using (Stream fs = FileUpload1.PostedFile.InputStream)
    {
        using (BinaryReader br = new BinaryReader(fs))
        {
            byte[] bytes = br.ReadBytes((Int32)fs.Length);
            string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
            using (SqlConnection con = new SqlConnection(constr))
            {
                string query = "INSERT INTO tblFiles VALUES (@Name, @ContentType, @Data)";
                using (SqlCommand cmd = new SqlCommand(query))
                {
                    cmd.Connection = con;
                    cmd.Parameters.AddWithValue("@Name", filename);
                    cmd.Parameters.AddWithValue("@ContentType", contentType);
                    cmd.Parameters.AddWithValue("@Data", bytes);
                    con.Open();
                    cmd.ExecuteNonQuery();
                    con.Close();
                }
            }
        }
    }
    Response.Redirect(Request.Url.AbsoluteUri);
}

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 = GetContentType(Path.GetExtension(sdr["Name"].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();
}

private string GetContentType(string fileExtension)
{
    if (string.IsNullOrEmpty(fileExtension))
    {
        return string.Empty;
    }

    string contentType = string.Empty;
    switch (fileExtension)
    {
        case ".htm":
        case ".html":
            contentType = "text/html";
            break;
        case ".txt":
            contentType = "text/plain";
            break;
        case ".doc":
            contentType = "application/msword";
            break;
        case ".rtf":
            contentType = "application/rtf";
            break;
        case ".docx":
            contentType = "application/vnd.openxmlformats-officedocument.wordprocessingml.document";
            break;
        case ".xls":
            contentType = "application/vnd.ms-excel";
            break;
        case ".xlsx":
            contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
            break;
        case ".jpg":
        case ".jpeg":
            contentType = "image/jpeg";
            break;
        case ".gif":
            contentType = "image/gif";
            break;
        case ".pdf":
            contentType = "application/pdf";
            break;
        case ".dwg":
            contentType = "application/acad";
            break;
    }

    return contentType;
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
    If Not Me.IsPostBack Then
        Me.BindGrid()
    End If
End Sub

Private Sub BindGrid()
    Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
    Using con As SqlConnection = New SqlConnection(constr)
        Using cmd As SqlCommand = New SqlCommand()
            cmd.CommandText = "SELECT Id, Name FROM tblFiles"
            cmd.Connection = con
            con.Open()
            GridView1.DataSource = cmd.ExecuteReader()
            GridView1.DataBind()
            con.Close()
        End Using
    End Using
End Sub

Protected Sub Upload(ByVal sender As Object, ByVal e As EventArgs)
    Dim filename As String = Path.GetFileName(FileUpload1.PostedFile.FileName)
    Dim contentType As String = FileUpload1.PostedFile.ContentType
    Using fs As Stream = FileUpload1.PostedFile.InputStream
        Using br As BinaryReader = New BinaryReader(fs)
            Dim bytes As Byte() = br.ReadBytes(CType(fs.Length, Int32))
            Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
            Using con As SqlConnection = New SqlConnection(constr)
                Dim query As String = "INSERT INTO tblFiles VALUES (@Name, @ContentType, @Data)"
                Using cmd As SqlCommand = New SqlCommand(query)
                    cmd.Connection = con
                    cmd.Parameters.AddWithValue("@Name", filename)
                    cmd.Parameters.AddWithValue("@ContentType", contentType)
                    cmd.Parameters.AddWithValue("@Data", bytes)
                    con.Open()
                    cmd.ExecuteNonQuery()
                    con.Close()
                End Using
            End Using
        End Using
    End Using

    Response.Redirect(Request.Url.AbsoluteUri)
End Sub

Protected Sub DownloadFile(ByVal sender As Object, ByVal e As EventArgs)
    Dim id As Integer = Integer.Parse((TryCast(sender, LinkButton)).CommandArgument)
    Dim bytes As Byte()
    Dim fileName, contentType As String
    Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
    Using con As SqlConnection = New SqlConnection(constr)
        Using cmd As SqlCommand = New SqlCommand()
            cmd.CommandText = "SELECT Name, Data, ContentType FROM tblFiles WHERE Id = @Id"
            cmd.Parameters.AddWithValue("@Id", id)
            cmd.Connection = con
            con.Open()
            Using sdr As SqlDataReader = cmd.ExecuteReader()
                sdr.Read()
                bytes = CType(sdr("Data"), Byte())
                contentType = GetContentType(Path.GetExtension(sdr("Name").ToString()))
                fileName = sdr("Name").ToString()
            End Using
            con.Close()
        End Using
    End Using

    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()
End Sub

Private Function GetContentType(ByVal fileExtension As String) As String
    If String.IsNullOrEmpty(fileExtension) Then
        Return String.Empty
    End If
    Dim contentType As String = String.Empty
    Select Case fileExtension
        Case ".htm", ".html"
            contentType = "text/html"
        Case ".txt"
            contentType = "text/plain"
        Case ".doc"
            contentType = "application/msword"
        Case ".rtf"
            contentType = "application/rtf"
        Case ".docx"
            contentType = "application/vnd.openxmlformats-officedocument.wordprocessingml.document"
        Case ".xls"
            contentType = "application/vnd.ms-excel"
        Case ".xlsx"
            contentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
        Case ".jpg", ".jpeg"
            contentType = "image/jpeg"
        Case ".gif"
            contentType = "image/gif"
        Case ".pdf"
            contentType = "application/pdf"
        Case ".dwg"
            contentType = "application/acad"
    End Select

    Return contentType
End Function