请问如何将SQL SERVER数据库中的图片导入DATAGRID并正常显示为图片，如何在企业管理器中知道图片字段（二进制）是否为空，因为空与不空im

[csharplove]

请问如何将SQL SERVER数据库中的图片导入DATAGRID并正常显示为图片，如何在企业管理器中知道图片字段（二进制）是否为空，因为空与不空image字段值都是binary,我不太懂SQL等数据库东东
敬请指教

[lhfeng]

读取:
<asp:TemplateColumn HeaderText="Image">
<ItemTemplate>
<asp:Image
Width="150" Height="125"
ImageUrl='<%# FormatURL(DataBinder.Eval(Container.DataItem, "PersonID")) %>'
Runat=server />
</ItemTemplate>
</asp:TemplateColumn>


And the method FormatURL (A Server side Function) is as follows.

Function FormatURL(strArgument) as String
Return ("readrealimage.aspx?id=" & strArgument)
End Function

And the method FormatURL (A Server side Function) is as follows.

Function FormatURL(strArgument) as String
Return ("readrealimage.aspx?id=" & strArgument)
End Function
显示:
Public Sub Page_Load(sender As Object, e As EventArgs)

Dim strImageID as String = Request.QueryString("id")

' Create Instance of Connection and Command Object
Dim myConnection As New SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"))
Dim myCommand As New SqlCommand("Select PersonImageType, PersonImage from das_person_real_images Where PersonID=" & strImageID, myConnection)

' I have used the select statement. But it would be much much better, if you
'could write a small stored procedure which contains the above sql statement.
' Mark the Command as a SPROC (in case, if you wrote the stored procedure
'myCommand.CommandType = CommandType.StoredProcedure

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()
Catch SQLexc As SqlException

End Try

End Sub

[DavidBone]

up

[yypt111]

假设你的Image参数:VbyteFile[](以二进制数组传入)

这样判断：
if (VbyteFile==null）{
//
}
else
{
//
}

[yypt111]

将数据库字段定义为image(可以存放：Doc,Txt,Gif,Jpg...所有文件)

[PoorAngel]

收藏!

[孟子E章]

http://xml.sz.luohuedu.net/xml/ShowDetail.asp?id=EY1XLDYV-PIDF-43LO-1WFL-FMY5ALE1F635

[gqxm]

http://www.chinaaspx.com/searchsite.htm

[yirenboy]

哈哈，这个简单
在查询分析器里 SELECT * FROM YourTable WHERE 图字段 IS NOT NULL

楼上的不用这么兴师动众哈

[极限999]

mark