Sample Visual Basic Code for the SCIROCCO ADO Data Control 1.0

There is a sample Visual Basic Project copied to the installation folder (Download Sample). After setup you might need to drop the control on the form and rename it.

If you have any questions or need help using the control please contact . It will be our pleasure to assist you.

5 Easy Steps to follow to connect to the Authors TABLE (AuthorID, AuthorName) with a valid ConnectionString:

1) Add the SCIROCCOADOTool Component to your project.

2) Drop the control onto your form, SCIROCCOADODataControl1 View screenshot

3) Create 2 text boxes, txtAuthorID, txtAuthorName.

4) In the Load event of your form add this code:

SCIROCCOADODataControl1.OpenRecordset "SELECT AuthorID, AuthorName FROM Authors", Connection.ConnectionString
Set txtAuthorID.DataSource = SCIROCCOADODataControl1.Recordset
txtAuthorID.DataField = "AuthorID"
Set txtAuthorName.DataSource = SCIROCCOADODataControl1.Recordset
txtAuthorName.DataField = "AuthorName"

5) Enjoy the fruits of your labor. Now you can Navigate, Add New, Delete, Refresh, Search, Undo and Save Changes to the TABLE.