实在百思不得其解阿 ! 望赐教 !
错误如下 :
------------------------------------------------------------------------
异常详细信息: System.Data.SqlClient.SqlException: 子查询返回的值多于一个。当子查询跟随在 =、!=、<、<=、>、>= 之后,或子查询用作表达式时,这种情况是不允许的。源错误: 行 641: SqlDataAdapter myDA = new SqlDataAdapter(strQuery, myConnection);
行 642: DataSet myDS = new DataSet();
行 643: myDA.Fill(myDS, "menu");
行 644:
行 645: myConnection.Close();源文件: d:\LJ\eInfo\App_Code\data\DB.cs 行: 643
-------------------------------------------------------------------------
代码如下:#region 菜单
public DataTable getFirstMenu(string admin)
{
SqlConnection myConnection = new SqlConnection(ConfigurationSettings. AppSettings["ConnectionString"]);string strQuery;
if(admin=="0")
{
strQuery="select menuid,name,menulink from menu where fatherid=(select menuid from menu where fatherid=-1) order by seq";
}
else
{
strQuery="select menuid,name,menulink from menu where fatherid=(select menuid from menu where fatherid=-1) and name!='系统管理' order by seq";
}
try
{
myConnection.Open();SqlDataAdapter myDA = new SqlDataAdapter(strQuery, myConnection);
DataSet myDS = new DataSet();
myDA.Fill(myDS, "menu");myConnection.Close();return myDS.Tables["menu"];
}
catch (Exception err)
{
throw new Exception("获取菜单的过程中出现错误。", err);
}}
错误如下 :
------------------------------------------------------------------------
异常详细信息: System.Data.SqlClient.SqlException: 子查询返回的值多于一个。当子查询跟随在 =、!=、<、<=、>、>= 之后,或子查询用作表达式时,这种情况是不允许的。源错误: 行 641: SqlDataAdapter myDA = new SqlDataAdapter(strQuery, myConnection);
行 642: DataSet myDS = new DataSet();
行 643: myDA.Fill(myDS, "menu");
行 644:
行 645: myConnection.Close();源文件: d:\LJ\eInfo\App_Code\data\DB.cs 行: 643
-------------------------------------------------------------------------
代码如下:#region 菜单
public DataTable getFirstMenu(string admin)
{
SqlConnection myConnection = new SqlConnection(ConfigurationSettings. AppSettings["ConnectionString"]);string strQuery;
if(admin=="0")
{
strQuery="select menuid,name,menulink from menu where fatherid=(select menuid from menu where fatherid=-1) order by seq";
}
else
{
strQuery="select menuid,name,menulink from menu where fatherid=(select menuid from menu where fatherid=-1) and name!='系统管理' order by seq";
}
try
{
myConnection.Open();SqlDataAdapter myDA = new SqlDataAdapter(strQuery, myConnection);
DataSet myDS = new DataSet();
myDA.Fill(myDS, "menu");myConnection.Close();return myDS.Tables["menu"];
}
catch (Exception err)
{
throw new Exception("获取菜单的过程中出现错误。", err);
}}
解决方案 »
- Discuz验证码问题
- asp.net 读取excel模版,设置excel的单元格为下拉框
- C#写了ActiveX控件,请问一下如何才能使这个控件调用它所在页面的客户端javascript脚本??急急急
- 有点小难度~~
- 在线考试,关于b端编辑试题问题,请前辈指引方向!
- .net执行exe文件,并接受返回值的问题
- 怎么取到这个自动增长的字段值
- RegularExpressionValidator的用法问题
- RegularExpressionValidator验证手机号码
- 请教^^^^^^关于TextBox的内容无法实现修改,不知是何原因?
- 如何更换cookies中的值呢?
- vs.net 中的css样式的 继承问题??
========================================================================strQuery="select menuid,name,menulink from menu where fatherid in (select menuid from menu where fatherid=-1) order by seq"; strQuery="select menuid,name,menulink from menu where fatherid in (select menuid from menu where fatherid=-1) and name!='系统管理' order by seq";
你的select menuid from menu where fatherid=-1返回的记录是多个,不能用 =
========================================================================strQuery="select menuid,name,menulink from menu where fatherid in (select menuid from menu where fatherid=-1) order by seq"; strQuery="select menuid,name,menulink from menu where fatherid in (select menuid from menu where fatherid=-1) and name!='系统管理' order by seq";
你的select menuid from menu where fatherid=-1返回的记录是多个,不能用 =================================================================================那怎么用 ? 谢谢 !