<%@ 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 Codice = Request.QueryString("Codice") Dim Id_Missione = Request.QueryString("Id") If Codice = "Elimina" Then sqlConn.Open() sqlComm = New SqlCommand("DELETE FROM Missioni WHERE Id = '"& Id_Missione &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DELETE FROM Soldati_In_Missione WHERE Id_Missione = '"& Id_Missione &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() End If %>
<% Dim Times = 0 Dim Username = request.querystring ("username") sqlConn.Open() sqlComm = New SqlCommand("SELECT Ris_Legna, Ris_Pietra, Ris_Ferro, Ris_Zolfo, Ris_Oro, Quantity_Soldato, Type_Soldato, Type_Mission, Time_Started, Army_Of, Time_Arrive, Id FROM Missioni JOIN SOldati_In_Missione on Missioni.Id = SOldati_In_Missione.Id_Missione WHERE Army_Of = '"& Username &"' ORDER BY ID ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() If Times <> r("Id") Then Times = r("Id") %> <% End If %> <% End While r.Close() sqlConn.Close() %>
Nome Tipo Missione Tempo di Partenza Tempo di Arrivo Elimina
         
-------------------------------------------------------
<%=r("Army_Of")%> <%=r("Type_Mission")%> <%=r("Time_Started")%> <%=r("Time_Arrive")%> ">Elimina
         
Legna: <%=r("Ris_Legna")%> Pietra: <%=r("Ris_Pietra")%> Ferro: <%=r("Ris_Ferro")%> Zolfo: <%=r("Ris_Zolfo")%> Oro: <%=r("Ris_Oro")%>
         
<%=r("Type_Soldato")%> <%=r("Quantity_Soldato")%>