Public Sub SavePic(ByVal pPicPath As String) Dim Rs As New ADODB.Recordset dim adoCn As New ADODB.Connection Dim bytPicData() As Byte dim strCn As String
Open pPicPath For Binary As #1 ReDim bytPicData(LOF(1) - 1) Get #1, , bytPicData() Close #1 strCn = "Provider=SQLOLEDB.1;User ID=sa;Initial Catalog=databasename;Data Source=Server;Password=;" adoCn.Open strCn Rs.Open "SELECT * FROM dPicture", adoCn, adOpenKeyset, adLockOptimistic Rs("PicData").AppendChunk bytPicData() Rs.Update Set Rs = Nothing End Sub
Dim Rs As New ADODB.Recordset
dim adoCn As New ADODB.Connection
Dim bytPicData() As Byte
dim strCn As String
Open pPicPath For Binary As #1
ReDim bytPicData(LOF(1) - 1)
Get #1, , bytPicData()
Close #1 strCn = "Provider=SQLOLEDB.1;User ID=sa;Initial Catalog=databasename;Data Source=Server;Password=;"
adoCn.Open strCn Rs.Open "SELECT * FROM dPicture", adoCn, adOpenKeyset, adLockOptimistic
Rs("PicData").AppendChunk bytPicData()
Rs.Update Set Rs = Nothing
End Sub