I've written a program for work that uses a MySQL database. I currently read and write directly to the database instead of using a dataadapter.

I am thinking of porting over to use a dataadapter but I'm curious about one thing.

If 2 users are working on the same database and table and if one of them makes a change will the changes be reflected immediately to the other user?

I think using a dataadapter would be preferable to what I'm doing but I want to make sure the data doesn't get stale.

Anyone who can answer this? Thanks in advance.