VideoHome.Web/admin/Film/aspx/1/ajax.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Text;
using System.Data.SqlClient;
using Maticsoft.DBUtility;

namespace myfilm.Web.aspx._1
{
    public partial class ajax : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            string searchText = Request["searchText"];
            StringBuilder result = new StringBuilder(100);

            if (!string.IsNullOrEmpty(searchText))
            {

                SqlDataReader dr = null;
                try
                {

                    dr = DbHelperSQL.ExecuteReader("select top 20 id,Name from T_Films where name like '%'+@keywords+'%'", new SqlParameter("@keywords", searchText));
                 
                    while (dr.Read())
                    {
                        result.Append("<a href='/search.aspx?stype=fName&svalue=" + Server.UrlEncode(dr[1].ToString()) + "'>" + dr[1].ToString() + "</a> ");
                    }
                }
                catch
                {
                }
                finally
                {
                    if (dr != null && !dr.IsClosed)
                    {
                        dr.Close();
                        dr.Dispose();
                    }
                }
            }
            if (result.ToString() == "")
            {
                Response.Write("0");
            }
            else
            {
                Response.Write(result.ToString());
            }


        }
    }
}