winform显示数据库

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

public class MainForm : Form
{
    private DataGridView dataGridView;
    private SqlConnection connection;

    public MainForm()
    {
        InitializeComponent();
        LoadData();
    }

    private void InitializeComponent()
    {
        this.dataGridView = new DataGridView();
        this.SuspendLayout();
        // 
        // dataGridView
        // 
        this.dataGridView.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.AutoSize;
        this.dataGridView.Location = new System.Drawing.Point(10, 10);
        this.dataGridView.Name = "dataGridView";
        this.dataGridView.Size = new System.Drawing.Size(400, 250);
        this.dataGridView.TabIndex = 0;
        // 
        // MainForm
        // 
        this.ClientSize = new System.Drawing.Size(420, 270);
        this.Controls.Add(this.dataGridView);
        this.Name = "MainForm";
        this.Text = "WinForms显示数据库";
        this.ResumeLayout(false);
    }

    private void LoadData()
    {
        string connectionString = "Server=your_server;Database=your_database;User Id=your_user;Password=your_password;";
        connection = new SqlConnection(connectionString);

        try
        {
            connection.Open();
            string query = "SELECT * FROM your_table";
            SqlCommand command = new SqlCommand(query, connection);
            SqlDataAdapter adapter = new SqlDataAdapter(command);
            DataTable dataTable = new DataTable();
            adapter.Fill(dataTable);
            dataGridView.DataSource = dataTable;
        }
        catch (Exception ex)
        {
            MessageBox.Show("连接数据库失败: " + ex.Message);
        }
        finally
        {
            connection.Close();
        }
    }

    [STAThread]
    static void Main()
    {
        Application.EnableVisualStyles();
        Application.SetCompatibleTextRenderingDefault(false);
        Application.Run(new MainForm());
    }
}