主页面：
protected void cmdSearch_Click(object sender, EventArgs e)
{
Session["tool"] = "人事处----输入关键字为＂"+TextBox1.Text+"＂";
//" + DropDownList1.Text + "'and
//Session["search"] = "select * from List where Title and Word like '%'and Word like'%" + TextBox1.Text + "%' ";
// Session["search"] = "select * from BoWorkAfter,ConsultData,Download,employ,inform,InformationOpen,Organiaztion,Organiaztion,Organiaztion,ServiceGuide where Content like '%" + TextBox1.Text + "%'";
Session["search"] = TextBox1.Text ;
Response.Redirect("search_new.aspx");
}
搜索页面：
if (!IsPostBack)
{
string strsql;
//strsql = "select * from List order by id desc";
//strsql = " select * from List where Title and Word like '%'and Word like'%" + TextBox1.Text + "%'";
strsql = "select * from BoWorkAfter,ConsultData,Download,employ,inform,InformationOpen,Organiaztion,Organiaztion,Organiaztion,ServiceGuide where Title like '%" + Session["search"] + "%'";
DataSet ds = new DataSet();
ds = new Class1().hsggetdata(strsql);
Repeater2.DataSource = ds.Tables[0];
Repeater2.DataBind();
Label1.Text = Convert.ToString(Session["tool"]);
}
