Setting up a K2 Data Source
Creating a K2 DataSource enables the developer to access SmartObjects properties and methods when building Forms.
Data sources are configured in Microsoft Visual Studio by creating an ASP.NET Web site or Windows application project.
In this help file reference will be made to creating a data source in an ASP.NET Web site project. The principles of adding a data source will be similar in a Windows Application project.
In Microsoft Visual Studio 2010 the Data Source Wizard is used to specify one or more data sources for Microsoft SQL Server 2005. There are two data source wizards that can be configured, namely:
The wizards are accessed either:
- in the Visual Studio toolbox, data section, SqlDataSource or ObjectDataSource,
- or by dragging a tool onto the design canvas and selecting "<New Data Source>" from the Choose a Data Source drop-down list.
| Feature | What it is |
|---|---|
| Pointer | Selects the mouse pointer |
| AccessDataSource | Opens the Data Source wizard enabling the configuration of a data source from an Access database |
| Chart | Displays data in chart format |
| DataList | Displays data in rows only |
| DataPager | http://msdn.microsoft.com/query/dev10.query?appId=Dev10IDEF1&l=EN-US&k=k(MSDNSTART)&rd=true |
| DetailsView | Displays the details of one set of data at a time |
| EntityDataSource | http://msdn.microsoft.com/query/dev10.query?appId=Dev10IDEF1&l=EN-US&k=k(MSDNSTART)&rd=true |
| FormView | Displays a single record from a data source in a table |
| GridView | Displays data in grid view with columns and rows |
| LinqDataSource | http://msdn.microsoft.com/query/dev10.query?appId=Dev10IDEF1&l=EN-US&k=k(MSDNSTART)&rd=true |
| ListView | Provides the option for data editing, insertion, deleting, paging and sorting |
| ObjectDataSource | Opens the Data Source wizard enabling the configuration of a business object that can be used as a Data Source |
| QueryExtender | http://msdn.microsoft.com/query/dev10.query?appId=Dev10IDEF1&l=EN-US&k=k(MSDNSTART)&rd=true |
| Repeater | http://msdn.microsoft.com/query/dev10.query?appId=Dev10IDEF1&l=EN-US&k=k(MSDNSTART)&rd=true |
| SiteMapDataSource | Provides a data source control that Web Server controls and other controls can use to bind to a hierarchical site data map |
| SqlDataSource | Opens the Data Source wizard enabling the configuration of a Sql Data Source |
| XmlDataSource | Opens the Data Source wizard enabling the configuration of an XML data file as a data source |
| ReportViewer | Allows the creation of reports using data sources |
Items in the Data section of the Toolbox can be added to the design canvas by dragging the items onto the design canvas.