7
Is it true???Help me please..
I want to search data from Database..And..The result is view in new "DIV"..
<%@ Page Language="vb" AutoEventWireup="false" Codebehind="new.aspx.vb" Inherits="Testing._new" %>
<%
Dim objDbConn, strConn, rsSearchResults, strSQL, I
If Request.QueryString("action") <> "" Then
'Here you put your code that you use to retrieve your
'search results, something akin to:
objDbConn = Server.CreateObject("ADODB.Connection")
strConn = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("../Testing/database/database.mdb")
objDbConn.Open(strConn)
rsSearchResults = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT * FROM name_USER WHERE Keyword LIKE '%" & Request.QueryString("keywords") & "%';"
rsSearchResults.Open(strSQL, objDbConn, 1, 1)
'That's your recordset open, now you need to loop through it to display your results
%>
<table>
<% For I = 1 To rsSearchResults.RecordCount %>
<tr><td><%=rsSearchResults("field0")%></td>
<td><%=rsSearchResults("field1")%></td>
<td><%=rsSearchResults("field2")%></td></tr>
<% rsSearchResults.MoveNext
Next %>
</table>
<%
Else
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11_flat.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
<title>Search page</title>
<script type="text/javascript">
function GetXmlHttpObject() {
objXMLHttp = null;
if (window.ActiveXObject) {
objXMLHttp = new ActiveXObject("Microsoft.XMLHTTP");
} else if (window.XMLHttpRequest) {
objXMLHttp = new XMLHttpRequest();
}
return objXMLHttp
}
function doAjax(myXmlObj,myUrl,myParameters,myMethod,return Div) {
if (myMethod == "POST") {
myXmlObj.open(myMethod,myUrl,true);
} else {
myXmlObj.open(myMethod,myUrl+"?"+ myParameters,true);
}
myXmlObj.onreadystatechange=function() { stateChanged(myXmlObj,return Div) };
if (myMethod == "POST") {
myXmlObj.send(myParameters);
} else {
myXmlObj.send(null);
}
myXmlObj.close;
}
function stateChanged(thisXML,divToReturn) {
switch (thisXML.readyState) {
case 1:
document.getElementById(divToReturn).innerHTML=thi sXML.responseText;
break;
default:
document.getElementById(divToReturn).innerHTML='<d iv style="top:5px;left:5px;position:relative;filter:a lpha(opacity=60);opacity:0.6;-moz-opacity:0.6;font-weight:bold;">Loading...</div>';
}
}
var xmlHttpObj = GetXmlHttpObject();
</script>
</head>
<body>
<div id="searchfromhere">
<input type="text" name="keywords"/>
<br />
<input type="submit" onclick="javascript:doAjax(xmlHttpObj,'new.aspx',' ?action=search&keywords='+document.forms.elements[0].value,'GET','searchresults');" />
</div>
<div id="searchresults">
</div>
</body>
</html>
<% End If%>
