Skip to main content

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.v22.2.dll

NuGet Package: DevExpress.Win.Spreadsheet


public DataSourceOptionsContainer DataSourceOptions { get; }

Property Value

Type Description

An object that contains data source options.

Property Paths

You can access this nested property as listed below:

Object Type Path to DataSourceOptions
.Options .DataSourceOptions


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.


View Example

spreadsheetControl1.Options.DataSourceOptions.ObjectDataSourceLoadingBehavior = DevExpress.DataAccess.DocumentLoadingBehavior.Prompt;
See Also