ASP.NET学习网|ASP.NET教程|ASP.NET MVC|ASP.NET 源码|VS2010教程|ASP.NET视频教程

SearchCompany.ashx文件

<%@ WebHandler Language="C#" Class="SearchCompany" %>  
using System;  
using System.Web;  
using System.Data;  
using System.Data.SqlClient;  
using System.Configuration;  
 
public class SearchCompany : IHttpHandler {  
 
    public void ProcessRequest(HttpContext context)  
    {  
        string strconn = ConfigurationManager.ConnectionStrings["DBConn"].ConnectionString;  
        string keyword = context.Request.QueryString["cname"];  
        //string keycontext.Responseword = "河北";  
        //此处更改为您自己的sql或者存储过程  
        string sql = "select Member_TrueName from users where Member_TrueName like '%" + @keyword + "%' and Member_ShenFen=1 order by id desc";  
        //context.Response.Write(sql);  
        //context.Response.End();  
        SqlParameter spr = new SqlParameter(@keyword, SqlDbType.NVarChar, 50);  
        spr.Value = keyword;  
        SqlCommand cmd = new SqlCommand(sql);  
        context.Response.CacheControl = "no-cache";  
        context.Response.Clear();  
        context.Response.ContentType = "text/xml";  
        context.Response.Write("<?xml version=\"1.0\" encoding=\"GB2312\"?>");  
        context.Response.Write("<response>");  
        using (SqlConnection sqlconn = new SqlConnection(strconn))  
        {  
            sqlconn.Open();  
            cmd.Connection = sqlconn;  
            SqlDataReader dre = cmd.ExecuteReader();  
            if (dre.HasRows)  
            {  
                while (dre.Read())  
                {  
                    context.Response.Write("<content>");  
                    context.Response.Write("<name>" + dre.GetString(0) + "</name>");  
                    context.Response.Write("</content>");  
                }  
            }  
            else 
            {  
                context.Response.Write("<content>");  
                context.Response.Write("<name>暂无查询数据</name>");  
                context.Response.Write("</content>");  
            }  
            context.Response.Write("</response>");  
            dre.Close();  
 
        }  
    }  
    public bool IsReusable {  
        get {  
            return false;  
        }  
    }  
 
} 
<%@ WebHandler Language="C#" Class="SearchCompany" %>
using System;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public class SearchCompany : IHttpHandler {

    public void ProcessRequest(HttpContext context)
    {
        string strconn = ConfigurationManager.ConnectionStrings["DBConn"].ConnectionString;
        string keyword = context.Request.QueryString["cname"];
        //string keycontext.Responseword = "河北";
        //此处更改为您自己的sql或者存储过程
        string sql = "select Member_TrueName from users where Member_TrueName like '%" + @keyword + "%' and Member_ShenFen=1 order by id desc";
        //context.Response.Write(sql);
        //context.Response.End();
        SqlParameter spr = new SqlParameter(@keyword, SqlDbType.NVarChar, 50);
        spr.Value = keyword;
        SqlCommand cmd = new SqlCommand(sql);
        context.Response.CacheControl = "no-cache";
        context.Response.Clear();
        context.Response.ContentType = "text/xml";
        context.Response.Write("<?xml version=\"1.0\" encoding=\"GB2312\"?>");
        context.Response.Write("<response>");
        using (SqlConnection sqlconn = new SqlConnection(strconn))
        {
            sqlconn.Open();
            cmd.Connection = sqlconn;
            SqlDataReader dre = cmd.ExecuteReader();
            if (dre.HasRows)
            {
                while (dre.Read())
                {
                    context.Response.Write("<content>");
                    context.Response.Write("<name>" + dre.GetString(0) + "</name>");
                    context.Response.Write("</content>");
                }
            }
            else
            {
                context.Response.Write("<content>");
                context.Response.Write("<name>暂无查询数据</name>");
                context.Response.Write("</content>");
            }
            context.Response.Write("</response>");
            dre.Close();

        }
    }
    public bool IsReusable {
        get {
            return false;
        }
    }

}

(责任编辑：admin)