Insert an attachment into a SQL database

Hi

I am using Imports System.Data.SqlClient with the code below to add new records to my online SQL server database. I want to save attachments to the SQL server database. Is this possible? What sort of code would I use?

Thanks

Sub oUpdate()
        Dim sss As Integer
        'myConnection = New SqlConnection("server=localhost;uid=sa;pwd=;database=pubs")
        myConnection.Open()
        myCommand = New SqlCommand("Update Authors Set city='Oakland' where city='San Jose' ", myConnection)
        sss = myCommand.ExecuteNonQuery()
        MsgBox("Records affected" & sss)
        myConnection.Close()
    End Sub

Select allOpen in new window