Set Limits in query for gridview pagination

[retport]

I am using C# and SQL Server 2008 ,here i attach my query.i want to set limit for dynamic grid view . I need this query for paging on the dynamic grid view how can i \[code\]SELECT Item.ItemID,Item.TypeID,Item.StatusID,Item.SeverityID,Item.PriorityID,Item.ProjectID,Item.ReleaseID, Item.ClientID,Item.Body,Item.CreatedBy,Item.CreatedDate,Item.ModifiedBy,Item.ModifiedDate,Item.IsActive, item.[Subject], Type.Name as Type, status.Name as Status, Project.Name as Project,Release.Name as Release,Priority.Name as Priority,Severity.Name as Severity,Client.Name as Client,ROW_NUMBER() OVER (ORDER BY ItemID) AS RowisFROM Item (NOLOCK) LEFT OUTER JOIN [Type] (NOLOCK) ON Item.TypeID = [Type].TypeIDLEFT OUTER JOIN [Status] (NOLOCK) ON Item.StatusID = [Status].StatusIDLEFT OUTER JOIN [Project] (NOLOCK) ON Item.ProjectID=[Project].ProjectIDLEFT OUTER JOIN [Release] (NOLOCK) ON Item.ReleaseID =[Release].ReleaseID LEFT OUTER JOIN [Priority] (NOLOCK) ON Item.PriorityID=[Priority].PriorityID LEFT OUTER JOIN [Severity] (NOLOCK) ON Item.SeverityID =[Severity].SeverityIDLEFT OUTER JOIN [Client] (NOLOCK) ON Item.ClientID =[Client].ClientID \[/code\]