LoadMode Property

Microsoft Office Web Components Visual Basic

LoadMode Property

Returns an enumeration constant that represents the numeric equivalent of the LoadMode attribute value of the <Binding> element for a particular data binding. Read-only BindingLoadMode.

expression .LoadMode

expression Required. An expression that returns an XMLDataBinding object.

Remarks

An XMLDataBinding object can be a binding to an XML file, an arbitrary SOAP service, another Web part (for the Spreadsheet Web Part), or a data retrieval service. The LoadMode property describes the binding behavior for loading. The possible LoadMode property settings and their numeric equivalent are shown below. If not provided, a default of "normal" is assumed:

BindingLoadMode	Description
Normal (0 )	For a query binding, binding occurs at first load, when the user clicks the Refresh All toolbar button, Refresh command on the toolstrip in the Spreadsheet Web Part, or the Refresh Data command on the context menu in the Spreadsheet component. Binding can be done programmatically as well. For an update binding, binding occurs every time the user clicks the Update Data command on the toolstrip in the Spreadsheet Web Part, or when using theSave Data command on the context menu. Binding can also occur programmatically
OM (1)	For a query binding, binding does not occur at first load, when the user clicks the Refresh All toolbar button, Refresh command on the toolstrip in the Spreadsheet Web Part, or the Refresh Data command on the context menu in the Spreadsheet component. Binding also does not occur when the Refresh method is called on the Spreadsheet object. Binding only occurs when the Refresh method of the XmlDataBinding object is called. For an update binding, binding does not occur at first load, when the user clicks the Update Data command on the toolstrip in the Spreadsheet Web Part, or when using the Save Data command on the context menu. Binding only occurs when the Update method of the XmlDataBinding object is called.
Delay (2)	For a query binding, when the user clicks the Refresh All toolbar button, the Refresh command on the toolstrip in the Spreadsheet Web Part, or the Refresh Data command on the context menu. Binding can be done programmatically as well. For an update binding, the behavior is the same as described for the Normal enumeration.

BindingLoadMode

Description

Normal (0 )

For a query binding, binding occurs at first load, when the user clicks the Refresh All toolbar button, Refresh command on the toolstrip in the Spreadsheet Web Part, or the Refresh Data command on the context menu in the Spreadsheet component. Binding can be done programmatically as well.

For an update binding, binding occurs every time the user clicks the Update Data command on the toolstrip in the Spreadsheet Web Part, or when using theSave Data command on the context menu. Binding can also occur programmatically

OM (1)

For a query binding, binding does not occur at first load, when the user clicks the Refresh All toolbar button, Refresh command on the toolstrip in the Spreadsheet Web Part, or the Refresh Data command on the context menu in the Spreadsheet component. Binding also does not occur when the Refresh method is called on the Spreadsheet object. Binding only occurs when the Refresh method of the XmlDataBinding object is called.

For an update binding, binding does not occur at first load, when the user clicks the Update Data command on the toolstrip in the Spreadsheet Web Part, or when using the Save Data command on the context menu. Binding only occurs when the Update method of the XmlDataBinding object is called.

Delay (2)

For a query binding, when the user clicks the Refresh All toolbar button, the Refresh command on the toolstrip in the Spreadsheet Web Part, or the Refresh Data command on the context menu. Binding can be done programmatically as well.

For an update binding, the behavior is the same as described for the Normal enumeration.

previous page start next page