62,046
社区成员
发帖
与我相关
我的任务
分享
public partial class List : System.Web.UI.Page
{
public string strPageTitle;
ClassDB DB = new ClassDB();
protected void Page_Load(object sender, EventArgs e)
{
strPageTitle = "数据列表";
if (!IsPostBack)
{
ArtList(1);
}
}
/// <summary>
/// 读取文章列表
/// </summary>
/// <param name="sType">文章类型</param>
public void ArtList(int sType)
{
SqlConnection myConn = DB.GetConnection();//得到数据库连接
string strSql = "Select ID,oTitle,oNow From News Where 1 = 1";
if (sType != null && sType != 0)
{
strSql += " And oBid = " + sType + " ";
}
strSql += " Order By Id Desc";
SqlCommand oIsCmd = new SqlCommand(strSql, myConn);
myConn.Open();
RepeaterList.DataSource = oIsCmd.ExecuteReader();
RepeaterList.DataBind();
myConn.Close();
}
}
<asp:Repeater ID="RepeaterList" runat="server">
<HeaderTemplate>
<div class="Box">
<h5>
Asp编程</h5>
<ul>
</HeaderTemplate>
<ItemTemplate>
<li><span>
<%#Eval("oNow")%></span><a href="View.aspx?id=<%#Eval("id")%>" target="_blank"><%#Eval("oTitle")%></a></li>
</ItemTemplate>
<FooterTemplate>
</ul> </div>
</FooterTemplate>
</asp:Repeater>
<asp:Repeater ID="Repeater1" runat="server">
<HeaderTemplate>
<div class="Box">
<h5>
Asp.Net编程</h5>
<ul>
</HeaderTemplate>
<ItemTemplate>
<li><span>
<%#Eval("oNow")%></span><a href="View.aspx?id=<%#Eval("id")%>" target="_blank"><%#Eval("oTitle")%></a></li>
</ItemTemplate>
<FooterTemplate>
</ul> </div>
</FooterTemplate>
</asp:Repeater>
protected void Page_Load(object sender, EventArgs e)
{
strPageTitle = "数据列表";
if (!IsPostBack)
{
ArtList(1, this.RepeaterList);
ArtList(2, this.Repeater1);
}
}
protected void Page_Load(object sender, EventArgs e)
{
strPageTitle = "数据列表";
if (!IsPostBack)
{
ArtList(1, "RepeaterList");
ArtList(2, "Repeater1");
}
}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Web.UI.HtmlControls;
using System.Configuration;