how to get table from sql to htmltable using javascript

Question

0.00/5 (No votes)

See more:

hi everybody,
i have taken a html page my task was i have taken a button and table in html page ,my task is "when clicked on button table in sqlserver must display in html table using javascript("i have written a piece of code its not executing please edit my code so that i can execute")

"my code is as follows"
"errormessage of my code":(ADODB.Recordset: Item cannot be found in the collection corresponding to the requested name or ordinal.)

XML

<script language="javascript" type="text/javascript">
   function getsqltable()
   {
       var strtable;
       var connection = new ActiveXObject("ADODB.Connection");
       var connectionstring = "Persist Security Info=False;Data Source=xxxxxx;Initial Catalog=xxxx;User ID=sa;Password=xxxx;Provider=SQLOLEDB";
       connection.Open(connectionstring);
       var rs = new ActiveXObject("ADODB.Recordset");
       rs.Open("select * from studenttable", connection);
       rs.MoveFirst
       strtable='<table cellpadding=0 cellspacing=0 width=75%>';
       while (!rs.eof)
       {
           strtable+='<tr>';
           strtable += '<td>' + rs.fields(0) + '</td>' + '<td>' + rs.fields(1) + '</td>' + '<td>' + rs.fields(2) + '</td>' + '<td>' + rs.fields(3) + '</td>'
           strtable+='</tr>';
           rs.movenext;
       }
       strtable+='</table>';
       rs.close;
       connection.close;
       document.getElementById('htmltable').innerHTML=strtable;
   }
   </script>
   <input type="button" onclick="getsqltable();" value="Click Me" />
   <div id="htmltable">
   </div>
    <p>
        &nbsp;</p>
    <table style="width:100%;">
        <tr>
            <td>
                &nbsp;</td>
            <td>
                &nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
        <tr>
            <td>
                &nbsp;</td>
            <td>
                &nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
        <tr>
            <td>
                &nbsp;</td>
            <td>
                &nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
    </table>

Posted 8-Aug-11 20:49pm

sriram from Hyderabad

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

thatraja · Answer 1 · 2011-08-08T20:57:00

Don't re-post your question man. :((

You got around 10+ answers for your previous questions. If you have any doubt then make a comment for answers using Add comment link below the answer

Just see your question history

http://www.codeproject.com/script/Answers/MemberPosts.aspx?tab=questions&mid=7994901[^]

EDIT
-----------------------------------------------------------

OP wrote:
"my code is as follows"
"errormessage of my code":(ADODB.Recordset: Item cannot be found in the collection corresponding to the requested name or ordinal.)

Read this
Troubleshooting 800a0cc1 Errors[^]

Don't use select * from studenttable. Use select Column1,Column2,Column3,etc., from studenttable

EDIT2
------------------------------------------------------------

OP wrote:
sir i entered rs.Open("select studentno,studentname,studentcourse from studenttable", connection);again its giving error sir in the following line like this strtable += '<td>' + rs.fields(0) + '</td>' + '<td>' + rs.fields(1) + '</td>' + '<td>' + rs.fields(2) + '</td>' + '<td>' + rs.fields(3) + '</td>' ADODB.Recordset: Item cannot be found in the collection corresponding to the requested name or ordinal.

In your query, you are selecting only 3 columns in your query. But in your code you are trying to get 4 columns. That's the issue. So select the 4th column in your query.

Christian Graus · Answer 2 · 2011-08-08T21:09:00

Solution 2

One obvious question - why is your database visible on the network of the machines doing this ? Even so, why use javascript to do this ?

Posted 8-Aug-11 21:09pm

Christian Graus

Comments

sriram from Hyderabad 9-Aug-11 3:18am

sir iam a fresher its my task sir i have to do like that only please help me sir see my code and above comments also