Salaam ,
I started learn Ajax,I want use it with ASP
any one know more give me example like this example but how benefit from Ajax to use taken information from through data base, also I hope know about "xmlHttp.responseText" what contain ?
Regards, thanks for all.
<html dir="rtl">
<head>
<!-define a div that will be our pseudo progress indicator -->
<div id="divProgress">Please wait</div>
<script TYPE="text/javascript" LANGUAGE="JavaScript">
// Create an instance of the XML HTTP Request object
var oXMLHTTP = new ActiveXObject( "Microsoft.XMLHTTP" );
var userid;
function validateuserid(suserid) {
// Prepare the XMLHTTP object for a HTTP POST to our validation ASP page
userid = suserid;
var sURL = "test.asp?userid=" + userid;
oXMLHTTP.open( "POST", sURL, false );
// Define an event handler for processing
oXMLHTTP.onreadystatechange = managestatechange;
// Execute the request
try {
oXMLHTTP.send();
}
catch (e) {
alert("Could not validate your User ID at this time.");
document.all.item("FirstName").focus;
}
}
function managestatechange() {
switch (oXMLHTTP.readyState) {
case 2, 3:
// Display a progress indicator of some kind, informing the
// user that you are checking to see if the UserID exists
document.all.item("divProgress").style.display = "block";
break;
case 4:
if (oXMLHTTP.responseText == "exists")
alert("Sorry - the User ID " + userid + " already exists.");
document.all.item("divProgress").style.display = "none";
break;
}
}
// Hide the progress indicator for now
document.all.item("divProgress").style.display = "none";
</script>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1256">
<title>New Page 1</title>
</head>
<body>
<form action="test.asp">
<%
Dim Conn, RS, sUserID
'Capture the username that we need to lookup, making sure its prepared for
'our forthcoming SQL query
sUserID = Replace(Trim(Request.QueryString("UserID")),"'","")
set conn=Server.CreateObject("ADODB.Connection")
conn.Open "driver={SQL Server};server=elecdbtest1;uid=persys;pwd=sysper;database=ELECDB"
set rs=conn.execute("Select *from T_EMPLOYEES where EMP_FIRST_NAME = '"&sUserID &"' ")
If Not rs.EOF Then Response.Write " " & "exists"
%>
<input type="text" name="UserID" onblur="validateuserid(this.value);" >
<div id=divProgress></div>
</form>
</body>
<%
'Clean up
rs.Close
conn.Close
Set rs = Nothing
Set conn = Nothing
%>
</html>