获取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;
        }

posted @ 2011-03-22 17:03  桃花雪  阅读(949)  评论(0编辑  收藏  举报