winform显示数据库数据

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

namespace WinFormsDatabaseDemo
{
    public partial class MainForm : Form
    {
        private SqlConnection connection;
        private SqlDataAdapter adapter;
        private DataTable dataTable;

        public MainForm()
        {
            InitializeComponent();

            // 初始化数据库连接
            connection = new SqlConnection("Server=your_server;Database=your_database;User Id=your_username;Password=your_password;");
            adapter = new SqlDataAdapter("SELECT * FROM your_table", connection);
            dataTable = new DataTable();
        }

        private void MainForm_Load(object sender, EventArgs e)
        {
            try
            {
                // 打开数据库连接并填充数据表
                connection.Open();
                adapter.Fill(dataTable);

                // 将数据表绑定到DataGridView控件
                dataGridView.DataSource = dataTable;
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error: " + ex.Message);
            }
            finally
            {
                // 关闭数据库连接
                connection.Close();
            }
        }
    }
}