salve, dovrei inserire l'indirizzo del visitatore nel campo "Note" del DB Access.
come posso fare?
questo è parte del codice
<script runat="server">
Sub page_Load(ByVal sender As Object, ByVal e As EventArgs)
Dim userdata As String
Dim remote_IP As String = Request.ServerVariables("REMOTE_ADDR")
userdata = remote_IP
Response.Write("Your IP is: ")
Response.Write(userdata)
End Sub
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Insert Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="...........DB.mdb"
DeleteCommand="DELETE FROM [TABLE] WHERE [ID] = ?" InsertCommand="INSERT INTO [TABLE] ([Date], [Prefisso], [Telefono], [Campaign], [Cognome], [Nome], [Note], [Richiamato]) VALUES (?, ?, ?, ?, ?, ?, ?, ?)"
SelectCommand="SELECT * FROM [TABLE]" UpdateCommand="UPDATE [TABLE] SET [Date] = ?, [Prefisso] = ?, [Telefono] = ?, [Campaign] = ?, [Cognome] = ?, [Nome] = ?, [Note] = ?, [Codice] = ?, [Richiamato] = ? WHERE [ID] = ?">
<DeleteParameters>
<asp:Parameter Name="ID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="Date" Type="DateTime" />
<asp:Parameter Name="Prefisso" Type="String" />
Rispondi quotando