VS2005怎么实现图片控件中的图像存储到SQL和读取SQL中的图像
谢谢各位的帮忙
把图片控件中的图像保存到SQL
查找图片的时候从SQL查询并显示在图片控件中
[解决办法]
protected void Page_Load(object sender, EventArgs e)
{
string photoid;
photoid = Request.Params[ "id "];
Image aa = (Image)FormView1.FindControl( "Image1 ");
aa.ImageUrl = GetPicPath(photoid);
}
private string GetPicPath(string addictNo)
{
OracleConnection conn = new OracleConnection( " ");
OracleCommand Oraclecomm = new OracleCommand();
Oraclecomm.CommandText = "SELECT pic FROM pp WHERE rybh = ' " + addictNo + " ' ";
Oraclecomm.Connection = conn;
OracleDataAdapter da = new OracleDataAdapter(Oraclecomm);
DataSet ds = new DataSet();
conn.Open();
da.Fill(ds, "pp ");
conn.Close();
Response.Clear();
//将图片数据存成本地文件
string tempfile = " " + addictNo + ".jpg ";
string fpath = Server.MapPath(Request.ApplicationPath) + "\\temp\\ " + tempfile;
FileStream fs = new FileStream(fpath, FileMode.OpenOrCreate, FileAccess.Write);
BinaryWriter bw = new BinaryWriter(fs);
bw.Write((byte[])ds.Tables[ "pp "].Rows[0][0]);
bw.Close();
return "temp/ " + tempfile;
}
从数据库中读取图片信息在IMAGE中显示，分拿来，呵呵
[解决办法]
顶
