天天看點

ajax的自動加載資料庫,Ajax動态加載資料庫示例

function btnClick() {

var xmlhttp = xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");

if (!xmlhttp) {

alert("建立xmlhttp對象異常!");

return false;

}

var text1 = document.getElementById("Text1");

xmlhttp.open("post","GetPrice2.ashx?ts"+text1, false);

xmlhttp.onreadystatechange = function () {

if (xmlhttp.readyState == 4) {

if (xmlhttp.status == 200) {

document.getElementById("Text2").value = xmlhttp.responseText;

}

else {

alert("Ajax傳回錯誤!");

}

}

}

xmlhttp.send();

}

産品名稱:

價格:

using System;

using System.Linq;

using System.Web;

using DataSetProductsTableAdapters;

public class GetPrice : IHttpHandler {

public void ProcessRequest (HttpContext context)

{

context.Response.ContentType = "text/plain";

//context.Response.Write("Hello World");

string name = context.Request["text1"];

var data = new PriceTableAdapter().GetDataByName(name);//需要建一個強類型的dataset

if (data.Count <= 0)

{

context.Response.Write("none|0");

}

else

{

context.Response.Write("ok|" + data.Single().Price);

}

}

public bool IsReusable {

get {

return false;

}

}

}