gridview with asp.net

Question

0.00/5 (No votes)

See more:

I have a doubt on grid-view.. i have a database with 1 lack records.. suppose if i want to retrieve 1 lack database records at a time the database performance will be decreasing.. i want to retrieve the records based on the page size.. suppose my page size is 100 if i press first page button call first 100 records only from database..and i press 2nd button call 101-200 records only..can any one help for this problem.. thank you

Posted 29-Jul-12 19:22pm

srikanthgvs

Updated 29-Jul-12 19:45pm

_Amy

v3

Add a Solution

4 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)

ManojDhobale · Answer 1 · 2012-07-29T19:30:00

its nothing but paging in gridview

Add Gridview

XML

<asp:gridview id="DgTest" runat="server" autogeneratecolumns="False" xmlns:asp="#unknown">
            Width="100%" AllowSorting="True" OnRowCommand="DgTest_RowCommand" 
            OnRowDataBound="DgTest_RowDataBound" AllowPaging="True" 
            onpageindexchanging="DgTest_PageIndexChanging" CaptionAlign="Right"> </asp:gridview>

Create PageIndexChanging event as

C#

protected void DgTest_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            DgTest.PageIndex = e.NewPageIndex;
            Populate();
        }

C#

private void Populate()
        {
            //Code To get datasource to Databind
        }

Dont forget to set property Pagesize=100

Career Web Helper · Answer 2 · 2012-07-29T19:58:00

Solution 2

Use Paging and Sorting concept of GridView

Read the following links for concepts:
http://msdn.microsoft.com/en-us/library/aa479347.aspx[^]

http://www.c-sharpcorner.com/uploadfile/rohatash/gridview-paging-sample-in-asp-net/[^]

set pagesize property to 100

Posted 29-Jul-12 19:58pm

Career Web Helper

Vinod Viswanath · Answer 3 · 2012-09-06T16:29:00

There are so-many efficient ways to query n records from the data base.

SQL

SELECT TOP numberofrecordsyouwanttotake
    [yourColumns...]
FROM tableName
WHERE yourIDColumn NOT IN (
    SELECT TOP numberofrecordsyouwanttoskip
        yourIDColumn
    FROM tableName
    ORDER BY yourOrderColumn
)
ORDER BY yourOrderColumn

Thanks!!!

Ganesh Nikam · Answer 4 · 2012-09-06T18:14:00

hiii,

one solution is that
datasource will be get
by
using
below sample Query

SQL

select * from
   (select Row_Number() over (order by employee_id) as RowIndex, * from employee) as Sub
   Where Sub.RowIndex >= @record_start and Sub.RowIndex < @record_end

where pass parameter

@record_start=(GridPageIndex-1)*GridpageSize
@record_end=GridPageIndex*GridpageSize

populated dataset bind to gridview will improve your speed

gridview with asp.net

4 solutions

Solution 1

Solution 2

Solution 4

Solution 5

Add your solution here

Preview 0