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=400top=50left=50); while (!records.EOF) { Display.document.write(records(0) +   + records (1) +   + records(2)  -  + records (3)); Display.document.write( ); records.moveNext(); } records.Close(); }