<%@ 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 = 2 AND paese = 16 order by proprietary", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Response.Write (r("ID")) Response.Write ((" - ")) 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("Tasse")) Response.Write (("
")) End While r.Close() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Pianeti SET Tasse = 0 WHERE dimensione = 19 AND Reame = 2 AND paese = 16 ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() %>