向同一Datagrid c# WPF添加多个SQL查询

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

namespace WpfApp
{
    public partial class MainWindow : Window
    {
        private SqlConnection connection;
        private SqlDataAdapter adapter;
        private DataTable dataTable;

        public MainWindow()
        {
            InitializeComponent();
            InitializeDatabaseConnection();
            ExecuteSQLQueries();
        }

        private void InitializeDatabaseConnection()
        {
            string connectionString = "YourConnectionString"; // 替换为实际的数据库连接字符串
            connection = new SqlConnection(connectionString);
        }

        private void ExecuteSQLQueries()
        {
            try
            {
                connection.Open();

                // 第一个SQL查询
                string query1 = "SELECT * FROM Table1";
                adapter = new SqlDataAdapter(query1, connection);
                dataTable = new DataTable();
                adapter.Fill(dataTable);
                datagrid.ItemsSource = dataTable.DefaultView;

                // 第二个SQL查询
                string query2 = "SELECT * FROM Table2";
                adapter = new SqlDataAdapter(query2, connection);
                dataTable = new DataTable();
                adapter.Fill(dataTable);
                datagrid2.ItemsSource = dataTable.DefaultView;

                // 可以继续添加更多的SQL查询和Datagrid控件

                connection.Close();
            }
            catch (SqlException ex)
            {
                MessageBox.Show("数据库连接错误：" + ex.Message);
            }
        }
    }
}