Ajax调用存储过程简单实例

       ajax基于javascript ，就是通过网页脚本向服务器发送异步的请求，改变同步请求的不便

       同步请求 一个请求必须等待到服务器的响应 然后整个页面刷新

       异步请求 则不需要等待服务器的响应 因此页面可以实现局部刷新

       这样的好处是提供了更好的用户体验，仅供初学者学习。

页面代码如下：

代码

< script type = " text/javascript " >
        var xmlHttp;
        function createXMLHttpRequest()
        {
             if (window.ActiveXObject)
            {
                xmlHttp  =   new  ActiveXObject( " Microsoft.XMLHTTP " );
            }
             else   if (window.XMLHttpRequest)
            {
                xmlHttp  =   new  XMLHttpRequest();
            }
        }
        function addNumber()
        {
            createXMLHttpRequest();
            var url =   " Handler.ashx " ;
            xmlHttp.open( " GET " ,url, true );
            xmlHttp.onreadystatechange = showResult;
            xmlHttp.send( null );
        }
        function showResult()
        {  
         // alert(xmlHttp.status) ;
             if (xmlHttp.readyState == 4 )
            {
                 if (xmlHttp.status == 200 )
                {
                    document.getElementById( " result " ).innerHTML = xmlHttp.responseText;
                }
            }
        }
     </ script >
</ head >
< body >
     < form id = " form2 "  runat = " server " >
     < div style = " text-align: center " >
         < div id = " result " ></ div >
         </ div >
         < input id = " btnGetData "  type = " button "  value = " Ajax 获取存储过程数据 "   onclick = " addNumber(); " />
     </ form >
</ body >
</ html >

 

 

非常简单的存储过程实例  如下：

存储过程代码

create  procedure GetDataSam(
@number  int  
)
as  
begin   
declare @str nvarchar( 200 );
set    @str = ' select top  ' + cast(@number   as   nvarchar) +   ' title  from  zhq_in_content    order by  createdate   desc ' ;
exec(@str);
end

 

 

一般处理文件Handler.ashx；代码如下

 

一般处理文件代码

<% @ WebHandler Language = " C# "  Class = " Handler "   %>

using  System;
using  System.Web;

using  System.Data;
using  System.Data.SqlClient;

using  System.Text;

public   class  Handler : IHttpHandler
{

     public   void  ProcessRequest(HttpContext context)
    {
        context.Response.ContentType  =   " text/plain " ;
        StringBuilder sb  =   new  StringBuilder();
         int  num  =   10 ;
        DataSet ds  =  GetDataSetFromDB(num);
         if (ds != null   && ds.Tables[ 0 ].Rows.Count > 0 ){
             for  ( int  i  =   0 ; i  <  ds.Tables[ 0 ].Rows.Count ;i ++ )
            {
                if (sb.ToString() == "" ){
                   sb.Append(ds.Tables[ 0 ].Rows[i][ " title " ].ToString());
               }
                else
               {
                   sb.Append( " <br/> " ).Append(ds.Tables[ 0 ].Rows[i][ " title " ].ToString());
               }
            }
        }
        context.Response.Write(sb.ToString());
    }

     public   bool  IsReusable
    {
         get
        {
             return   false ;
        }
    }
     public  DataSet GetDataSetFromDB( int  num) {
        SqlConnection conn  =   new  SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[ " foretech " ].ToString());
         try
        {
            conn.Open();
             // string sql = "select top 10 title from   zhq_in_content order  by   createdate  desc;";
             //  SqlCommand comm = new SqlCommand("select top 10 title from   zhq_in_content order  by   createdate  desc;",conn);
            SqlDataAdapter da  =   new  SqlDataAdapter( " GetDataSam " , conn);
            da.SelectCommand.CommandType  =  CommandType.StoredProcedure;
            SqlParameter para  =   new  SqlParameter( " @number " ,num);
            para.Direction  =  ParameterDirection.Input;
            da.SelectCommand.Parameters.Add(para);
            DataSet ds  =   new  DataSet();
            da.Fill(ds);
             if  (ds  !=   null   &&  ds.Tables[ 0 ].Rows.Count  >   0 )
            {
                 return  ds;

            }
             else
            {
                 return   null ;
            }
        }
         finally
        {
            conn.Close();
        }
    }
}

 

 

     仅供初学者学习，说不定去其他公司笔试的时候有用，用SQLHelper怕初学者看不懂，这个简单易懂。