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();
}