<%@ 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" %> <% sqlConn.Open() sqlComm = New SqlCommand("SELECT Id_Utente, Vacanza.Id as Id_Vacanza, Vacanza.Data_Inizio, Utenti.Username FROM Vacanza JOIN Utenti ON Vacanza.Id_Utente = Utenti.Id ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Response.Write (r("Id_Vacanza")) Response.Write (" : ") Response.Write (r("username")) Response.Write (" : ") Response.Write (r("Data_Inizio")) Response.Write ("
") End While r.Close() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DELETE FROM Vacanza WHERE ID = 841 ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() %>