to display sql table in textarea in html page when button clicked in javascript

Question

0.00/5 (No votes)

See more:

hi everybody,
in have added an html page in asp.net website now my task is ::
i have one button and textarea in design part of html page,i want to display sqlserver table data in textarea control when clicked on button using javascript.please tell me the procedure and javascript code to do this task

i have written some code please look at this code as follows:

XML

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <title></title>
    <script type="text/javascript" language="javascript">

        function getsql() {

            var connection = new ActiveXObject("ADODB.Connection");

            var connectionstring = "Data Source=ajel-xxxxxx;Initial Catalog=xxxxx;User ID=sa;Password=xxxxx;Provider=xxxxx";

            connection.Open(connectionstring);
            var rs = new ActiveXObject("ADODB.Recordset");

            rs.Open("SELECT * FROM studenttable", connection);

            rs.MoveFirst
            while (!rs.eof) {
    
                document.write(rs.fields(0));
                document.write(rs.fields(1));
                document.write(rs.fields(2));
                rs.movenext;
            }

            rs.close;
            connection.close;
        }       
    </script>
    <style type="text/css">
        #TextArea1
        {
            height: 40px;
            width: 108px;
            margin-bottom: 0px;
        }
    </style>
</head>
<body>

    <p>
        <input id="Button1" type="button" value="button"  önclick="return Button1_onclick()" /></p>
    
    <p>
        <textarea id="TextArea1" cols="20" name="S1" rows="1"></textarea></p>
    <p>
         </p>
    <p>
         </p>
    
</body>
</html>

Posted 24-Jul-11 21:35pm

sriram from Hyderabad

Updated 24-Jul-11 23:03pm

v3

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)

AlexBanu · Answer 1 · 2011-07-24T21:44:00

Solution 1

Hi,

I think your code is not safe.
I sure that every one can see your js code. There you have you connection sting made public.
I can try populate the area from code behind and use js action set visible attribute of textarea component.

Posted 24-Jul-11 21:44pm

AlexBanu

sriram from Hyderabad · Answer 2 · 2011-07-24T23:05:00

Solution 2

Hi alex banu,
please give me the answer for my task iam a fresher

thanks and reguards,
chv.siram.

Posted 24-Jul-11 23:05pm

sriram from Hyderabad