<%@ Language=VBScript %>
<% Response.Buffer=true%>
<%
set remoteConn = Server.CreateObject("ADODB.Connection")%>
remoteConn.Open "FILEDSN","uid","pwd"%>
<%
'code by Manikantan
'Web Developer
'3rd Agenda
'Nungambakkam, Chennai India
%>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<SCRIPT LANGUAGE="Javascript">
var arr = new Array()
var arr1 =new Array()
<% sql="select name,e_mail from emptable" %>
<% set rec11=remoteconn.execute(sql) %>
<% counter1=0 %>
<% while not rec11.eof %>
<% response.write "arr" & "[" & counter1 & "]" & "=" & rec11.fields(0)& ";" %>
<% response.write "arr1" & "[" & counter1 & "]" & "=" & rec11.fields(1)& ";" %>
<% counter1=counter1+1 %>
<% rec11.movenext %>
<% wend %>
<% set rec11= nothing %>
</script>
| <body>
This page contains an array that can be accessed by javascript...
The array values are populated in the server with server side objects..
</body>
</html>
|
ASP Code 
ASP.NET Export to Excel and Word using VB.NET and C#
