11-24写搜索的后台代码

来源：互联网发布：js 汉字转utf8编码编辑：程序博客网时间：2024/05/17 01:44

protected void Page_Load(object sender, EventArgs e) -----Page_Load中
{

if (PreviousPage != null)
            {
                TextBox tb = (TextBox)PreviousPage.FindControl("txtsearch");
                string Selectbiaoti = tb.Text;
                string q = Selectbiaoti;

                DataTable tableHelper = SqlHelper.dataset("select * from tbl_right where biaoti like '%" + q + "%", new SqlParameter("tiaoti", Selectbiaoti)).Tables[0];
                for (int i = 0; i < tableHelper.Rows.Count; i++)
                {
                    divselect.InnerHtml = tableHelper.Rows[i]["biaoti"].ToString() + "</br>" + tableHelper.Rows[i]["data"].ToString() + "</br>" + tableHelper.Rows[i]["date"].ToString() + "\"/>";
                }
            }

}
-----搜索按钮事件

protected void ImageBtn1_Click1(object sender, ImageClickEventArgs e)
        {
            Session["ss"] = txtsearch.Text;---用session 保存信息
            Response.Redirect("search.aspx");

}

--search.aspx 页 Page_Load中

protected void Page_Load(object sender, EventArgs e)
{

            string Selectbiaoti = Session["ss"].ToString();--传过来的信息
            string q = Selectbiaoti;
            DataTable tableHelper = SqlHelper.dataset("select * from tbl_right where biaoti like '%" + q + "%'", new SqlParameter("tiaoti", Selectbiaoti)).Tables[0];
            for (int i = 0; i < tableHelper.Rows.Count; i++)
            {
                divselect.InnerHtml = tableHelper.Rows[i]["biaoti"].ToString() + "</br>" + tableHelper.Rows[i]["data"].ToString() + "</br>" + tableHelper.Rows[i]["date"].ToString() + "\"/>";
            }

}