注册 登录
编程论坛 ASP.NET技术论坛

至少一个参数没有被指定值。

chenjincheng 发布于 2013-03-13 10:26, 590 次点击
  string s = "";
        string str = "select xingming,dianhua,zhuti,neirong from youke";
        OleDbConnection cn = new OleDbConnection(System.Configuration.ConfigurationManager.AppSettings["SQLConnString"].ToString());
        OleDbDataAdapter da = new OleDbDataAdapter(str, cn);
        DataSet ds = new DataSet();
        da.Fill(ds);
        int ret = 0;
        for (int i = 0; i <= youkexinxi.count() - 1; i++)
        {
            string s1 = ds.Tables[0].Rows[i]["zhuti "].ToString();
            if (zhuti == s1)
                ret = 1;
        }
        if (ret == 1)
        {
            s = "";
        }
        else
        {
            s = "没有该主题";
        }
        return s;
至少一个参数没有被指定值。
这里为什么会出现这种情况,哪位大哥能帮忙解决下,我刚学ASP,谢谢了
2 回复
#2
Aviva_Wang2013-03-14 09:28
OleDbDataAdapter da = new OleDbDataAdapter(str, cn);换成底下这个写法看看
OleDbCommand cmd = new OleDbCommand(str, con);
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
#3
冰镇柠檬汁儿2013-03-14 10:21
同意楼上
1