How to get colum values in SQL server

Question

0.00/5 (No votes)

See more:

SQL-Server-2012

I am having a column in sql server with 15 records. In that 15 records I want for example 10 records to be displayed and later on 5 records should be displayed after button click like creating a bootstrap tab panel.

What I have tried:

Query:
select columnname from table group by columnname order by number asc

With this query in c# asp.net I am getting 15 records at a time.... How can I achieve this goal

Posted 27-Nov-18 23:04pm

Member 8583441

Updated 28-Nov-18 0:05am

Add a Solution

Comments

F-ES Sitecore 28-Nov-18 6:06am

This is quite a large issue involving many things and there are many ways of doing it. Google for how to page through data using asp.net and whatever database access you are using (entity framework, ado.net, nhibernate etc) to get a feel for the problem space and what possible solutions there are. You haven't even said if you're using MVC, webforms etc, there simply isn't enough info in your question to give you specific help.

2 solutions

Solution 2

The concept you are looking for is called "Paging".

Here are CodeProject articles that will help
ADO Recordset Paging in ASP[^]
ASP.NET Pagination[^]
How to implement Paging in ASP.NET at SQL Query Level[^]

Posted 28-Nov-18 0:06am

CHill60

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2018-11-28T00:06:00

Solution 1

There are two parts to this: getting ten items is pretty easy, just use TOP:

SELECT TOP 10 columnname FROM table ORDER BY number asc

Note that you can't use the GROUP BY clause of your example, because if you do you can't use ORDER BY unless that column appears in the GROUP BY clause. This may help: SQL GROUP By and the "Column 'name' is invalid in the select list because..." error[^]

Getting the next ten is more complex:

SELECT columnname FROM 
 (SELECT ROW_NUMBER() OVER (ORDER BY columnname ASC) AS RN, columnname FROM table GROUP BY columnname) j
WHERE RN BETWEEN 11 AND 20

Posted 28-Nov-18 0:06am

OriginalGriff

Comments

Member 8583441 28-Nov-18 6:39am

this query works well sir "SELECT TOP 10 columnname FROM table ORDER BY number asc". sir can it be possible without using top

OriginalGriff 28-Nov-18 6:58am

No, TOP is there to limit the number of rows. If you want generic pagin then you need to use the second form.

Member 8583441 28-Nov-18 7:13am

then can you give me how to create it sir

OriginalGriff 28-Nov-18 7:34am

Try it - the code is there!

Member 8583441 29-Nov-18 6:05am

Thank you very much sir with this code "SELECT TOP 1 columnname FROM table ORDER BY number asc". Not with 10 but i changed it to 1 it worked like a charm.