.net里DataList1不用select top 10 显示前10条
DataTable dt = DT();
DataView dv = new DataView(dt);
dv.Sort = "id desc" ;
DataTable dt2 = dt.Clone();
if (dv.Count > 10)
{
for ( int i = 0; i < 11; i++)
{
dt2.Rows.Add(dv[i].Row.ItemArray);
}
}
else
{
for ( int i = 0; i < dv.Count; i++)
{
dt2.Rows.Add(dv[i].Row.ItemArray);
}
}
DataList1.DataSource = dt2;
DataList1.DataBind();
|