<%@ 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 Username, Password FROM Utenti WHERE password = 'akblaertoe1' ", sqlConn) 'sqlComm = New SqlCommand("SELECT Nome, Is_Principal FROM Pianeti WHERE Proprietary = 'stefanofrancini' ", sqlConn) 'sqlComm = New SqlCommand("SELECT * FROM Pianeti JOIN Generali ON Pianeti.Proprietary = Generali.Proprietary JOIN Utenti ON Utenti.Username = Pianeti.Proprietary WHERE Pianeti.Proprietary = 'stefanofrancini' AND Utenti.Username = 'stefanofrancini' AND Utenti.Password = '123abc&' ORDER BY Pianeti.ID ", sqlConn) sqlComm = New SqlCommand("SELECT Nome FROM Pianeti WHERE Dragon_Tooth = 1 ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() response.write (r("Nome")) response.write ("
") 'response.write (r("Is_Principal")) 'response.write ("
") End While r.Close() sqlConn.Close() %>