create table tbRepeater --创建表
(
rID int identity(1,1) primary key,
rTitle varchar(50) not null,
rText text null
)
--插入几项数据
insert into tbRepeater values('test1','test1')
insert into tbRepeater values('test2','test2')
insert into tbRepeater values('test3','test3')
insert into tbRepeater values('test4','test4')
insert into tbRepeater values('test5','test5')
DataTable dt = 获取数据的函数;
int i = 1; //行数
foreach(DataRow dr in dt.Rows)
{
list += String.Form("<div><span>序号:{0}</span><span>{1}</span></div>",i.ToString(),dr["XXXX"].ToString()); //可以用string + string 来接驳不过不好看
i++;
}