<%response.buffer=true 'if request("admin")="" then ' response.redirect "login.asp" ' response.end 'end if set rs=server.createobject("ADODB.Recordset") set conn=server.createobject("ADODB.Connection") conn.Open "Provider=sqloledb; Data Source=prasgendb.db.10848931.hostedresource.com; Initial Catalog=prasgendb; User ID=prasgendb; Password='Gendb@prash12';" %> Admin

<% strsql="select count(*) from tbl_sap_campaign_teaser" rs.open strsql,conn mycnt=rs(0) rs.close() %>
View Data: Total:<%=mycnt%>
<% strsql="select * from tbl_sap_campaign_teaser" rs.open strsql,conn i=1 do until rs.eof=true%> <% i=i+1 rs.movenext loop rs.close() set rs=nothing set conn=nothing %>
SL NoSalutationFull NameOrganisationDesignationEmailMobile NoDate
<%=i%><%=rs("salutation")%><%=rs("fname")%><%=rs("companyname")%><%=rs("designation")%><%=rs("email")%><%=rs("mobile")%><%=rs("entry_date")%>
Download to Excel