<%@ 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" %> <%@ Import namespace="System.Drawing" %> <% Dim Utente = Request.QueryString("Utente") sqlConn.Open() sqlComm = New SqlCommand("SELECT * FROM Pianeti WHERE Pianeti.Proprietary = '"& Utente &"' And Is_Principal = 1 ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Response.write ("In Cittą: ") Response.write (r("E_Generale")) %>
<% End While r.Close() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("SELECT * FROM Generali WHERE Proprietary = '"& Utente &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Response.write ("E' Morto: ") Response.write (r("Is_Dead")) %>
<% End While r.Close() sqlConn.Close() Response.write ("Ha Missioni: ") sqlConn.Open() sqlComm = New SqlCommand("SELECT * FROM Missioni WHERE Army_Of = '"& Utente &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Response.write ("Si") %>
><% End While r.Close() sqlConn.Close() %>