图片是以二进制的形式存到数据库里,现在想把它读出来写道页面上的特定的位置,我打算写到控件上,然后用控件定位,请问大家怎样实现?
下面的Code实现了把图片打到页面上,但是没有实现准确的定位。而且读出的图片失桢。
Dim dbCmd As OleDbCommand
Dim dbReader As OleDbDataReader
Dim strSql As String = "SELECT FILE_PIC FROM M_FILE WHERE BORYUMU_ID = " & Request.QueryString("ID")
dbCmd = New OleDbCommand(strSql, dbConn)
dbReader = dbCmd.ExecuteReader
If dbReader.Read Then
If Not IsDBNull(dbReader("FILE_PIC")) Then
Response.ContentType = "image/gif"
Response.BinaryWrite(dbReader("FILE_PIC"))
End If
Else
Response.Write("aaaaa")
End If
下面的Code实现了把图片打到页面上,但是没有实现准确的定位。而且读出的图片失桢。
Dim dbCmd As OleDbCommand
Dim dbReader As OleDbDataReader
Dim strSql As String = "SELECT FILE_PIC FROM M_FILE WHERE BORYUMU_ID = " & Request.QueryString("ID")
dbCmd = New OleDbCommand(strSql, dbConn)
dbReader = dbCmd.ExecuteReader
If dbReader.Read Then
If Not IsDBNull(dbReader("FILE_PIC")) Then
Response.ContentType = "image/gif"
Response.BinaryWrite(dbReader("FILE_PIC"))
End If
Else
Response.Write("aaaaa")
End If
{
Dim dbCmd As OleDbCommand
Dim dbReader As OleDbDataReader
Dim strSql As String = "SELECT FILE_PIC FROM M_FILE WHERE BORYUMU_ID = " & Request.QueryString("ID")
dbCmd = New OleDbCommand(strSql, dbConn)
dbReader = dbCmd.ExecuteReader
If dbReader.Read Then
If Not IsDBNull(dbReader("FILE_PIC")) Then
Response.ContentType = "image/gif"
Response.BinaryWrite(dbReader("FILE_PIC"))
End If
Else
Response.Write("aaaaa")
End If
}//////////////////////////
下面的代码是要显示图片的页面“showimg.aspx”
在该页面中加入image控件
<asp:Image id="Image1" runat="server"ImageUrl="ImageGen.aspx"></asp:Image>
<asp:TemplateColumn>
<ItemTemplate>
<asp:Image ID="VolImage1" ImageUrl="ebasew_getPic.aspx?ID='<%# DataBinder.Eval(Container.DataItem, "Col1")%>'" width="100" height="100" Runat="server"></asp:Image>
</ItemTemplate>
</asp:TemplateColumn>