Ciao a tutti espongo il mio problema: utilizzo visual web developer copio un database access in remoto nella cartella mdb-database poi creo una pagina aspx
e con il comando DetailsView genero lo script per interrogare il database, succede che riesco a visualizzare i dati, a modificarli, ma quando tento di aggiungere nuovi record mi da errore.
Questo è lo script che utilizzo
<%@ Page Language="VB" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
Protected Sub AccessDataSource1_Selecting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs)
End Sub
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Pagina senza titolo</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:DetailsView ID="DetailsView1" runat="server" AllowPaging="True" AutoGenerateRows="False"
DataKeyNames="ID" DataSourceID="AccessDataSource1" Height="50px" Width="125px">
<Fields>
<asp:BoundField DataField="Colore" HeaderText="Colore" SortExpression="Colore" />
<asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True"
SortExpression="ID" />
<asp:BoundField DataField="Nome" HeaderText="Nome" SortExpression="Nome" />
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ShowInsertButton="True" />
</Fields>
</asp:DetailsView>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" ConflictDetection="CompareAllValues"
DataFile="~/mdb-database/fapic.mdb" DeleteCommand="DELETE FROM [Nomi] WHERE [ID] = ? AND [Colore] = ? AND [Nome] = ?"
InsertCommand="INSERT INTO [Nomi] ([Colore], [ID], [Nome]) VALUES (?, ?, ?)"
OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [Nomi]"
UpdateCommand="UPDATE [Nomi] SET [Colore] = ?, [Nome] = ? WHERE [ID] = ? AND [Colore] = ? AND [Nome] = ?">
<DeleteParameters>
<asp:Parameter Name="original_ID" Type="Int32" />
<asp:Parameter Name="original_Colore" Type="String" />
<asp:Parameter Name="original_Nome" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="Colore" Type="String" />
<asp:Parameter Name="Nome" Type="String" />
<asp:Parameter Name="original_ID" Type="Int32" />
<asp:Parameter Name="original_Colore" Type="String" />
<asp:Parameter Name="original_Nome" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="Colore" Type="String" />
<asp:Parameter Name="ID" Type="Int32" />
<asp:Parameter Name="Nome" Type="String" />
</InsertParameters>
</asp:AccessDataSource>
</div>
</form>
</body>
</html>
cosa posso fare ?
10annidi.ASPItalia.com: iscriviti alla competizione e vinci fantastici premi ogni mese!