DbVisualizer 9.1.5

DbVisualizer is a database tool for developers and database administrators, helping you with both the development and maintenance of your databases.

Firebird 2.5.2

Firebird is a relational database offering many ANSI SQL standard features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers.

Reitec.PMM 1.2.1.0

Reitec.PMM is a free tool for the management of test equipment as part of quality assurance.

WowBase 1.1

Create your own database quickly and easily.

MyContacts 3.1

Managing contacts, birthdays and dates/tasks.

LibreOffice Rus for Windows 3.6.4

LibreOffice office suite is the best free alternative for Microsoft Office 2003, 2007 and even 2010.

PhpMyAdmin 3.5.3

phpMyAdmin Rus is a program for managing a MySQL database, which you can download and use for free - both at home and in an organization. Russian version.

Oracle MySQL for Linux, UNIX, *BSD and other *nix 5.5.28 Final / 6.0.6 Beta

Oracle MySQL - Famous database server. Famous for its impeccable stability and speed.

Oracle MySQL for Windows 5.5.28 Final / 6.0.6 Beta

MySQL is one of the most popular open source databases and is completely free to download and use.

Let's create a simple database application that displays information from the "Tourists" table and the "Tourist Information" table record from the Microsoft Access database associated with the current record of the "Tourists" table.

To do this, let's create an empty Windows application. Environment appearance

development is shown in Figure 39.

Rice. 39. Blank application

Figure 39 highlights the “Data” component group, which contains components for accessing and manipulating data.

The binding of database data to the form is carried out by the “Binding Source” component. Let's transfer it to the form. After placing it on the form, the development environment takes the following form (Fig. 40).

Rice. 40. Binding Source component on the form

The component is not visual, so it is displayed in an additional panel. The main property of the component is the DataSource property, which points to the data source. By default, the property is empty, so you need to configure its value. When you select this property in the properties window, the following window appears (Fig. 41).

Rice. 41. List of data sources

The list is currently empty, so you need to create a new data source by selecting the Add Project Data Source command to create a new data source and connect to it. The following dialog box appears (Fig. 42).

Rice. 42. List of data sources

This dialog provides the following choice of data sources:

Database - Database;

Service - A service is some service that provides data. Most often this is a Web service;

Object - Object for selecting an object that will generate data and objects to work with it.

In our case, you need to select the “Database” item. A window for selecting a data connection appears (Fig. 43).

Rice. 43. Selecting a data connection

The purpose of this dialog is to create a connection string that will describe the connection parameters for the ADO engine, such as the database type, its location, user names, security features, etc.

The dialog drop-down list contains all previously created connections. If the required connection is not in the list, then you should use the “New connection” button. Pressing the button causes the following dialog to appear (Fig. 44).

In this dialog, you select the data source type (in this case, Microsoft Access), the database name (in this case, the name and location of the database file), and the username and password used to connect to the database. The "Advanced" button allows you to set a large number of parameters related to various parts of the ADO engine. Using the “Test Connection” button will ensure that the entered parameters are correct and the connection is working.

Rice. 44. Creating a new connection

The last step of the dialogue is to select those tables or other database objects that are needed in this data source. The selection window is shown in Figure 45.

Rice. 45. Selecting the necessary tables

In this window, the “Tourists” and “Tourist Information” tables are selected. Since no objects other than tables were created in the database, only tables are displayed in Figure 45. This completes the creation of the data source. After clicking the “Finish” button, a DataSet component appears next to the BindingSource component on the form.

Now the data connected above needs to be displayed on the form. The simplest way to display data is to use the DataGridView component from the Data component group. The component is visual and looks like this on the form (Fig. 46).

Rice. 46. ​​DataGridView Component

The component settings window immediately appears, which determines its data editing capabilities: “Enable Adding”, “Enable Editing”, “Enable Deleting”; the ability to change the sequence of columns: “Enable the ability to change the order of columns” (“Enable Column Reordering”); as well as the ability to be attached to the parent container.

In order for the component to display data, you must select a data source in the drop-down list. Selecting the drop-down list causes the following dialog to appear (Fig. 47).

Rice. 47. Selecting a data source for DataGridView

In this case, we chose the “Tourists” table as the data source. This selection changes the screen form as follows (Fig. 48).

