I've come from a client/server background using Non-MS development tools, and found the new ADO.Net concepts a little tricky to get my head round - disconnected recordsets etc.

I think I've got my head round how that works now and We're currently embarking on a development with .Net & SqlServer, and there's a couple of things I can't figure out.

1) Multi-User systems

How do I detect wether someone else has changed the data that I'm about to update.

How do you hande this using a DataGrid ?

The previous database product had a concept of RowID's, where if a row in the database had changed and I trie dto update it, it was possible to detect that and handle that in the code.

I haven't seen any discussions or articles on it, but if anyone could point me in the right direction I'd be grateful.

2) DataGrid

If I filled up a datagrid and wanted to set the cell color depending on a certain value, how could I do that ?

In my previous language ( None MS ) I'm used to picking up an event from a table as it fills up, and setting the colours of text at that point, but I can't see the same here at the moment.

Any help would be appreciated.


Pete