通过ADO.NET读取并显示数据库中的图片

2024-07-10 13:12:51

字体：大中小

来源：转载

供稿：网友

下面举一个从microsoft sql server的pub数据库读取图片并显示它的例子：

以下是示例源代码：
<%@ import namespace="system.data.sqlclient" %>
<%@ import namespace="system.drawing" %>
<%@ import namespace="system.drawing.imaging" %>
<%@ import namespace="system.io" %>
<script language="c#" runat="server">
void page_load(object sender, eventargs e) {
        memorystream stream = new memorystream();
        sqlconnection connection;
        connection = new sqlconnection("server=localhost;database=pubs;uid=sa;pwd=");
        try {
            connection.open();
            sqlcommand command;
            command = new sqlcommand("select logo from pub_info where pub_id=/’0736/’", connection);
            byte[] image;
            image = command.executescalar();
            stream.write(image, 0, image.length);
            bitmap imgbitmap;
            imgbitmap = new bitmap(stream);
            response.contenttype = "image/gif";
            imgbitmap.save(response.outputstream, imageformat.gif);
        }
        finally {
            connection.close();
            stream.clse();
        }
    }

</script>

上一篇：ASP.NET发送邮件示例源代码

下一篇：.net编程开发常用函数收集