|
In Visual Studio .NET, when you drag certain database objects from the SQL Anywhere Explorer and drop them onto Visual Studio .NET designers, the IDE automatically creates new components that reference the selected objects. You can configure the settings for drag and drop operations by choosing Tools > Options in Visual Studio .NET.
For example, if you drag a stored procedure from the SQL Anywhere Explorer onto a Windows form, the IDE automatically creates a Command object preconfigured to call that stored procedure.
The following table lists the objects you can drag from the SQL Anywhere Explorer, and describes the components created when you drop them onto a Visual Studio .NET Forms Designer or Code Editor.
| Item | Result |
|---|---|
| Data connection | Creates a data connection. |
| Table | Creates an adapter. |
| View | Creates an adapter. |
| Stored procedure or function | Creates a command. |
Open the form or class that you want to add a data component to.
In the SQL Anywhere Explorer, select the object you want to use.
Drag the object from the SQL Anywhere Explorer to the Forms Designer or Code Editor.