Gets or sets the offset to the Value property.
<BrowsableAttribute(False)> _ Public Property Offset As Integer
Dim instance As SqlParameter Dim value As Integer value = instance.Offset instance.Offset = value
[BrowsableAttribute(false)] public int Offset { get; set; }
[BrowsableAttribute(false)] public: property int Offset { int get (); void set (int value); }
public function get Offset () : int public function set Offset (value : int)
The Offset property is used for client-side chunking of binary and string data. For example, in order to insert 10MB of text into a column on a server, a user might execute 10 parameterized inserts of 1MB chunks, shifting the value of Offset on each iteration by 1MB.
Offset specifies the number of bytes for binary types, and the number of characters for strings. The count for strings does not include the terminating character.
The following example creates a SqlParameter and sets some of its properties.
Private Sub CreateSqlParameterOffset() Dim parameter As New SqlParameter("pDName", SqlDbType.VarChar) parameter.IsNullable = True parameter.Offset = 3 End Sub
static void CreateSqlParameterOffset() { SqlParameter parameter = new SqlParameter("pDName", SqlDbType.VarChar); parameter.IsNullable = true; parameter.Offset = 3; }
Windows 7, Windows Vista, Windows XP SP2, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP Starter Edition, Windows Server 2008 R2, Windows Server 2008, Windows Server 2003, Windows Server 2000 SP4, Windows Millennium Edition, Windows 98, Windows CE, Windows Mobile for Smartphone, Windows Mobile for Pocket PC