How To Read And Add Image to Sql 2000 ???
By using vb.net 2003 code (not script)

thanks

Mr.Nsr

Here is the methodology that I used:

1.) The data type for your table should be "IMAGE".
2.) The following code will format your image so it can be saved:
        Dim fs As New FileStream(strFileName, FileMode.Open)
        Dim Data() As Byte = New [Byte](fs.Length) {}
        fs.Read(Data, 0, fs.Length)

        '* Your stored procedure code here...

3.) The following code will format your image so it can be displayed:
        '* Your stored procedure code here...
        '* In this case I used a DataReader

        Dim bits As Byte() = CType(.Item(strFieldName), Byte())
        Dim MemoryBits As New MemoryStream(bits)
        Dim bitmap As New Bitmap(MemoryBits)
        PictureBox1.Image = bitmap

Hope this helps.





Best Regards,
Earl Francis