如何从数据库中获取图片。
数据库中是存储的图片位置,但是我现在已经把图片的位置获取出来了,不晓得如何转成图片显示在页面这事以下代码。
using System;
using System.Collections.Generic;
using System.Data;
using System.Text;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Mobile_Content_BLL;
namespace Mobile_Content.Mobile
{
public partial class FoodStuff_type1 : System.Web.UI.Page
{
public string bb = string.Empty;
public string Content = string.Empty;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Contents();
}
}
public void Contents()
{
if (null == Request["id"])
{
Response.Write("");
Response.End();
}
int id = Convert.ToInt32(Request["id"]); //接收ID
StringBuilder str = new StringBuilder();
DataTable dt = new Mobile_Content_BLL.Mobile_Manager.Mobile_Manager().FoodStuff_Type(id); //读取数据
if (dt.Rows.Count != 0)
{
//byte[] bPhoto = dt.Rows[0]["pics"] as byte[];
string name = dt.Rows[0]["name"].ToString();
string bieming = dt.Rows[0]["bieming"].ToString();
string tupian = dt.Rows[0]["pics"].ToString(); //这里是图片获取出来的只是路径
string pinyin = dt.Rows[0]["pinyin"].ToString();
string gongxiao = dt.Rows[0]["gongxiao"].ToString();
string googfor = dt.Rows[0]["goodfor"].ToString();
string badfor = dt.Rows[0]["badfor"].ToString();
string feature = dt.Rows[0]["feature"].ToString();
string desc = dt.Rows[0]["desc"].ToString();
Content = "<table style=\"width:100%\"><tr><td style='width:100px'><b>[名称]</b> " + name + "</td></tr> <tr><td><b>[别名]</b> " + bieming + "</td></tr><tr><td><b>[图片]</b> " + tupian + "</td></tr><tr><td><b>[拼音]</b> " + pinyin + "</td></tr><tr><td><B>[功效]</b> " + gongxiao + "</td></tr><tr><td><b>[适宜]</b> " + googfor + "</td></tr><tr><td><b>[禁忌]</b> " + badfor + "</td></tr><tr><td><b>[特点]</b> " + feature + "</td></tr><tr><td><b>[描述]</b> " + desc + "</td></tr></table>";
this.Response.Write(Content);
}
else
{
Response.Write("lock");
Response.End();
}
bb = str.ToString();
Response.Write(bb);
Response.End();
}
}
} --------------------编程问答-------------------- 用控件显示出来,比如Image控件
Image1.ImageUrl="图片路径"; --------------------编程问答-------------------- Content = "<table style=\"width:100%\"><tr><td style='width:100px'><b>[名称]</b> " + name + "</td></tr> <tr><td><b>[别名]</b> " + bieming + "</td></tr><tr><td><b>[图片]</b> <img src=" + tupian + " /></td></tr><tr><td><b>[拼音]</b> " + pinyin + "</td></tr><tr><td><B>[功效]</b> " + gongxiao + "</td></tr><tr><td><b>[适宜]</b> " + googfor + "</td></tr><tr><td><b>[禁忌]</b> " + badfor + "</td></tr><tr><td><b>[特点]</b> " + feature + "</td></tr><tr><td><b>[描述]</b> " + desc + "</td></tr></table>";
补充:.NET技术 , C#