>Hello All, is there an equivalent of OldVal(), CurVal() in ADO.Net, I need to check the value of a field before updating another , I'm using C# and connecting to a SQL 2000 database running on W2K server

see http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconrowstates.asp