winform附加数据库

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

namespace WinFormDatabaseExample
{
    public partial class Form1 : Form
    {
        private SqlConnection connection;

        public Form1()
        {
            InitializeComponent();
            AttachDatabase();
        }

        private void AttachDatabase()
        {
            string connectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\path\to\your\database.mdf;Integrated Security=True";
            try
            {
                connection = new SqlConnection(connectionString);
                connection.Open();
                MessageBox.Show("Database attached successfully!");
            }
            catch (Exception ex)
            {
                MessageBox.Show("Failed to attach database: " + ex.Message);
            }
        }

        private void button1_Click(object sender, EventArgs e)
        {
            string query = "SELECT * FROM YourTable";
            try
            {
                SqlCommand command = new SqlCommand(query, connection);
                SqlDataReader reader = command.ExecuteReader();
                while (reader.Read())
                {
                    // Process data
                    MessageBox.Show(reader["ColumnName"].ToString());
                }
                reader.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Failed to execute query: " + ex.Message);
            }
        }
    }
}