|
- Private Sub CommandButton1_Click() '保存相片
- '引用Microsoft ActiveX Data Objects 2.x Library
- If strFile = False Or TextBox1.Text = "" Then Exit Sub
- Dim cnn As New ADODB.Connection
- Dim rs As New ADODB.Recordset
- Dim srm As New ADODB.Stream
- On Error GoTo ErrMsg
- cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & ThisWorkbook.Path & "\档案.mdb"
- srm.Mode = adModeReadWrite
- srm.Type = adTypeBinary
- srm.Open
- srm.LoadFromFile strFile
- SQL = "select * from 档案 where 编号='" & TextBox1.Text & "'"
- rs.Open SQL, cnn, adOpenDynamic, adLockOptimistic
- If rs.RecordCount = 0 Then rs.AddNew Else rs.Fields("编号").Value = TextBox1.Text
- rs.Fields("相片").Value = srm.Read()
- rs.Update
- MsgBox "相片已存入数据库", vbInformation
- Set rs = Nothing
- rs.Close
- Set srm = Nothing
- Set cnn = Nothing
- cnn.Close
- Exit Sub
- ErrMsg:
- MsgBox Err.Description, , "错误报告"
- End Sub
复制代码 |
|