Reader Level:
ARTICLE

Show Whether a Textbox Value Exists in Database Using JavaScript

Posted by Nitin Bhardwaj Articles | JavaScript May 02, 2013
In this article I explain how to show whetehr a TextBox value exists in the database using JavaScript.
  • 0
  • 0
  • 8017
Download Files:
 

Note: This program will work only with Internet Explorer.

In this article I explain how to show whetehr a TextBox value exists in the database using JavaScript.

First I created a database "EmpSalary_Info". Then I created a table in this database. 

Query Code

CREATE TABLE [dbo].[EmpSalary_Info](

      [id] [int] NULL,

      [name] [varchar](50) NULL,

      [salary] [int] NULL

) ON [PRIMARY]

Now insert some data into the "EmpSalary_Info" table. Then use the following procedure.

Complete Program

Show_Data.htm

 

<!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" >

        function ShowDB()

        {      

                var txtid = document.getElementById('txtid').value;

                if (txtid.length != 0)

                {

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

                    var connectionstring = "Data Source=.;Initial Catalog=EmpDetail;Persist Security Info=True;User ID=sa;Password=password@123;Provider=SQLOLEDB";

                    connection.Open(connectionstring);

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

                    rs.Open("select * from EmpSalary_Info where EmpId=" + txtid, connection);

                    rs.MoveFirst();

                    var span = document.createElement("span");

                    span.style.color = "Blue";

                    span.innerText = "  ID " + "  Name " + "   Salary";

                    document.body.appendChild(span);

                    while (!rs.eof)

                    {

                        var span = document.createElement("span");

                        span.style.color = "Red";

                        span.innerText = "\n " + rs.fields(0) + " |  " + rs.fields(1) + " |  " + rs.fields(2);

                        document.body.appendChild(span);

                        rs.MoveNext();

                        alert("Employee exit in Database");

                    }

                    rs.close();

                    connection.close();

                }

                else

                {

                    alert("Please Enter Employee Id In TextBox");

                }

        }

    </script>

    <style type="text/css">

        #main

        {

            height: 264px;

        }

    </style>

</head>

<body>

    <div id="show" style="font-size: x-large; font-weight: bold; height: 142px; color: #993333;">

        Employee Details<p style="font-size: medium; color: #000000;">

    Enter Employee Id&nbsp;

    <input id="txtid" type="text" /></p>  

<p>

    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

    <input id="ShowRecord" type="button" value="Show" onclick="ShowDB()" style="font-weight: bold" />&nbsp;</p>

    </div>

    </body>

</html>

 

Output 1

 First-image.jpg


Enter an employee id and then click on the "Show" button.

 second-image.jpg


Output 2

We are not entering a value into the TextBox and we click on the "Show" button.

 error-msg.jpg


For more information, download the attached sample application.

COMMENT USING

Trending up