<%@ 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("UPDATE Pianeti SET Data_Costr_Infr = '03/21/2006 19:53:43', Data_Fine_Infr = '03/21/2006 23:33:43' WHERE ID = 2 ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() 'sqlConn.Open() 'sqlComm = New SqlCommand("UPDATE Pianeti SET In_Costr_Infr = 'No', Cosa_Costr_Infr = '' WHERE Id = 476 ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() 'sqlConn.Open() 'sqlComm = New SqlCommand("UPDATE Missioni SET Time_Arrive = '03/15/2006 19:40:54' WHERE ID = 370 ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() 'sqlConn.Open() 'sqlComm = New SqlCommand("UPDATE Pianeti SET Proprietary = 'Asgow' WHERE Dimensione = 2 AND Reame = 1 AND Paese = 28 ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() 'sqlConn.Open() 'sqlComm = New SqlCommand("UPDATE Pianeti SET Proprietary = 'asgow' WHERE Proprietary = 'Asgow' ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() 'sqlConn.Open() 'sqlComm = New SqlCommand("UPDATE Item_Quest SET Id_Utente = 995 ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() SqlConn.Open() sqlComm = New SqlCommand("UPDATE Utenti SET Premium_Data = '11/12/2006 21:25:07' WHERE ID = '863' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() 'sqlConn.Open() 'sqlComm = New SqlCommand("DELETE CODE ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() 'sqlConn.Open() 'sqlComm = New SqlCommand("UPDATE Edifici SET C_Costr_1 = 18, C_Costr_2 = 200, C_Costr_3 = 10, C_Costr_4 = 10, C_Costr_5 = 10, C_Costr_6 = 10, C_Costr_7 = 15, C_Costr_8 = 15, C_Costr_9 = 10, C_Costr_10 = 10, C_Costr_11 = 5, C_Costr_12 = 5, C_Costr_13 = 5, C_Costr_14 = 5, C_Costr_15 = 10 WHERE Id_Paese = 1608 ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() 'sqlConn.Open() 'sqlComm = New SqlCommand("UPDATE Ricerche SET R_Ric_1 = 10, R_Ric_2 = 10, R_Ric_3 = 10, R_Ric_4 = 10, R_Ric_5 = 10, R_Ric_6 = 10, R_Ric_7 = 10 WHERE Id_Paese = 1608 ",sqlConn) 'result = sqlComm.ExecuteNonQuery() 'sqlConn.Close() %>