Although I do not advocate much, it is easy to store images in the database, but sometimes it is easy to read.
Front-end code:
1 <% @ page Language = "C #" autoeventwireup = "true" codefile = "getimage. aspx. cs" inherits = "getimage" %>
2
3 <! Doctype HTML public "-// W3C // dtd xhtml 1.0 transitional // en" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
4
5 <HTML xmlns = "http://www.w3.org/1999/xhtml">
6 7 <title> No title page </title>
8 9 <body>
10 <Form ID = "form1" runat = "server">
11 <div>
12
13 <asp: sqldatasource id = "sqlperformance1" runat = "server"
14 connectionstring = "<% $ connectionstrings: connectionstring %>"
15 selectcommand = "select imagedata from imagestore where imageid = 1">
16
17 </ASP: sqldatasource>
18
19 </div>
20 </form>
21 </body>
22 23
Note: The data type of the imagedata field is image.
Background code:
1 using system;
2 using system. collections;
3 using system. configuration;
4 using system. Data;
5 using system. LINQ;
6 using system. Web;
7 using system. Web. Security;
8 using system. Web. UI;
9 using system. Web. UI. htmlcontrols;
10 using system. Web. UI. webcontrols;
11 using system. Web. UI. webcontrols. webparts;
12 using system. xml. LINQ;
13
14 public partial class getimage: system. Web. UI. Page
15 {
16 protected void page_load (Object sender, eventargs E)
17 {
18 dataview DV = (dataview) This. sqldatasource1.select (datasourceselectarguments. Empty );
19
20 byte [] buffer = (byte []) dv [0] ["imagedata"];
21 response. binarywrite (buffer );
22 response. End ();
23
24}
25}
26
That's it.
