net+oracle存贮图片
来源:互联网 发布:node inspector 编辑:程序博客网 时间:2024/05/23 15:34
temp = xclsywcl.SavePhoto2(txtsfzhm.Text, Photosbinary())
If temp = "" Then
MsgBox("新增成功")
txtsfzhm.Focus()
Else
MsgBox("更新照片时发生错误,错误原因:" & temp)
End If
'将图片转化为字节信息
Private Function Photosbinary() As Byte()
Try
Dim image As New Bitmap(PictureBox1.Image)
Dim stream As New MemoryStream
image.Save(stream, System.Drawing.Imaging.ImageFormat.Bmp)
Return stream.ToArray()
Catch ex As Exception
Return Nothing
End Try
End Function
Public Function SavePhoto2(ByVal data_id As String, ByVal p_Blob As Byte()) As String
Dim cn As OracleConnection = New OracleConnection(GetConn2) 'oracle数据库
Try
cn.Open()
Dim photoadapter As OracleDataAdapter
photoadapter = New OracleDataAdapter("SELECT * FROM drv_photo WHERE sfzmhm ='" + data_id + "'", cn)
Dim photoDataSet As New DataSet("drv_photo")
photoadapter.Fill(photoDataSet, "drv_photo")
Dim updatesql As String = "UPDATE drv_photo SET zp=:vPHOTO WHERE sfzmhm='" + data_id + "'"
Dim updatecmd As New OracleCommand(updatesql, cn)
photoadapter.UpdateCommand = updatecmd
photoadapter.UpdateCommand.Parameters.Add(":vPHOTO", OracleType.Blob, p_Blob.Length, "ZP")
photoadapter.MissingSchemaAction = MissingSchemaAction.AddWithKey
photoadapter.FillSchema(photoDataSet, SchemaType.Source, "drv_photo")
photoadapter.Fill(photoDataSet, "drv_photo")
Dim phototable As DataTable 'table
Dim photoRow As DataRow 'datarow
phototable = photoDataSet.Tables("drv_photo")
photoRow = phototable.Rows(0)
photoRow.BeginEdit()
photoRow("zp") = p_Blob
photoRow.EndEdit()
photoadapter.Update(photoDataSet, "drv_photo")
Return ""
Catch e As Exception
Return e.ToString
Finally
cn.Close()
End Try
End Function
- net+oracle存贮图片
- .net操作Oracle存贮过程
- .net + SQL语句和存贮过程插入图片
- oracle rowid存贮类型
- oracle存贮过程示例
- 图片拍照图片 处理工具 旋转 存贮等等
- 把附件(WORD、EXCEL、PDF)或图片存贮到数据库的完整范例程序。(MYSQL、SQL SERVER、ORACLE)三个版本
- 把附件(WORD、EXCEL、PDF)或图片存贮到数据库的完整范例程序。(MYSQL、SQL SERVER、ORACLE)三个版本
- Asp.net中,用Oarcle存贮过程实现,高效率翻页
- Server Side ViewState 在服务器端存贮ViewState (ASP.NET 2.0)
- Oracle实践之存贮过程的创建与执行(7)
- Asp.Net 保存图片或读取图片从Oracle数据库
- 数据存贮
- 存贮byte[]
- 临时存贮
- 存贮信息量
- 存贮beatbox
- 存贮过程
- XNA学习笔记——SpriteBatch.Draw的layerDepth
- 巧用On Field Update Invoke,和Named Method
- NETCFv35.Messages.zh-CHS.wm.cab 下载 download
- 软件测试搜索功能测试用例
- Spool_internal_error 错误解析.
- net+oracle存贮图片
- Random generate in C
- (一)AJAXPro之旅---神奇的小魔盒
- 身份证号码15位转18位
- 委托调用
- typedef的四个用途和两个陷阱
- 获取oracle服务器上的当前时间
- 如何解析超长的protobuf
- 获取ORACLE符合记录的前5条