SQL timestamp column for concurrency

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Ade (Ade_at_discussions.microsoft.com)
Date: 02/28/05 

Date: Mon, 28 Feb 2005 11:33:04 -0800

Excuse my ignornance but I am relatively new to .NET. We have migrated a
solution from Access to web based and have a fully working solution except
that we failed to consider multi-user use in ceratain areas, although
last-write is OK it has caused a few minor issues with some information being
overtyped.

Thought that we could adjust tables and VB code to work with the SQL
timestamp column but are having a few problems understanding byte/sqlbinary
declarations.

I am trying to extract the timestamp column value from SQL2000 into a
variable to display on the web form from a datareader for debugging purposes
and then use this in the where clause of our update command instead of the
rowid.

We have tried several declarations and keep receiving a CAST error For
example we get cannot cast byte() to byte on debugging the respective page.
Would be grateful if someone could point me in the right direction.

regards