asked on
Hi I am trying to upload an image - Logo.jpg display it in an asp image (Image1) then save it to SQL 2014 Server database file
File name - LogoFile Fields ID - Type = Integer, Logo - Type = Image
Then when program rerun get the image from database and redisplay in the asp image
I have tried a few web for information sites to Save the data but without the Upload showning the jpg I doint know if it works
Folowing is the code for Uploading the logo
then displaying when program is rerun
and Saving the logo
Protected Sub bLogo_Click(sender As Object, e As EventArgs) Handles bLogo.Click
Dim FolderPath As String = ConfigurationManager.AppSettings("LogoPath")
If FileUpload1.HasFile Then
Dim fileDelete = FolderPath & FileUpload1.FileName
If System.IO.File.Exists(fileDelete) = True Then
Try
System.IO.File.Delete(fileDelete)
Catch ex As Exception
Finally
End Try
End If
Dim filePath As String = FolderPath & FileUpload1.FileName
FileUpload1.SaveAs(filePath)
Image1.Attributes.Add("style", "background-repeat: no-repeat; background-image:url(filepath)") ???
Image1.ImageUrl = filePath ???
Else
Exit Sub
End If
End Sub
If Not Me.IsPostBack Then
Dim conn As New SqlConnection(connString)
Using sqlCommand = New SqlCommand()
With sqlCommand
If conn.State = ConnectionState.Open Then conn.Close()
conn.Open()
.CommandText = "SELECT Logo FROM LogoFile where Id=@Id"
.Parameters.Clear()
.Parameters.AddWithValue("@Id", 1)
.Connection = conn
.CommandType = CommandType.Text
Dim logo = .ExecuteScalar()
Image1.ImageUrl = logo ???????
End With
sqlCommand.Dispose()
End Using
conn.Close()
conn.Dispose()
End If
Dim conn As New SqlConnection(connString)
conn.Open()
Dim SqlCommand = New SqlCommand()
With SqlCommand
.CommandText = "Insert Into File (Id, Logo)"
.CommandText = .CommandText & " Values (@ID, @Logo)"
.Connection = conn
.CommandType = CommandType.Text
.Parameters.Clear()
.Parameters.AddWithValue("@FD", "FD")
Dim url As String = Image1.ImageUrl
Dim bytes As Byte() = Convert.FromBase64String(Image1.ImageUrl.Split(","c)(1))
.Parameters.AddWithValue("@Logo", bytes)
.ExecuteNonQuery()
end with