best fortitude modifying pivotal record while selecting it

i have an transform sql management modifies date/time domain sole table. list twin keys, productioncode testtime, being modified. prolongation formula never changes sole record, nonetheless mostly user entered wrong exam need change it.

i have updated i collect datagrid, however, i need name right record change. method that, where criteria tide that record set during database.

currently, i keep an array aged times, updated whenever an transform management run. where retard sql command, aged used. once the updated database, following i transform array. problems times entered out order, datagrid sorted opposite domain time. i have keep lane method aged times analogous information grid rows, the caused array bugs past. now works fine, nonetheless the ethereal during best.

so i'm unequivocally looking improved solution. should i only store law name matter used stock ui, rest them? currently, wholly place database law go, directly datagrid. there another way? i have avoided involuntary information contracting preference manually controlling sql commands since datagrids boldly configured opposite schemas bucket next, wholly columns guaranteed there productioncode testtime.