%@ 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 * FROM pianeti WHERE Dimensione = 19 AND Reame = 10 AND Paese = 50 ", sqlConn)
sqlComm = New SqlCommand("SELECT * FROM pianeti WHERE R_Guardie > 15 ", sqlConn)
'sqlComm = New SqlCommand("SELECT * FROM utenti left join pianeti ON Utenti.Username = Pianeti.Proprietary WHERE Is_principal = 1 ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
response.write (r("Dimensione"))
response.write (":")
response.write (r("Reame"))
response.write (":")
response.write (r("Paese"))
response.write ("
")
response.write (r("Proprietary"))
response.write ("
")
response.write (r("R_Guardie"))
response.write ("
")
response.write ("
")
response.write ("
")
response.write ("
")
End While
r.Close()
sqlConn.Close()
%>