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

NuGet Package: DevExpress.Win.Spreadsheet

Declaration

C#

public DataSourceOptionsContainer DataSourceOptions { get; }

VB.NET

Public ReadOnly Property DataSourceOptions As DataSourceOptionsContainer

Property Value

Type	Description
DataSourceOptionsContainer	An object that contains data source options.

Property Paths

You can access this nested property as listed below:

Object Type	Path 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

Form1.cs

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

Form1.vb

spreadsheetControl1.Options.DataSourceOptions.ObjectDataSourceLoadingBehavior = DevExpress.DataAccess.DocumentLoadingBehavior.Prompt