Windows窗体从数据库获取数据并在标签中显示

using System;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;

namespace WindowsFormsApp
{
    public partial class MainForm : Form
    {
        private const string connectionString = "Data Source=YourServer;Initial Catalog=YourDatabase;User ID=YourUsername;Password=YourPassword";

        public MainForm()
        {
            InitializeComponent();
        }

        private void MainForm_Load(object sender, EventArgs e)
        {
            // 连接数据库
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                connection.Open();

                // 查询数据
                string query = "SELECT Name FROM YourTable";
                SqlCommand command = new SqlCommand(query, connection);
                SqlDataReader reader = command.ExecuteReader();

                // 在标签中显示数据
                while (reader.Read())
                {
                    string name = reader.GetString(0);
                    label1.Text += name + Environment.NewLine;
                }

                reader.Close();
            }
        }
    }
}