<%@ 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 i = 0 Dim Data = Datetime.now.AddDays(-60) Data = Format_Date(Data) sqlConn.Open() sqlComm = New SqlCommand("SELECT Vacanza.Id as Id_Vacanza, Utenti.Id as Id_Utente, Username, Data_Last_Access, Proprietary, Is_Principal FROM Utenti JOIN Pianeti ON Utenti.Username = Pianeti.Proprietary LEFT JOIN Vacanza ON Utenti.Id = Vacanza.Id_Utente WHERE Pianeti.Is_Principal = 1 AND Data_Last_Access < '"& Data &"' ORDER BY Data_Last_Access", sqlConn) r = sqlComm.ExecuteReader() While r.Read() If r("Id_Vacanza") Is System.DbNull.Value Then i = i + 1 %> <% End If End While r.Close() sqlConn.Close() %>
Nome Data Last Access Elimina
       
<%=i%> <%=r("Username")%> <%=r("Data_Last_Access")%> ">Elimina