Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 1.0 and 1.1 > ASP.NET 1.0 and 1.1 Professional
|
ASP.NET 1.0 and 1.1 Professional For advanced ASP.NET 1.x coders. Beginning-level questions will be redirected to other forums. NOT for "classic" ASP 3 or the newer ASP.NET 2.0 and 3.5
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.0 and 1.1 Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 20th, 2006, 03:04 AM
Authorized User
 
Join Date: Jan 2006
Posts: 53
Thanks: 0
Thanked 0 Times in 0 Posts
Default

sorry i have added virtualitem count also plz refer i have edited post
thanks in advance imar

 
Old June 20th, 2006, 12:45 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

It's hard for me to say what's going on, because you make a number of calls into your own business or data access layer.

Basic question is: does your business layer return paged data (that is, exactly one page) or does it return all records? In the latter case, don't use custom paging...

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
 
Old June 2nd, 2008, 01:15 PM
Registered User
 
Join Date: Jun 2008
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have the same issue which madhusrp specified.Here is the scenario

I am using .NET 1.1 and oracle 10g.I am using datagrid's custom paging.these are my datagrid's properties

AutogenerateColumns= false (dynamically creating columns)
allowpaging=true
allowcustompaging=true

[u]Code-behind</u>

[u]Page_Load()</u>

 MyDataGrid.VirtualItemCount = CType(dat.GetScalar("select count(*) FROM tablename where condition"
BindGrid()

[u]Bindgrid()</u>
 Dim dtFinal As DataTable = CreateDataSource()

Dim fromID As Int16 = MyDataGrid.CurrentPageIndex * MyDataGrid.PageSize
        Dim toID As Int16 = MyDataGrid.PageSize

        Dim dv As DataView = New DataView(dtFinal)
        dv.RowFilter = "id >=" & fromID & " AND id<=" & toID

        MyDataGrid.DataSource = dv
        MyDataGrid.DataBind()

[u]CreateDataSource()</u>

 Dim dtSrc, dtDest As DataTable
        Dim wClause = pop.WhereClause(WFPID, ePop, busUnit, jFunction)
        Dim sql As String

        sql = "select * from employees"

        dtSrc = New DataTable
        dat.GetDataTable(dtSrc, sql)

         dtDest = New DataTable
        Dim col As New DataColumn
        dtDest = dtSrc.Clone()

        'adding an id column for data retreival
        col.ColumnName = "id"
        col.AutoIncrement = True
        col.ReadOnly = True
        col.Unique = True
        col.AutoIncrementSeed = 1
        col.AutoIncrementStep = 1
        dtDest.Columns.Add(col)

        For Each r As DataRow In dtSrc.Rows
            dtDest.ImportRow(r)
        Next

Return dtDest

These are the main codes....My pageEvent is not firing.It doesnot go to "PageIndexChanged" method when the paging is changed.I dono in Custompaging it is supposed to go to PageIndexChanged method.All the time the "currentpageIndex" of datagrid is 0.

I would really appreciate any help!!!

thanks.

harini






Similar Threads
Thread Thread Starter Forum Replies Last Post
Paging in DataGrid vijay_83 ASP.NET 2.0 Basics 0 September 29th, 2006 02:06 PM
Paging in DataGrid vijay_83 ASP.NET 2.0 Professional 0 September 29th, 2006 02:02 PM
Paging in datagrid Renu ASP.NET 1.0 and 1.1 Basics 2 September 9th, 2004 01:11 PM
Datagrid Paging collie VB.NET 2002/2003 Basics 17 January 25th, 2004 07:02 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.