c# - 查询抛出 "IndexOutOfRange"

Question

我觉得这很奇怪，我有这段代码:

string getBatchesQuery = "SELECT DISTINCT CONVERT(VARCHAR(8), time, 4) AS Batch FROM Calls ORDER BY Batch";
SqlCommand getBatchesQueryCom = new SqlCommand(getBatchesQuery, connection);

SqlDataReader getBatchesQueryReader = myCom.ExecuteReader();

List<string> allBatches = new List<string>();

while (getBatchesQueryReader.Read())
{

    allBatches.Add(getBatchesQueryReader["Batch"].ToString());

}
getBatchesQueryReader.Close();

Batch 怎么可能不存在呢？也许是因为我这样命名它？

我该怎么办？

Answer 1

该列不存在，因为您运行了错误的命令。将 myCom 更改为 getBatchesQueryCom。

SqlDataReader getBatchesQueryReader = getBatchesQueryCom.ExecuteReader();