Javascript code to retrieve result search results from database

[rempit]

Hye all..I'm Newbie..

I'm using asp.net..This code below I put in .aspx file..And become like that..
I want to make something like "WHEN USER PUT SOMETHING IN TEXTBOX AND CLICK THE BUTTON SEARCH..THE RESULT COMEOUT IN NEW ' div '..

I want to apply to my website..Using AJAX code..
I just copy the code from http://www.w3schools.com/ajax/ajax_database.asp.

Help me please..

HEAD

<%
        Dim sql, conn, rs, x
 
        Response.Expires = -1
        sql = "SELECT * FROM the_TABLE WHERE the_COLUMN="
        sql = sql & "'" & Request.QueryString("q") & "'"
 
 
        conn = Server.CreateObject("ADODB.Connection")
        conn.Provider = "Microsoft.Jet.OLEDB.4.0"
        conn.Open(Server.MapPath("../AJAXPage/db/Database1.mdb"))
        rs = Server.CreateObject("ADODB.recordset")
        rs.Open(sql, conn)
        Response.Write("<table>")
        Do Until rs.EOF
            For Each x In rs.Fields
                Response.Write("<tr><td><b>" & x.name & "</b></td>")
                Response.write("<td>" & x.value & "</td></tr>")
            Next
            rs.MoveNext()
        Loop
 
        Response.Write("</table>")
    %>
 

BODY

[HTML]<div id="Div1" align="center">
<asp:Label ID="lblSearch" runat="server" Font-Bold="True" Text="SEARCH"></asp:Label>
<br />
<br />
<asp:TextBox ID="txtSearch" runat="server"></asp:TextBox>
<br />
<br />
<input type="BUTTON" value="SEARCH" onclick="Show(txtSearch.text)" id="btnSearch"/>
<br />
</div>

<div id="Div2"><b>Here...</b>
</div>[/HTML]

[dmjpro]

Hye all..I'm Newbie..

I'm using asp.net..This code below I put in .aspx file..And become like that..
I want to make something like "WHEN USER PUT SOMETHING IN TEXTBOX AND CLICK THE BUTTON SEARCH..THE RESULT COMEOUT IN NEW ' div '..

I want to apply to my website..Using AJAX code..
I just copy the code from http://www.w3schools.com/ajax/ajax_database.asp.

Help me please..

HEAD

<%
Dim sql, conn, rs, x

Response.Expires = -1
sql = "SELECT * FROM the_TABLE WHERE the_COLUMN="
sql = sql & "'" & Request.QueryString("q") & "'"


conn = Server.CreateObject("ADODB.Connection")
conn.Provider = "Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.MapPath("../AJAXPage/db/Database1.mdb"))
rs = Server.CreateObject("ADODB.recordset")
rs.Open(sql, conn)
Response.Write("<table>")
Do Until rs.EOF
For Each x In rs.Fields
Response.Write("<tr><td><b>" & x.name & "</b></td>")
Response.write("<td>" & x.value & "</td></tr>")
Next
rs.MoveNext()
Loop

Response.Write("</table>")
%>

BODY

<div id="Div1" align="center">
<asp:Label ID="lblSearch" runat="server" Font-Bold="True" Text="SEARCH"></asp:Label>
<br />
<br />
<asp:TextBox ID="txtSearch" runat="server"></asp:TextBox>
<br />
<br />
<input type="BUTTON" value="SEARCH" onclick="Show(txtSearch.text)" id="btnSearch"/>
<br />
</div>

<div id="Div2"><b>Here...</b>
</div>

Show us the Ajax Code and describe your specific Problem.
Then we able to solve your Problem.

Kind regards,
Dmjpro.

[rempit]

Sorry because I'm forgot to put full code..
So..Below I add the "JScript.js"..
The problem is error in JavaScript..

HEAD

<script type="text/javascript" src="JScript.js"></script>
 
<%
Dim sql, conn, rs, x
 
Response.Expires = -1
sql = "SELECT * FROM the_TABLE WHERE the_COLUMN="
sql = sql & "'" & Request.QueryString("q") & "'"
 
 
conn = Server.CreateObject("ADODB.Connection")
conn.Provider = "Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.MapPath("../AJAXPage/db/Database1.mdb"))
rs = Server.CreateObject("ADODB.recordset")
rs.Open(sql, conn)
Response.Write("<table>")
Do Until rs.EOF
For Each x In rs.Fields
Response.Write("<tr><td><b>" & x.name & "</b></td>")
Response.write("<td>" & x.value & "</td></tr>")
Next
rs.MoveNext()
Loop
 
Response.Write("</table>")
%>

BODY

[HTML]<div id="Div1" align="center">
<asp:Label ID="lblSearch" runat="server" Font-Bold="True" Text="SEARCH"></asp:Label>
<br />
<br />
<asp:TextBox ID="txtSearch" runat="server"></asp:TextBox>
<br />
<br />
<input type="BUTTON" value="SEARCH" onclick="Show(txtSearch.text)" id="btnSearch"/>
<br />
</div>

<div id="Div2"><b>Here...</b>
</div>[/HTML]

JScript.js

// JScript File
var xmlHttp
 
function Show(str)
{ 
xmlHttp=GetXmlHttpObject();
if (xmlHttp==null)
  {
  alert ("Your browser does not support AJAX!");
  return;
  } 
var url="Default.aspx";
url=url+"?q="+str;
url=url+"&sid="+Math.random();
xmlHttp.onreadystatechange=stateChanged;
xmlHttp.open("GET",url,true);
xmlHttp.send(null);
}
 
function stateChanged() 
{ 
if (xmlHttp.readyState==4)
{ 
document.getElementById("Div2").innerHTML=xmlHttp.responseText;
}
}
 
function GetXmlHttpObject()
{
var xmlHttp=null;
try
  {
  // Firefox, Opera 8.0+, Safari
  xmlHttp=new XMLHttpRequest();
  }
catch (e)
  {
  // Internet Explorer
  try
    {
    xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
    }
  catch (e)
    {
    xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
    }
  }
return xmlHttp;
}

[dmjpro]

You should maintain the Code tags while you do Post.
OK.

function stateChanged()
{
if (xmlHttp.readyState==4&&xmlHttp.status==200)
{
document.getElementById("Div2").innerHTML=xmlHttp.responseText;
}
}
 

Only you checked that whether your page Loaded or not.
But you didn't check whether it is successful or not.
That's why I put one more condition xmlHttp.status==200.
It means your page successfully loaded.
And do one thing your page, which you call by Ajax, check that whether it runs successfully or not means it returns expected Output or not.
Good Luck with your Code.

Kind regards,
Dmjpro.

[rempit]

still having error..

"Unknown runtime error" in Head PART..Is it my mistake to call the database?

[dmjpro]

still having error..

"Unknown runtime error" in Head PART..Is it my mistake to call the database?

Look,
I am not a .NET Man, I am J2EE Man.
I think the error comes for your Head Part.
Means your Ajax call is made properly.
But on the Server Side the page you are calling that is the error.
First run it Separately, if it runs properly and shows Output properly then i think there will be no problem with your work.
Best of Luck with your try.

Kind regards,
Dmjpro.

[rempit]

Thanks dmjpro..
Thanks again for your help.. ;-)

[dmjpro]

Thanks dmjpro..
Thanks again for your help.. ;-)

Your Code is Working.
And no need to wish me Thanks.
You welcome always.

Kind regards,
Dmjpro.

[acoder]

Changed thread title to describe the problem a little better. Extra question marks don't make the question any more urgent.

rempit, please use code tags in future when posting code. Thanks!

Glad you got your problem solved. Post again any time should you hit any more problems.