vb.net - trying to compare a SQL record count and a DataGridView row count -

-



i trying compare sql record count , datagridview row count ensure returning same info. example, if have 6 records come sql query, want execute try-catch statement compares row count , sql record count make sure display same number of items. tried:

    sql3.addparam("@plan", cmboplans.selecteditem())     sql3.execquery("select dbo.tagsinplan.[tag number] tagsinplan [plan number] = @plan , [plant] ='" & getplant() & "'")     sqlrecordcount = sql3.recordcount      dgvtagsinplan.rowcount = dgvcount      try         dgvcount = sqlrecordcount     catch ex exception         tagsinplan()     end try

tagsinplan() sub statement in. want rerun sub if datagridview row count not match sql record count





wiki

Comments

Post a Comment

Popular posts from this blog

Jenkins: find build number for git commit -

-
each commit git repo triggers build of jenkins pipeline. i want retrieve buildnumber of old build commit hash. how can that? i know information exists because can find in ui. some background why want this: when tags commit want create release (by tagging docker image). each build push image containing build number. want find out build number corresponds commit can find image want release. if understand question correctly, first need create git hook trigger new build. part covered in answer how react new tags in git hooks? ', though if using github, bitbucket or gitlab, there may other ways of going it. then when build initiated, there build number provided variable ' build_number ' ,in jenkins. if want include git tag name, can use in script, there seems fews ways: git parameter plugin git tag message plugin typically these plugins create environment variable can consumed scripts. not providing more concrete examples, since not aware of exact ...
Read more

firebase - How to wait value in Ionic 2 -

-
i'm trying wait value may change after execute "this.bookmarlist.take(1).subscribe(..." my problem when run application, execute second if statement "if(found==false)" before execute subscribe. this code may found thing wrong or need add additions solve problem. let loader = this.loadingctrl.create({ content: "", }); let found=false; loader.present().then(()=>{ this.bookmarklist.take(1).subscribe(data=>{ data.foreach(b=>{ if(b.nid==this.appservice.id && b.url==url){ let alert = this.alertctrl.create({ title: 'already bookmarked', subtitle: 'this note image bookmarked', buttons: ['ok'] }); alert.present(); found=true; } }) }) }).then(()=>{ if(found==false){ this.afd.list('/bookmark/').push({ uemail: th...
Read more

typescript - Typings for sub-folders inside a root index.d.ts -

-
we created typings material-ui@next , want ship them library, did last beta. here link index.d.ts . but typings not usable in current form. in development used locally , worked fine, when shipping files library typescript seems use different discovery strategy. all typings reference subfolder (e.g. declare 'material-ui/button/button' ) not found typescript. when importing components error show up: [ts] not find declaration file module 'material-ui/button/button'. '<project path>/node_modules/material-ui/button/button.js' implicitly has 'any' type. try `npm install @types/material-ui/button/button` if exists or add new declaration (.d.ts) file containing `declare module 'material-ui/button/button';` does typescript not accept declaring other imports when used inside npm_modules folder? because said, using them locally or moving them @types/material-ui make them work. also, typescript seems find index.d.ts , because impor...
Read more