ComponentOne ADO.NET DataExtender
ADO.NET DataExtender Overview / ADO.NET DataExtender Samples
In This Topic
    ADO.NET DataExtender Samples
    In This Topic

    Please be advised that this ComponentOne software tool is accompanied by various sample projects and/or demos, which may make use of other development tools included with the ComponentOne Studio.

    All samples use the standard Microsoft Access sample Northwind database, C1NWind.mdb. Note that the sample projects have the database location hard coded in the connection string:

    Documents\ComponentOne Samples\Common

    If you have the Northwind database installed in a different location, you can change the connection strings, or copy the C1NWind.mdb file to the required location.

    Please refer to the pre-installed product samples through the following path:

    Documents\ComponentOne Samples\WinForm

    Click one of the following links to view a list of ADO.NET DataExtender samples:

    To write code in Visual Basic

    ADO.NET DataExtender includes the following Visual Basic samples:
    Sample Description

    ViewSet_Define_Fill_Update

    Explains the basic functionality of the C1DataViewSet component. Namely, it depicts how to define C1DataViewSet to work against ADO.NET typed DataSet, fill it with data and commit changes made by the user back to the database server. This sample uses the C1DataViewSet component connected to a typed DataSet object with two C1DataView objects joined by a C1ViewRelation object.

    ClientFilterSortFind

    Demonstrates filtering, sorting and searching of C1DataView rows, which are performed on a client. This sample uses the C1DataViewSet component connected to a typed DataSet object with a single C1DataView.

    SchemaExtender

    Demonstrates the usage of ADO.NET typed DataSet with DataSetExtender and explains the usage of constraints defined in an arbitrary .NET programming language (represented by the ConstraintsForm form). This sample uses the C1DataViewSet component connected to a typed DataSet object with a single C1DataView.

    CompositeRowEditing

    Depicts some details of composite rows editing behavior. This sample uses the C1DataViewSet component connected to a typed DataSet object with a single C1DataView.

    UntypedDataSet

    Demonstrates how to use C1DataViewSet in conjunction with untyped ADO.NET DataSet. C1DataViewSet allows the user to show and edit data from untyped DataSet tables according to its C1DataView(s) definitions This sample uses the C1DataViewSet component connected to an untyped DataSet object with a single C1DataView.

    Programmatic

    Demonstrates how to create and use C1DataViewSet in run time programmatically. This sample creates the C1DataViewSet component connected to a typed DataSet object with two C1DataView objects joined by a C1ViewRelation object.

    ColumnStyles_In_FlexGrid

    Demonstrates how to set up column styles, which are honored by the C1FlexGrid control in run time, using an ADO.NET DataSet Extender.

    ColumnStyles_In_TrueDBGrid

    Demonstrates how to set up column styles, which are honored by the C1TrueDBGrid control in run time, using an ADO.NET DataSet Extender.

    To write code in C#

    ADO.NET DataExtender includes the following C# samples:

    Sample Description

    ViewSet_Define_Fill_Update

    Explains the basic functionality of the C1DataViewSet component. Namely, it depicts how to define C1DataViewSet to work against ADO.NET typed DataSet, fill it with data and commit changes made by the user back to the database server. This sample uses the C1DataViewSet component connected to a typed DataSet object with two C1DataView objects joined by a C1ViewRelation object.

    ClientFilterSortFind

    Demonstrates filtering, sorting and searching of C1DataView rows, which are performed on a client. This sample uses the C1DataViewSet component connected to a typed DataSet object with a single C1DataView.

    SchemaExtender

    Demonstrates the usage of ADO.NET typed DataSet with DataSetExtender and explains the usage of constraints defined in an arbitrary .NET programming language (represented by the ConstraintsForm form). This sample uses the C1DataViewSet component connected to a typed DataSet object with a single C1DataView.

    CompositeRowEditing

    Depicts some details of composite rows editing behavior. This sample uses the C1DataViewSet component connected to a typed DataSet object with a single C1DataView.

    UntypedDataSet

    Demonstrates how to use C1DataViewSet in conjunction with untyped ADO.NET DataSet. C1DataViewSet allows the user to show and edit data from untyped DataSet tables according to its C1DataView(s) definitions This sample uses the C1DataViewSet component connected to an untyped DataSet object with a single C1DataView.

    Programmatic

    Demonstrates how to create and use C1DataViewSet in run time programmatically. This sample creates the C1DataViewSet component connected to a typed DataSet object with two C1DataView objects joined by a C1ViewRelation object.

    ColumnStyles_In_FlexGrid

    Demonstrates how to set up column styles, which are honored by the C1FlexGrid control in run time, using an ADO.NET DataSet Extender.

    ColumnStyles_In_TrueDBGrid

    Demonstrates how to set up column styles, which are honored by the C1TrueDBGrid control in run time, using an ADO.NET DataSet Extender.

    See Also