VB Datagrid and ADODC data problem when refresh
Posted on 2003-02-20
I am using datagrid with ADODC. The grid is for display only, so I set it as "update not allowed". And there's nowhere will change this property. I change the data to be displayed by change data srouce of the ADODC. The applicaiton get refresh every, say 2 mins, with the right-the-moment ADODC data source. Users were performing operation by click on the diffrerent columns of the grid to call a menu and some stored procedures will be called via the menu to perform corresponding actions (i.e. no data manipulation via the grid).
However, some abnormal data were created to the database during daily using of this application. It looked like when I was stopping the arrow at column 1 of row 12, for e.g.; and just happen it was time to refresh, then the data at first column of first row will be replaced with content of col 1 row 12 -- and one new records was created in DB. This happens 1 out of about 20 times of refresh. Howver, actually I am still not 100% sure if this was really created by the refreshing or some other properties or events among the grid.
Has any one experienced such sutiation before? how was it caused and the sulotion?
Or can any one have a rough idea about the occurence and thus suggest some preventive methods?
1000 thx in advance.