我现在查询条件有5项,有些可以为空,帮忙写一条查询语句参考下。谢谢了!
解决方案 »
- DataTable无法即时更新
- 关于DataGrid 显示时间的问题
- 请问大家,如何判断Calendar是否有被用户选中?
- ASP.NET动态Button事件无法响应
- cookies存储最近浏览信息问题
- JAVASCRIPT openModelWin()
- 实时刷新网页后,为什么在自己机子上运行正常,到别人机子上访问就会出错呢.
- 其中A一个页面,向B的一个页面的左框架中传值.怎么实现啊?各位帮我看看啊,谢谢了
- 大家在项目中的AJAX都用什么框架啊?
- 急...!在ASP.NET中加入javascript代码的问题?
- Intelligencia.UrlRewriter如何实现无后缀名的重写?
- 网站上传了一个flv视频文件,FTP上确实有,但是通过网址访问,提示系统找不到该文件,怎么个问题啊?
string sql = "select * from table where 1=1";
if ("条件1" != null) sql += " and name='csdn' ";
if ("条件2" != null) sql += " and sex='woman' ";
//运用此写法,注意每一个sql+=语句""和and之间的空格,
//打开与数据库的连接
SqlConnection myConn = CC.GetConnection();
myConn.Open();
//查询符合搜索条件的字符串
string sqlStr = "select * from tb_files";
if (this.txtFilesName.Text.Trim() != "" || ddlUD.SelectedIndex != 0 || ddlProvince.SelectedItem.Text.Trim() != "" || ddlCity.SelectedItem.Text.Trim() != "" || ddlCity.SelectedItem.Text.Trim() != "" || ddlVilliage.SelectedItem.Text.Trim() != "")
{
sqlStr += " where ";
if (this.txtFilesName.Text.Trim() != "" && ddlUD.SelectedIndex == 0 && ddlProvince.SelectedItem.Text.Trim() == "" && ddlCity.SelectedItem.Text.Trim() == "" && ddlVilliage.SelectedItem.Text.Trim() == "")
{
sqlStr += "fileName like'%" + this.txtFilesName.Text.Trim() + "%' ORDER BY fileid DESC";
}
else if (this.txtFilesName.Text.Trim() == "" && ddlUD.SelectedIndex != 0 && ddlProvince.SelectedItem.Text.Trim() == "" && ddlCity.SelectedItem.Text.Trim() == "" && ddlVilliage.SelectedItem.Text.Trim() == "")
{
sqlStr += "fileUpDate= '" + this.ddlUD.SelectedValue.ToString() + "' ORDER BY fileid DESC"; }
else if (this.txtFilesName.Text.Trim() == "" && ddlUD.SelectedIndex == 0 && ddlProvince.SelectedItem.Text.Trim() != "" && ddlCity.SelectedItem.Text.Trim() == "" && ddlVilliage.SelectedItem.Text.Trim() == "")
{
sqlStr += "areaname= '" + this.ddlProvince.SelectedItem.Text.Trim().ToString() + "' ORDER BY fileid DESC";
}
else if (this.txtFilesName.Text.Trim() == "" && ddlUD.SelectedIndex == 0 && ddlProvince.SelectedItem.Text.Trim() == "" && ddlCity.SelectedItem.Text.Trim() != "" && ddlVilliage.SelectedItem.Text.Trim() == "")
{
sqlStr += "cityname= '" + this.ddlCity.SelectedItem.Text.Trim().ToString() + "' ORDER BY fileid DESC";
}
else if (this.txtFilesName.Text.Trim() == "" && ddlUD.SelectedIndex == 0 && ddlProvince.SelectedItem.Text.Trim() == "" && ddlCity.SelectedItem.Text.Trim() == "" && ddlVilliage.SelectedItem.Text.Trim() != "")
{
sqlStr += "provincename= '" + this.ddlVilliage.SelectedItem.Text.Trim().ToString() + "' ORDER BY fileid DESC";
}
else if (this.txtFilesName.Text.Trim() != "" && ddlUD.SelectedIndex == 0 && ddlProvince.SelectedItem.Text.Trim() != "" && ddlCity.SelectedItem.Text.Trim() == "" && ddlVilliage.SelectedItem.Text.Trim() == "")
{
sqlStr += "fileName like'%" + this.txtFilesName.Text.Trim() + "%'";
sqlStr += "and areaname= '" + this.ddlProvince.SelectedItem.Text.Trim().ToString() + "' ORDER BY fileid DESC";
}
else if (this.txtFilesName.Text.Trim() == "" && ddlUD.SelectedIndex != 0 && ddlProvince.SelectedItem.Text.Trim() != "" && ddlCity.SelectedItem.Text.Trim() == "" && ddlVilliage.SelectedItem.Text.Trim() == "")
{
sqlStr += "fileUpDate= '" + this.ddlUD.SelectedValue.ToString() + "'";
sqlStr += "and areaname= '" + this.ddlProvince.SelectedItem.Text.Trim().ToString() + "' ORDER BY fileid DESC";
}
else if (this.txtFilesName.Text.Trim() != "" && ddlUD.SelectedIndex != 0 && ddlProvince.SelectedItem.Text.Trim() == "" && ddlCity.SelectedItem.Text.Trim() == "" && ddlVilliage.SelectedItem.Text.Trim() == "")
{ sqlStr += "fileUpDate='" + this.ddlUD.SelectedValue.ToString() + "'";
sqlStr += " and fileName like'%" + this.txtFilesName.Text.Trim() + "%' ORDER BY fileid DESC";
}
else if (this.txtFilesName.Text.Trim() == "" && ddlUD.SelectedIndex == 0 && ddlProvince.SelectedItem.Text.Trim() != "" && ddlCity.SelectedItem.Text.Trim() != "" && ddlVilliage.SelectedItem.Text.Trim() == "")
{ sqlStr += "areaname='" + this.ddlProvince.SelectedItem.Text.Trim().ToString() + "'";
sqlStr += "and cityname='" + this.ddlCity.SelectedItem.Text.Trim().ToString() + "' ORDER BY fileid DESC";
}
else if (this.txtFilesName.Text.Trim() == "" && ddlUD.SelectedIndex == 0 && ddlProvince.SelectedItem.Text.Trim() != "" && ddlCity.SelectedItem.Text.Trim() != "" && ddlVilliage.SelectedItem.Text.Trim() != "")
{ sqlStr += "areaname='" + this.ddlProvince.SelectedItem.Text.Trim().ToString() + "'";
sqlStr += "and cityname='" + this.ddlCity.SelectedItem.Text.Trim().ToString() + "'";
sqlStr += "and provincename='" + this.ddlVilliage.SelectedItem.Text.Trim().ToString() + "' ORDER BY fileid DESC";
}
else if (this.txtFilesName.Text.Trim() == "" && ddlUD.SelectedIndex != 0 && ddlProvince.SelectedItem.Text.Trim() != "" && ddlCity.SelectedItem.Text.Trim() != "" && ddlVilliage.SelectedItem.Text.Trim() == "")
{ sqlStr += "fileUpDate='" + this.ddlUD.SelectedValue.ToString() + "'";
sqlStr += "and areaname='" + this.ddlProvince.SelectedItem.Text.Trim().ToString() + "'";
sqlStr += "and cityname='" + this.ddlCity.SelectedItem.Text.Trim().ToString() + "' ORDER BY fileid DESC";
} else
{
sqlStr += "fileUpDate='" + this.ddlUD.SelectedValue.ToString() + "'";
sqlStr += "and cityname='" + this.ddlCity.SelectedItem.Text.Trim().ToString() + "'";
sqlStr += "and provincename='" + this.ddlVilliage.SelectedItem.Text.Trim().ToString() + "'";
sqlStr += "and areaname='" + this.ddlProvince.SelectedItem.Text.Trim().ToString() + "'";
sqlStr += " and fileName like'%" + this.txtFilesName.Text.Trim() + "%' ORDER BY fileid DESC";
}
}
else
{ sqlStr += " ORDER BY fileid DESC";
}
SqlDataAdapter dapt = new SqlDataAdapter(sqlStr, myConn);
DataSet ds = new DataSet();
//填充数据集
dapt.Fill(ds, "files");
//绑定数据控件
this.gvFiles.DataSource = ds.Tables["files"].DefaultView;
this.gvFiles.DataKeyNames = new string[] { "fileID" };
this.DataBind();
//释放占用的资源
ds.Dispose();
dapt.Dispose();
myConn.Close();
string sql = "select * from table where 1=1";
if ("条件1" != null) sql += " and name='csdn' ";
if ("条件2" != null) sql += " and sex='woman' ";正解
if (this.txtCode.Text.Trim() != string.Empty)
{
where += (where.Length > 0 ? "AND" : " ") + "TCARD_BATCH_ID LIKE '%" + this.txtCode.Text.Trim() + "%' ";
}
if (this.txtName.Text.Trim() != string.Empty)
{
where += (where.Length > 0 ? "AND" : " ") + " USER_NAME LIKE '%" + this.txtName.Text.Trim() + "%'";
}