blocks|key|4603178|text|这里要记住的重要一点是，你不应该尝试将图像数据与个人资料页面本身一起传输。相反，您希望您的配置文件页面为浏览器生成HTML标记，如下所示：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4603179|<img+src="~/MyImageHandler.ashx?UserID=1234"+alt="User+1234+avatar"+width="100px"+height="150px"+/>|code-block|syntax|javascript|4603180|这就是<asp:Image+.../>控件的最终结果。则浏览器将发送一个完全独立的Http请求来检索该图像。这就是网站上图片的工作原理。然后，您需要能够处理这个额外的请求。为此，创建一个Http+handler+(*.ashx+file)并使用它从数据库中检索适当的图像数据，并将其发送到浏览器。|offset|length|style|CODE|4603181|entityMap^0|0|0|3|G|2L|Q|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@$I|R|J|S|K|L]|$I|T|J|U|K|L]]|9|@]|A|$]]|$1|M|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|N|$]]

The important thing to remember here is that you shouldn't try to transmit the image data with the profile page itself. Instead, you want your profile page to generate HTML markup for the browser that looks something like this:

<pre><code>&lt;img src="~/MyImageHandler.ashx?UserID=1234" alt="User 1234 avatar" width="100px" height="150px" /&gt;
</code></pre>

That is the ultimate result of your <code>&lt;asp:Image .../&gt;</code> control. Then the browser will send a completely separate Http request to retrieve the image. That's how pictures on web sites work. You then need to be able to handle that additional request. To do that, create an <code>Http handler (*.ashx file)</code> and use it to retrieve the appropriate image data from the database and send it to the browser.

blocks|key|4603194|text|正如乔尔提到的，您应该使用HttpHandler或页面来显示图像。以下是输出图像(Image.ashx)的示例代码：|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|4603195|//+ProcessRequest+method+of+Image.ashx
long+imageId+=+Convert.ToInt64(Request.QueryString["ImageId"]);

using+(var+conn+=+new+SqlConnection(connectionString))
using+(var+command+=+new+SqlCommand(
++++"SELECT+ImageFile+FROM+ImageTable+WHERE+ImageId+=+@ImageID",+conn))
{
++++command.Parameters.Add("@ImageID",+SqlDbType.Int).Value+=+imageId;
++++conn.Open();

++++Response.ContentType+=+"image/gif";
++++Response.BinaryWrite((byte[])+command.ExecuteScalar());
}|code-block|syntax|javascript|4603196|然后在页面中使用图像，如下所示：|4603197|++<asp:Image+id="Image1"+runat="server"+ImageUrl="Image.ashx?ImageID=12"/>|4603198|entityMap^0|15|A|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|U|8|@]|D|@]|E|$]]|$1|M|3|N|5|H|7|V|8|@]|D|@]|E|$I|J]]|$1|O|3|-4|5|6|7|W|8|@]|D|@]|E|$]]]|P|$]]

As Joel mentioned you should use an HttpHandler or a page to display the image. Here is a sample code to output image (Image.ashx) : 

<pre><code>// ProcessRequest method of Image.ashx
long imageId = Convert.ToInt64(Request.QueryString["ImageId"]);

using (var conn = new SqlConnection(connectionString))
using (var command = new SqlCommand(
 "SELECT ImageFile FROM ImageTable WHERE ImageId = @ImageID", conn))
{
 command.Parameters.Add("@ImageID", SqlDbType.Int).Value = imageId;
 conn.Open();

 Response.ContentType = "image/gif";
 Response.BinaryWrite((byte[]) command.ExecuteScalar());
}
</code></pre>

and then use image in your page as : 

<pre><code> &lt;asp:Image id="Image1" runat="server" ImageUrl="Image.ashx?ImageID=12"/&gt;
</code></pre>

blocks|key|4603238|text|如果您使用的是SQL2005或更高版本，则不应该使用数据类型Image，因为它现在是deprecated。相反，如果可能，您希望使用新的Varbinary(MAX)类型。一旦你存储了它，你需要做的就是通过ADO.Net调用检索它，并将单元格值转换为Byte[]类型，然后调用Response.BinaryWrite，就像上面ScarletGarden的例子一样。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4603239|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/ms191262.aspx^0|16|A|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

If you're using SQL 2005 or greater you should not use the data type Image because it's now <a href="http://msdn.microsoft.com/en-us/library/ms191262.aspx" rel="nofollow noreferrer">deprecated</a>. Instead you want to use the new Varbinary(MAX) type if possible. Once you have it stored all you need to do is retrieve it via ADO.Net call and cast the cell value into type Byte[] and then call Response.BinaryWrite like in ScarletGarden's example above.

blocks|key|538238|text|在存储了几百is的图像之后，我相信你会发现自己认为操作系统的文件系统和静态文件http服务器比数据库更适合用来存储图像。它还允许您使用数千个现有的免费工具来处理、移动、托管等图像。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|538239|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

After a few hundred gigabytes of images, I believe you'll find yourself thinking that the operating systems' file system and static file http servers is better suited than the database, which is busy which a lot of other details, for storing images. It also allows you to use thousands of existing free tools to work with, move, host, etc the images.

blocks|key|4603299|text|不是将图像存储在数据库中，而是存储图像的路径和/或文件名。图像会填满数据库并使其变慢。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4603300|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Instead of storing images in the database, store the path and/or filename for the image. Images will fill up the database and make it slow.

blocks|key|3758557|text|protected+void+Page_Load(object+sender,+EventArgs+e)+{
++++GridView1.DataSourceID+=+"";
++++GridView1.DataSource+=+SqlDataSource1;
++++GridView1.DataBind();
}

