How to connect WinForms to a database?

2 years ago
Olivia Parker
2 minutes

One common method of connecting to a database in a WinForms application is using ADO.NET. ADO.NET is a framework for accessing data that provides a set of classes and methods to connect to and manipulate databases.

Here are the general steps for connecting to a database using ADO.NET:

  1. Include the necessary namespaces:
    At the beginning of the code file, add the following namespaces:
using System.Data.SqlClient; // 如果使用SQL Server数据库
  1. Creating a connection string: The connection string provides the necessary information to connect to a database, such as the database server’s address, username, password, etc. The connection string can be specified directly in the code or stored in the application’s configuration file. Example:
string connectionString = "Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password";
  1. Create a connection object:
    Using a connection string, create a database connection object.
SqlConnection connection = new SqlConnection(connectionString);
  1. Open the connection:
    Open the database connection:
connection.Open();
  1. Performing database operations:
    You can use the SqlCommand object to execute SQL queries, insertions, updates, and other operations. For example, executing a query and reading the results:
string sqlQuery = "SELECT * FROM TableName";
SqlCommand command = new SqlCommand(sqlQuery, connection);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
    // 处理查询结果
}
reader.Close();
  1. Close the connection:
    It is necessary to close the database connection when it is no longer needed.
connection.Close();

Please note that the code examples above are for reference only, and there may be some differences in actual application depending on the type of database used and the requirements of the application.

bannerAds