一个datagridview中两个SQL表的比较

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

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

        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            // 连接数据库
            string connectionString = "Data Source=YourServer;Initial Catalog=YourDatabase;User ID=YourUsername;Password=YourPassword";
            connection = new SqlConnection(connectionString);
            connection.Open();

            // 查询数据
            string queryA = "SELECT * FROM TableA";
            string queryB = "SELECT * FROM TableB";
            SqlDataAdapter adapterA = new SqlDataAdapter(queryA, connection);
            SqlDataAdapter adapterB = new SqlDataAdapter(queryB, connection);
            DataTable tableA = new DataTable();
            DataTable tableB = new DataTable();
            adapterA.Fill(tableA);
            adapterB.Fill(tableB);

            // 比较数据
            CompareTables(tableA, tableB);

            // 显示比较结果
            dataGridView.DataSource = tableA;
        }

        private void CompareTables(DataTable tableA, DataTable tableB)
        {
            // 比较逻辑，可以根据具体需求自行实现
            // 以下示例比较了两个表中的每一行数据是否相等
            for (int i = 0; i < tableA.Rows.Count; i++)
            {
                DataRow rowA = tableA.Rows[i];
                DataRow rowB = tableB.Rows[i];

                bool isEqual = true;
                for (int j = 0; j < tableA.Columns.Count; j++)
                {
                    if (!rowA[j].Equals(rowB[j]))
                    {
                        isEqual = false;
                        break;
                    }
                }

                if (!isEqual)
                {
                    // 标记不相等的行
                    rowA["ComparisonResult"] = "Not Equal";
                }
                else
                {
                    rowA["ComparisonResult"] = "Equal";
                }
            }
        }
    }
}