Windows apps
Collapse the table of content
Expand the table of content
Information
Switch
Switch
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

SqlParameter::Offset Property

.NET Framework (current version)
 

Gets or sets the offset to the Value property.

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

C#
C++
F#
VB
Copy 
public:
[BrowsableAttribute(false)]
property int Offset {
	int get();
	void set(int value);
}

Property Value

Type: System::Int32

The offset to the Value. The default is 0.

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.

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.

.NET Framework
Available since 1.1
Return to top
Show:
© 2017 Microsoft