ajax简单的应用

protected void Page_Load(object sender, EventArgs e)
    {
        Ajax.Utility.RegisterTypeForAjax(typeof(wuliu_lzj_purchase_lp_purchase_content_show));
    }

[Ajax.AjaxMethod]
public string GetBookInfoByID(string code)
    {
        strint[] paras = new string[] { "@code" };
        object[] value = new object[] { int.Parse(code) };
        System.Data.DataSet ds = Lzjoa.LzjoaControl.CommomControl.Commom.Query(paras, value, "bookinfo_detail_show");
        if (ds.Tables[0].Rows.Count > 0)
        {
            strMessage = ds.Tables[0].Rows[0]["_name"].ToString().Trim().Replace("_", "—");
            strMessage += "|" + ds.Tables[0].Rows[0]["_price"].ToString().Trim();
            return strMessage;
        }
        else
            return "^_^";
    }

Code
<script>
<!--
function setBookInfo(sender)
  {
    if(sender.value.match(/\D/)==null && sender.value!="")
        {
             var strValue=wuliu_lzj_purchase_lp_purchase_content_show.GetBookInfoByID(sender.value).value;
      
              if(strValue=="^_^")
                     {
                          alert("产品不存在");
                           sender.value="";
                     }
               else
                     {
                          var values=strValue.split('|')
                          document.getElementById("txtbookname").value=values[0];
                          document.getElementById("txtprice").value=values[1];         
        
                     }
         }
         
 }
-->
</script>

前台代码
图书代号：<asp:TextBox ID="txtbookcode" runat="server" Width="80px" onblur="setBookInfo(this)" onkeypress="if(event.keyCode==13){document.getElementById('txtbookcode').select();}" TabIndex="1"></asp:TextBox>
          图书名称：<asp:TextBox ID="txtbookname" runat="server" Width="150px"/>
                 单价：<asp:TextBox ID="txtprice" runat="server" Width="50px"></asp:TextBox>

CREATE PROCEDURE [dbo].[bookinfo_detail_show]
@code int
AS
select  *  from  book where _code=@code

转载于:https://www.cnblogs.com/jizhitao/archive/2009/11/03/1595181.html