论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2008-10-22 16:40 |只看该作者 |倒序浏览

public DataSet QueryJobInstruction(string sID, string sCheckItem, string sShopNo, string sProcedure, string sDeviceNo)
        {
            OdbcDataAdapter theAdapter = new OdbcDataAdapter();
            DataSet data = new DataSet();
            try
            {
                string strSQL = "";
                strSQL = @"select * from standardjobinstruction,shopinfo b,chcekdevice c,procedure e where a.shopno=b.shopno and a.checkdeviceno=c.checkdeviceno and a.shopno=e.shopno";
                if (sID != "") strSQL = strSQL + " and a.jobno ='" + sID + "'";
                if (sCheckItem != "") strSQL = strSQL + " and a.checkitem ='" + sCheckItem + "'";
                if (sShopNo != "") strSQL = strSQL + " and a.checkshopno ='" + sShopNo + "'";
                if (sProcedure != "") strSQL = strSQL + " and a.procedureno ='" + sProcedure + "'";
                if (sDeviceNo != "") strSQL = strSQL + " and a.checkdeviceno ='" + sDeviceNo + "'";
                OdbcCommand commandDtl3 = new OdbcCommand(strSQL, conn);
                theAdapter.SelectCommand = commandDtl3;
                theAdapter.Fill(data, "standardjobinstruction");
            }
            catch (System.Exception e)
            {
                throw e;
            }
            finally
            {
                theAdapter.Dispose();
                theAdapter = null;
            }
            return data;
        }

我这个查询函数写的怎么了，报错了

未命名.jpg (18.79 KB, 下载次数: 40)

文库|博客

我是DBA

小富即安

论坛徽章:: 0

2楼 [报告]

发表于 2008-10-22 16:42 |只看该作者

strSQL = @"select * from standardjobinstruction,shopinfo b,chcekdevice c,procedure e where a.shopno=b.shopno and a.checkdeviceno=c.checkdeviceno and a.shopno=e.shopno";

a表在哪？

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

lrg223

白手起家

论坛徽章:: 0

3楼 [报告]

发表于 2008-10-22 16:49 |只看该作者

原帖由 我是DBA 于 2008-10-22 16:42 发表
strSQL = @"select * from standardjobinstruction,shopinfo b,chcekdevice c,procedure e where a.shopno=b.shopno and a.checkdeviceno=c.checkdeviceno and a.shopno=e.shopno";

a表在哪？

这都被你发现了。。我把a加上还是报同样的错，不过这次不是a了，是shopno