如何在水晶报表中显示图片?数据存储在sql sqerver2000的image字段中,代码:
SaveImg(picelimg.Image, "insert into zmlquote01d1(barcode,elimg) values('" + NeonBaseFun.AddComma(txtbarcode.Text) + "',@elimg)", "@elimg", trans); private void SaveImg(System.Drawing.Image img, string insert, string field, SqlTransaction trans)
{
byte[] imgdata;
using (System.IO.MemoryStream stream = new System.IO.MemoryStream())
{
Bitmap bmp = new Bitmap(img);
bmp.Save(stream, System.Drawing.Imaging.ImageFormat.Gif);
imgdata = new byte[stream.Length];
stream.Position = 0;
stream.Read(imgdata, 0, (int)stream.Length);
SqlCommand cmd = NeonConn.CreateCommand(insert);
cmd.Transaction = trans;
cmd.Parameters.Add(field, SqlDbType.Image);
cmd.Parameters[field].Value = imgdata;
cmd.ExecuteNonQuery();
cmd.Dispose();
bmp.Dispose();
}
}
有时图片会显示不出来,请问是什么原因?
SaveImg(picelimg.Image, "insert into zmlquote01d1(barcode,elimg) values('" + NeonBaseFun.AddComma(txtbarcode.Text) + "',@elimg)", "@elimg", trans); private void SaveImg(System.Drawing.Image img, string insert, string field, SqlTransaction trans)
{
byte[] imgdata;
using (System.IO.MemoryStream stream = new System.IO.MemoryStream())
{
Bitmap bmp = new Bitmap(img);
bmp.Save(stream, System.Drawing.Imaging.ImageFormat.Gif);
imgdata = new byte[stream.Length];
stream.Position = 0;
stream.Read(imgdata, 0, (int)stream.Length);
SqlCommand cmd = NeonConn.CreateCommand(insert);
cmd.Transaction = trans;
cmd.Parameters.Add(field, SqlDbType.Image);
cmd.Parameters[field].Value = imgdata;
cmd.ExecuteNonQuery();
cmd.Dispose();
bmp.Dispose();
}
}
有时图片会显示不出来,请问是什么原因?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货