Non riesco a effettuare l'inserimento di record nel database, ma non mi da alcun errore...
Non so come fare.
Questo è il codice:
<%@ Page Language="VB" %>
<%@ Register TagPrefix="wmx" Namespace="Microsoft.Matrix.Framework.Web.UI" Assembly="Microsoft.Matrix.Framework, Version=0.6.0.0, Culture=neutral, PublicKeyToken=6f763c9966660626" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.OleDb" %>
<script runat="server">
Sub Insert(obj As Object, e As EventArgs)
Dim TesseraAvis = 45
Dim dataP = "13/02/2000"
Dim tipoP = "xxxxx"
Dim ConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=C:\Documents and Settings\Amico\Desktop\prova\ultima prova\prova login senza database e senza webconfig\database.mdb"
Dim CommandText As String = "INSERT INTO Prenotazioni VALUES (" & TesseraAvis & ", " & dataP & ", " & tipoP & ")"
Dim myConnection As New OleDbConnection(ConnectionString)
Dim myCommand As New oleDbCommand(CommandText, myConnection)
myConnection.Open()
myConnection.Close()
End Sub
</script>
<html>
<head>
</head>
<body style="FONT-FAMILY: arial">
<h2>Inserisci nuovo donatore
</h2>
<hr size="1" />
<form runat="server">
<asp:Label id="Label1" runat="server">Tessera Avis</asp:Label>
<asp:TextBox id="Tessera" runat="server"></asp:TextBox>
<asp:Label id="Label4" runat="server">Data</asp:Label>
<asp:TextBox id="data" runat="server"></asp:TextBox>
</p>
<asp:Label id="Label2" runat="server">Tipo</asp:Label>
<asp:TextBox id="tipo" runat="server"></asp:TextBox>
</p>
</p>
</p>
</p>
<asp:Button id="Button1" onclick="Insert" runat="server" Text="Inserisci"></asp:Button>
</p>
</form>
</body>
</html>
Rispondi quotando
