Printable View
hi
i have two text box in a page. one
name:
ID
Name
when a user enter a ID and click Go button the page get the name from database and show in Name column
i want the name comes in text box from Database with out refresh the page...
is there any way to do it???
Look at remote scripting :
http://msdn.microsoft.com/library/en...ting041299.asp
---
Anglo Saxon
You would have to retrieve the data for every single user and store it in a client side array and filter through that array when the user enters an id...
not necessarily recommended if user data is sensitive.
thanks for replay....
i read the artical
http://msdn.microsoft.com/library/e...pting041299.asp
it's complex... :confused: :confused:
I think it using jscript...
i just want to use ASP and javascript......
i m still waiting
:cool: :cool:
Then you will have to use the method that PunkRockNeil suggested , you will need to take note that this is a very unsecure way of achieving what you want !:
Code:<%option explicit%>
<html>
<head>
<title>Untitled</title>
<script>
<!--
<%
dim objConn, objRS, strSQL,conString,strID,strNames
conString="Driver={SQL Server};Server=(local);UID=;PWD=;Database=YOURDATABASE;"
set objConn = server.createobject("ADODB.Connection")
objConn.ConnectionString = conString
objConn.open
strSQL = "SELECT id,name FROM users ORDER BY user_name"
set objRS = objConn.execute(strSQL)
if not objRS.eof then
do while not objRS.eof
strID = strID & objRS("id") & ","
strNames = strNames & "'" & objRS("name") & "',"
objRS.movenext
loop
end if
'strip off trailing commas
strID = left(strID,len(strID)-1)
strNames = left(strNames,len(strNames)-1)
'write out javascript array info
'**UNCOMMENT THESE LINES**
'Response.Write "var IDList = new Array(" & strID & ");" & vbCrLf
'Response.Write "var NameList = new Array(" & strNames & ");" & vbCrLf
%>
//THIS IS AN EXAMPLE OF WHAT SHOULD BE GENERATED BY THE ASP CODE!!
//REMOVE THESE LINES WHEN YOU ARE RUNNING THE CODE ABOVE
var IDList = new Array(128,124,125,123,127,126);
var NameList = new Array('Fred Flintstone','Peter Pan','Mickey Mouse','Dan Dare','Spiderman','Goofy');
function SearchIDList(ID){
var counter = 0;
var IDCount = IDList.length;
for(counter=0;counter<IDCount;counter++){
if(ID == IDList[counter]){
return NameList[counter];
}
}
alert("User not found!");
return '';
}
//-->
</script>
</head>
<body>
<form name="form1" action="">
ID : <input type="text" name="id">
<input type="button" onclick="document.form1.user_name.value=SearchIDList(document.form1.id.value);" value="search"><br>
User Name : <input type="text" name="user_name">
</form>
</body>
</html>
---
Anglo Saxon
Remote Scripting does get a little "involved" but if you ever learn it you will find a whole lot more uses for it. I'm glad I took the time to learn it.
Quote:
Originally posted by Anglo Saxon
Then you will have to use the method that PunkRockNeil suggested , you will need to take note that this is a very unsecure way of achieving what you want !:
Code:<%option explicit%>
<html>
<head>
<title>Untitled</title>
<script>
<!--
<%
dim objConn, objRS, strSQL,conString,strID,strNames
conString="Driver={SQL Server};Server=(local);UID=;PWD=;Database=YOURDATABASE;"
set objConn = server.createobject("ADODB.Connection")
objConn.ConnectionString = conString
objConn.open
strSQL = "SELECT id,name FROM users ORDER BY user_name"
set objRS = objConn.execute(strSQL)
if not objRS.eof then
do while not objRS.eof
strID = strID & objRS("id") & ","
strNames = strNames & "'" & objRS("name") & "',"
objRS.movenext
loop
end if
'strip off trailing commas
strID = left(strID,len(strID)-1)
strNames = left(strNames,len(strNames)-1)
'write out javascript array info
'**UNCOMMENT THESE LINES**
'Response.Write "var IDList = new Array(" & strID & ");" & vbCrLf
'Response.Write "var NameList = new Array(" & strNames & ");" & vbCrLf
%>
//THIS IS AN EXAMPLE OF WHAT SHOULD BE GENERATED BY THE ASP CODE!!
//REMOVE THESE LINES WHEN YOU ARE RUNNING THE CODE ABOVE
var IDList = new Array(128,124,125,123,127,126);
var NameList = new Array('Fred Flintstone','Peter Pan','Mickey Mouse','Dan Dare','Spiderman','Goofy');
function SearchIDList(ID){
var counter = 0;
var IDCount = IDList.length;
for(counter=0;counter<IDCount;counter++){
if(ID == IDList[counter]){
return NameList[counter];
}
}
alert("User not found!");
return '';
}
//-->
</script>
</head>
<body>
<form name="form1" action="">
ID : <input type="text" name="id">
<input type="button" onclick="document.form1.user_name.value=SearchIDList(document.form1.id.value);" value="search"><br>
User Name : <input type="text" name="user_name">
</form>
</body>
</html>
---
Anglo Saxon
if i use this code then the latest data will not appear on javascript array
for example
at the time 8:10
user A : open the page of item he enter code 99 the desc appear in a text box but no details appear bcoz the 99 code does not exist
at the time 8:11
user B open a page and enter the code 99 and it's detail and save the page
now user a was unable to see the detials bcoz it enter after a minute ..........:confused: :confused: :confused:
just cheat and submit form to same page, so when the button is clicked it will load the same page with the box filled. if your database is small it should do it quick enough to look instantaneous
thanks to all