帮忙看看这句话错在哪里

BabySky716 2008-12-23 12:31:02

dt = sql.SelectSql("select * from einfo where SchID ='" + dt.Rows[0]["SchID"].ToString() + "' order by class,srid");

...全文

102 14 打赏收藏转发到动态举报

写回复

用AI写文章

14 条回复

切换为时间正序

请发表友善的回复…

发表回复

BabySky716 2008-12-23

打赏
举报

Titandick 加过'也没用

BabySky716 2008-12-23

打赏
举报

private void button2_Click(object sender, EventArgs e)
{
dt = sqlc.SelectSql("select * from SchInfo where flag='1'");
if (comboClass.SelectedValue.ToString() == "0")
{
dt = sql.SelectSql("select * from einfo where SchID ='" + dt.Rows[0]["SchID"].ToString() + "' order by class,srid");
}
else
{
dt = sql.SelectSql("select * from einfo where SchID ='" + dt.Rows[0]["SchID"].ToString() + "' and class=" + comboClass.SelectedValue.ToString() + " order by class,srid");
}
lblStatus.Text = "搜索到的记录数：" + dt.Rows.Count + " 条";

r.SetDataSource(dt);
r.Refresh();
ReportViewer.ReportSource = r;
}

刚开始到 if (comboClass.SelectedValue.ToString() == "0")这里的时候就不行了
后来改成if (comboClass.SelectedValue!= null && comboClass.SelectedValue.ToString() == "0")
然后到这里就停住了

Titandick 2008-12-23

打赏
举报

class=" + comboClass.SelectedValue.ToString() + " order by class,srid" 少了单引号
改成
class='" + comboClass.SelectedValue.ToString() + "' order by class,srid"

niitnanfeng 2008-12-23

打赏
举报

[Quote=引用 1 楼 BabySky716 的回复:]
dt = sql.SelectSql("select * from einfo where SchID ='" + dt.Rows[0]["SchID"].ToString() + "' and class=" + comboClass.SelectedValue.ToString() + " order by class,srid");
是这句,不好意思.
[/Quote]
dt.Rows[0]["SchID"].ToString()从哪儿来的？代码贴全来看

智者知已应修善业 2008-12-23

打赏
举报

dt.Rows[0]["SchID"].ToString() 改用变量

BabySky716 2008-12-23

打赏
举报

dt = sql.SelectSql("select * from einfo where SchID ='" + dt.Rows[0]["SchID"].ToString() + "' and class=" + comboClass.SelectedValue.ToString() + " order by class,srid");
是这句,不好意思.

dxmnh 2008-12-23

打赏
举报

[Quote=引用 5 楼 BabySky716 的回复:]
private void button2_Click(object sender, EventArgs e)
{
dt = sqlc.SelectSql("select * from SchInfo where flag='1'");
if (comboClass.SelectedValue.ToString() == "0")
{
dt = sql.SelectSql("select * from einfo where SchID ='" + dt.Rows[0]["SchID"].value.ToString() + "' order by class,srid");
}
else…
[/Quote]

waiwenlianxi 2008-12-23

打赏
举报

看了LS 我自己闭上了左眼 =_=

bbbbbb888888 2008-12-23

打赏
举报

确保那2个Tostring()得到正确的值.有可能你得到的object[]这样的值.用变量把.

ILoveRMB 2008-12-23

打赏
举报

把sql语句打印出来，copy到查询分析器中运行，一眼看出错误



dt = sql.SelectSql("select * from einfo where SchID ='" + dt.Rows[0]["SchID"].ToString() + "'  and class=" + comboClass.SelectedValue.ToString() + " order by class,srid");