如何提取sqlserver中得图片(不是图片地址)? asp.net中如何提取sqlserver中得图片(不是图片地址)?并显示到页面 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 using System;using System.Data;using System.Data.SqlClient;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.HtmlControls;namespace ReadImage {public class MainDisplay : System.Web.UI.Page {public void Page_Load(System.Object sender, System.EventArgs e) { int ImgID = Convert.ToInt32(Request.QueryString["ImgID"]); //ImgID为图片ID //建立链接 SqlConnection Con = new SqlConnection("Data Source=KING;Initial Catalog=testdb;User ID=sa;Pwd=;"); String SqlCmd = "SELECT * FROM ImageStore WHERE ImageID = @ImageID"; SqlCommand CmdObj = new SqlCommand(SqlCmd, Con); CmdObj.Parameters.Add("@ImageID", SqlDbType.Int).Value = ImgID; Con.Open(); SqlDataReader SqlReader = CmdObj.ExecuteReader(); SqlReader.Read(); Response.ContentType = (string)SqlReader["ImageContentType"];//设定输出文件类型 //输出图象文件二进制数制 Response.OutputStream.Write((byte[])SqlReader["ImageData"], 0, (int)SqlReader["ImageSize"]); Response.End(); Con.Close(); // 创建一个新的getimage.aspx code :try { sqlcon.Open(); sqldr=sqlcmd.ExecuteReader(); if(sqldr.Read()) { Response.Clear(); //Response.ContentType=(string)sqldr["ImageContentType"];//设定输出文件类型 //输出图象文件二进制数制 byte[] imagecontent=(byte[])sqldr[0]; //Response.BinaryWrite((byte[])sqldr["Imageinf"]); Response.BinaryWrite(imagecontent); } sqldr.Close(); sqlcon.Close(); } catch(Exception ee) { Response.Write(ee.Message.ToString()); } Response.End(); 在EA软件中,如何绘制通信图? asp.net结合WMI的应用 javascript 帮助手册 asp.net 如何使用双缓冲优化图片显示 winform、webform和B/S 、C/S的关系? asp.net 点击按钮保留原来页面,打开新页面 一点小问题,但是你看了后才知道会不会,不信你看----> 后台管理问题 <form runat=server> 问题 急急急急急急急急!!!!!100分 EntityFramework做的程序服务器iis必须安装ef么 问个关于asp的简单问题。 输出下载文件后,所有的javascript语句都找不到了??
using System.Data;
using System.Data.SqlClient;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
namespace ReadImage {
public class MainDisplay : System.Web.UI.Page {
public void Page_Load(System.Object sender, System.EventArgs e) {
int ImgID = Convert.ToInt32(Request.QueryString["ImgID"]); //ImgID为图片ID
//建立链接
SqlConnection Con = new SqlConnection("Data Source=KING;Initial Catalog=testdb;User ID=sa;Pwd=;");
String SqlCmd = "SELECT * FROM ImageStore WHERE ImageID = @ImageID";
SqlCommand CmdObj = new SqlCommand(SqlCmd, Con);
CmdObj.Parameters.Add("@ImageID", SqlDbType.Int).Value = ImgID;
Con.Open();
SqlDataReader SqlReader = CmdObj.ExecuteReader();
SqlReader.Read();
Response.ContentType = (string)SqlReader["ImageContentType"];//设定输出文件类型
//输出图象文件二进制数制
Response.OutputStream.Write((byte[])SqlReader["ImageData"], 0, (int)SqlReader["ImageSize"]);
Response.End();
Con.Close();
code :try
{
sqlcon.Open();
sqldr=sqlcmd.ExecuteReader();
if(sqldr.Read())
{
Response.Clear();
//Response.ContentType=(string)sqldr["ImageContentType"];//设定输出文件类型
//输出图象文件二进制数制
byte[] imagecontent=(byte[])sqldr[0];
//Response.BinaryWrite((byte[])sqldr["Imageinf"]);
Response.BinaryWrite(imagecontent);
}
sqldr.Close();
sqlcon.Close();
}
catch(Exception ee)
{
Response.Write(ee.Message.ToString());
}
Response.End();