请问我的程序错在哪？毕业设计， 高手拜托了

[WindBoy1987]

请问我的程序错在哪了！！！

        /// <summary>
        /// 按照条件搜索客房
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btn_roomPrerequisite_Click(object sender, EventArgs e)
        {
            bool cBTel = cB_tel.Checked;
            bool cBADSL = cB_ADSL.Checked;
            bool cBToilet = cB_toilet.Checked;
            string tbxPrice = tbx_price.Text.Trim();
            dGV_roomCheck.DataSource = mybo.roomPrerequisite(cBTel,cBADSL,cBToilet,tbxPrice);
        }

        /// <summary>
        /// 按照条件搜索客房的方法
        /// </summary>
        /// <param name="cBTel"></param>
        /// <param name="cBADSL"></param>
        /// <param name="cBToilet"></param>
        /// <param name="tbxPrice"></param>
        /// <returns></returns>
        internal object roomPrerequisite(bool cBTel, bool cBADSL, bool cBToilet, string tbxPrice)
        {
            return mydb.roomPrerequisite(cBTel,cBADSL,cBToilet,tbxPrice);
        }
        /// <summary>
        /// 调用数据库中符合条件的行
        /// </summary>
        /// <param name="cBTel"></param>
        /// <param name="cBADSL"></param>
        /// <param name="cBToilet"></param>
        /// <param name="tbxPrice"></param>
        /// <returns></returns>
        internal object roomPrerequisite(bool cBTel, bool cBADSL, bool cBToilet, string tbxPrice)
        {
            cmd.CommandText = "select * from roomInfo where haveTel = '" + cBTel + "',"+"haveADSL='" + cBADSL + "',"+"haveToilet='" + cBToilet + "',"+"rent<='"+tbxPrice+"'";
            OleDbDataAdapter da = new OleDbDataAdapter();
            da.SelectCommand = cmd;
            DataTable dt = new DataTable();
            da.Fill(dt);//在这提示
            return dt;
        }

[WindBoy1987]

mybo 是实例化一个业务逻辑
mydb 是实例化一个数据访问
我用了三层架构

[Kevin_LiuFeng]

cmd.CommandText = "select * from roomInfo where haveTel = '" + cBTel + "',"+"haveADSL='" + cBADSL + "',"+"haveToilet='" + cBToilet + "',"+"rent<='"+tbxPrice+"'";这个sql有问题。。

改成：cmd.CommandText ="select * from roomInfo where haveTel ='"+cBTel+"' and haveADSL ='"+cBADSL+"' and haveToilet='"+cBToilet+"' and rent <='"+tbxPrice+"'";

[lya121]

报什么错！

[lya121]

[Quote=引用 2 楼 Kevin_LiuFeng 的回复:]
cmd.CommandText = "select * from roomInfo where haveTel = '" + cBTel + "',"+"haveADSL='" + cBADSL + "',"+"haveToilet='" + cBToilet + "',"+"rent <='"+tbxPrice+"'";这个sql有问题。。

改成：cmd.CommandText ="select * from roomInfo where haveTel ='"+cBTel+"' and haveADSL ='"+cBADSL+"' and haveToilet='"+cBToilet+"' and rent <='"+tbxPrice+"'";
[/Quote]

刚没仔细看。
确实是
语法错误。
粗心了吧

select * from 表名 where 字段名＝值 and 字段名1＝值1

[youyouke]

internal object roomPrerequisite(bool cBTel, bool cBADSL, bool cBToilet, string tbxPrice)
{
cmd.CommandText = "select * from roomInfo where haveTel = '" + cBTel + "',"+"haveADSL='" + cBADSL + "',"+"haveToilet='" + cBToilet + "',"+"rent<='"+tbxPrice+"'";

OleDbDataAdapter da = new OleDbDataAdapter();
da.SelectCommand = cmd;
DataTable dt = new DataTable();
da.Fill(dt);//在这提示
return dt;
}
就该改写为：
internal DataTable roomPrerequisite(bool cBTel, bool cBADSL, bool cBToilet, string tbxPrice)
{
cmd.CommandText = "select * from roomInfo where haveTel = '" + cBTel + "',"+"haveADSL='" + cBADSL + "',"+"haveToilet='" + cBToilet + "',"+"rent<='"+tbxPrice+"'";

OleDbDataAdapter da = new OleDbDataAdapter();
da.SelectCommand = cmd;
DataSet ds=new DataSet();
da.Fill(ds);
DataTable dt = ds.Tables[0];

return dt;
}

