JQuery插件实现相册效果（数据库调用图片）

来源：互联网发布：sip服务器端口编辑：程序博客网时间：2024/06/05 06:34

aspx页面----------------------------

<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="nf.lightbox.css" rel="stylesheet" type="text/css" />
    <script src="Jquery1.7.js" type="text/javascript"></script>
    <script src="NFLightBox.js" type="text/javascript"></script>
    <script type="text/javascript">
        $(function () {
            $('#mydiv ul a').lightBox();
        })
    </script>
</head>
<body>
    <form id="form1" runat="server">
    <div id="mydiv" runat="server">

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

aspx.cs页面--------------------

protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                loadshow();
            }
        }
        string constr = @"data source=.;initial catalog=Text;User Id=sa;Password=admin";
        public void loadshow()
        {
            SqlConnection conn = new SqlConnection(constr);
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandText = "SELECT img FROM T_img WHERE class='small'";

            SqlDataAdapter adapter = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            adapter.Fill(dt);

            cmd.CommandText = "SELECT img FROM T_img WHERE class='big'";
            SqlDataAdapter adapter1 = new SqlDataAdapter(cmd);
            DataTable dt1 = new DataTable();
            adapter.Fill(dt1);
            cmd.Dispose();
            conn.Dispose();

            StringBuilder sb1 = new StringBuilder();
            sb1.Append("<ul>");
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                sb1.Append("<li>");
                sb1.Append("<a href=images/"+dt1.Rows[i][0].ToString()+"><img src=images/"+dt.Rows[i][0].ToString()+" /></a>");
                sb1.Append("</li>");
            }
            sb1.Append("</table>");
            mydiv.InnerHtml = sb1.ToString();
        }