<%@ 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" %> <% 'm_sql = "INSERT INTO Avv_Pugnale (Data_Avvistamento, Messaggio) VALUES (@Data_Avvistamento, @Messaggio)" 'm_conn = New SqlConnection(strConn) 'm_cmd = new SqlCommand 'm_cmd.connection = m_conn 'm_cmd.commandtext = m_sql 'm_cmd.Parameters.Add("@Data_Avvistamento", sqldbtype.datetime).Value = Datetime.Now 'm_cmd.Parameters.Add("@Messaggio", sqldbtype.varchar).Value = "a"' 'm_conn.Open 'm_cmd.ExecuteNonQuery 'm_conn.Close sqlConn.Open() sqlComm = New SqlCommand("SELECT * FROM Avv_Pugnale", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Response.Write (r("ID")) Response.Write ((" - ")) Response.Write (r("Data_Avvistamento")) Response.Write ((" - ")) Response.Write (r("Messaggio")) Response.Write (("
")) End While r.Close() sqlConn.Close() %>