一、将图片存入Oracle数据库
示例表NEWS的结构为:newsid number(10),title varchar2(100),image(blob)
方法1:利用OracleCommandBuilder类(该类用于自动生成用于协调 DataSet 的更改与关联的数据库的单表命令。)
Dim cn As New OracleConnection("data source=site;uid=gf;pwd=macro;")
cn.Open()
Dim da As New OracleDataAdapter("select * from news", cn)
Dim myCB As New OracleCommandBuilder(da)
Dim ds As New DataSet("news")
da.MissingSchemaAction = MissingSchemaAction.AddWithKey
Dim fs As Stream = File1.PostedFile.InputStream 'File1为文件选择框,作为服务器控件使用
Dim mydata(fs.Length) As Byte
fs.Read(mydata, 0, fs.Length)
fs.Close()
da.Fill(ds, "news")
Dim myRow As DataRow = ds.Tables("news").NewRow
m