Binary Data Type

Hello Dears,

I was Maked Pictures table in sql server 2005 with Two Col pic_Id (int) and picture(binary)

i need now ro insert image into this table by Asp.net under VB.net Code  i have in my form  FileUpload and button control

and this is my CodeProtected Sub btnLoad_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnLoad.Click

 Dim content() As Byte = ReadBitmap2ByteArray(FileUpload1.PostedFile.ContentType)

StoreBlob2DataBase(content)

End SubFunction ReadBitmap2ByteArray(ByVal FileName As String) As Byte()

Dim image As Drawing.Bitmap = New Drawing.Bitmap(FileName)Dim stream As IO.MemoryStream = New IO.MemoryStream()

image.Save(stream, System.Drawing.Imaging.ImageFormat.Bmp)Return stream.ToArray

End Function

 Sub StoreBlob2DataBase(ByVal content As Byte())

con.Open()Dim cm As New SqlCommand("Insert into Pictures(Pic_Id,picture) values(@id,@pic)", con)

cm.Parameters.AddWithValue("@ID", 1)Dim p1 As New SqlParameter

p1.ParameterName = "@pic"

p1.SqlDbType = Data.SqlDbType.Binary

p1.Value = content

p1.Size = content.Length

cm.Parameters.Add(p1)

cm.ExecuteNonQuery()

End Sub

 

when i make run to my website it give me an Exeption in this statement

Dim image As Drawing.Bitmap = New Drawing.Bitmap(FileName)

it tell me that Parameter is not valid

  i need help about this please

with my Best regard

khalil