search.aspx.cs

来自「具体功能质量高得到以后可以到我的博客去看看你能收获很多」· CS 代码 · 共 44 行

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

using guihua.App_Code;
public partial class Search : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }

    protected void sousuo_Click(object sender, EventArgs e)
    {
        string title, contents,strSql="";
        title = Title.Text;
        contents = Contents.Text;
        if (title == "" && contents == "")
        {
            strSql = "SELECT * FROM [LM01]";
        }
        if(title !="" && contents =="") {
            strSql = "SELECT * FROM [LM01] WHERE (Title LIKE"+"'%"+title+"%')";
        }
        if (title == "" && contents != "") {
            strSql = "SELECT * FROM LM01 WHERE Contents LIKE" + "'%" + contents + "%'";
        }
        if (title != "" && contents != "") {
            strSql = "SELECT * FROM LM01 WHERE (Title LIKE" + "'%" + title + "%'" + "OR Contents LIKE" + "'%" + contents + "%')";
        }
DataSet ds = new DataSet();
        ds = DBControl.DBSelect1(strSql);
        DataList1.DataSource = ds;
        DataList1.DataBind();
    }
}