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
<input id="txtid" type="text" /></p>
<p>
<input id="ShowRecord" type="button" value="Show" onclick="ShowDB()" style="font-weight: bold" /> </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.