<%@ 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() %>