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)

Not applicable.

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 Server 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 Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

.NET Framework

Supported in: 3.0, 2.0, 1.1, 1.0

.NET Compact Framework

Supported in: 2.0, 1.0

Community Additions

ADD
Show:
© 2014 Microsoft