Rice. 48. The DataGridView component displays the table structure

The figure shows that another BindingSource component has appeared and a TableAdapter component that works with the “Tourists” table. Please note that in design-time or during the development process, the data from the table is not displayed.

Now you need to display the data from the linked table “Tourist Information”. To do this, place another DataGridView component on the form and select the following as a data source (Fig. 49).

Rice. 49. Selecting a data source for the second DataGridView

Here, the data source is not the “Tourist Information” table itself, but the connection (Binding Source) between the “Tourists” and “Tourist Information” tables. This selection ensures that only those rows from the Tourist Information table that are associated with the current row in the Tourists table are selected. This choice also ensures that associated data is updated and deleted correctly. The operation of the resulting application is shown in Figure 50.

Rice. 50. Database application at work

Navigating through data using the arrow keys is awkward. To simplify data navigation, there is a BindingNavigator component. Let's place it on the form (Fig. 51).

Rice. 51. BindingNavigator component on the form

This component allows you to navigate between table records, add and delete table rows. The functionality and appearance of the component can be customized because it is a ToolStripContainer menu strip.

The property that determines the table through which navigation is performed is the BindingSource property. Let's set the value of this property to "touristsBindingSource". In operation, the component looks like this (Fig. 52).

Rice. 52. BindingNavigator component at work

Editing data in the cells of the DataGridView component with appropriate settings is possible, but it is inconvenient and not rational. In particular, it is difficult to check entered values ​​for errors. Therefore, for the “Tourists” table we will make a screen form that allows you to display data in TextBox components and edit them. To do this, place a container of the Panel type on the form, and on it three TextBox components as follows (Fig. 53).

Rice. 53. Screen panel for editing entries in the “Tourists” table

Now you need to bind the TextBox components to the corresponding fields of the “Tourists” table. To do this, we use the property from the DataBindings - Advanced group, shown in Figure 54.

Rice. 54. Property “DataBindings - Advanced”

Selecting this property leads to the appearance of the dialog shown in Figure 55. This dialog allows you not only to bind data, but also to set an event within which the data will be updated, as well as formatting the data when outputting it.

For the top TextBox component, in the Binding drop-down list, select “touristsBmdmgSource” as the data source and the source field as “Last Name”. For the middle and bottom TextBox components, select the same data source and the “Name” and “Patronymic” fields, respectively.

The developed application in operation looks like this (Fig. 56).

Rice. 55. Dialog window for the “DataBindings - Advanced” property

Rice. 56. Data binding to visual components

However, when changes are made, all new data remains only on the form. They are not saved in the database, and when the application is called again, of course, they will be missing. This occurs because the data was loaded into a DataSet object, which is an in-memory copy of the table. All actions are performed with this copy. In order for changes to be reflected in the database, you must execute the Update method of the TableAdapter class. Thus, in the application being developed, it is necessary to place the “Update” button and write the following program code in the Click event handler:

touristsTableAdapterUpdate(bDTur_firmDataSet); information_about_touristsTableAdapter.Update(bDTur_firmDataSet);

This code updates information in the Tourists and Tourist Information tables provided by the data source. Note that this method is overloaded, and its variants allow you to update both an individual table row and a group of rows.

EMS Database Management Solutions offers a comprehensive suite of free database management software, which will allow you to increase the productivity of working with data and the efficiency of database administration. These free database management programs can help you solve most administrative tasks by providing essential functionality for database and data application developers without having to rely on multiple, multi-faceted SQL utilities.

EMS SQL Manager Freeware is suitable for both beginners and experienced developers; it will make it easy to control the data infrastructure thanks to the availability of all the necessary tools for organizing the effective functioning of database systems. Our free tools give you the power to perform server administration and database development, manage users and security, view and edit data, and more, all from one powerful application with an intuitive GUI.

Using EMS SQL Manager Freeware, you can work with servers, databases and schemas, view, edit, search, group, sort and filter data, create and run SQL queries using a powerful SQL editor, work with multiple selected objects simultaneously and much more .

We offer a wide range of free database administration programs for the most popular servers. EMS SQL Manager Freeware supports all server, database and table objects, as well as the latest server versions and related RDBMS functionality.