how to use TOP N in c#.net ?

[horacyjr]

i need a help using crystal.net with c#.net here is my problem: i want to use TOP N propriety in code on c#.net, but i just know how to do it on crystal, can anybody help me ? tks

[Colin Angus Mackay]

horacyjr wrote:

i want to use TOP N propriety in code on c#.net, but i just know how to do it on crystal, can anybody help me ?

TOP N? In C#? I think you are getting confused with SQL. In SQL you can do something like this:

SELECT TOP 10 * FROM MyTable

If this is not what you are looking for please clarify your request.

---

My: Blog | Photos "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious

[Johny Ng]

In Sql server, you can specify "N" dynamically but you have to use dynamic query.

[Colin Angus Mackay]

Only for SQL Server 2000. In SQL Server 2005 you can specify N with a variable.

SELECT TOP @numRows * FROM MyTable

---

My: Blog | Photos "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious

[Johny Ng]

Good to know. Thanks

[leppie]

Yeah that one got me on SQL2000 too :( xacc.ide-0.1.0.11 released! Now working properly under .NET 2 :) Download and screenshots

[horacyjr]

this was the answwer , thanks for helping http://msdn.microsoft.com/library/default.asp?url=/library/en-s/crystlrf/html/crlrftopbottomnsortfieldclasstopic.asp private TopBottomNSortField GetTopBottomNSortField (int sortFieldIndex) { TopBottomNSortField topBottomNSortField; // Get the SortField object by index, cast it as a // TopBottomNSortField object, and return it. topBottomNSortField = Report.DataDefinition.SortFields[sortFieldIndex] as TopBottomNSortField; if (topBottomNSortField != null) return topBottomNSortField; else return null; }