下面的这个方法用VS2005在本机运行、调试是有一条记录的,但是发布到服务器上就查不到数了。测试了很久都没找到原因...请高手帮忙解决下。谢谢!!!!!
public string getcode(string kehuid, string kehuleibie, string riqi, string bianm)
{
OracleConnection con = new OracleConnection("Data Source=aa;User ID=test;Password=test");
string sql = "select * from vw_jiage1 where (客户编码='" + kehuid + "' or 客户类别 like '%" + kehuleibie + "%') and 开始日期 < '" + riqi + "' and '" + riqi + "' < 结束日期 and 物料ID like '" + bianm + "'";
OracleCommand com = new OracleCommand(sql,con);
con.Open();
OracleDataReader dr = com.ExecuteReader();
string aa = "0";
while (dr.Read())
{
aa = dr["整件单价"].ToString();
}
dr.Close();
con.Close();
return aa;
}
public string getcode(string kehuid, string kehuleibie, string riqi, string bianm)
{
OracleConnection con = new OracleConnection("Data Source=aa;User ID=test;Password=test");
string sql = "select * from vw_jiage1 where (客户编码='" + kehuid + "' or 客户类别 like '%" + kehuleibie + "%') and 开始日期 < '" + riqi + "' and '" + riqi + "' < 结束日期 and 物料ID like '" + bianm + "'";
OracleCommand com = new OracleCommand(sql,con);
con.Open();
OracleDataReader dr = com.ExecuteReader();
string aa = "0";
while (dr.Read())
{
aa = dr["整件单价"].ToString();
}
dr.Close();
con.Close();
return aa;
}
是不是数据库连接有问题
2、再看数据库通过程序连接是否正常;
3、再单步调试下程序;