急急 ASP.NET连10G ORA-01008: 并非所有变量都已关联

[anyqu]

private const string SQL_SELECT_UNDER = "SELECT CID, FCID,QYQC, QYDM,QYLB, PXH, QYJC, LXR, GDDH, YDDH, BZ,F FROM INF_CompanyInfo WHERE CID=:CID OR FCID=:FCID and F='0' ORDER BY FCID,PXH";

public List<CompanyInfo> GetUnderCompanys(string CID)
{
OleDbParameter[] parm = new OleDbParameter[]{
new OleDbParameter(":CID", OleDbType.VarChar, 5),
new OleDbParameter(":FCID", OleDbType.VarChar, 5)
};
parm[0].Value = CID;
parm[1].Value = CID;
List<CompanyInfo> companys = new List<CompanyInfo>();
using (OleDbDataReader rdr = OledbHelper.ExecuteReader(OledbHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_SELECT_UNDER, parm))
{
while (rdr.Read())
{
CompanyInfo company = new CompanyInfo(rdr.GetString(0), rdr.GetString(1), rdr.GetString(2), rdr.GetString(3), rdr.GetString(4), rdr.GetInt32(5), rdr.GetString(6), rdr.GetString(7), rdr.GetString(8), rdr.GetString(9), rdr.GetString(10), rdr.GetString(11));
companys.Add(company);
}
}
return companys;
}

请问什么原因?

[MSDNXGH]

没用过用OLE的，

弱弱地问一下，是不是将
WHERE CID=:CID OR FCID=:FCID and F='0' ORDER BY FCID,PXH
换成
WHERE CID=@CID OR FCID=@FCID and F='0' ORDER BY FCID,PXH

new OleDbParameter("@CID", OleDbType.VarChar, 5),
new OleDbParameter("@FCID", OleDbType.VarChar, 5)

[MSDNXGH]

MSSQL的局部变量是用@声明的，ORL的不知道

[anyqu]

没人知道吗?跪求!

[子夜__]

[Quote=引用 3 楼 anyqu 的回复:]

没人知道吗?跪求!
[/Quote]
参考