gridview in asp.net with c#

Question

0.00/5 (No votes)

See more:

ASP.NET

how to show only 10 values in gridview without using paging in asp.net with c#.

Posted 18-Jan-13 3:38am

Nitin from shamli

Add a Solution

Comments

BC @ CV 18-Jan-13 9:40am

"without using paging...", So you want to just show the top 10 and that's it?

Member 9581488 18-Jan-13 9:41am

as stated by BC @ CV . Use top 10 in your select statement.

Nandakishore G N 18-Jan-13 23:16pm

paste the code what you have done till now?

3 solutions

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)

nika2008 · Answer 1 · 2013-01-18T14:03:00

hi you can do it with sql query
if u wanna get only 1 to 10 rowns i do with select top 10 * from tabel
but if u wanna get from 20 to 30 or 40 to 50 u must use 2 tops in query

select top 10 id
from table where id in (select top 50 id from table order by id desc)
order by id

with this query u can get from 40 to 50
u must only change number 50 to wich max row u wanna do and how many rows u wanna select u change it to first select hope i this can help u
sry for my bad english good luck

MaulikDusara · Answer 2 · 2013-01-18T06:55:00

Hi,
You can use LINQ instead of change in SQL statement. Given links may be useful to you.

http://stackoverflow.com/questions/787302/linq-to-sql-return-top-n-rows[^]
http://stackoverflow.com/questions/5769948/how-to-select-top-n-rows-in-a-linq-groupby[^]
http://stackoverflow.com/questions/9718117/selecting-first-10-records-then-next-10-paging-using-linq[^]

Abhinav S · Answer 3 · 2013-01-18T04:12:00

Solution 1

Select the top 10 rows from the data source and assign to the gridview -
http://msdn.microsoft.com/en-us/library/aa479339.aspx[^]
http://www.dotnetspider.com/resources/Category518-ASP.NET-GridView.aspx[^]

Posted 18-Jan-13 4:12am

Abhinav S

gridview in asp.net with c#

3 solutions

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0