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