|
web
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
DataView Multiple ChangeHi all,
I edit records using a form that have multiple control bind on Dataview, But I don't want to update right always to database, I would like to delay until all Changes (add all new record using a form or edit various existing records) This way I could minimize transaction on server.. Any hint ? VS 2003 Marc R. Thanks for your help guys ! Marc,
It is up to you when you update a datatable to a database, so can you explain your question a little bit more? Cor Show quoteHide quote "Marc R." <Nospam@NewgroupsONLY.com> schreef in bericht news:OeQE7B1RGHA.5728@tk2msftngp13.phx.gbl... > Hi all, > > > > I edit records using a form that have multiple control bind on Dataview, > But I don't want to update right always to database, I would like to delay > until all Changes (add all new record using a form or edit various > existing records) > > This way I could minimize transaction on server.. > > Any hint ? > > VS 2003 > > Marc R. > Thanks for your help guys ! > > > well I use a grid bound to a dataview,
went I click on a row, All textboxes on the form updates accordingly. if I edit the textboxes, I absolutely need to do an update to not loose information. if I change to a different row, then back to the previously edited row my edited information aren't into textboxes anymore. I see the original data. I would like to be able to edit, as much as many row I like or even add some new rows then update database. Let hope that is better explained. thks Show quoteHide quote "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message news:uq1cfL1RGHA.5108@TK2MSFTNGP09.phx.gbl... > Marc, > > It is up to you when you update a datatable to a database, so can you > explain your question a little bit more? > > Cor > > > "Marc R." <Nospam@NewgroupsONLY.com> schreef in bericht > news:OeQE7B1RGHA.5728@tk2msftngp13.phx.gbl... >> Hi all, >> >> >> >> I edit records using a form that have multiple control bind on Dataview, >> But I don't want to update right always to database, I would like to >> delay until all Changes (add all new record using a form or edit various >> existing records) >> >> This way I could minimize transaction on server.. >> >> Any hint ? >> >> VS 2003 >> >> Marc R. >> Thanks for your help guys ! >> >> >> > > Marc
You have a way in telling a problem what says in my opinion absolute nothing to the ones who tries to help you. By instance this. >well I use a grid bound to a dataview, Version 2005?WindowsForm Grid or Webform Grid or a grid build by yourself? >if I edit the textboxes.........? And then do you click an update button or whatever or do you do nothingCor Show quoteHide quote > went I click on a row, All textboxes on the form updates accordingly. > if I edit the textboxes, I absolutely need to do an update to not loose > information. > if I change to a different row, then back to the previously edited row my > edited information aren't into textboxes anymore. I see the original data. > > I would like to be able to edit, as much as many row I like or even add > some new rows then update database. > > Let hope that is better explained. > thks > > > > "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message > news:uq1cfL1RGHA.5108@TK2MSFTNGP09.phx.gbl... >> Marc, >> >> It is up to you when you update a datatable to a database, so can you >> explain your question a little bit more? >> >> Cor >> >> >> "Marc R." <Nospam@NewgroupsONLY.com> schreef in bericht >> news:OeQE7B1RGHA.5728@tk2msftngp13.phx.gbl... >>> Hi all, >>> >>> >>> >>> I edit records using a form that have multiple control bind on Dataview, >>> But I don't want to update right always to database, I would like to >>> delay until all Changes (add all new record using a form or edit various >>> existing records) >>> >>> This way I could minimize transaction on server.. >>> >>> Any hint ? >>> >>> VS 2003 >>> >>> Marc R. >>> Thanks for your help guys ! >>> >>> >>> >> >> > > well I use a grid bound to a dataview,
went I click on a row, All textboxes on the form updates accordingly. if I edit the textboxes, I absolutely need to do an update to not loose information. if I change to a different row, then back to the previously edited row my edited information aren't into textboxes anymore. I see the original data. I would like to be able to edit, as much as many row I like or even add some new rows then update database. Let hope that is better explained. thks Dunno what happen here, my 1st response didn't made it to the news group. Show quoteHide quote "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message news:uq1cfL1RGHA.5108@TK2MSFTNGP09.phx.gbl... > Marc, > > It is up to you when you update a datatable to a database, so can you > explain your question a little bit more? > > Cor > > > "Marc R." <Nospam@NewgroupsONLY.com> schreef in bericht > news:OeQE7B1RGHA.5728@tk2msftngp13.phx.gbl... >> Hi all, >> >> >> >> I edit records using a form that have multiple control bind on Dataview, >> But I don't want to update right always to database, I would like to >> delay until all Changes (add all new record using a form or edit various >> existing records) >> >> This way I could minimize transaction on server.. >> >> Any hint ? >> >> VS 2003 >> >> Marc R. >> Thanks for your help guys ! >> >> >> > > Marc,
Not any piece of code how you do that? Cor Show quoteHide quote "Marc R." <Nospam@NewgroupsONLY.com> schreef in bericht news:Oxl%23GDtSGHA.4168@tk2msftngp13.phx.gbl... > well I use a grid bound to a dataview, > went I click on a row, All textboxes on the form updates accordingly. > if I edit the textboxes, I absolutely need to do an update to not loose > information. > if I change to a different row, then back to the previously edited row my > edited information aren't into textboxes anymore. I see the original data. > > I would like to be able to edit, as much as many row I like or even add > some > new rows then update database. > > Let hope that is better explained. > thks > > > Dunno what happen here, my 1st response didn't made it to the news group. > > "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message > news:uq1cfL1RGHA.5108@TK2MSFTNGP09.phx.gbl... >> Marc, >> >> It is up to you when you update a datatable to a database, so can you >> explain your question a little bit more? >> >> Cor >> >> >> "Marc R." <Nospam@NewgroupsONLY.com> schreef in bericht >> news:OeQE7B1RGHA.5728@tk2msftngp13.phx.gbl... >>> Hi all, >>> >>> >>> >>> I edit records using a form that have multiple control bind on Dataview, >>> But I don't want to update right always to database, I would like to >>> delay until all Changes (add all new record using a form or edit various >>> existing records) >>> >>> This way I could minimize transaction on server.. >>> >>> Any hint ? >>> >>> VS 2003 >>> >>> Marc R. >>> Thanks for your help guys ! >>> >>> >>> >> >> > > Sorry,
I got a treeview that contains Service nodes here how I works with each record, me.dvserviceoperation.rowfilter = "ser_id=" & ctype e.node,service).id so now data view as 1 record. all bound control on form bounds to that specific record. At this point If I don't save the change right away (let say I click on a other Node(service)) All Change made are lost. Show quoteHide quote "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message news:e4fC2$xSGHA.4384@tk2msftngp13.phx.gbl... > Marc, > > Not any piece of code how you do that? > > Cor > > "Marc R." <Nospam@NewgroupsONLY.com> schreef in bericht > news:Oxl%23GDtSGHA.4168@tk2msftngp13.phx.gbl... >> well I use a grid bound to a dataview, >> went I click on a row, All textboxes on the form updates accordingly. >> if I edit the textboxes, I absolutely need to do an update to not loose >> information. >> if I change to a different row, then back to the previously edited row my >> edited information aren't into textboxes anymore. I see the original >> data. >> >> I would like to be able to edit, as much as many row I like or even add >> some >> new rows then update database. >> >> Let hope that is better explained. >> thks >> >> >> Dunno what happen here, my 1st response didn't made it to the news group. >> >> "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message >> news:uq1cfL1RGHA.5108@TK2MSFTNGP09.phx.gbl... >>> Marc, >>> >>> It is up to you when you update a datatable to a database, so can you >>> explain your question a little bit more? >>> >>> Cor >>> >>> >>> "Marc R." <Nospam@NewgroupsONLY.com> schreef in bericht >>> news:OeQE7B1RGHA.5728@tk2msftngp13.phx.gbl... >>>> Hi all, >>>> >>>> >>>> >>>> I edit records using a form that have multiple control bind on >>>> Dataview, But I don't want to update right always to database, I would >>>> like to delay until all Changes (add all new record using a form or >>>> edit various existing records) >>>> >>>> This way I could minimize transaction on server.. >>>> >>>> Any hint ? >>>> >>>> VS 2003 >>>> >>>> Marc R. >>>> Thanks for your help guys ! >>>> >>>> >>>> >>> >>> >> >> > > Marc,
Do you really think that you have to hide things not showing it. This newsgroups are build of given information and get it back. I get the idea that you think you build something special that you should not show. However, if you use version 1.1 than you need probably the bindingmanagerbase.endcurrentedit. That pushes the data without a rowchange into the datasource. http://msdn2.microsoft.com/en-us/library/system.windows.forms.bindingmanagerbase.endcurrentedit.aspx I hope this helps, Cor Show quoteHide quote "Marc R." <Nospam@NewgroupsONLY.com> schreef in bericht news:eS8gOv4SGHA.5264@TK2MSFTNGP10.phx.gbl... > Sorry, > > I got a treeview that contains Service nodes > > here how I works with each record, > > me.dvserviceoperation.rowfilter = "ser_id=" & ctype e.node,service).id > > so now data view as 1 record. > > all bound control on form bounds to that specific record. > > At this point If I don't save the change right away (let say I click on a > other Node(service)) All Change made are lost. > > > "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message > news:e4fC2$xSGHA.4384@tk2msftngp13.phx.gbl... >> Marc, >> >> Not any piece of code how you do that? >> >> Cor >> >> "Marc R." <Nospam@NewgroupsONLY.com> schreef in bericht >> news:Oxl%23GDtSGHA.4168@tk2msftngp13.phx.gbl... >>> well I use a grid bound to a dataview, >>> went I click on a row, All textboxes on the form updates accordingly. >>> if I edit the textboxes, I absolutely need to do an update to not loose >>> information. >>> if I change to a different row, then back to the previously edited row >>> my >>> edited information aren't into textboxes anymore. I see the original >>> data. >>> >>> I would like to be able to edit, as much as many row I like or even add >>> some >>> new rows then update database. >>> >>> Let hope that is better explained. >>> thks >>> >>> >>> Dunno what happen here, my 1st response didn't made it to the news >>> group. >>> >>> "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message >>> news:uq1cfL1RGHA.5108@TK2MSFTNGP09.phx.gbl... >>>> Marc, >>>> >>>> It is up to you when you update a datatable to a database, so can you >>>> explain your question a little bit more? >>>> >>>> Cor >>>> >>>> >>>> "Marc R." <Nospam@NewgroupsONLY.com> schreef in bericht >>>> news:OeQE7B1RGHA.5728@tk2msftngp13.phx.gbl... >>>>> Hi all, >>>>> >>>>> >>>>> >>>>> I edit records using a form that have multiple control bind on >>>>> Dataview, But I don't want to update right always to database, I would >>>>> like to delay until all Changes (add all new record using a form or >>>>> edit various existing records) >>>>> >>>>> This way I could minimize transaction on server.. >>>>> >>>>> Any hint ? >>>>> >>>>> VS 2003 >>>>> >>>>> Marc R. >>>>> Thanks for your help guys ! >>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > > Sorry Cor, That wasn't the intent,
I use all Automatic code that comes with the Bindings, the only code I may give you (because it is the only existing code it is then treeview.click event handler) that is me.DataView.rowfilter = "Ser_id = " & ctype(me.treeView.selectednodes,service).ID of course all controls on the form (3 textboxes ,1 Combobox, 2 checkbox) are bonded on The Dataview that get changed. the problem is : went I click a 2nd nodes all previous change are lost If I don't do an update. an other good reason why I don't Copy the code : my first language is French, so is my variable name. but there is nothing else the code Show quoteHide quote "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message news:%23c4nbD$SGHA.4368@TK2MSFTNGP14.phx.gbl... > Marc, > > Do you really think that you have to hide things not showing it. This > newsgroups are build of given information and get it back. I get the idea > that you think you build something special that you should not show. > > However, if you use version 1.1 than you need probably the > bindingmanagerbase.endcurrentedit. > That pushes the data without a rowchange into the datasource. > > http://msdn2.microsoft.com/en-us/library/system.windows.forms.bindingmanagerbase.endcurrentedit.aspx > > I hope this helps, > > Cor > > "Marc R." <Nospam@NewgroupsONLY.com> schreef in bericht > news:eS8gOv4SGHA.5264@TK2MSFTNGP10.phx.gbl... >> Sorry, >> >> I got a treeview that contains Service nodes >> >> here how I works with each record, >> >> me.dvserviceoperation.rowfilter = "ser_id=" & ctype e.node,service).id >> >> so now data view as 1 record. >> >> all bound control on form bounds to that specific record. >> >> At this point If I don't save the change right away (let say I click on a >> other Node(service)) All Change made are lost. >> >> >> "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message >> news:e4fC2$xSGHA.4384@tk2msftngp13.phx.gbl... >>> Marc, >>> >>> Not any piece of code how you do that? >>> >>> Cor >>> >>> "Marc R." <Nospam@NewgroupsONLY.com> schreef in bericht >>> news:Oxl%23GDtSGHA.4168@tk2msftngp13.phx.gbl... >>>> well I use a grid bound to a dataview, >>>> went I click on a row, All textboxes on the form updates accordingly. >>>> if I edit the textboxes, I absolutely need to do an update to not loose >>>> information. >>>> if I change to a different row, then back to the previously edited row >>>> my >>>> edited information aren't into textboxes anymore. I see the original >>>> data. >>>> >>>> I would like to be able to edit, as much as many row I like or even add >>>> some >>>> new rows then update database. >>>> >>>> Let hope that is better explained. >>>> thks >>>> >>>> >>>> Dunno what happen here, my 1st response didn't made it to the news >>>> group. >>>> >>>> "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message >>>> news:uq1cfL1RGHA.5108@TK2MSFTNGP09.phx.gbl... >>>>> Marc, >>>>> >>>>> It is up to you when you update a datatable to a database, so can you >>>>> explain your question a little bit more? >>>>> >>>>> Cor >>>>> >>>>> >>>>> "Marc R." <Nospam@NewgroupsONLY.com> schreef in bericht >>>>> news:OeQE7B1RGHA.5728@tk2msftngp13.phx.gbl... >>>>>> Hi all, >>>>>> >>>>>> >>>>>> >>>>>> I edit records using a form that have multiple control bind on >>>>>> Dataview, But I don't want to update right always to database, I >>>>>> would like to delay until all Changes (add all new record using a >>>>>> form or edit various existing records) >>>>>> >>>>>> This way I could minimize transaction on server.. >>>>>> >>>>>> Any hint ? >>>>>> >>>>>> VS 2003 >>>>>> >>>>>> Marc R. >>>>>> Thanks for your help guys ! >>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > > Marc,
> of course all controls on the form (3 textboxes ,1 Combobox, 2 checkbox) And did you implement in that click event that "endcurrentedit" instead of > are bonded on The Dataview that get changed. > > the problem is : went I click a 2nd nodes all previous change are lost If > I don't do an update. > that? \\\ DirectCast(BindingContext(dv), CurrencyManager).EndCurrentEdit /// I hope this helps, Cor I changed My way Around, I Use My nodes to "gather the new information" then
went user click Save, I take All info from Nodes and put it back to the Dataview then Update the dataview. longer step but I have full control of everything the only question I got now : is there a way to Bind A textbox control to a Tree as in : me.textbox.data.text = ctype(me.treeview.selectedNodes,service).Description I thing I just got the perfect Ideal, To my service Nodes I will implement each a Dataview, that dataview will me affected to the databinding of the text control at runtime (click even of node) on the form's save button, I simply to run the tree view to update each service if has change. Do I make any sense ? Show quoteHide quote "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message news:e4fC2$xSGHA.4384@tk2msftngp13.phx.gbl... > Marc, > > Not any piece of code how you do that? > > Cor > > "Marc R." <Nospam@NewgroupsONLY.com> schreef in bericht > news:Oxl%23GDtSGHA.4168@tk2msftngp13.phx.gbl... >> well I use a grid bound to a dataview, >> went I click on a row, All textboxes on the form updates accordingly. >> if I edit the textboxes, I absolutely need to do an update to not loose >> information. >> if I change to a different row, then back to the previously edited row my >> edited information aren't into textboxes anymore. I see the original >> data. >> >> I would like to be able to edit, as much as many row I like or even add >> some >> new rows then update database. >> >> Let hope that is better explained. >> thks >> >> >> Dunno what happen here, my 1st response didn't made it to the news group. >> >> "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message >> news:uq1cfL1RGHA.5108@TK2MSFTNGP09.phx.gbl... >>> Marc, >>> >>> It is up to you when you update a datatable to a database, so can you >>> explain your question a little bit more? >>> >>> Cor >>> >>> >>> "Marc R." <Nospam@NewgroupsONLY.com> schreef in bericht >>> news:OeQE7B1RGHA.5728@tk2msftngp13.phx.gbl... >>>> Hi all, >>>> >>>> >>>> >>>> I edit records using a form that have multiple control bind on >>>> Dataview, But I don't want to update right always to database, I would >>>> like to delay until all Changes (add all new record using a form or >>>> edit various existing records) >>>> >>>> This way I could minimize transaction on server.. >>>> >>>> Any hint ? >>>> >>>> VS 2003 >>>> >>>> Marc R. >>>> Thanks for your help guys ! >>>> >>>> >>>> >>> >>> >> >> > > 
Other interesting topics
String builder (Parsing vertically presented records)
Programming for Touch Screens I'm perplexed with simple ADO.NET - Access DB Access - Please Help Edit and Continue?? VS2005 VB6 to VB.Net - Using X1,X2,Y1,Y2 in .Net Urgent: VB.NET Code to Change Excel Worksheet Header/Footer need help with regular expression Enabling / Disabling Tab Pages generating dev documentation from standard commenting. Distributing Application / SQL Server Express question |
|||||||||||||||||||||||
