How to use JavaScript to get data from a SQL Server database

javascript|server|sqlserver| Data | How does a database use JavaScript to get data from a SQL Server database? ---------------------------------------------------------------var conn = new ActiveXObject ("ADODB. Connection "); Conn. Open ("Data source=190.190.200.100,1433;initial catalog=pubs; User Id=sa; PASSWORD=ASDASD; "); var strSQL = "Select * from Data"; var rs = new ActiveXObject ("ADODB. Recordset "); Rs. CursorType = 3; adOpenStatic Rs. LockType = 1; adLockReadOnly Rs. Open (strSQL, conn)---------------------------------------------------------------okay, you try.

Table Display Datasheet Record

All of the---------------------------------------------------------------upstairs are accessed using ADODB, for SQL Server 2000, you can go to reference SQLXML, which provides an ISAPI to support SQL Server direct query and modify on IIS the specific content should be 1. Allow URL Lookup 2. Allow Templates 3. Allow XPath 4. Allow post The specific information you refer to SQLXML 3.0, in the. NET environment also implements the managed class------------------------------------------------------------------------------- -----------------------------------------------JS reads data from the database--Test success: