Following sample projects accompany dotConnect Universal and provide a good bootstrap to start working with it. They are located inside dotConnect Universal\Samples folder.
Sample | Description |
---|---|
Bin | Not a sample. This folder contains compiled binaries for all samples so you can launch the executables outside an IDE. |
Common | Not a sample. This folder includes common files for all the samples. |
Crystal | This sample project demonstrates using dotConnect Universal for generating reports with Crystal Reports. Be aware that this project requires Crystal Reports, which is no longer included with Visual Studio 2010 and higher. You have to download and install Crystal Reports separately: http://scn.sap.com/docs/DOC-7824 . Then update references to the CrystalDecisions.* assemblies and rebuild the solution. |
DataReader | This sample project demonstrates using UniDataReader class to obtain data from a query. The sample executes SQL statement at the UniCommand and gets UniDataReader to retrieve data. |
DataSet | This sample project demonstrates using untyped dataset with dotConnect Universal to review and update data. The sample uses UniDataAdapter to fill a dataset and post updated data to a database. UniDataAdapter uses UniCommandBuilder class to automatically generate SQL for INSERT/UPDATE/DELETE operations. |
MasterDetail | This sample project demonstrates setting master-detail relation at the untyped dataset. The sample fills two tables at dataset using UniDataAdapter and sets master-detail relation between them. |
Pictures | This sample project demonstrates using dotConnect Universal for working with graphics. The sample demonstrates how to retrieve binary data from a database and display it at the monitor, load and save pictures into the file and database. |
Table | This sample project demonstrates data mapping from tables. The sample sets CommandType property of UniCommand to TableDirect to access data from the table. |
Web | This sample project demonstrates how to work with dotConnect Universal data provider in ASP .NET application. Installation automatically creates IIS virtual directory. If for some reasons the directory was not created automatically, you should create it manually using Virtual Directory Creation Wizard of IIS Manager. |
Note: Before running sample projects you need to execute commands from Program Files\Devart\dotConnect\Universal\Samples\tables.sql to create test data.