sql - adding 'next' link to web application -


i have been able limit number of data send application need setting application show fetch next button.

data retrieval code - using show 2 rows because have small amount of data in test database

 <webmethod(description:="retrieve members of client list"), soapheader("messagesoapheader", direction:=soapheaderdirection.in)> _ public function getclientlistmembers() dataset     dim rs sqldatareader      rs = objapp.connectuser(messagesoapheader.uid, messagesoapheader.pwd, messagesoapheader.campaign, messagesoapheader.keyword, localcommon.apsoapadvanced)     rs.close()     if objapp.classerrorscount > 0         objapp.db.close()         dim nx new exception         llib.throwsoapexception(objapp.errors(1).number, nx, objapp.db, objapp.errors(1).errortype, objapp.errors(1).description)         getclientlistmembers = new dataset         exit function     end if     llib.functioncount(objapp, "getclientlistmembers") 'this must placed after close of rs      getclientlistmembers = llib.getdataset("select cellnumber,carrier,keyword, dbo.fn_toutc(actualoptindate) actualoptindate optins shortcode='" & objapp.shortcode & "' , keyword='" & objapp.keyword & "' , optinstate=2 order cellnumber asc offset 2 rows fetch next 2 rows only", objapp)     getclientlistmembers.tables(0).tablename = "cell numbers"     llib.recordrowtransfer(getclientlistmembers.tables(0).rows.count, llib.rowtransferdirection.toclient, objapp)     'now email stuff     llib.adddatatable(getclientlistmembers, "email addresses", "select emailaddress,keyword, dbo.fn_toutc(actualoptindate) actualoptindate emailoptins shortcode='" & objapp.shortcode & "' , keyword='" & objapp.keyword & "' , optinstate=2 order emailaddress", objapp)      if getclientlistmembers.tables.count > 1 llib.recordrowtransfer(getclientlistmembers.tables(1).rows.count, llib.rowtransferdirection.toclient, objapp)      objapp.db.close() end function

the user view (where need add 'next' link is

  private sub displayds(byref thisds dataset, byval tblnumber integer)     dim integer     me.txtdisplay.text = thisds.tostring     me.combodstables.items.clear()     = 0 thisds.tables.count - 1         me.combodstables.items.add(i.tostring & "_" & thisds.tables(i).tablename)     next     me.combodstables.selectedindex = tblnumber     me.lblnumberoftables.text = thisds.tables.count     dim mybindingsource bindingsource = new bindingsource     mybindingsource.datasource = thisds.tables(tblnumber)     me.advdatagrid.datasource = mybindingsource end sub

the 'click' or button code is

    'private sub cmddeleteslmembersdifferential_click(sender object, e eventargs) handles cmddeleteslmembersdifferential.click '    dim xmlnoderesult xml.xmlnode '    loadheader() '    try '        xmlnoderesult = advserver.deletesendlistmembersdifferential(me.txtlistname.text, testdb()) '    catch soapex exception '        msgbox(soapex.message) '        exit sub '    end try '    me.txtdisplay.text = xmlnoderesult.outerxml 'end sub  private sub cmdsendtolist_click(byval sender object, byval e system.eventargs) handles cmdsendtolist.click     dim xmlnoderesult xml.xmlnode, thistime date     loadheader()     if me.chkdelay.checked         if isdate(me.txtdelaytime.text)             thistime = cdate(me.txtdelaytime.text)             thistime = thistime.touniversaltime 'input in local time.         else             msgbox("delay set delay time not date")             exit sub         end if     else         thistime = now()     end if     try         xmlnoderesult = advserver.sendtosendlist(me.txtlistname.text, me.txtmsg.text, me.chkdelay.checked, thistime)     catch soapex exception         msgbox(soapex.message)         exit sub     end try     me.txtdisplay.text = xmlnoderesult.outerxml end sub

any appreciated - have been working on week , escaping me!

thank you!


Comments

Post a Comment

Popular posts from this blog

commonjs - How to write a typescript definition file for a node module that exports a function? -

consider, toml node module can use: // toml.d.ts declare module toml { export function parse(value:string):any; } declare module "toml" { export = toml; } then: /// <reference path="../../../../../defs/toml/toml.d.ts"/> import toml = require('toml'); toml.parse(...); however, node module export single function, such 'glob' ( https://github.com/isaacs/node-glob ). the node usage of module be: var glob = require("glob") glob("*.js", {}, callback(err, files) { ... }); you'd naively expect this: // glob.d.ts declare function globs(paths:string, options:any, callback:{(err:any, files:string[]):void; ...but because typescripts 'import' semantics bit strange, seems can use 'import .. = require()' statement alias modules . trying call: /// <reference path="../../../../../defs/glob/glob.d.ts"/> import blog = require('glob'); results in: error ts2072: mod
Read more

openid - Okta: Failed to get authorization code through API call -

i'm integrating okta own idp server using okta's api. i'm implementing authorization code flow following steps below: in own server, use /api/v1/authn endpoint sessiontoken. use sessiontoken obtain authorization calling endpoint: /oauth2/v1/authorize?client_id=" + clientid + "&sessiontoken=" + sessiontoken + "&response_type=code&response_mode=query&scope=openid&redirect_uri=" + redirecturl + "&state=evanyang&nonce=" it's supposed return response status code 302 , location header containing redirect url code value. however, keep getting response status code 200 , without location header, html body saying "you using unsupported browser." , "javascript disabled on browser." according api documentation: http://developer.okta.com/docs/api/resources/oidc.html#authentication-request , sessiontoken parameter sufficient this: an okta one-time sessiontoken. allows api-based
Read more

thorough guide for profiling racket code -

did googling ("racket profiling", "racket measure performance"), didn't find , there no examples in docs. did google "profile" search on htdp - no luck. (profile (f ...)) output isn't obvious other small snippets. ideally want python's python -m cprofile usage examples. when search "python profiling", both duckduckgo , google give top result: 26.4. python profilers . (although scanned quickly, seems more of reference "thorough usage guide" examples. if had else in mind, perhaps please link that?) the equivalent racket documentation be: profile: statistical profiler . a usage example: #lang racket (require profile) (profile-thunk (thunk (function-to-profile arg0 arg1) )) here (thunk e) convenience (lambda () e) . bigger example: #lang racket (module mod racket (provide f) (define (f) (for/list ([i 10000]) i))) (require (prefix-in mod: 'mod)) (define (f) (for ([i 10000
Read more