Re: problem with having a delete in database propagate to a bound data

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: W.G. Ryan eMVP (WilliamRyan_at_gmail.com)
Date: 10/21/04


Date: Thu, 21 Oct 2004 11:02:59 -0400

When you are refreshing the datatable - are you clearing it first? If not,
then the rows will be appended to the end and the datatable will appear to
have that row.

-- 
W.G. Ryan, MVP
www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"RJ" <RJ@discussions.microsoft.com> wrote in message
news:8B17C6DF-7857-4BFA-8243-EE04B727A218@microsoft.com...
> Hi,
> I have notice something with the datagrid update
> i have an application which is updated from multiple sources
> when one user deletes a row on the datagrid, the delete propgates back to
> the database. I see it is gone, from the database by using the SQL query
> analyzer.
> but, when other users app calls it's fill command to refresh it's
datatable,
> It sees the already deleted row.
> what am i doing wrong?
>
>
>


Relevant Pages

  • Re: Writing Activity Monitor
    ... But the performance is very slow approximate 40 seconds wait for viewing summary views and more for detail views. ... If you have 5 operators each refreshing different views the response times gets much worse. ... If the database takes 40 seconds to create your view data, you have to optimize your database or queries and not the display. ...
    (comp.lang.tcl)
  • Re: Refresh DataSet - please Help Me :-(
    ... >And than to get more help it probably better to ask this in the newsgroup ... Firstly let me say I agree with Cor, the best approach to a problem ... the usual approach to refreshing a dataset is to have one ... Update the database with any changes made. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Data Loss in Access 2000
    ... I believe it is referring to refreshing of links everytime the backend ... Now, on the persistent recordset, it does make a difference! ... > base my form on a table linked to the Back end database. ...
    (microsoft.public.access.modulesdaovba)
  • Re: refresh test from prod in wrong way
    ... what is the typical way of refreshing a test db from prod? ... logically consistent subsets of the production database. ... Princeton Softech also has great tech support which was able to ... without installing database patches first. ...
    (comp.databases.oracle.server)
  • Count all records in all tables
    ... refreshing the statistics on this database. ... countas ColumnCount ...
    (comp.databases.oracle.misc)