vb.net - Record duplication on dataset update -


have strange behaviour , have no idea going on after investigation. have datagridview on form. set datasource of datagrid getdataset method. user cannot add new rows manually or either code. there no way add new row. there 2 columns last represent integer - position user can change. somehow when trying update records (not always) update of sqldataadapter trying put duplicate entry table. before save button option checking checkchangesdataset before allow makechangesdataset.

question: wrong below code use check whether dataset has been changed , update rows? if not cmdbuilder variable if not used anywhere?

 private readonly getsectiondataset new dataset   public function getdataset() dataset implements idbmanipulation.getdataset             using con new sqlconnection(strcon)                 using cmd new sqlcommand("select id, name, position tbarticels position<>1", con)                     con.open()                     ' create data adapter in method , throw away afterwards                     using getprojectsdataadapter = new sqldataadapter(cmd)                         getprojectsdataadapter.fill(getsectiondataset, "main")                     end using                 end using             end using             return getsectiondataset         end function           public function checkchangesdataset() boolean implements idbmanipulation.checkchangesdataset             dim result boolean = false             if getsectiondataset.haschanges                 result = true             end if             return result         end function          public sub makechangesdataset() implements idbmanipulation.makechangesdataset             if getsectiondataset.haschanges                 dim integer                 using con new sqlconnection(strcon)                     con.open()                     using transaction = con.begintransaction                         try                             using cmd new sqlcommand("select id, name, position tbarticels position<>1", transaction.connection)                                 ' create data adapter in method , throw away afterwards                                 cmd.connection = con                                 cmd.transaction = transaction                                  using getprojectsdataadapter = new sqldataadapter(cmd)                                     dim cmdbuilder new sqlcommandbuilder(getprojectsdataadapter)                                     getprojectsdataadapter.update(getsectiondataset, "main")                                 end using                             end using                              transaction.commit()                          catch ex exception                             transaction.rollback()                             throw 'rethrow exception.                         end try                     end using                 end using             end if         end sub

meantime secured field ("name") in table avoid duplicates insertion using unique key on field because seems field going duplicated somehow dataadapter, , immediatly error message on random duplication occur on save:

enter image description here


Comments

Post a Comment

Popular posts from this blog

angular - Ionic slides - dynamically add slides before and after -

hi i'm using ngfor create set of 3 slides while starting in middle i'm guaranteed able slide left or right on start. when slide right can simple listen reachedend , push slide array i'm looping. but have problem adding slide beginning. if same above , use e.g. array.unshift() or spread add item beginning, view think it's on position 0 , snaps view new slide. the code below work animates slide change index 1. slide = [0,1,2] //example loop slidechanged(event) { if(this.slides.isbeginning()){ this.slide = [this.slide[0]-1, ...this.slide]; this.slides.update(); this.slides.slideto(1) } } <ion-slides [initialslide]="1" (ionslidedidchange)="slidechanged($event)"> <ion-slide *ngfor="let item of slide"> <h1>slide {{item}}</h1> </ion-slide> </ion-slides> any appreciated! you can using ionslidenextend , ionslideprevend events slides . please...
Read more

Add a dynamic header in angular 2 http provider -

i have http interceptor built via tutorial https://scotch.io/@kashyapmukkamala/using-http-interceptor-with-angular2 the problem need have dynamic header changes automatically once changes 'mode' in app. service able tell interceptor change header, or have interceptor pull header (which string)from service each request. able throwing away patch method, call http.patch('new header string') set header string. call in service controls 'mode' setting. wondering if there way interceptor pull recent value service each request or if can add method http provider via interceptor? i've tried call service in interceptor each request returns undefined. because creating new instance of service or copying value before service fired , loaded/changed data. i don't want pass header string every http provider call because defeats purpose of having interceptor, id able set once changes or have provider fetch service before makes request. tl;dr : need add autom...
Read more

minify - Minimizing css files -

i want know how css files can minimized. currently, using external sites css minifier compress css files. however, after removing whitespaces, comments, etc, file sizes reduced 10-15%. how frameworks bootstrap manage make minimized versions kilobytes. as example, css is: body { background-color: #ff0; } the reduction goes 28 bytes 22 bytes other css files have lot more characters still smaller this. actually minifying code means it's remove thing code white space characters new line characters comments block delimiters it reduces amount of code has transferred on web , speed site load fastly.but unreadable format.
Read more