获取Dataset前几条数据的两种方法
第一种
public static DataView GetLatestComments(int numComments)
{ DataView Comments = new DataView(GetComments());
Comments.Sort = “DateCreated Desc“;
string filter = string.Empty;
string delimiter = string.Empty;
numComments = Math.Min(numComments, Comments.Count);
for (int i = 0; i < numComments; i++)
{ filter += delimiter + Comments[i]["Id"].ToString(); delimiter = “,“;
}
if (filter.Length > 0) {
Comments.RowFilter = “Id in (“ + filter + “)“;
} return Comments; }
第二种
private DataTable SelectTop(int Top, DataTable oDT)
{
if (oDT.Rows.Count < Top) return oDT;
DataTable NewTable = oDT.Clone();
DataRow[] rows = oDT.Select("1=1");
for (int i = 0; i < Top; i++)
{
NewTable.ImportRow((DataRow)rows[i]);
}
return NewTable;
}