Ejemplo de paginacion y ordenacion con ajaxpro, aqui parte 1

[programadorvip]

hola aqui les dejo un ejemplo de como paginar y ordenar sin el gridview y usando ajax + html. saludos

Código PHP:

  create   PROCEDURE  [dbo].[Paginar] 
@PageSize int,  
@PageNumber int  
AS  
set @PageNumber = @PageNumber - 1 
SELECT orderid,productid,unitprice,quantity 
FROM (  
SELECT  
orderid,productid,unitprice,quantity,  
ROW_NUMBER() OVER (ORDER BY orderid desc) AS RowNumber  
FROM  
[order details] 
) AS [order details] 
WHERE RowNumber BETWEEN @PageSize * @PageNumber + 1  
AND @PageSize * (@PageNumber + 1)  
   

Código PHP:

  <?xml version="1.0"?> 
<configuration> 
    <configSections> 
        <sectionGroup name="ajaxNet"> 
            <section name="ajaxSettings" type="AjaxPro.AjaxSettingsSectionHandler,AjaxPro.2" requirePermission="false" restartOnExternalChanges="true"/> 
        </sectionGroup> 
    </configSections> 
    <ajaxNet> 
        <ajaxSettings> 
            <urlNamespaceMappings useAssemblyQualifiedName="false"> 
                <add type="MyAjaxMethods,App_Code" path="_a"/> 
            </urlNamespaceMappings> 
            <jsonConverters> 
                <add type="AjaxPro.BitmapConverter,AjaxPro.2"/> 
            </jsonConverters> 
            <oldStyle> 
                <includeMsPrototype/> 
            </oldStyle> 
        </ajaxSettings> 
    </ajaxNet> 
    <connectionStrings> 
        <add name="SQL_CN" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=northwind;Integrated Security=True" providerName="System.Data.SqlClient"/> 
    </connectionStrings> 
    <location path="Publica"> 
        <system.web> 
            <authorization> 
                <allow users="?"/> 
            </authorization> 
        </system.web> 
    </location> 
    <system.web> 
        <authentication mode="Forms"> 
            <forms loginUrl="Default.aspx" defaultUrl="Default.aspx"> 
            </forms> 
        </authentication> 
        <customErrors mode="Off"/> 
        <sessionState stateNetworkTimeout="20" sqlConnectionString="Data Source=.\SQLEXPRESS;Integrated Security=True" timeout="60"/> 
        <pages maintainScrollPositionOnPostBack="true" validateRequest="false" enableEventValidation="false" viewStateEncryptionMode="Never" enableViewStateMac="false"> 
            <controls> 
                <add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> 
            </controls> 
        </pages> 
        <!--<authentication mode="Forms"> 
            <forms loginUrl="Default.aspx" protection="All"> 
            </forms> 
        </authentication> 
        <authorization> 
            <deny users="?"/> 
        </authorization>--> 
        <compilation debug="true"> 
            <assemblies> 
                <add assembly="System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/> 
                <add assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> 
                <add assembly="System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/> 
                <add assembly="System.Web.Extensions.Design, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/> 
            </assemblies> 
        </compilation> 
        <httpRuntime executionTimeout="110" maxRequestLength="60264" requestLengthDiskThreshold="80" useFullyQualifiedRedirectUrl="false" minFreeThreads="8" minLocalRequestFreeThreads="4" appRequestQueueLimit="5000" enableKernelOutputCache="true" enableVersionHeader="true" requireRootedSaveAsPath="true" enable="true" shutdownTimeout="90" delayNotificationTimeout="5" waitChangeNotification="0" maxWaitChangeNotification="0" enableHeaderChecking="true" sendCacheControlHeader="true" apartmentThreading="false"/> 
        <httpHandlers> 
            <remove verb="*" path="*.asmx"/> 
            <add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> 
            <add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> 
            <add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" validate="false"/> 
        </httpHandlers> 
        <httpModules> 
            <add name="Session" type="System.Web.SessionState.SessionStateModule"/> 
            <add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> 
        </httpModules> 
    </system.web> 
    <location path="ajaxpro"> 
        <system.web> 
            <httpHandlers> 
                <add verb="*" path="*.ashx" type="AjaxPro.AjaxHandlerFactory,AjaxPro.2"/> 
            </httpHandlers> 
        </system.web> 
    </location> 
</configuration>  

te bajas la libreria ajaxpro2 de mcihael. o sino entra a esta web
http://es.geocities.com/romanticoper...neficiente.zip