c# - 我在C#应用程序中遇到此错误，找不到column2

大家好，我收到此错误“找不到列2”，我想将两个查询合并为一个，以便在数据库中插入数据，这一切都很完美，但是我不知道为什么会收到这种错误，并且我不知道如何解决它请帮我谢谢

Here is my code:

    string sqlCust21 = "SELECT Name,sum(CAST(ubl As int)) FROM payment WHERE dates <= '" + dateTimePicker1.Text + "' Group By union SELECT Name,sum(CAST(ubl As int)) FROM payment WHERE dates > '" + dateTimePicker2.Text + "' Group By Name";
                DataAccess.ExecuteSQL(sqlCust21);
                DataTable dtCust21 = DataAccess.GetDataTable(sqlCust21);
                MessageBox.Show(dtCust21.Rows[0][2].ToString());

最佳答案

您缺少GROUP BY之后的列名称。

string sqlCust21 = "SELECT Name,sum(CAST(ubl As int)) FROM payment WHERE dates <= '" + dateTimePicker1.Text + "'
Group By name  --<-- this
union SELECT Name,sum(CAST(ubl As int)) FROM payment WHERE dates > '" + dateTimePicker2.Text + "' Group By Name";

关于c# - 我在C#应用程序中遇到此错误，找不到column2，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/62836387/