从数据库中取图片路径实现jQuery 图片点击放大效果

最新推荐文章于 2020-02-24 20:05:08 发布

心如止静

最新推荐文章于 2020-02-24 20:05:08 发布

阅读量773

点赞数

本文链接：https://blog.csdn.net/qhx556/article/details/8901577

版权

前台：

WebForm1.aspx:

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="Web_2013_05_08.WebForm1" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
     <style type="text/css">
    #mydiv ul{ list-style-type:none;}
    #mydiv ul li{ display:inline;}
    #mydiv{ width:500px; border:solid 1px #444; background-color:#333;}
    </style>
<link href="css/nf.lightbox.css" rel="stylesheet" type="text/css" />
    <script src="js/Jquery1.7.js" type="text/javascript"></script>
    <script src="js/NFLightBox.js" type="text/javascript"></script>

    </div>
    </form>
</body>
</html>

后台：

WebForm1.aspx.cs:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Text;

namespace Web_2013_05_08
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                string sqlcon = @"Data Source=PC-20130314PXQG;Initial Catalog=picture;Persist Security Info=True;User ID=sa;Password=842674";
                SqlConnection conn = new SqlConnection(sqlcon);
                SqlCommand cmd = conn.CreateCommand();
                conn.Open();
                cmd.CommandText = "select BigImgUrl,SmallImgUrl from T_Photo";
                SqlDataAdapter ap = new SqlDataAdapter(cmd);
                DataTable dt = new DataTable();
                ap.Fill(dt);
                StringBuilder sb = new StringBuilder();
                sb.Append("<ul>");
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    sb.Append("<a href=" + dt.Rows[i]["BigImgUrl"] + ">");//添图片路径
                    sb.Append("<li>");
                    sb.Append("<img src=" + dt.Rows[i]["SmallImgUrl"] + ">");//添图片路径
                    sb.Append("</li>");
                    sb.Append("</a>");