ajax简单的应用
![](https://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
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 "^_^";
}
![](https://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
<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>
![](https://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
图书代号:<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
@code int
AS
select * from book where _code=@code