=======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
在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