Whats the purpose of the sqlParameter.SourceVersion?

Question

Hi,
In implementing concurrencies i have seen the use of :

 

SqlParameter parm = da.UpdateCommand.Parameters.Add("@PLastUpdatedTime", 
SqlDbType.DateTime, -1, "updatedTime");
parm.SourceVersion = DataRowVersion.Original;

It says that it will assign the Orignal TimeStamp value of the "updatedTime" Column in the dataset to "@PLastUpdatedTime". But it doesnt show the assignment of the value in that column and when i test it for value in that parm parameter, it says NULL. SO what happense here......?
. i'm suppose to pass the value in the "@PLastUpdatedTime" as a search value to find the row and later compares the value in @PLastUpdatedTime with the value in the actual DB table to figure concurrency violoation. How do i fix my problem?

TY

Roei Bar · Answer

This property is used by the UpdateCommand during the Update to determine whether the original or current value is used for a parameter value. This allows primary keys to be updated. This property is set to the version of the DataRow used by the Item property, or the GetChildRows method of the DataRow object. you can read more abour this in here http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlparameter.sourceversion%28VS.71%29.aspx

Kirtan Patel · Answer

It is used to Get and set the Values of DatarowVersion see below example :) SqlParameter parameter = new SqlParameter( "@LastRowVer" , SqlDbType.VarChar, 88); parameter.SourceColumn = "@LastRowVer" ; parameter.SourceVersion = DataRowVersion.Current; see more info here about it Click Here dont forget to mark " do you like this answer if my answer helped you :)

Whats the purpose of the sqlParameter.SourceVersion?

Answers (2)