以我中的SQL是在判断中赋值的,应该每个结果都有赋值的,但它说SQL没有赋值,求何固,且如何改正if (Request.QueryString["id"] == null && Request.QueryString["id2"] == null)
{
SQL = "select * from Book order by Times desc";
}
else
{
if (Request.QueryString["id"] != null)
{
SQL = "select * from Book where Max_class = " + Request.QueryString["id"] + " order by ID desc";
} if (Request.QueryString["id2"] != null)
{
SQL = "select * from Book where Min_class = " + Request.QueryString["id2"] + " order by ID desc";
}
}
{
SQL = "select * from Book order by Times desc";
}
else
{
if (Request.QueryString["id"] != null)
{
SQL = "select * from Book where Max_class = " + Request.QueryString["id"] + " order by ID desc";
} if (Request.QueryString["id2"] != null)
{
SQL = "select * from Book where Min_class = " + Request.QueryString["id2"] + " order by ID desc";
}
}
解决方案 »
- 服务器安全设置问题
- jquery.uploadify-v2.1.0 上传插件 在国外服务器上报错
- asp.net 2.0 treeview中,并且绑定上一些数据之后,但是如何实现点击上面字(例:山东省),展开子节点(山东省下面有济南,青岛,烟台等等...),再次点同一个字(例:山东省)时,再将其子节点折叠(山东省下面有济南,青岛,烟台等等...) .
- 将C#代码转成v.net的代码
- 连接SQL Server数据库
- 小生初学.NET,请多指教,大侠留步,请进来拿分!!
- vs.net如何使用数据控件设置数据源并在DataGrid中显示出来?
- vs2008 水晶报表10.5 怎么部署?
- 你好
- select 控件的值
- 网站注册
- 网上报修系统怎么做到有报修的时候会有声音提示?
!String.IsNullOrEmpty(Request.QueryString["id"])
而其他楼的人兄,那个String.IsNullOrEmpty(Request.QueryString["id"]),我不会用,sorry,我是初学的
if (Request.QueryString["id"] == null && Request.QueryString["id2"] == null)
{
SQL = "select * from Book order by Times desc";
}
else
{
if (Request.QueryString["id"] != null)
{
SQL = "select * from Book where Max_class = " + Request.QueryString["id"] + " order by ID desc";
} if (Request.QueryString["id2"] != null)
{
SQL = "select * from Book where Min_class = " + Request.QueryString["id2"] + " order by ID desc";
}
}public string SQL=string.Empty;
写在外
if(!String.IsNullOrEmpty())
{ SQL = "select * from Book where Max_class = " + Request.QueryString["id"] + " order by ID desc";
}
string SQL;
if (Request.QueryString["id"] == null && Request.QueryString["id2"] == null)
{
SQL = "select * from Book order by Times desc";
}
else
{ if (Request.QueryString["id"] != null && Request.QueryString["id"].ToString().Trim()!="")
{
SQL = "select * from Book where Max_class = " + Request.QueryString["id"] + " order by ID desc";
} if (Request.QueryString["id2"] != null && Request.QueryString["id2"].ToString().Trim()!="")
{
SQL = "select * from Book where Min_class = " + Request.QueryString["id2"] + " order by ID desc";
}
改这样还是不行啊
如果改成这样就没问题咯,不过,意思应该一样就是不明白为什么不行string SQL = "Select * from Book order by id desc";
if (Request.QueryString["id"] != null)
{
SQL = "Select * from Book where Max_class = " + Request.QueryString["id"] + "order by id desc";
} if(Request.QueryString["id2"] != null)
{
SQL = "Select * from Book where Min_class =" +Request.QueryString["id2"] + " order by id desc";
}
{
SQL = "select * from Book order by Times desc";
}
else
{
if (Request.QueryString["id"] != “”)
{
SQL = "select * from Book where Max_class = " + Request.QueryString["id"] + " order by ID desc";
} if (Request.QueryString["id2"] != “”)
{
SQL = "select * from Book where Min_class = " + Request.QueryString["id2"] + " order by ID desc";
}
}