评论列表

=======AdvSearchAjax.aspx================== ================== ================== ================== =================< br />
在aspx页面中 这个页面中只保留第一行  其余的html代码全部去掉,关键是后台cs文件中的处理

AdvSearchAjax.aspx.cs

using System;
using System.Data;
using System.Data.SqlClient;
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 CNTVS.TOOLS.COMM;
using CNTVS.TOOLS.SQLDB;
using System.Text;

public partial class Public_Product_AdvSearchAjax : System.Web.UI.Page
{
    DataBase db = new DataBase();
    SqlConnection conn = null;

    protected void Page_Load(object sender, EventArgs e)
    {
        Response.Clear();
        Response.ContentType = "text/xml";     //设置输出的格式为XML
        Response.Charset = "UTF-8";              //设置输出的编码为UTF-8
        this.GetXmlData();
    }


    private void GetXmlData()
    {    //这是用来获取下拉列表框中下面提示的项目数据，获取的数据用XML格式输出
        conn = db.GetConn();
        string names = Request.QueryString["names"];
        StringBuilder xmlData = new StringBuilder();
        xmlData.AppendLine(@" ");
        xmlData.AppendLine(@" ");
        string sql = "";
        sql = "select F_Name from T_Product where F_Name like '%" + names + "%'";
        SqlDataReader sdr = db.RunSql(sql, conn);
        while (sdr.Read())
        {
            xmlData.AppendLine(@" " + sdr["F_Name"].ToString() + " ");
        }
        sdr.Close();
        conn.Close();
        xmlData.AppendLine(@" ");
        Response.Write(xmlData.ToString());
    }
}

这两个页面就能完成类似Google suggest的功能 ,当然这样的版本比较简单 ,但是也能看到一点Ajax带来的新功能了.

本文转自
http://cnc.imgcache.qq.com/qzone/newblog/blogcontent.html#bid=53