今天遇到一個很奇怪的問題,如下:
There is already an open DataReader associated with this Connection which must be closed first.
描述: 在執行目前 Web 要求的過程中發生未處理的例外情形。請檢閱堆疊追蹤以取得錯誤的詳細資訊,以及在程式碼中產生的位置。
例外詳細資訊: MySql.Data.MySqlClient.MySqlException: There is already an open DataReader associated with this Connection which must be closed first.
原來是SQL語句中用別名欄位作群組及排序造成的