Export (0) Print
Expand All

SqlParameter.SourceVersion Property

Gets or sets the DataRowVersion to use when you load Value

Namespace: System.Data.SqlClient
Assembly: System.Data (in system.data.dll)

public override DataRowVersion SourceVersion { get; set; 
/** @property */
public DataRowVersion get_SourceVersion ()

/** @property */
public void set_SourceVersion (DataRowVersion value)

public override function get SourceVersion () : DataRowVersion

public override function set SourceVersion (value : DataRowVersion)

Property Value

One of the DataRowVersion values. The default is Current.

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 lets primary keys 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.

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;


Windows 98, Windows 2000 SP4, Windows CE, Windows Millennium Edition, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.

.NET Framework

Supported in: 2.0, 1.1, 1.0

.NET Compact Framework

Supported in: 2.0, 1.0

Community Additions

ADD
Show:
© 2014 Microsoft