byte[] bData = null;
string sContentType = "";
string ID = "";
ID = Request["ID"].ToString();
WdXxDAL wdxx = new WdXxDAL();
DataSet ds = wdxx.GetItemByWDBH(ID);
DataRow dr = ds.Tables[0].Rows[0];
bData = (byte[])dr["WDNR"];
string FileType = dr["wdlx"].ToString().ToLower();
switch (FileType)
{
case "jpg":
sContentType = "image/jpeg";
break;
case "jpeg":
sContentType = "image/jpeg";
break;
default:
sContentType = "";
break; } if (sContentType != "")
{
Response.ContentType = sContentType;
Response.BinaryWrite(bData);
}
为什么图片显示不出来,请大侠指点?
vs2005 oracle 9i 我用的是C# 操作系统xp sp2;
大家看看,这是为什么啊,bdata的长度不为0,说明已经把数据读出来了?
而且以上代码在sql server上确能执行成功,正确显示出图片来
string sContentType = "";
string ID = "";
ID = Request["ID"].ToString();
WdXxDAL wdxx = new WdXxDAL();
DataSet ds = wdxx.GetItemByWDBH(ID);
DataRow dr = ds.Tables[0].Rows[0];
bData = (byte[])dr["WDNR"];
string FileType = dr["wdlx"].ToString().ToLower();
switch (FileType)
{
case "jpg":
sContentType = "image/jpeg";
break;
case "jpeg":
sContentType = "image/jpeg";
break;
default:
sContentType = "";
break; } if (sContentType != "")
{
Response.ContentType = sContentType;
Response.BinaryWrite(bData);
}
为什么图片显示不出来,请大侠指点?
vs2005 oracle 9i 我用的是C# 操作系统xp sp2;
大家看看,这是为什么啊,bdata的长度不为0,说明已经把数据读出来了?
而且以上代码在sql server上确能执行成功,正确显示出图片来
解决方案 »
- 用C#.net怎样实现收取邮件
- 如何解决页面变形的问题?
- 图片上传后,显示不能马上刷新的问题
- XmlDocument.Load的問題
- Active控件读数据库遇到的问题,请进入看详情。如能解决可以再加一百分。
- 请 cuike519(marshal(修练中...)版主,从下午到现在了,就是调试不通,怎么回事?
- 谁有复合自定义控件的示例代码啊,求助,谢谢
- gridview的数据绑定问题????
- 问一下asp.net 编程方法 一
- 无法联接ORACLE数据库,错误信息:ORA-01034:ORACLE not available 其它信息
- 有关数据库转换问题。
- 没学过ASP 可以直接学习ASP.NET 2.0吗
Response.Clear();
Response.ContentType = sContentType;
Response.BinaryWrite(bData);
Response.End();
另外确定 sContentType != ""
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OracleClient;
using Microsoft.ApplicationBlocks.Data;
using GotDotNet.ApplicationBlocks.Data;
using Utility;namespace DAL
{
public class WdXxDAL
{ private const string SQL_SELECT = "SELECT wdbh,wdmc,wdlx,dwf,wdnr,lbdm,wdrq,wdzt,gdr FROM wdxx WHERE ";
private const string SQL_SELECT_ALL = "1=1 ";
private const string SQL_WDBH = " wdbh=@WDBH ";
private const string SQL_LBDM = " lbdm=@LBDM";
private const string SQL_ORDER = " Order By WDBH "; private const string PARM_LBDM = "@LBDM";
private const string PARM_WDBH = "@WDBH";
public WdXxDAL()
{
}
public DataSet GetItemByCustom(OracleParameter[] parms, string strQuery)
{
return OrlHelper.ExecuteDataset(Utility.Global.ConnString, CommandType.Text, strQuery, parms);
} private OracleParameter[] GetByLBDMParameters()
{
OracleParameter[] parms;
parms = new OracleParameter[] {
new OracleParameter(PARM_LBDM,OracleType.VarChar )
}; return parms;
}
}}
这是我的取数的类,没有错啊!请高手指教
{
OracleParameter[] parms;
parms = new OracleParameter[] {
new OracleParameter(PARM_WDBH,OracleType.VarChar )
}; return parms;
}
private void SetByWDBHParameters(OracleParameter[] parms, string ID)
{
parms[0].Value = ID; }
public DataSet GetItemByWDBH(string WDBH)
{ OracleParameter[] parms = GetByWDBHParameters();
SetByWDBHParameters(parms, WDBH);
string strQuery = SQL_SELECT + SQL_WDBH + SQL_ORDER;
return OrlHelper.ExecuteDataset(Utility.Global.ConnString, CommandType.Text, strQuery, parms);
}
请帮忙,谢谢!!!