Using (Top n ) in DataTable.Select()

Hi There..
how to use (Top n) to Select a Max Count of DataRow(s) from a
DataTable in a DataSet ?
Thanks.
[129 byte] By [hthm] at [2007-11-20 0:12:02]
# 1 Re: Using (Top n ) in DataTable.Select()
iMax=dataSet.Tables(0).Rows.Count
sql="SELECT TOP" & iMax & " * FROM tblName"

Hope this Helps
Nava at 2007-11-10 3:30:18 >