%@ Page Language="vb" Debug="true" %>
<% @Import NameSpace="System.Data" %>
<% @Import NameSpace="System.Data.SQLClient" %>
<% @Import NameSpace="System.Diagnostics.Debug" %>
<% @Import Namespace="System.Web.Mail" %>
<% @Import Namespace="System.Text.RegularExpressions" %>
<% @Import NameSpace="System.Data.OleDb" %>
<%@ Import namespace="System.IO" %>
<%@ Import namespace="System.Net" %>
<%
Dim Counter = 0
sqlConn.Open()
sqlComm = New SqlCommand("SELECT * FROM Utenti WHERE Attivo = 'Si' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Counter = Counter + 1
End While
r.Close()
sqlConn.Close()
response.write (counter)
%>
<%
Counter = 0
sqlConn.Open()
sqlComm = New SqlCommand("SELECT * FROM Utenti WHERE Attivo = 'No' AND ID < 5000 ORDER BY ID ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
response.write (r("ID"))
response.write (": ")
response.write (r("Username"))
response.write ("
")
Counter = Counter + 1
End While
r.Close()
sqlConn.Close()
response.write ("
")
response.write ("
")
response.write (counter)
'sqlConn.Open()
'sqlComm = New SqlCommand("DELETE FROM Utenti WHERE Attivo = 'No' AND ID < 2000 ",sqlConn)
'result = sqlComm.ExecuteNonQuery()
'sqlConn.Close()
%>