could someone tell me about lock types, cursor locations in ADO, the theory and the practices??

cuz I still write client server applications without using these things, not knowing how they work...