这个是公告栏的前台
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<asp:Repeater ID="RepRec" runat="server">
<ItemTemplate>
<tr>
<td width="16" height="22" align="center">·</td>
<td width="294" align="left"><a href=ReadArticle.aspx?id=<%# DataBinder.Eval(Container.DataItem,"article_ID") %> target="_parent" ><span class="a12 STYLE1 STYLE1"><%# DataBinder.Eval(Container.DataItem,"article_Title") %></span></a></td>
</tr>
</ItemTemplate>
</asp:Repeater>
</table>CS (article_Title公告标题,article_ID公告ID,article_Recommend是否推介)
public partial class Left : System.Web.UI.Page
{
public SqlConnection sqlcon = new SqlConnection(ConfigurationManager.AppSettings["ConnString"]);
protected void Page_Load(object sender, EventArgs e)
{
GOUGAO();
}
public void GOUGAO()
{
string sqltopadcom = "select top 5* from tb_Article where article_Recommend='1' ORDER BY article_Time DESC ";
SqlDataAdapter myda = new SqlDataAdapter(sqltopadcom, sqlcon);
DataSet myds = new DataSet();
myda.Fill(myds);
RepRec.DataSource = myds;
RepRec.DataBind();
}
}
以下才是主要的
这是图片前台
<div>
<%=fnRec()%>
</div>CSprotected void Page_Load(object sender, EventArgs e)
{
fnRec();
}
public string fnRec()
{
SqlConnection sqlcon = new SqlConnection("Data Source=007-324a07be4d8;User ID=sa;PWD=8812780;DataBase=db_ps");
string sqlcom = "select * from tb_ps";
SqlCommand myda = new SqlCommand(sqlcom, sqlcon);
sqlcon.Open();
SqlDataReader dr = myda.ExecuteReader(); StringBuilder _Html = new StringBuilder(); _Html.AppendLine(" <table border=\"1\"> <tr>");
int _ValueCont = 0;
while (dr.Read())
{
_ValueCont++; if (_ValueCont % 4 == 0)
{
_Html.AppendLine(" <tr>");
}
_Html.AppendLine(" <td > <img src=\"../Ex_11_3" + dr["ps_img"].ToString() + "\"/> </td>"); if (_ValueCont % 4 == 0)
{
_Html.AppendLine(" </tr>");
}
}
_Html.AppendLine(" </table>");
dr.Close();
sqlcon.Close();
return _Html.ToString();
}我的意思想图片排列是否可以像公告一样在前台按照ID进行排列, 排列方式为4行4列,超过了就设置下标转到第二页.而每张图片又要按照ID链接到图片的详细信息页面.(图片在数据库的路径字段ps_imd,ID字段ps_ID,图片的详细信息页面为tpxsxs.aspx)
在这多谢之前帮过我的朋友们,希望各位再帮帮忙太感谢啦!!!
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<asp:Repeater ID="RepRec" runat="server">
<ItemTemplate>
<tr>
<td width="16" height="22" align="center">·</td>
<td width="294" align="left"><a href=ReadArticle.aspx?id=<%# DataBinder.Eval(Container.DataItem,"article_ID") %> target="_parent" ><span class="a12 STYLE1 STYLE1"><%# DataBinder.Eval(Container.DataItem,"article_Title") %></span></a></td>
</tr>
</ItemTemplate>
</asp:Repeater>
</table>CS (article_Title公告标题,article_ID公告ID,article_Recommend是否推介)
public partial class Left : System.Web.UI.Page
{
public SqlConnection sqlcon = new SqlConnection(ConfigurationManager.AppSettings["ConnString"]);
protected void Page_Load(object sender, EventArgs e)
{
GOUGAO();
}
public void GOUGAO()
{
string sqltopadcom = "select top 5* from tb_Article where article_Recommend='1' ORDER BY article_Time DESC ";
SqlDataAdapter myda = new SqlDataAdapter(sqltopadcom, sqlcon);
DataSet myds = new DataSet();
myda.Fill(myds);
RepRec.DataSource = myds;
RepRec.DataBind();
}
}
以下才是主要的
这是图片前台
<div>
<%=fnRec()%>
</div>CSprotected void Page_Load(object sender, EventArgs e)
{
fnRec();
}
public string fnRec()
{
SqlConnection sqlcon = new SqlConnection("Data Source=007-324a07be4d8;User ID=sa;PWD=8812780;DataBase=db_ps");
string sqlcom = "select * from tb_ps";
SqlCommand myda = new SqlCommand(sqlcom, sqlcon);
sqlcon.Open();
SqlDataReader dr = myda.ExecuteReader(); StringBuilder _Html = new StringBuilder(); _Html.AppendLine(" <table border=\"1\"> <tr>");
int _ValueCont = 0;
while (dr.Read())
{
_ValueCont++; if (_ValueCont % 4 == 0)
{
_Html.AppendLine(" <tr>");
}
_Html.AppendLine(" <td > <img src=\"../Ex_11_3" + dr["ps_img"].ToString() + "\"/> </td>"); if (_ValueCont % 4 == 0)
{
_Html.AppendLine(" </tr>");
}
}
_Html.AppendLine(" </table>");
dr.Close();
sqlcon.Close();
return _Html.ToString();
}我的意思想图片排列是否可以像公告一样在前台按照ID进行排列, 排列方式为4行4列,超过了就设置下标转到第二页.而每张图片又要按照ID链接到图片的详细信息页面.(图片在数据库的路径字段ps_imd,ID字段ps_ID,图片的详细信息页面为tpxsxs.aspx)
在这多谢之前帮过我的朋友们,希望各位再帮帮忙太感谢啦!!!
LZ ?
因为前台只有
<div>
<%=fnRec()%>
</div>我试了一下
<!--
#d1
{
text-align:center;MARGIN: 0px;
width:600px;
height:600px;
padding:0px 0px 0px 0px;}
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
-->
</style>
</head>
<body>
<form id="form1" runat="server">
<div id="d1">
<%=fnRec()%>
</div>
</form>
</body>
</html>
结果还是一样在前台全部图片都显示出来了 而且大小没变过
//前台:
<div style="line-height: 143px; font-size: 14px; padding-right: 20px;padding-left: 30px;">
<%=imgs %>
</div>//后台: public string imgs
{
get
{
if (ViewState["imgs"] != null)
return ViewState["imgs"].ToString();
return "";
}
set
{
ViewState["imgs"] = value;
}
}
DataTable imgdt = bll_ad.GetList(yewu);
if (imgdt != null)
{
StringBuilder sb = new StringBuilder();
for (int i = 0; i < imgdt.Rows.Count; i++)
{
sb.Append("<a href='xiangxi.aspx?id=" + StaticConvert.ObjectToString(imgdt.Rows[i]["id"]) + "'><img width='185px' border='0' height='160px' src='..\\" + StaticConvert.ObjectToString(imgdt.Rows[i]["imageurl"]) + "' alt='" + StaticConvert.ObjectToString(imgdt.Rows[i]["re"]) + "'" + "></img></a> ");
if ((i + 1) % 3 == 0 && i != imgdt.Rows.Count - 1)
{
sb.Append("<br>");
}
}
imgs = sb.Append("<br>").ToString();
}
出现当前上下文中不存在的名称
是要添加using 还是什么 谢谢啊
<div>
<asp:DataList ID="DataList1" runat="server" DataKeyField="ps_ID"
DataSourceID="SqlDataSource1" Width="682px" height="200px"
onselectedindexchanged="DataList1_SelectedIndexChanged" RepeatColumns="4"
RepeatDirection="Horizontal">
<ItemTemplate>
<a href=default.aspx?id=<%#Eval("ps_ID")%>>
<img src="../ex_11_3<%# Eval("ps_img") %>" width="100" height="100" border="0"/>
</a>
</ItemTemplate>
</asp:DataList>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:db_psConnectionString %>"
SelectCommand="SELECT [ps_ID], [ps_img] FROM [tb_ps]"></asp:SqlDataSource>
</div>
ListView控件简单易用在前台就能实现一切功能!!太强大啦