奇怪,我在本地调试通过.但是一放到服务器上就报错
Exception Details: System.Data.OleDb.OleDbException: No value given for one or more required parameters.SQL语句是:
string cmdText = "SELECT ATO FROM tblRebateFillout WHERE Zip = @zip and ScheduleDate = @schdate and CustomerID = @custid";
Exception Details: System.Data.OleDb.OleDbException: No value given for one or more required parameters.SQL语句是:
string cmdText = "SELECT ATO FROM tblRebateFillout WHERE Zip = @zip and ScheduleDate = @schdate and CustomerID = @custid";
OleDbCommand cmd = new OleDbCommand(cmdText, con1);
cmd.Parameters.Add("@zip",zip);
cmd.Parameters.Add("@schdate",schdate);
cmd.Parameters.Add("@custid",custid);
OleDbDataReader dr = cmd.ExecuteReader();
不知道怎么回事,谁能给看看?服务器的数据库和本地是一样的啊.为什么本地能通过,服务器通不过?