Share via


SqlParameter.SourceVersion Property

Definition

Gets or sets the DataRowVersion to use when you load Value

public:
 virtual property System::Data::DataRowVersion SourceVersion { System::Data::DataRowVersion get(); void set(System::Data::DataRowVersion value); };
public override System.Data.DataRowVersion SourceVersion { get; set; }
member this.SourceVersion : System.Data.DataRowVersion with get, set
Public Overrides Property SourceVersion As DataRowVersion

Property Value

One of the DataRowVersion values. The default is Current.

Implements

Examples

The following example creates a SqlParameter and sets some of its properties.

static void CreateSqlParameterSourceVersion()
{
    SqlParameter parameter = new SqlParameter("Description", SqlDbType.VarChar, 88);
    parameter.SourceColumn = "Description";
    parameter.SourceVersion = DataRowVersion.Current;
}

Remarks

This property is used by the UpdateCommand during an update to determine whether the original or current value is used for a parameter value. This lets primary keys be updated. This property is set to the version of the DataRow used by the Item[String] property, or one of the GetChildRows(String) methods of the DataRow object.

Applies to