Using the ADO.NET Provider in Visual Studio

This section explains how you can use the SmartObjects ADO.NET provider as a Data Source (SQLDatasource or ObjectDataSource) in a Visual Studio Project.

The following is covered in this section.

Designing a Form	K2 allows ASP.NET and Windows Forms to be created using a SQL data source that exposes all the SmartObject properties and methods.
Setting up a K2 DataSource	Creating a K2 DataSource enables the developer to access SmartObjects properties and methods when building Forms.
SqlDataSource	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.
ObjectDataSource	Creating an Object Data Source that utilizes the K2 Data Provider will expose SmartObjects and allow the data to be manipulated using SQL statements or stored procedures to return specific data.
Configure Form layout	Forms incorporating the K2 data provider allows business users to model capture and list views using the SmartObject properties and methods.
Toolbox	Certain controls in the Toolbox allows the user to select a configured K2 data source when dragged onto the design canvas.
Control Tasks	The control tasks enable the developer to select the K2 data source and configure the Form's look and feel to meet the business requirements.