System.Data.SqlClient Namespace SqlCommandBuilder Class
Sets or retrieves the beginning character or characters to use when specifying SQL Server™ object names, ( for example, tables or columns ), that contain characters such as spaces.
Script |
SqlCommandBuilder.QuotePrefix [ = strValue ] |
strValue |
The beginning character or characters to use. |
The property is read/write with no default value.
Exception Type |
Condition |
InvalidOperationException |
The property is changed after an insert, update, or delete command has been generated. |
Database objects in instances of SQL Server™ 2000 and SQL Server™ version 7.0 can contain any valid Microsoft Windows NT® or Microsoft Windows® 2000 characters, including spaces, commas, and semicolons. To accommodate this capability, use the QuotePrefix and QuoteSuffix properties to specify delimiters such as a left bracket and a right bracket to 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 a SqlDataAdapter.
SqlCommandBuilder Members