uploading Images into Database

[sravankolla]

Hii All,
I havea problem with uploading Images into Database(MS Sql2000)..
and i want to retrive them back..
Please do favour to me..

[tgreer]

What have you tried? What specific problem are you having? Are you have problems saving, retrieving, or both? Show us the code you've written.

Have you done a web search?

http://www.google.com/search?hl=en&q=ASP.NET+upload+image+SQL+database&btnG=Google+Search

Several articles appear to deal with this topic.

[Blah Blah]

Private Sub btnadd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnadd.Click
        Dim fst As New FileStream(OpenDialog.FileName, FileMode.Open, FileAccess.Read)
        Dim s As String = cmb1.SelectedIndex
        Dim br As BinaryReader = New BinaryReader(fst)
        Dim buffer(fst.Length) As Byte
        br.Read(buffer, 0, CInt(fst.Length))
        fst.Close()
        InsertImage(buffer, s)
    End Sub
    Public Function InsertImage(ByRef buffer, ByVal str)
        SqlConnection1.Open()
        Try
            Dim com As New SqlCommand
            com.Connection = SqlConnection1
            com.CommandText = "insert into photo(image)values(@image)"
            com.Parameters.Add("@image", SqlDbType.Image).Value = buffer
            com.ExecuteNonQuery()
            MsgBox("IMAGE INSERTED SUCCESSFULLY")
        Catch ex As Exception
            MsgBox(ex.ToString)
        End Try
        SqlConnection1.Close()
    End Function
    Private Sub DrawToScale(ByVal bmp As Image)
        picbox.Image = New Bitmap(bmp)
    End Sub

THIS WILL ADD TEH SELECTED IMAGE TO THE SQL SERVER DATABASE AND TO SELECT........

=>USE PIC BOX ON FORM
=>DRAG OPENDIALOG TO THE FORM AND THEN BROWSE THE IMAGE FROM THE HARD DRIVE

[postmaster]

There is an example on
http://www.programmingknowledge.com/ImageUpload.aspx