62,047
社区成员
发帖
与我相关
我的任务
分享
<body>
<div>
<dl>
<dt>标题:(对应后台语句这儿该填什么?)</dt>
<dd>作者:(对应后台语句这儿该填什么?)> 日期:(对应后台语句这儿该填什么?)>&</dd>
<dd>内容:(对应后台语句这儿该填什么?)>&</dd>
</dl>
</div>
</body>
string CnnString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("GuestBook.MDB");
OleDbConnection cnn = new OleDbConnection(CnnString);
protected void Page_Load(object sender, EventArgs e)
{
OleDbDataAdapter adapter = new OleDbDataAdapter(CnnString ,cnn );
DataSet ds = new DataSet();
………………
}
<body>
<div>
<dl>
<dt>标题:(对应后台语句这儿该填什么?)</dt>
<dd>作者:(对应后台语句这儿该填什么?) 日期:(对应后台语句这儿该填什么?)</dd>
<dd>内容:(对应后台语句这儿该填什么?)</dd>
</dl>
</div>
</body>
public partial class _Default : System.Web.UI.Page
{
string CnnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + HttpContext.Current.Server.MapPath("App_Data/GuestBook.MDB");
string oleselect = "select title,author,date,content from data order by date desc";
protected void Page_Load(object sender, EventArgs e)
{
OleDbDataAdapter adapter = new OleDbDataAdapter( oleselect ,CnnString );
………………
}
}
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Repeater.aspx.cs" Inherits="Repeater" %>
<!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>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Repeater ID="Repeater1" runat="server">
<HeaderTemplate>
<table>
<tr>
<td colspan="3" align="center">
大家好 我来了。
</td>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td>
遍体<%# Eval("Title") %>
</td>
<td>
作者:<%# Eval("author")%>日期:<%# Eval("time")%></dd>
</td>
<td>
内容:<%# Eval("content")%>
</td>
</tr>
</ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater>
</div>
</form>
</body>
</html>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
public partial class Repeater : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.Repeater1.DataSource = GetTable();
this.Repeater1.DataBind();
}
}
public DataTable GetTable()
{
DataTable Dt_News = new DataTable();
Dt_News.Columns.Add("Title");
Dt_News.Columns.Add("author");
Dt_News.Columns.Add("content");
Dt_News.Columns.Add("time");
for (int i = 0; i < 10; i++)
{
DataRow dr = Dt_News.NewRow();
dr[0] = "标题" + i.ToString();
dr[1] = "作者" + i.ToString();
dr[2] = "内容" + i.ToString();
dr[3] = "时间" + i.ToString();
Dt_News.Rows.Add(dr);
}
return Dt_News;
}
}
<body>
<div>
<dl>
<dt>标题:<%=title %></dt>
<dd>作者:<%=author %>> 日期:<%= time%>>&</dd>
<dd>内容:<%=content%>>&</dd>
</dl>
</div>
</body>
string title =string.Empty;
title=ds.Table[0].Rows[0]["列名比如title"].ToString();