<%@ 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" %> <% Dim Id_Gilda = Request.QueryString ("Gilda") Dim There_Is = 0 sqlConn.Open() sqlComm = New SqlCommand("SELECT ID FROM Guilds_Requests WHERE Id_Utente = '"& Id_This_User &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() There_Is = 1 End While r.Close() sqlConn.Close() If There_Is > 0 Then Response.Write ("Hai già fatto richiesta a una gilda") End If If There_Is = 0 Then m_sql = "INSERT INTO Guilds_Requests (Id_Gilda, Id_Utente, Data_Richiesta) VALUES (@Id_Gilda, @Id_Utente, @Data_Richiesta)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Id_Gilda", sqldbtype.int).Value = Id_Gilda m_cmd.Parameters.Add("@Id_Utente", sqldbtype.int).Value = Id_This_User m_cmd.Parameters.Add("@Data_Richiesta", sqldbtype.datetime).Value = Datetime.Now m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close End If If There_Is = 0 Then Response.Write ("Richiesta inviata all'amministratore della gilda.") End If %>