Configuring a SQL Data Source

The Microsoft SqlDataSource tool allows the Data Source wizard to be invoked enabling the user to add a K2 SQL data source to a Microsoft Visual Studio project.

To invoke the Data Source wizard drag the SqlDataSource tool onto the design canvas and click on Configure Data Source.

Wizard Steps	What it does
Choose your Data Connection	Allows the user to select the data source and configure the connection settings
Save the Connection String to the Application Configuration File	Allows the user to save the connection string in the application configuration file or in the page as a property of the data source control
Configure the Select Statement	Determines how the data will be retrieved from the selected database
Define Custom Statements or Stored Procedures	Allows the user to write a SQL statement or select a stored procedure
Define Parameters	Allows each SmartObject property's input parameters to be configured
Test Query	Displays a preview of the data returned by the data source