Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

OracleCommandBuilder.QuoteSuffix Property

.NET Framework 1.1
Note: This namespace, class, or member is supported only in version 1.1 of the .NET Framework.

Gets or sets the ending character or characters to use when working with database objects (for example, tables or columns) whose names contain characters such as spaces or reserved tokens.

[Visual Basic]
Public Property QuoteSuffix As String
[C#]
public string QuoteSuffix {get; set;}
[C++]
public: __property String* get_QuoteSuffix();
public: __property void set_QuoteSuffix(String*);
[JScript]
public function get QuoteSuffix() : String;
public function set QuoteSuffix(String);

Property Value

The ending character or characters to use. The default is an empty string.

Exceptions

Exception Type Condition
InvalidOperationException This property cannot be changed after an insert, update, or delete command has been generated.

Remarks

Some databases may contain objects whose names include characters such as spaces, commas, and semicolons. To accommodate this, use the QuotePrefix and QuoteSuffix properties to specify delimiters, such as a left and right bracket, that will encapsulate the object name.

Note   Although you cannot change the QuotePrefix or QuoteSuffix properties after an insert, update, or delete operation has been generated, you can change their settings after calling the Update method of an OracleDataAdapter.

Requirements

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

.NET Framework Security: 

See Also

OracleCommandBuilder Class | OracleCommandBuilder Members | System.Data.OracleClient Namespace

Show:
© 2015 Microsoft