SQL Statement in Java Script

Question

How to use SQL Query in JavaScript in ASP.Net? If this is not possible can you suggest me on alternate plss Thank you

Scott Lysle · Answer

The alternative would be to use server side code; I don't think you really want to put this into your javascript but if you want to use javascript, try something like this: function GetSomeData() { var records; var dataSource; var sqlStatement; var Display; records = new ActiveXObject("ADODB.Recordset"); dataSource= new ActiveXObject("ADODB.Connection"); dataSource.Open ("Provider=SQLOLEDB.1;Persist Security Info=False;User ID=SomeUseId;Initial Catalog=Northwind;Data Source=DatabaseServername; pwd=snigglefritz!01"); sqlStatement = ("select firstNam, middleName, lastName, phoneNumber from Customers"); records.Open (sqlStatement, dataSource); Display = window.open("","","width=500, height=400,top=50,left=50"); while (!records.EOF) { Display.document.write(records(0) + " " + records (1) + " " + records(2) " - " + records (3)); Display.document.write(" "); records.moveNext(); } records.Close(); }

SQL Statement in Java Script

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (1)