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?
Dim sss As Integer
'myConnection = New SqlConnection("server=localhost;uid=sa;pwd=;database=pubs")
myCommand = New SqlCommand("Update Authors Set city='Oakland' where city='San Jose' ", myConnection)
sss = myCommand.ExecuteNonQuery()
MsgBox("Records affected" & sss)