zhlxh1201 发表于 2007-9-11 16:46

怎样读取oracle数据库中的blob字段并显示在Image上

怎样读取oracle数据库中的blob字段并显示在Image上

zhlxh1201 发表于 2007-9-11 16:53

Dim strConnection As String = System.Configuration.ConfigurationManager.AppSettings("kksb")<BR>Dim Conn As System.Data.OleDb.OleDbConnection = New System.Data.OleDb.OleDbConnection(strConnection)<BR>Dim strSQL As String = "select photo from t_veh_matching where picname=" &amp; Request("picname")<BR>Dim comm As System.Data.OleDb.OleDbCommand = New System.Data.OleDb.OleDbCommand(strSQL, Conn)<BR>Dim myReader As System.Data.OleDb.OleDbDataReader = comm.ExecuteReader(CommandBehavior.SequentialAccess)<BR>Do While myReader.Read()<BR>    ' Get the publisher id, which must occur before getting the logo.<BR>    <FONT color=#f70909>Photo = myReader.GetString(0)<BR></FONT>以上是我的程序<BR>红色一句报错：指定的转换无效

bygg 发表于 2007-9-11 19:12

你的Photo是什么类型啊?<br>myReader.GetString(0) 这个取出来是string型的

zhlxh1201 发表于 2007-9-12 08:45

<P>是blob类型的</P>

zhlxh1201 发表于 2007-9-12 08:46

我是不是改用GetByte来取值

bygg 发表于 2007-9-12 10:20

是的,你试试吧<BR><a href="http://bbs.bc-cn.net/viewthread.php?tid=112678&amp;star=at" target="_blank" >http://bbs.bc-cn.net/viewthread.php?tid=112678&amp;star=at</A>#

zhlxh1201 发表于 2007-9-12 12:34

我使用BS方式编写的<BR>程序代码与你给的有点出入<BR>由于我是新手<BR>请指点

zhlxh1201 发表于 2007-9-12 15:54

Dim strConnection As String = System.Configuration.ConfigurationManager.AppSettings("kksb")<BR>Dim Conn As System.Data.OleDb.OleDbConnection = New System.Data.OleDb.OleDbConnection(strConnection)<BR>Dim strSQL As String = "select photo from t_veh_matching where picname=" &amp; Request("picname")<BR>Dim comm As System.Data.OleDb.OleDbCommand = New System.Data.OleDb.OleDbCommand(strSQL, Conn)<BR>Dim de As System.Data.OleDb.OleDbDataReader<BR>dr = comm.ExcuteScalar()<BR>

bygg 发表于 2007-9-12 20:08

<P>用DataReader取值..再用BTYE的形式转成Image,</P>

zhlxh1201 发表于 2008-1-15 15:55

？？？

怎么办？

zhlxh1201 发表于 2008-1-18 11:21

???

咋就没人理我呢？

fairy4 发表于 2008-1-18 12:04

人家都給你相似的詳細代碼！還要怎么幫你？？？？？？？？？
按照你的所有詳細要求，幫你完成你的工作？？？？

bygg 发表于 2008-1-18 12:32

Dim data() As Byte = ds.Tables("employees").Rows(9)("photo")
Dim stmphoto As New MemoryStream(data)
PictureBox1.Image = Image.FromStream(stmphoto)

这是我给的链接网页中的三句，这个你能看懂吧？
那你就成功了。

页: [1]

编程论坛