|
Development of desktop applications and access to data with Visual BASIC 2005
|
Introduction and presentation of the course.
- Objectives.
- Reauisitos.
- Like following the course.
- Content.
|
Módulo1. To create applications
desktop I.
- To create a project of type desktop application.
- Like adding forms to a project.
- The form from the point of view of the direction to objects.
- Properties of the forms.
- Like choosing the beginning form.
- Main events of the forms.
- Final Exercise. |
Module 2. To create applications
desktop II.
- Like adding controls to a form.
- To adapt the controls within the form.
- To position and to determine the proportions.
- To align.
- Anchor and Dock.
- To establish the tabulation order.
- To respond to the events emitted by the controls.
- To connect manifolds events to a unique manager of events.
- Final Exercise.
|
Module 3. To create applications
desktop III.
- To connect managers of events in run time.
- To show forms in form Modal and NoModal.
- To add controls in run time.
- Crar keys of access for controls.
- Events related to keyboard entrances.
- Final Exercise.
|
Module 4. To use controls standard I.
- The most elementary controls (TextBox, Label, Button).
- Ready basic (ListBox, ComboBox, CheckedListBox).
- Boolean Controls (CheckBox, RadioButton).
- Other lists (NumericUpDown, TreeView, ListView).
- Final Exercise.
|
Module 5. To use controls standard II.
- Panel and GroupBox.
- SplitContainer.
- TabControl.
- ToolStrip and StatusStrip.
- PictureBox.
- ImageList.
- MonthCalendar.
- WebBrowser.
- Final Exercise.
|
Module 6. To create menus.
-What is a system of menus?
- Introduction to the MenuStrip control.
- To add improvements to a ToolStripMenuItem.
- To hide and to deactivate ToolStripMenuItems.
- To respond to menu events.
- To create menus of context with the ContextMenuStrip component.
- Final Exercise.
|
Module 7. The dialog pictures.
- Description of the dialog pictures.
- OpenFileDialog.
- SaveFileDialog.
- ColorDialgo.
- FontDialog.
- FolderBrowserDialgo.
- Final Exercise.
|
Module 8. The inheritance between forms.
- Utility of the inheritance between forms.
- To create a form bases.
- To inherit of a form bases.
- To modify the form bases.
- Sobreescribir events of the form bases.
- Final Exercise.
|
Module 9. Introduction to the access to data.
- The necessity to store data.
- Introduction to the relational databases.
- Description of language SQL.
- The suppliers of data bases.
- Description of ADO.NET.
- Connected Scenes and disconnected scenes.
- Final Exercise. |
Module 10. To connect to a data base.
-What is the connection chain?
- As to connect to a data base.
- Like creating an object. Instruction NEW.
- As to disconnect of a data base.
- Like managing the connection events.
- Final Exercise.
|
Module 11. Operations in a connected scene I
- As to send a commando to a data base.
- The types of answer to a commando.
- Scalar Commandos.
- Commandos who give back a set of results. The DataReader.
- Like iterar through a DataReader.
- Final Exercise.
|
Module 12. Operations in a connected scene II.
- Introduction to Microsoft SQL Server 2005 Express.
- The modification of the data.
- The parametrizados commandos.
- The reference to bookstores.
- As to execute procedures stored in the data base.
- Final Exercise.
|
Module 13. Operations in a disconnected scene I.
-What is a DataSet?
- To create DataSets programmatic.
- To create DataSets with the designer.
- To define restrictions and relations in a DataSet.
- Final Exercise.
|
Module 14. Operations in a disconnected scene II.
- Like adding registries to a DataSet.
- Like modifying registries of a DataSet.
- Like eliminating registries of a DataSet.
- Like iterar through the registries of a DataTable.
- Iterar through related registries.
- To look for registries in a DataTable.
- Final Exercise.
|
Module 15. Operations in a disconnected scene III.
-What is a DataAdapter?
- To create DataAdapters programmatic.
- Like loading data in a DataSet using a DataAdapter.
- To keep and to load DataSets in the local disc.
- Final Exercise.
|
Module 16. Operations in a disconnected scene IV.
- To create DataAdapters with the designer.
- The state of the rows.
- Like updating in the origin the changes realized in a DataSet.
- To personalize the update of the changes.
- Final Exercise.
|
Module 17. Operations in a disconnected scene V.
- The problem of the concurrence.
- The version of the rows.
- Optimistic Concurrence.
- Pessimistic Concurrence.
- Forms to manage the concurrence conflicts.
- Final Exercise.
|
Module 18. Operations in a disconnected scene I SAW.
-What is a typified DataSet?
-What is a scheme XSD?
- To create DataSets typified being based on a DataAdapter.
- The tool Data Sources de Visual Studio 2005.
- Like using a typified DataSet.
- Final Exercise.
|
Module 19. Operations in a disconnected scene VII.
-What is a TableAdapter?
- As they are created the TableAdapters.
- Like using a TableAdapter.
- To use parámetors in a TableAdapter.
- To keep chains from connection outside the code.
- Final Exercise.
|
Module 20. To show and to publish data through forms I.
- Forms to manage data from a form.
- The BindingSource control.
- To connect simple controls to a DataTable.
- To connect simple controls in run time.
- The BindingNavigator control.
- To use herramientta DataSource to create forms of a single registry.
- Final Exercise.
|
Module 21. To show and to publish data through forms II.
- To use the ComboBox as control of simple connection.
- The DataGridView control.
- To personalize the appearance of the cells.
- The CellFormating event of the DataGridView.
- Teacher-Detail Relation between two DataGridViews.
- Final Exercise.
|
Module 22. The transactions.
- Definition of transaction.
- Forms to negotiate the transaction.
- To negotiate the transaction from ADO.NET
|
Module 23. To unfold desktop applications I.
- Assembled Advantages to distribute the code in.
- Dedicated Bookstores and global bookstores.
- The Global Assembly Cache.
-What is a compilation strong?
- The GacUtil tool.
- Final Exercise.
|
Module 24. To unfold desktop applications II.
- The Setup Wizard.
-What is a Setup project?
- Like generating a Setup project.
- To register bookstores in the Global Assembly Cache during the installation.
- To install an application using a Setup project.
- Desinstalar an application.
- Final Exercise.
|
|
