winforms - 没有为一个或多个必需参数指定值。在使用 (OleDbDataReader rdrGLAcounts = cmdGLAcounts.ExecuteReader())
问题描述
string sql = @"SELECT tblglaccounts.glaccountid as id,tblglaccounts.account as glaccount,
rtrim(tblglaccounts.accountname) as glaccountname, credit.tblgltransactions FROM
tblglaccounts INNER JOIN tblgltransactions ON tblglaccounts.glaccountid = tblgltransactions.gltransactionid
where glaccountstatus = 'True'"+" order by tblglaccounts.account";
解决方案
推荐阅读
- string - bash中的十六进制到ASCII
- nullpointerexception - FragmentActivity.onBackPressed() 上的 NullPointerException
- javascript - OpenLayers 添加功能来添加和删除覆盖?
- javascript - 超过最大堆栈深度
- python - 如何在csv的下一行中制作单词
- javascript - 如何使用 Nodejs 导入数学模块?
- excel - 嵌套的 IF 语句查询,可能与括号有关
- javascript - Metro bundler - 日志/详细
- postgresql - 使用前一个 DO 子句中的变量
- c++ - memcpy'ing std::string in C++