winform数据库控件

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

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

        public MainForm()
        {
            InitializeComponent();

            // 初始化数据库连接
            connection = new SqlConnection("Server=your_server_address;Database=your_database_name;User Id=your_username;Password=your_password;");

            // 初始化数据适配器
            adapter = new SqlDataAdapter("SELECT * FROM your_table_name", connection);

            // 初始化数据表
            dataTable = new DataTable();
            adapter.Fill(dataTable);

            // 绑定数据到DataGridView控件
            dataGridView.DataSource = dataTable;
        }

        private void MainForm_Load(object sender, EventArgs e)
        {
            // 加载数据
            LoadData();
        }

        private void LoadData()
        {
            try
            {
                connection.Open();
                adapter.Fill(dataTable);
            }
            catch (Exception ex)
            {
                MessageBox.Show("加载数据失败：" + ex.Message);
            }
            finally
            {
                connection.Close();
            }
        }
    }
}