Whats the purpose of the sqlParameter.SourceVersion?

petre ricardo

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Roei Bar17y ago
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
0
Kirtan Patel17y ago
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 :)
0