protected+void+btnSubmit_Click(object+sender,+EventArgs+e)+{
++++string+strImageName+=+txtImageName.Text.ToString();

++++if+(FileUpload1.PostedFile+!=+null+&&+FileUpload1.PostedFile.FileName+!=+"")+{
++++++++byte[]+imageSize+=+new+byte[FileUpload1.PostedFile.ContentLength];
++++++++HttpPostedFile+uploadedImage+=+FileUpload1.PostedFile;
++++++++uploadedImage.InputStream.Read(imageSize,+0,+(int)FileUpload1.PostedFile.ContentLength);

++++++++//+Create+SQL+Connection
++++++++SqlConnection+con+=+new+SqlConnection();
++++++++con.ConnectionString+=+"Data+Source=RND3"+%2B+"\\"+%2B+"SQLEXPRESS;Initial+Catalog=SSSolutionFiles;Integrated+Security=True";

++++++++//+Create+SQL+Command+
++++++++SqlCommand+cmd+=+new+SqlCommand();
++++++++cmd.CommandText+=+"INSERT+INTO+Imagess(ImageName,Image)"+%2B+"+VALUES+(@ImageName,@Image)";
++++++++cmd.CommandType+=+CommandType.Text;
++++++++cmd.Connection+=+con;

++++++++SqlParameter+ImageName+=+new+SqlParameter("@ImageName",+SqlDbType.VarChar,+50);
++++++++ImageName.Value+=+strImageName.ToString();
++++++++cmd.Parameters.Add(ImageName);

++++++++SqlParameter+UploadedImage+=+new+SqlParameter("@Image",+SqlDbType.Image,+imageSize.Length);
++++++++UploadedImage.Value+=+imageSize;
++++++++cmd.Parameters.Add(UploadedImage);
++++++++con.Open();
++++++++cmd.ExecuteNonQuery();
++++++++con.Close();

++++++++Label1.Text+=+"File+Uploaded";

++++++++GridView1.DataSourceID+=+"";
++++++++GridView1.DataSource+=+SqlDataSource1;
++++++++GridView1.DataBind();
++++++++con.Close();
++++}
}|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|3758558|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>protected void Page_Load(object sender, EventArgs e) {
 GridView1.DataSourceID = "";
 GridView1.DataSource = SqlDataSource1;
 GridView1.DataBind();
}

protected void btnSubmit_Click(object sender, EventArgs e) {
 string strImageName = txtImageName.Text.ToString();

 if (FileUpload1.PostedFile != null &amp;&amp; FileUpload1.PostedFile.FileName != "") {
 byte[] imageSize = new byte[FileUpload1.PostedFile.ContentLength];
 HttpPostedFile uploadedImage = FileUpload1.PostedFile;
 uploadedImage.InputStream.Read(imageSize, 0, (int)FileUpload1.PostedFile.ContentLength);

 // Create SQL Connection
 SqlConnection con = new SqlConnection();
 con.ConnectionString = "Data Source=RND3" + "\\" + "SQLEXPRESS;Initial Catalog=SSSolutionFiles;Integrated Security=True";

 // Create SQL Command 
 SqlCommand cmd = new SqlCommand();
 cmd.CommandText = "INSERT INTO Imagess(ImageName,Image)" + " VALUES (@ImageName,@Image)";
 cmd.CommandType = CommandType.Text;
 cmd.Connection = con;

 SqlParameter ImageName = new SqlParameter("@ImageName", SqlDbType.VarChar, 50);
 ImageName.Value = strImageName.ToString();
 cmd.Parameters.Add(ImageName);

 SqlParameter UploadedImage = new SqlParameter("@Image", SqlDbType.Image, imageSize.Length);
 UploadedImage.Value = imageSize;
 cmd.Parameters.Add(UploadedImage);
 con.Open();
 cmd.ExecuteNonQuery();
 con.Close();

 Label1.Text = "File Uploaded";

 GridView1.DataSourceID = "";
 GridView1.DataSource = SqlDataSource1;
 GridView1.DataBind();
 con.Close();
 }
}
</code></pre>

blocks|key|4603311|text|试试这些链接，它可能会对你有所帮助。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4603312|您也可以尝试将图像文件存储在服务器上，并将路径存储在Sql表中。通过这些链接|4603313|http://pratikataspdotnet.blogspot.in/2014/11/retrieve-images-from-path-stored-in.html|offset|length|4603314|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|2D|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Q|8|@]|9|@$F|R|G|S|1|T]]|A|$]]|$1|H|3|-4|5|6|7|U|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|E]]]]

Try these links it might help you..

you can also try by storing the image files on the server and store the paths on the Sql table..
by these links

<a href="http://pratikataspdotnet.blogspot.in/2014/11/retrieve-images-from-path-stored-in.html" rel="nofollow">http://pratikataspdotnet.blogspot.in/2014/11/retrieve-images-from-path-stored-in.html</a>

I am looking to fileupload a picture jpeg,gif,etc into an SQL database on an updateprofilepicture page. Then on the profile page, I want to retrieve the image from an sql database and have it show up in an Asp:Image control. I have much code trying to do this and it doesn't work. The table contains a column of type Image.

ASP.NET store Image in SQL and retrieve for Asp:Image

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我希望文件上传一个图片jpeg，gif等到一个更新配置文件页面上的SQL数据库等。然后在配置文件页面上，我希望从sql数据库中检索图像，并将其显示在Asp:Image控件中。我有很多代码试图做到这一点，但它不能工作。该表包含类型为Image的列。

问ASP.NET在SQL中存储图像并为Asp:Image检索
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问ASP.NET在SQL中存储图像并为Asp:Image检索EN