string SqlStr;
DatabaseUtil m_dbu=new DatabaseUtil();
SqlDataReader m_SqlDataReader;
SqlStr ="select aimg from dict_area where acode='"+Request.QueryString["acode"]+"'";
m_SqlDataReader = m_dbu.searchFromDb(SqlStr);
if(m_SqlDataReader.Read())
{
if (!m_SqlDataReader.IsDBNull(0))
{
Response.ContentType ="image/gif";
Response.BinaryWrite((byte[])m_SqlDataReader["aimg"]);
}
}
m_SqlDataReader.Close();
m_dbu.ClosesqlCon();
DatabaseUtil m_dbu=new DatabaseUtil();
SqlDataReader m_SqlDataReader;
SqlStr ="select aimg from dict_area where acode='"+Request.QueryString["acode"]+"'";
m_SqlDataReader = m_dbu.searchFromDb(SqlStr);
if(m_SqlDataReader.Read())
{
if (!m_SqlDataReader.IsDBNull(0))
{
Response.ContentType ="image/gif";
Response.BinaryWrite((byte[])m_SqlDataReader["aimg"]);
}
}
m_SqlDataReader.Close();
m_dbu.ClosesqlCon();
解决方案 »
- asp.net存储过程
- 高分求搜索技术的"汉语分词"好用的组件
- SDK2.0转1.0的问题
- checkbox的AutoPostBack=True时 每次点它 也面必须刷新,如何解决这个问题,并且是代码OnCheckedChanged="do_checkchanged"能运行?
- 用VS2005运行.NET程序,编译通过,但运行时页面报错:HTTP 500 - 内部服务器错误。查看OUTPUT,显示什么No symbols loaded,大家帮我。
- 三级联动的dropdownlist在修改时怎么加载原来的数据
- 请教一下大家是如何读书的?
- 怎样改变树节点的字体和颜色?
- 做人才网站,页面状态管理用Cookie,还是Session好?
- 为什么在textbox 填完内容会调用page_load 一次?
- 在ASP.NET中使用<input type=file>實現上傳時只能上傳小于4M的文件﹐如何解決大于4M文件上傳的問題?
- 初学者进来!!学习源程序大放送!!!
myConnection = new OracleConnection("Password=mk;User ID=mk;Data Source=redb.retech.com");
string sql;
sql = "SELECT SYSTEMTITLE,SYSTEMCONTENT FROM T_TrainSafeSystem WHERE ID = '" + Request.QueryString["ID"] + "'";
OracleCommand cmd = new OracleCommand(sql,myConnection);
OracleDataAdapter adapter = new OracleDataAdapter(sql,myConnection);
DataSet ds = new DataSet();
adapter.Fill(ds,"showText");
byte[] sysRuler = (byte[])ds.Tables["showText"].Rows[0]["SYSTEMCONTENT"];
Response.BinaryWrite(sysRuler);
strsqlconn = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"].ToString();
SqlConnection sqlConn = new SqlConnection(strsqlconn);
sqlConn.Open(); //查找符合条件的图片,取出来
string strsql;
strsql = "select Image from Page_Image where Page_Id='"+strid+ "'";
SqlDataAdapter daImage = new SqlDataAdapter(strsql, sqlConn); //定义一个DataSet,并且进行填充数据
DataSet dsImage = new DataSet();
daImage.Fill(dsImage,"Page_Image"); //取消和数据库的关联,释放资源
sqlConn.Close();
daImage.Dispose();
sqlConn.Dispose(); //从数据库中读出图片流
byte[] btImage = (byte[])dsImage.Tables["Page_Image"].Rows[0]["Image"];
System.IO.MemoryStream ms = new MemoryStream(btImage);
//create a bitmap object
System.Drawing.Bitmap bmp = new Bitmap(ms); // create the actual thumbnail image
System.Drawing.Image thumImage = bmp.GetThumbnailImage(1638,2338,new System.Drawing.Image.GetThumbnailImageAbort(ThumbnailCallback),IntPtr.Zero); // make a memory stream to work with the image bytes
MemoryStream msimage = new MemoryStream(); // put the image into the memory stream
thumImage.Save(msimage,System.Drawing.Imaging.ImageFormat.Jpeg); // make byte array the same size as the image
byte[] imageContent = new Byte[msimage.Length]; // rewind the memory stream
msimage.Position = 0;
// load the byte array with the image
msimage.Read(imageContent, 0, (int)msimage.Length); // return byte array to caller with image type
Response.ContentType = "image/JPEG";
Response.BinaryWrite(imageContent);
Response.End();
你读的是Sql server 2000吗?