Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
See more: VB.NET
Hello every one
can you help me to learn how can i Add an image to my SQL Database using VB.NET
Posted 12-Nov-12 19:50pm
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

Protected Sub btnUpload_Click
(ByVal sender As Object, ByVal e As EventArgs)
    Dim strImageName As String = txtName.Text.ToString()
    If FileUpload1.PostedFile IsNot Nothing AndAlso
       FileUpload1.PostedFile.FileName <> "" Then
        Dim imageSize As Byte() = New Byte
          (FileUpload1.PostedFile.ContentLength - 1) {}
        Dim uploadedImage__1 As HttpPostedFile =
        uploadedImage__1.InputStream.Read(imageSize, 0,
        ' Create SQL Connection
        Dim con As New SqlConnection()
        con.ConnectionString =
        ' Create SQL Command

        Dim cmd As New SqlCommand()
        cmd.CommandText = "INSERT INTO Images
           (ImageName,Image) VALUES (@ImageName,@Image)"
        cmd.CommandType = CommandType.Text
        cmd.Connection = con
        Dim ImageName As New SqlParameter
                  ("@ImageName", SqlDbType.VarChar, 50)
        ImageName.Value = strImageName.ToString()
        Dim UploadedImage__2 As New SqlParameter
            ("@Image", SqlDbType.Image, imageSize.Length)
        UploadedImage__2.Value = imageSize
        Dim result As Integer = cmd.ExecuteNonQuery()
        If result > 0 Then
            lblMessage.Text = "File Uploaded"
        End If
    End If
End Sub

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 277
1 Maciej Los 210
2 BillWoodruff 205
3 Jochen Arndt 180
4 DamithSL 165
0 OriginalGriff 5,130
1 DamithSL 4,157
2 Maciej Los 3,670
3 Kornfeld Eliyahu Peter 3,470
4 Sergey Alexandrovich Kryukov 2,821

Advertise | Privacy | Mobile
Web02 | 2.8.141216.1 | Last Updated 13 Nov 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100