Updating The Image Field In SQL Server Via DataSet

Hello,

I am trying to update the Image type field named as BlobData in sqlServer 2000. I capture the record in a data set to have the schema and try to update the BlobData field of type Image by assigning it a value of buffer as below. but my assignment seems to be wrong and generates an error saying Object reference not set.

Code
=========================

Dim
fileBuffer(contentLength)
As
Byte

 

Dim
attachmentFile
As HttpPostedFile =
Me.fileUpload_fu.PostedFile

 

attachmentFile.InputStream.Read(fileBuffer, 0, contentLength)
 

Dim
cn
As SqlClient.SqlConnection

 

Try


      Dim
sSQL
As
String


     
Dim cmd
As SqlClient.SqlCommand


     
Dim da
As SqlClient.SqlDataAdapter


     
Dim ds
As System.Data.DataSet =
New DataSet

 


      cn =
New SqlClient.SqlConnection(myconnectionString)

 

cn.Open()

 

sSQL = "SELECT * FROM Attachment WHERE ID = " & attachmentRecordID


                           

cmd =
New SqlClient.SqlCommand(sSQL, cn)

 

da =
New SqlClient.SqlDataAdapter(cmd)

 

da.Fill(ds)


If
(ds.Tables(0).Rows.Count = 1)
Then

 


      ' ======================================

' ERROR GENERATED HERE


' ======================================

 

ds.Tables("Attachment").Rows(0).Item("BlobData") = fileBuffer

' ====================================== 

 

da.Update(ds, "Attachment")

 

Return

True

Else

Return

False

End

If

 

Catch
ex
As Exception

Me
.error_lbl.Text = ex.Message


           
Return
False

Finally

cn.Close()


End

Try

==========================

Can anyone please help this one out.

Cheers.
Imran.