[lunat]

cmd.CommandText = "select * from roomInfo where haveTel = '" + cBTel + "',"+"haveADSL='" + cBADSL + "',"+"haveToilet='" + cBToilet + "',"+"rent<='"+tbxPrice+"'";

后边 "rent<='"+tbxPrice+"'"; 这里出错了

你的tbxPrice是字符串，sql里面还把它用''引起来怎么比较大小？？？

"ren<="+tbxPrice 就可以了

[lunat]

还有2楼说的。。晕 还有这样的错误 刚开始都没看出来

[WindBoy1987]

[Quote=引用 5 楼 youyouke 的回复:]
internal object roomPrerequisite(bool cBTel, bool cBADSL, bool cBToilet, string tbxPrice)
{
cmd.CommandText = "select * from roomInfo where haveTel = '" + cBTel + "',"+"haveADSL='" + cBADSL + "',"+"haveToilet='" + cBToilet + "',"+"rent <='"+tbxPrice+"'";

OleDbDataAdapter da = new OleDbDataAdapter();
da.SelectCommand = cmd;
DataTable dt = new…
[/Quote]
好像不行！

[WindBoy1987]

[Quote=引用 6 楼 lunat 的回复:]
cmd.CommandText = "select * from roomInfo where haveTel = '" + cBTel + "',"+"haveADSL='" + cBADSL + "',"+"haveToilet='" + cBToilet + "',"+"rent <='"+tbxPrice+"'";

后边 "rent <='"+tbxPrice+"'"; 这里出错了

你的tbxPrice是字符串，sql里面还把它用''引起来怎么比较大小？？？

"ren <="+tbxPrice 就可以了
[/Quote]
不是这个错误
我那样写可以！！

[WindBoy1987]

[Quote=引用 6 楼 lunat 的回复:]
cmd.CommandText = "select * from roomInfo where haveTel = '" + cBTel + "',"+"haveADSL='" + cBADSL + "',"+"haveToilet='" + cBToilet + "',"+"rent <='"+tbxPrice+"'";

后边 "rent <='"+tbxPrice+"'"; 这里出错了

你的tbxPrice是字符串，sql里面还把它用''引起来怎么比较大小？？？

"ren <="+tbxPrice 就可以了
[/Quote]
不是这个错误
我那样写可以！！

[CHEN_SL1986]

where 语句后面的各条件间应该是and 或or 而不是“,”吧，再说了da应该是数据源与dataset之间用的吧 da.fill(ds)


这是我的理解，试试看行不行

[WindBoy1987]

高手再看看
[Quote=引用 5 楼 youyouke 的回复:]
internal object roomPrerequisite(bool cBTel, bool cBADSL, bool cBToilet, string tbxPrice)
{
cmd.CommandText = "select * from roomInfo where haveTel = '" + cBTel + "',"+"haveADSL='" + cBADSL + "',"+"haveToilet='" + cBToilet + "',"+"rent <='"+tbxPrice+"'";

OleDbDataAdapter da = new OleDbDataAdapter();
da.SelectCommand = cmd;
DataTable dt = new…
[/Quote]
现在出现这个问题！！！

[firehand01]

建议：
你添加监视看看你程序里的sql语句吧，
把监视到的sql语句放到查询分析器里运行一下...

[一品梅]

DataSet ds = new DataSet();
da.Fill(ds);

"select * from roomInfo where haveTel = '" + cBTel + "' and haveADSL='" + cBADSL + "' and haveToilet='" + cBToilet + "' and rent='"+tbxPrice+"'";