Adding buttons to a DataWindow object

Buttons make it easy to provide command button actions in a DataWindow object. No coding is required. The use of Button controls in the DataWindow object, ensures that actions appropriate to the DataWindow object are included in the object itself.

The Button control is a command or picture button that can be placed in a DataWindow object. When clicked at runtime, the button activates either a built-in or user-supplied action.

For example, you can place a button in a report and specify that clicking it opens the Filter dialog box, where users can specify a filter to be applied to the currently retrieved data.

To add a button to a DataWindow object:

Select Button from the DataWindow Painter section of the Visual Studio toolbox.

Click where you want the button to display.

You may find it useful to put a Delete button or an Insert button in the detail band. Clicking a Delete button in the detail band will delete the row next to the button clicked. Clicking an Insert button in the detail band will insert a row following the current row.

Be careful when putting buttons in the detail band Buttons in the detail band repeat for every row of data, which is not always desirable. Buttons in the detail band are not visible during retrieval, so a Cancel button in the detail band would be unavailable when needed.

With the button still selected, type the text to display on the button in the Properties window.

Select the action you want to assign to the button from the Action drop-down list.

For information about actions, see “Actions assignable to buttons in DataWindow objects”.

If you want to add a picture to the button, set the DefaultPicture property to True or enter the name of the Picture file to display on the button in the FileName field.

If you want to suppress event processing when the button is clicked at runtime, set SuppressEventProcessing to True.

When this option has been selected for the button and the button is clicked at runtime, only the action assigned to the button and the Clicked event are executed. The ButtonClicking and the ButtonClicked events are not triggered.

What happens if Suppress Event Processing is off

If Suppress Event Processing is off and the button is clicked, the Clicked and ButtonClicking events are fired. Code in the ButtonClicking event (if any) is executed. Note that the Clicked event is executed before the ButtonClicking event.

If the return code from the ButtonClicking event is 0, the action assigned to the button is executed and then the ButtonClicked event is executed.

If the return code from the ButtonClicking event is 1, neither the action assigned to the button nor the ButtonClicked event are executed.