Delphi dialog box for starting Database Connection Properties

Delphi dialog box for starting Database Connection Properties

When writing a program, we often need to dynamically configure the database. If we can directly call the database connection window of the system, this is the most convenient. We can see that other programs are like this, after checking, we found that the following methods can be used for implementation.

The following uses ADO as an example.

The key part is a line of code.

Connectionstr: = promptdatasource (application. Handle, adoconnection. connectionstring );

This function returns a value of the string type. we store it in the connectionstr string variable. The value of this variable is

The last value of connectionstring. With this value, you can dynamically configure the database.

See

 

 

 

(7-25 plus) supplement: if you use the specified user name and password to log on, do not forget to mark the allowed password. You can take this

Put the connection string in the file or store it in the registry, so that you can connect directly next time.