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 !
10  1894 
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." <No****@NewgroupsONLY.com> schreef in bericht
news:Oe**************@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
"Cor Ligthert [MVP]" <no************@planet.nl> wrote in message
news:uq**************@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." <No****@NewgroupsONLY.com> schreef in bericht
news:Oe**************@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 nothing
Cor
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]" <no************@planet.nl> wrote in message
news:uq**************@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." <No****@NewgroupsONLY.com> schreef in bericht
news:Oe**************@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.
"Cor Ligthert [MVP]" <no************@planet.nl> wrote in message
news:uq**************@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." <No****@NewgroupsONLY.com> schreef in bericht
news:Oe**************@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
"Marc R." <No****@NewgroupsONLY.com> schreef in bericht
news:Ox****************@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]" <no************@planet.nl> wrote in message
news:uq**************@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." <No****@NewgroupsONLY.com> schreef in bericht
news:Oe**************@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.
"Cor Ligthert [MVP]" <no************@planet.nl> wrote in message
news:e4**************@tk2msftngp13.phx.gbl... Marc,
Not any piece of code how you do that?
Cor
"Marc R." <No****@NewgroupsONLY.com> schreef in bericht
news:Ox****************@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]" <no************@planet.nl> wrote in message
news:uq**************@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." <No****@NewgroupsONLY.com> schreef in bericht
news:Oe**************@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 !
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).Descripti on
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 ?
"Cor Ligthert [MVP]" <no************@planet.nl> wrote in message
news:e4**************@tk2msftngp13.phx.gbl... Marc,
Not any piece of code how you do that?
Cor
"Marc R." <No****@NewgroupsONLY.com> schreef in bericht
news:Ox****************@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]" <no************@planet.nl> wrote in message
news:uq**************@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." <No****@NewgroupsONLY.com> schreef in bericht
news:Oe**************@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/lib...rrentedit.aspx
I hope this helps,
Cor
"Marc R." <No****@NewgroupsONLY.com> schreef in bericht
news:eS**************@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]" <no************@planet.nl> wrote in message
news:e4**************@tk2msftngp13.phx.gbl... Marc,
Not any piece of code how you do that?
Cor
"Marc R." <No****@NewgroupsONLY.com> schreef in bericht
news:Ox****************@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]" <no************@planet.nl> wrote in message
news:uq**************@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." <No****@NewgroupsONLY.com> schreef in bericht
news:Oe**************@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
"Cor Ligthert [MVP]" <no************@planet.nl> wrote in message
news:%2****************@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/lib...rrentedit.aspx
I hope this helps,
Cor
"Marc R." <No****@NewgroupsONLY.com> schreef in bericht
news:eS**************@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]" <no************@planet.nl> wrote in message
news:e4**************@tk2msftngp13.phx.gbl... Marc,
Not any piece of code how you do that?
Cor
"Marc R." <No****@NewgroupsONLY.com> schreef in bericht
news:Ox****************@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]" <no************@planet.nl> wrote in message
news:uq**************@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." <No****@NewgroupsONLY.com> schreef in bericht
> news:Oe**************@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)
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.
And did you implement in that click event that "endcurrentedit" instead of
that?
\\\
DirectCast(BindingContext(dv), CurrencyManager).EndCurrentEdit
///
I hope this helps,
Cor This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Paul Slavin |
last post by:
I have a textbox bound to a dataview, when I update the text in the textbox no changes take place in the underlying dataset. Why is this??
any answers appreciated, as to due to the underlying...
|
by: Vern |
last post by:
The following code retrieves data into a dataset, and then creates a dataview
with a filter. This dataview is then attached to a combobox. When the
effective date changes, I would like to see the...
|
by: kjvt |
last post by:
Based on a prior posting, I've written a function to convert a
recordset to a dataview. The first call to the function for a given
recordset works perfectly, but the second call always returns a...
|
by: Steve |
last post by:
I have a form with a dataset and a datagrid.
I created a dataview on this dataset.
When the user modifies the datagrid, I look up this record in the dataview
to make sure it is unique.
Here is...
|
by: Tim Frawley |
last post by:
I need to return a DataRow or the Row Index in a DataSet wherein the
value I am attempting to find is not a primary key.
I have to do this often, more than 200 times when importing a file so
it...
|
by: David Wender |
last post by:
I want to create a dataview with a sort on multiple columns. However,
when I use FindRows, I only want to search some of the columns, not
all. Is this possible? I have not been able to make it...
|
by: =?Utf-8?B?UmljaA==?= |
last post by:
Greetings,
I need to locate a row (or see if it exists) in a table contained in a
dataset. The DataView.Find method seems to work OK for one criteria but I
need to use 2 criterias. Is there...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
| |
