%@ 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()
%>