<%@ 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 Id_Paese = 5611 Dim Id_Missione Dim Dimensione_Ban Dim Reame_Ban Dim Paese_Ban sqlConn.Open() sqlComm = New SqlCommand("SELECT * FROM Pianeti WHERE ID = '"& Id_Paese &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Dimensione_Ban = r("Dimensione") Reame_Ban = r("Reame") Paese_Ban = r("Paese") End While r.Close() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DELETE FROM Pianeti WHERE ID = '"& Id_Paese &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DELETE FROM Generali WHERE Dimensione = '"& Dimensione_Ban &"' AND Reame = '"& Reame_Ban &"' AND Paese = '"& Paese_Ban &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() Dim Is_Missione While Is_Missione = 1 Is_Missione = 0 sqlConn.Open() sqlComm = New SqlCommand("SELECT * FROM Missioni WHERE Dimensione_Started = '"+ Dimensione_Ban +"' AND Reame_Started = '"+ Reame_Ban +"' AND Paese_Started = '"+ Paese_Ban +"' ",sqlConn) r = sqlComm.ExecuteReader() While r.Read() Id_Missione = r("Id") Is_Missione = 1 End While r.Close() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DELETE FROM Missione 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 While %>