vb.net - .NET Gridview Paging shows different content on following pages -

-

i have gridview in page paging enabled (sorting not enabled, not used). onrowdatabound , onpageindexchanged events assigned.

<asp:gridview showheader="false" id="gv1" runat="server" autogeneratecolumns="false" onrowdatabound="gridview_rowdatabound" datasourceid="sqldatasource1" gridlines="none" cellpadding="0" pagesize="25" allowpaging="true" onpageindexchanging="gv1_pageindexchanging">

datasource assigned below gridview as:

<asp:sqldatasource id="sqldatasource1" runat="server" connectionstring="<%$ connectionstrings:my_connectionstring %>"></asp:sqldatasource>

onrowdatabound used display content in formatted way. don't think causes problem:

 protected sub gridview_rowdatabound(byval sender object, byval e gridviewroweventargs).....

pageindexchanging defined follows:

    protected sub gv1_pageindexchanging(byval sender object, byval e system.web.ui.webcontrols.gridviewpageeventargs)     gv1.pageindex = e.newpageindex     gv1.databind() end sub

in page_load part here's how populate datasource. it's custom query constructed in string tempsqlstr:

sqldatasource1.selectcommand = tempsqlstr if not page.ispostback      gv1.databind() end if

everything seems working, results paged 25 records, can move through pages. recognized content of pages changing move between them. amount of records not change can see record saw on first page again in second, when move first page , again second page content of second page changes , see different set of records.

i have printed tempsqlstr value pages, same on pages (it not in "not page.ispostback" part).

can because construct tempsqlstr in page_load section , gv1_pageindex_changing cannot see value? if case why following pages showing record?

any comment appreciated. thank you.

the problem not ordering results returned , why. execute select statement 5 times , see if results same , know if this. if add order in query. let me know if solved problem otherwise can further...


Comments

Post a Comment

Popular posts from this blog

c# - how to write client side events functions for the combobox items -

-
<dx:aspxcombobox id="aspxcombobox2" runat="server" clientidmode="autoid" selectedindex="-1" onselectedindexchanged="aspxcombobox1_selectedindexchanged1" > <clientsideevents selectedindexchanged="function(s, e) { grid.selectrows();}" /> <items> <dx:listedititem text="selecte rows" /> <dx:listedititem text="unselectall" /> </items> </dx:aspxcombobox> i want write event "unselect all" item in combobox. how can this? you'll need write javascript function iterates thru combo-box , marks selected items false. see select/unselect checkbox fields using pure javascript , html sample code msdn:
Read more

exception - Python, pyPdf OCR error: pyPdf.utils.PdfReadError: EOF marker not found -

-
pypdf throws exception: pypdf.utils.pdfreaderror: eof marker not found i don't need fix pypdf, need eof error cause "except" block execute , skip on file, doesn't work. still causes program stop running. background: batch ocr program pdfs python, pypdf, adobe pdf ocr error: unsupported filter /lzwdecode ... saga continues. i got 10,000 pdfs in folder. ocrd, not. can't tell 'em apart. step 1 figure out ones not ocrd , ocr (see other threads details). so i'm using pypdf. exceptions related unrecognized characters , unsupported filters when try read text. guestimated if throws exception, it's got text in , doens't go in list. problem solved, right? so: pypdf import pdffilewriter, pdffilereader import sys, os, pypdf, re path = 'c:\users\homer\documents\my pdfs' filelist = os.listdir(path) has_text_list = [] does_not_have_text_list = [] pdf_name in filelist: pdf_file
Read more