如何从sqlserver 2005检索两个不同的图像? [英] How to retrieve two different images from sqlserver 2005?

问题描述

大家好，

如何获取两个不同的图像，
例如照片，从sqlserver 2005到vb.net 2003中两个不同的PictureBox的签名?

在此先感谢

Hello All,

How can I retrieve two different images,
e.g photo, signature from sqlserver 2005 to two different picturebox in vb.net 2003?

Thanks in advance

推荐答案

从SQL Server检索图像的代码.

公共子Page_Load(作为对象发送，作为EventArgs发送)

将myConnection设置为新的SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"))
将myCommand设置为新的SqlCommand(从Person中选择*"，myConnection)

试试
myConnection.Open()
将myDataReader昏暗为SqlDataReader
myDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection)

尽力而为(myDataReader.Read())
Response.ContentType = myDataReader.Item("PersonImageType")
Response.BinaryWrite(myDataReader.Item("PersonImage"))
循环

myConnection.Close()
Response.Write(成功检索个人信息！")
将SQLexc捕获为SqlException
Response.Write("Read Failed:"& SQLexc.ToString())
结束尝试

结束Sub

Code to retrieve image from sql server.

Public Sub Page_Load(sender As Object, e As EventArgs)

Dim myConnection As New SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"))
Dim myCommand As New SqlCommand("Select * from Person", myConnection)

Try
myConnection.Open()
Dim myDataReader as SqlDataReader
myDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection)

Do While (myDataReader.Read())
Response.ContentType = myDataReader.Item("PersonImageType")
Response.BinaryWrite(myDataReader.Item("PersonImage"))
Loop

myConnection.Close()
Response.Write("Person info successfully retrieved!")
Catch SQLexc As SqlException
Response.Write("Read Failed : " & SQLexc.ToString())
End Try

End Sub

这篇关于如何从sqlserver 2005检索两个不同的图像?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！