Click here to Skip to main content
15,902,763 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: ibm language ware Pin
Manas Bhardwaj25-May-09 22:07
professionalManas Bhardwaj25-May-09 22:07 
GeneralRe: ibm language ware Pin
newmember2226-May-09 5:15
newmember2226-May-09 5:15 
QuestionVideo Pin
Robymon25-May-09 21:22
Robymon25-May-09 21:22 
AnswerRe: Video Pin
Eduard Keilholz25-May-09 21:27
Eduard Keilholz25-May-09 21:27 
GeneralRe: Video Pin
Robymon25-May-09 21:40
Robymon25-May-09 21:40 
QuestionHow to navigate Next,Previous ,Last,First Pin
govindi unal25-May-09 20:38
govindi unal25-May-09 20:38 
AnswerRe: How to navigate Next,Previous ,Last,First Pin
Baran M25-May-09 21:06
Baran M25-May-09 21:06 
AnswerRe: How to navigate Next,Previous ,Last,First Pin
gottimukkala26-May-09 0:57
gottimukkala26-May-09 0:57 
Hi

When you select the rows from table sorted by some order let's say sorting by name you can ranking for selected rows and then get the rows where between 1 and 14

This sample query may help you:

DECLARE @PageIndex int = 1,
DECLARE @PageSize int = 14

SELECT * FROM
(
-- selecting the rows sorted by name
SELECT Row_NUMBER() OVER (ORDER BY Name DESC) AS Row,
Q.*
FROM Questions_Table Q
)
AS questions
WHERE Row BETWEEN CONVERT(nvarchar(10), ((@PageIndex - 1) * @PageSize + 1)) AND
CONVERT(nvarchar(10),@PageIndex*@PageSize)

Hope that helps

--
http://ashakthi.blogspot.com
http://kids-articles.blogspot.com

Question.net framework 3.5 Pin
vishwjeet25-May-09 20:36
vishwjeet25-May-09 20:36 
AnswerRe: .net framework 3.5 Pin
Tuwing.Sabado25-May-09 20:54
Tuwing.Sabado25-May-09 20:54 
AnswerRe: .net framework 3.5 Pin
Ramesh Swaminathan25-May-09 21:03
Ramesh Swaminathan25-May-09 21:03 
GeneralRe: .net framework 3.5 Pin
vishwjeet25-May-09 21:06
vishwjeet25-May-09 21:06 
AnswerRe: .net framework 3.5 Pin
Baran M25-May-09 20:58
Baran M25-May-09 20:58 
Question[Message Deleted] Pin
Subin Alex25-May-09 19:04
Subin Alex25-May-09 19:04 
AnswerRe: How to change the colour of the MenuItem which is generated dynamically? Pin
Baran M25-May-09 19:25
Baran M25-May-09 19:25 
AnswerRe: How to change the colour of the MenuItem which is generated dynamically? Pin
Ramesh Swaminathan25-May-09 19:27
Ramesh Swaminathan25-May-09 19:27 
GeneralRe: How to change the colour of the MenuItem which is generated dynamically? Pin
Baran M25-May-09 19:44
Baran M25-May-09 19:44 
GeneralRe: How to change the colour of the MenuItem which is generated dynamically? Pin
Ramesh Swaminathan25-May-09 20:49
Ramesh Swaminathan25-May-09 20:49 
QuestionJavascript and Obfuscator Pin
ycorre25-May-09 17:29
ycorre25-May-09 17:29 
AnswerRe: Javascript and Obfuscator Pin
N a v a n e e t h25-May-09 17:43
N a v a n e e t h25-May-09 17:43 
QuestionSetting ValidationExpression clientSide Pin
dwolver25-May-09 14:29
dwolver25-May-09 14:29 
AnswerRe: Setting ValidationExpression clientSide Pin
N a v a n e e t h25-May-09 17:07
N a v a n e e t h25-May-09 17:07 
QuestionCurrent best practices to querying sql server in an asp.net website? Pin
Goalie3525-May-09 9:11
Goalie3525-May-09 9:11 
AnswerRe: Current best practices to querying sql server in an asp.net website? Pin
N a v a n e e t h25-May-09 16:45
N a v a n e e t h25-May-09 16:45 
Questionuse fax in asp.net Pin
MAHDIEHES25-May-09 8:49
MAHDIEHES25-May-09 8:49 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.