在Datagrid WPF中显示SQL结果

using System.Data.SqlClient;
using System.Windows;
using System.Windows.Controls;

namespace WpfApp
{
    public partial class MainWindow : Window
    {
        public MainWindow()
        {
            InitializeComponent();
            LoadData();
        }

        private void LoadData()
        {
            string connectionString = "Your SQL connection string";
            string query = "SELECT * FROM YourTable";

            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                SqlCommand command = new SqlCommand(query, connection);
                connection.Open();

                SqlDataReader reader = command.ExecuteReader();

                // Create a DataTable to hold the data
                System.Data.DataTable dataTable = new System.Data.DataTable();
                dataTable.Load(reader);

                // Bind the DataTable to the DataGrid
                dataGrid.ItemsSource = dataTable.DefaultView;

                reader.Close();
            }
        }
    }
}