WinForms Database Connection: Step-by-Step

To connect to a database, you can utilize the ADO.NET library provided by .NET. Here is one way to establish a connection to the database:

1. First, make sure you have installed and referenced the appropriate database driver. For example, if you are connecting to a SQL Server database, you need to reference System.Data.SqlClient.
2. Open the code file of your Form in your WinForms application.
3. Add the following namespace reference at the beginning of the code file:

using System.Data.SqlClient; // 如果连接到SQL Server数据库

1. In the event handler where you want to establish a database connection, create a SqlConnection object and set the connection string. The connection string specifies the location of the database and login credentials. For example:

string connectionString = "Data Source=your_server;Initial Catalog=your_database;User ID=your_username;Password=your_password;";
SqlConnection connection = new SqlConnection(connectionString);

1. Open the database connection.

connection.Open();

You have now successfully connected to the database. You can now perform various database operations such as inserting, updating, deleting, and querying data. After completing all operations, remember to close the database connection.

connection.Close();

This is an example of connecting to a SQL Server database. If you want to connect to a different type of database, such as MySQL or Oracle, you will need to use the appropriate driver provided by that database and modify the connection string accordingly.

I hope this is helpful to you!