• AjaxPro.dll(无刷新分页原理)

    [c#]
    post by bgaidu / 2009-2-1 9:56 Sunday
    前台

    [code]<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>

    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

    <html xmlns="http://www.w3.org/1999/xhtml" >
    <head runat="server">
        <title>无刷新分页原型</title>
        <script type="text/javascript">
        function getById(id)  
        {  
            return document.getElementById(id);  
        }  
        function createObj(name)  
        {  
            return document.createElement(name);  
        }
        function showtable(sid)
        {  
            var pager = getById(sid);
            var v = _Default.getDS().value; // 类的名称
            var innerStr = "<table border='1'><tr><td>id</td><td>单位编号</td></tr>";
          
            if (v != null)
            {      
                if(v != null && typeof(v) == "object" && v.Tables != null)
                {            
                    for(var i=0; i<v.Tables[0].Rows.length; i++)
                    {
                        var txt = v.Tables[0].Rows[i].id; //这个地方需要注意区分大小写
                        var vvol = v.Tables[0].Rows[i].num; //跟dataset表的列名称要一致
                        innerStr += "<tr><td>" + txt + "</td>";
                        innerStr += "<td>" + vol + "</td></tr>";
                    }
                }
            }    
            innerStr +="</table>";
            pager.innerHTML=innerStr;
            return;
        }
        document.onclick=function(){
            showtable("pager");
        }
        </script>
    </head>
    <body>
        <form id="form1" runat="server">
        <div id="pager">
        </div>
        </form>
    </body>
    </html>

    [/code]
    后台
    [code]
    using System;
    using System.Data;
    using System.Configuration;
    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 System.Data.SqlClient;

    public partial class _Default : System.Web.UI.Page  
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            AjaxPro.Utility.RegisterTypeForAjax(typeof(_Default));
        }
        /// <summary>
        /// 返回DataSet
        /// </summary>
        /// <returns></returns>
        [AjaxPro.AjaxMethod]
        public DataSet getDS()
        {
            string connStr = ConfigurationManager.ConnectionStrings["hrmbookConnectionString"].ToString();
            SqlConnection conn = new SqlConnection(connStr);
            DataSet ds = new DataSet();
            try
            {
                conn.Open();
                string Sqlstr = "SELECT id,单位编号 num FROM ttest order by 单位编号";

                SqlDataAdapter da = new SqlDataAdapter(Sqlstr, conn);
                da.Fill(ds);
            }
            catch (Exception ex)
            {
                Response.Write(ex.ToString());
            }
            finally
            {
                conn.Close();
            }
            return ds;
        }  
    }
    [/code]
    配置
    [code]<?xml version="1.0"?>
    <!--  
        注意: 除了手动编辑此文件以外，您还可以使用  
        Web 管理工具来配置应用程序的设置。可以使用 Visual Studio 中的
         “网站”->“Asp.Net 配置”选项。
        设置和注释的完整列表在  
        machine.config.comments 中，该文件通常位于  
        \Windows\Microsoft.Net\Framework\v2.x\Config 中
    -->
    <configuration>
        <appSettings/>
      <connectionStrings>
        <add name="hrmbookConnectionString" connectionString="Data Source=lyylsoft-server,3668;Initial Catalog=hrmbook;Persist Security Info=True;User ID=sa;Password=123"
         providerName="System.Data.SqlClient" />
      </connectionStrings>
        <system.web>
        <!--AjaxPro_Start-->
        <httpHandlers>
          <remove verb="*" path="*.asmx"/>
          <add verb="*" path="*.asmx" type="Microsoft.Web.Services.ScriptHandlerFactory" validate="false"/>
          <add verb="POST,GET" path="ajaxpro/*.ashx" type="AjaxPro.AjaxHandlerFactory, AjaxPro.2"/>
        </httpHandlers>
        <!--AjaxPro_End-->
            <!--  
                设置 compilation debug="true" 将调试符号插入
                已编译的页面中。但由于这会  
                影响性能，因此只在开发过程中将此值  
                设置为 true。
            -->
            <compilation debug="true"/>
            <!--
                通过 <authentication> 节可以配置 ASP.NET 使用的  
                安全身份验证模式，
                以标识传入的用户。  
            -->
            <authentication mode="Windows"/>
            <!--
                如果在执行请求的过程中出现未处理的错误，
                则通过 <customErrors> 节可以配置相应的处理步骤。具体说来，
                开发人员通过该节可以配置
                要显示的 html 错误页
                以代替错误堆栈跟踪。

            <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
                <error statusCode="403" redirect="NoAccess.htm" />
                <error statusCode="404" redirect="FileNotFound.htm" />
            </customErrors>
            -->
        </system.web>
    </configuration>

    [/code]
    
    您对本文的评分:
    当前平均分: 2.0(1 次打分)
    « asp.net程序性能优化的七个方面 (c#（或vb.net）程序改进) | javascript操作Xml增删改查(IE下)»

    引用地址:

    发表评论：