Re: Batch Insert/Updates

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello and thank you for your answer.

I don't understand what do you mean by "Manipulating RowState". The problem
is not whether to call the AcceptChanges for each row or to call the Update
method in order to submit the inserts. The problem is that if I insert a new
record then this record is visible in the user interface only if I call the
Update method (or the Row.AcceptChanges). If I don't call the Update method
then the new row is not visible to the user interface. This situation is an
obstacle in inserting two or more rows and updating the database at the end.
It is common practice in desktop applications when there is a master-detail
relationship between two tables, to update both tables at the same time and
not post changes to the detail table and cancel changes to the master table.
That is what I want to implement.

Regards
Dimitris Milonas


"W.G. Ryan" <WilliamRyan@xxxxxxxxxxxxxxxx> wrote in message
news:ebv8K$2NIHA.1188@xxxxxxxxxxxxxxxxxxxxxxx
Manimpulating RowState will do it for you. When you call Update, it calls
AcceptChanges on each row as the row is updated. I'm not familiar with
the Details view but you could just call AcceptChanges on the row and it
would be in the same state is if you called Update.

The question is why it's showing. I suspect that once you call Update, the
SELECT query is firing again and that's why it's now visible. Do you hvae
the Refresh Dataset option on when you call Update?
"Dimitris Milonas" <gnout@xxxxxxxxxxx> wrote in message
news:Ob1FVtYMIHA.5224@xxxxxxxxxxxxxxxxxxxxxxx
Hello to all,

I would like to inserts/delete some records from a table and Update the
DataAdapter at the end of all the operations. The problem is that I would
like the intermediate changes to be visible in the User Interface (i.e.
DetailView). I am using the following code:

DataRow DataRow1 = DataSet1.Tables["Table1"].NewRow();

DataRow1["CODE"] = "...";
DataRow1["NAME"] = "...";

DataSet1.Tables["Table1"].Rows.Add(DataRow1);

At this point the new row is not visible to the User Interface. That
means that I have to Update the DataAdapter
(DataAdapter1.Update(DataSet1,"Table1")) in order for the new row to be
visible to User Interface. Is there a way the changes to be visible to
the User Interface before Update the DataAdapter?

Thanks in advance
Dimitris Milonas










.

Relevant Pages

  • Re: Batch Insert/Updates
    ... Manimpulating RowState will do it for you. ... AcceptChanges on each row as the row is updated. ... DataAdapter at the end of all the operations. ... At this point the new row is not visible to the User Interface. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Saving Data with DataAdapter to Jet DB
    ... uses the Update method of the DataAdapter, not before, as you talk about. ... The Acceptchanges accept all the changes in the DataSet as done, so there is nothing anymore to update. ... As it is about a complete dataTable or DataSet, then the DataAdapter has an inbuild AcceptChanges as soon as the update is done. ... use virtually the same code set in another project writing to a SQL server DB ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Question about DataTable
    ... you don't necessarily have to use a data set that is filled with a ... I was referring to the Update method. ... > DataAdapter adds a DataTable into a Dataset via da.Fillmethod. ... >> You don't have to call AcceptChanges. ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: Update SqlServer Table Fom xml file
    ... DataAdapter that this particular row has all ready committed its changes to ... I would put the AcceptChanges after the Update method call. ... > I use the code below but nothing is updated in my sqlServer DataBase. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Saving Data with DataAdapter to Jet DB
    ... the Update method of the DataAdapter, not before, as you talk about. ... newsgroup not to use the Acceptchanges before you do an update. ... As it is about a complete dataTable or DataSet, then the DataAdapter has ... use virtually the same code set in another project writing to a SQL ...
    (microsoft.public.dotnet.framework.adonet)