How to insert and access SQLServer DB using HTML,Javascript

Hi,

I am trying to insert data into SQL Server by using HTML5, CSS3 and JAVASCRIPT. After press a button all the values should store in the database and again access data from SQL Server and display in HTML5 table. But I can't understand how to do it. I am using Visual Studio 2010 for creating HTML pages and SQL Server Database.

Can any help me for finding correct solution for this?

I am unable to find working solution for this in Google search. Actually I found one solution for inserting and accessing data from SQL server. But it is not working.

I tried bellow code:

Source Link:

http://www.c-sharpcorner.com/uploadfile/5089e0/insert-record-in-database-using-textboxes-in-javascript/

Code: I followed all the steps as same in above link.

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

<head>

<title>title>

function InsertRecord()

{

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

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

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

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

if (txtid.length != 0 || txtname.length !=0 || txtsalary.length !=0|| txtcity.length !=0)

{

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

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

connection.Open(connectionstring);

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

rs.Open("insert into Emp_Info values('" + txtid + "','" + txtname + "','" + txtsalary + "','" + txtcity + "')", connection);

alert("Insert Record Successfuly");

txtid.value = " ";

connection.close();

}

else

{

alert("Please Enter Employee \n Id \n Name \n Salary \n City ");

}

function ShowAll()

{

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

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

connection.Open(connectionstring);

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

rs.Open("select * from Emp_Info ", connection);

rs.MoveFirst();

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

span.style.color = "Blue";

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

document.body.appendChild(span);

while (!rs.eof)

{

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

span.style.color = "green";

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

document.body.appendChild(span);

rs.MoveNext();

}

rs.close();

connection.close();

}

script>

#main

{

height: 264px;

}

#ShowRecord

{

width: 67px;

z-index: 1;

left: 20px;

top: 257px;

position: absolute;

}

#showall

{

z-index: 1;

left: 114px;

top: 257px;

position: absolute;

}

style>

head>

<div id="show"

style="font-size: x-large; font-weight: bold; height: 298px; color: #009999;">

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

Employee Id

Name

Salary

City

body>

html>

When I try to insert or access data by using above code it displays following error.

Error Description:

“JavaScript runtime error: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done”.

I tried to found solution for above error in that process I got below information about activeX object method.

Link for Refer:

https://support.microsoft.com/en-in/kb/269495

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bikesh Srivastava10y ago
Hi ,
http://www.c-sharpcorner.com/UploadFile/5089e0/insert-record-in-database-using-textboxes-in-javascript/
Nitin Sontakke10y ago
You are writing a web-application. That means the code you have written is going to execute on a client machine. Which means, you don't want to show all of the code to your user.
You will need a way to post all these values to the server. On server side C# code you will connect to database and save values there.
Same to do in reverse order to show values on the form again.
Personally, I will be dead surprised, if you could connect to db from javaScript. Even if you do, whole world would know your connection string to db and would easily connect without ever using application.
Midhun Tp10y ago
Hi,
Have you tried resolution methods specified in this link?
https://support.microsoft.com/en-in/kb/269495