Bob,
I cannot answer yes or no on your question, because when you do the database
updates while editing it can be that you use it. But it has forever to do
with update from a database as long as you don't do that, you normally
should not use the acceptchanges.
The acceptchanges can be used by instance in this sentence.
myDataAdapter.Update(myDataTable.getchanges)
Not that this gives any advantage but let assume.
The dataadapter marks the rowstate of rows which are done as not changed.
But the myDataTable.getchanges is a copy of the datatable, so it has to be
done in the origanal as well.
Therefore than the myDataTable.acceptchanges which means that those rows
will not be updated again.
I hope that this makes it a little bit clear because there are not much
samples to give where it has to be used. It is not rare to use it, but there
are very few places (a cascade update by instance can need it as well).
Cor
<bo*@datasync.com> schreef in bericht
news:11**********************@c74g2000cwc.googlegr oups.com...
Cor, I am not clear on what you mean by saying "If means something as
Accept changes as done." Does this mean you should AcceptChanges
(update the database on disk) only when you are done and exit the
DataGrid/program, and not during the editing process? Or, is it
recommended to confirm/write/update a small portion of the data (ie,
the row you just changed) right away? If the latter, how to you do
that?
Thanks.
bo*@datasync.com
Cor Ligthert [MVP] wrote: MFleet,
I would try it by refreshing the datagrid.
http://msdn.microsoft.com/library/de...freshtopic.asp
More worse is the acceptchanges in your code.
It means that all the data in your dataset should be handled as been
updated
to the database.
(You are not the first one who interprets this command wrong)
:-)
If means something as Accept changes as done.
I hope this helps,
Cor
<mf********@yahoo.ca> schreef in bericht
news:11**********************@u72g2000cwu.googlegr oups.com... > Hello. I'm fairly new to VB.Net (2003). I'm using a datagrid to
> display data (access db) and when user double clicks on a record,
> another form shows up which allows modification/addition of data. The
> problem is when user accepts the changes made and gets back to
> datagrid. The information displayed is still the old info. How do I
> get the new information to display? Here is an example of the code
> used to update the data:
>
> objDataSet.Tables("Table").Rows(objCurrencyManager .Position).BeginEdit()
> objDataRow =
> objDataSet.Tables("Table").Rows(objCurrencyManager .Position)
>
> With objDataRow
> .Item("Field1") = Text1.Text
> End With
> objDataRow.AcceptChanges()
> objDataSet.Tables("Table").Rows(objCurrencyManager .Position).AcceptChanges()
>
> Shouldn't the data in the datagrid diplay the information that was
> entered in Text1.Text? Or is it that I'm doing something wrong?
>
> Many thanks for any replies!!
>
