Back to Devexpress

SpreadsheetControlOptions.DataSourceOptions Property

windowsforms-devexpress-dot-xtraspreadsheet-dot-spreadsheetcontroloptions-fe4d2e48.md

latest2.4 KB
Original Source

SpreadsheetControlOptions.DataSourceOptions Property

Allows you to specify whether to prohibit the ObjectDataSource data retrieval, prompt the user or silently load the data.

Namespace : DevExpress.XtraSpreadsheet

Assembly : DevExpress.XtraSpreadsheet.v25.2.dll

NuGet Package : DevExpress.Win.Spreadsheet

Declaration

csharp
public DataSourceOptionsContainer DataSourceOptions { get; }
vb
Public ReadOnly Property DataSourceOptions As DataSourceOptionsContainer

Property Value

TypeDescription
DataSourceOptionsContainer

An object that contains data source options.

|

Property Paths

You can access this nested property as listed below:

Object TypePath to DataSourceOptions
SpreadsheetControl

.Options .DataSourceOptions

|

Remarks

If the DataSourceOptions specifies to prompt the user, the ObjectDataSourceValidationService service is called for validation. You can implement your own service and provide a custom validation instead of displaying the default warning dialog.

Example

csharp
spreadsheetControl1.Options.DataSourceOptions.ObjectDataSourceLoadingBehavior = DevExpress.DataAccess.DocumentLoadingBehavior.Prompt;
vb
spreadsheetControl1.Options.DataSourceOptions.ObjectDataSourceLoadingBehavior = DevExpress.DataAccess.DocumentLoadingBehavior.Prompt

See Also

SpreadsheetControlOptions Class

SpreadsheetControlOptions Members

DevExpress.XtraSpreadsheet Namespace