Link to home
Create AccountLog in
.NET Programming

.NET Programming

--

Questions

--

Followers

Top Experts

Avatar of mathieu_cupryk
mathieu_cupryk🇨🇦

Open different content type of files. vb.net
I have the following:

Protected Sub GridViewAttachments_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) Handles GridViewAttachments.RowCommand
        If e.CommandName = "Browse" Then

            Dim myConnection As New SqlConnection(ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString)

            Dim index As Integer = Convert.ToInt32(lblInterviewID.Text)
            Try

                Dim ds As New DataSet

                Dim da As SqlClient.SqlDataAdapter

                Dim arrContent As Byte()

                Dim dr As DataRow

                Dim strSql As String
               
                strSql = "Select * from [tbl_dotnet_attachments] Where [AttachmentID]='" + e.CommandArgument.ToString() + "'"

                Dim myCommand As New SqlCommand(strSql, myConnection)

                da = New SqlClient.SqlDataAdapter(strSql, myConnection)

                da.Fill(ds)

                dr = ds.Tables(0).Rows(0)

                arrContent = CType(dr.Item("ImageContent"), Byte())

                Dim filePath As String = dr.Item("Filename").ToString()

                Dim dotPosition As Integer = filePath.LastIndexOf(".")

                Dim filenameOnly As String = filePath.Substring(dotPosition + 1)

                Select Case filenameOnly
                    Case "zip"
                        Response.ContentType = "application/x-zip-compressed"
                    Case "pdf"
                        Response.ContentType = "application/pdf"
                    Case "csv"
                        Response.ContentType = "application/csv"
                    Case "doc"
                        Response.ContentType = "application/doc"
                    Case "docx"
                        Response.ContentType = "application/docx"
                    Case "xls"
                        Response.ContentType = "application/xls"
                    Case "xlsx"
                        Response.ContentType = "application/xlsx"
                    Case "png"
                        Response.ContentType = "application/png"
                    Case "gif"
                        Response.ContentType = "application/gif"
                    Case "jpg"
                        Response.ContentType = "application/jpg"
                    Case "csv"
                        Response.ContentType = "application/csv"
                    Case "txt"
                        Response.ContentType = "application/txt"
                End Select

                Response.BinaryWrite(arrContent)
                Response.Flush()
                Response.Close()



            Catch ex As Exception

         
            End Try



           
        End If

    End Sub

it fails when I try to write the binary content.

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.


ASKER CERTIFIED SOLUTION
Avatar of AshleighGreenAshleighGreen

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Create Account

Avatar of mathieu_cuprykmathieu_cupryk🇨🇦

ASKER

i was missing Response.AddHeader("Content-disposition", "attachment;filename=" & strFriendlyName) //Make sure to
it is working.

Reward 1Reward 2Reward 3Reward 4Reward 5Reward 6

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.

.NET Programming

.NET Programming

--

Questions

--

Followers

Top Experts

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.