Editing table/datagrid in ASP

arstacey · 05-12-2006, 12:55 PM

I have created form that will show an Access table in a datagrid and allow me to edit and update the table. I am not getting any errors but when I click update, nothinn happens. The screen refreshes but the original data is still there. Can anyone tell me what I am doing wrong? Here is my source:

Code:

<%@ Page Language="VB" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">

<script runat="server">

</script>

<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
    <title>Editing Access Database</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>

<asp:gridview id="GridView1" runat="server" datakeynames="Cell_Phone"
    datasourceid="AccessDataSource1" AllowSorting="True" AutoGenerateDeleteButton="True" AutoGenerateEditButton="True"><Columns>
<asp:BoundField ReadOnly="True" DataField="Cell_Phone" SortExpression="Cell_Phone" HeaderText="Cell_Phone"></asp:BoundField>
<asp:BoundField DataField="Action_Date" SortExpression="Action_Date" HeaderText="Action_Date"></asp:BoundField>
<asp:BoundField DataField="First_Name" SortExpression="First_Name" HeaderText="First_Name"></asp:BoundField>
<asp:BoundField DataField="Last_Name" SortExpression="Last_Name" HeaderText="Last_Name"></asp:BoundField>
<asp:BoundField DataField="column1" SortExpression="column1" HeaderText="column1"></asp:BoundField>
<asp:BoundField DataField="Rate_Plan" SortExpression="Rate_Plan" HeaderText="Rate_Plan"></asp:BoundField>
<asp:BoundField DataField="Opt_Feature_1" SortExpression="Opt_Feature_1" HeaderText="Opt_Feature_1"></asp:BoundField>
<asp:BoundField DataField="Opt_Feature_2" SortExpression="Opt_Feature_2" HeaderText="Opt_Feature_2"></asp:BoundField>
<asp:BoundField DataField="Opt_Feature_3" SortExpression="Opt_Feature_3" HeaderText="Opt_Feature_3"></asp:BoundField>
<asp:BoundField DataField="Opt_Feature_4" SortExpression="Opt_Feature_4" HeaderText="Opt_Feature_4"></asp:BoundField>
<asp:BoundField DataField="Opt_Feature_5" SortExpression="Opt_Feature_5" HeaderText="Opt_Feature_5"></asp:BoundField>
<asp:BoundField DataField="Opt_Feature_6" SortExpression="Opt_Feature_6" HeaderText="Opt_Feature_6"></asp:BoundField>
<asp:BoundField DataField="Opt_Feature_7" SortExpression="Opt_Feature_7" HeaderText="Opt_Feature_7"></asp:BoundField>
<asp:BoundField DataField="Opt_Feature_8" SortExpression="Opt_Feature_8" HeaderText="Opt_Feature_8"></asp:BoundField>
<asp:BoundField DataField="Company_Comm_Due" SortExpression="Company_Comm_Due" HeaderText="Company_Comm_Due"></asp:BoundField>
<asp:BoundField DataField="Company_Comm_Paid" SortExpression="Company_Comm_Paid" HeaderText="Company_Comm_Paid"></asp:BoundField>
<asp:BoundField DataField="column2" SortExpression="column2" HeaderText="column2"></asp:BoundField>
<asp:BoundField DataField="SIM" SortExpression="SIM" HeaderText="SIM"></asp:BoundField>
</Columns>
</asp:gridview>
<asp:accessdatasource id="AccessDataSource1" runat="server" conflictdetection="CompareAllValues"
    datafile="~/files/WereWireless.mdb" deletecommand="DELETE FROM [Reconcile] WHERE [Cell Phone] = ? AND [Action Date] = ? AND [First Name] = ? AND [Last Name] = ? AND [Postal/ZIP Code] = ? AND [Rate Plan] = ? AND [Opt Feature 1] = ? AND [Opt Feature 2] = ? AND [Opt Feature 3] = ? AND [Opt Feature 4] = ? AND [Opt Feature 5] = ? AND [Opt Feature 6] = ? AND [Opt Feature 7] = ? AND [Opt Feature 8] = ? AND [Company Comm Due] = ? AND [Company Comm Paid] = ? AND [ESN/IMEI] = ? AND [SIM] = ?"
    insertcommand="INSERT INTO [Reconcile] ([Cell Phone], [Action Date], [First Name], [Last Name], [Postal/ZIP Code], [Rate Plan], [Opt Feature 1], [Opt Feature 2], [Opt Feature 3], [Opt Feature 4], [Opt Feature 5], [Opt Feature 6], [Opt Feature 7], [Opt Feature 8], [Company Comm Due], [Company Comm Paid], [ESN/IMEI], [SIM]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
    oldvaluesparameterformatstring="original_{0}" selectcommand="SELECT [Cell Phone] AS Cell_Phone, [Action Date] AS Action_Date, [First Name] AS First_Name, [Last Name] AS Last_Name, [Postal/ZIP Code] AS column1, [Rate Plan] AS Rate_Plan, [Opt Feature 1] AS Opt_Feature_1, [Opt Feature 2] AS Opt_Feature_2, [Opt Feature 3] AS Opt_Feature_3, [Opt Feature 4] AS Opt_Feature_4, [Opt Feature 5] AS Opt_Feature_5, [Opt Feature 6] AS Opt_Feature_6, [Opt Feature 7] AS Opt_Feature_7, [Opt Feature 8] AS Opt_Feature_8, [Company Comm Due] AS Company_Comm_Due, [Company Comm Paid] AS Company_Comm_Paid, [ESN/IMEI] AS column2, [SIM] FROM [Reconcile]"
    updatecommand="UPDATE [Reconcile] SET [Action Date] = ?, [First Name] = ?, [Last Name] = ?, [Postal/ZIP Code] = ?, [Rate Plan] = ?, [Opt Feature 1] = ?, [Opt Feature 2] = ?, [Opt Feature 3] = ?, [Opt Feature 4] = ?, [Opt Feature 5] = ?, [Opt Feature 6] = ?, [Opt Feature 7] = ?, [Opt Feature 8] = ?, [Company Comm Due] = ?, [Company Comm Paid] = ?, [ESN/IMEI] = ?, [SIM] = ? WHERE [Cell Phone] = ? AND [Action Date] = ? AND [First Name] = ? AND [Last Name] = ? AND [Postal/ZIP Code] = ? AND [Rate Plan] = ? AND [Opt Feature 1] = ? AND [Opt Feature 2] = ? AND [Opt Feature 3] = ? AND [Opt Feature 4] = ? AND [Opt Feature 5] = ? AND [Opt Feature 6] = ? AND [Opt Feature 7] = ? AND [Opt Feature 8] = ? AND [Company Comm Due] = ? AND [Company Comm Paid] = ? AND [ESN/IMEI] = ? AND [SIM] = ?"><DeleteParameters>
<asp:Parameter Type="String" Name="original_Cell_Phone"></asp:Parameter>
<asp:Parameter Type="String" Name="original_Action_Date"></asp:Parameter>
<asp:Parameter Type="String" Name="original_First_Name"></asp:Parameter>
<asp:Parameter Type="String" Name="original_Last_Name"></asp:Parameter>
<asp:Parameter Type="String" Name="original_column1"></asp:Parameter>
<asp:Parameter Type="String" Name="original_Rate_Plan"></asp:Parameter>
<asp:Parameter Type="String" Name="original_Opt_Feature_1"></asp:Parameter>
<asp:Parameter Type="String" Name="original_Opt_Feature_2"></asp:Parameter>
<asp:Parameter Type="String" Name="original_Opt_Feature_3"></asp:Parameter>
<asp:Parameter Type="String" Name="original_Opt_Feature_4"></asp:Parameter>
<asp:Parameter Type="String" Name="original_Opt_Feature_5"></asp:Parameter>
<asp:Parameter Type="String" Name="original_Opt_Feature_6"></asp:Parameter>
<asp:Parameter Type="String" Name="original_Opt_Feature_7"></asp:Parameter>
<asp:Parameter Type="String" Name="original_Opt_Feature_8"></asp:Parameter>
<asp:Parameter Type="String" Name="original_Company_Comm_Due"></asp:Parameter>
<asp:Parameter Type="String" Name="original_Company_Comm_Paid"></asp:Parameter>
<asp:Parameter Type="String" Name="original_column2"></asp:Parameter>
<asp:Parameter Type="String" Name="original_SIM"></asp:Parameter>
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Type="String" Name="Action_Date"></asp:Parameter>
<asp:Parameter Type="String" Name="First_Name"></asp:Parameter>
<asp:Parameter Type="String" Name="Last_Name"></asp:Parameter>
<asp:Parameter Type="String" Name="column1"></asp:Parameter>
<asp:Parameter Type="String" Name="Rate_Plan"></asp:Parameter>
<asp:Parameter Type="String" Name="Opt_Feature_1"></asp:Parameter>
<asp:Parameter Type="String" Name="Opt_Feature_2"></asp:Parameter>
<asp:Parameter Type="String" Name="Opt_Feature_3"></asp:Parameter>
<asp:Parameter Type="String" Name="Opt_Feature_4"></asp:Parameter>
<asp:Parameter Type="String" Name="Opt_Feature_5"></asp:Parameter>
<asp:Parameter Type="String" Name="Opt_Feature_6"></asp:Parameter>
<asp:Parameter Type="String" Name="Opt_Feature_7"></asp:Parameter>
<asp:Parameter Type="String" Name="Opt_Feature_8"></asp:Parameter>
<asp:Parameter Type="String" Name="Company_Comm_Due"></asp:Parameter>
<asp:Parameter Type="String" Name="Company_Comm_Paid"></asp:Parameter>
<asp:Parameter Type="String" Name="column2"></asp:Parameter>
<asp:Parameter Type="String" Name="SIM"></asp:Parameter>
<asp:Parameter Type="String" Name="original_Cell_Phone"></asp:Parameter>
<asp:Parameter Type="String" Name="original_Action_Date"></asp:Parameter>
<asp:Parameter Type="String" Name="original_First_Name"></asp:Parameter>
<asp:Parameter Type="String" Name="original_Last_Name"></asp:Parameter>
<asp:Parameter Type="String" Name="original_column1"></asp:Parameter>
<asp:Parameter Type="String" Name="original_Rate_Plan"></asp:Parameter>
<asp:Parameter Type="String" Name="original_Opt_Feature_1"></asp:Parameter>
<asp:Parameter Type="String" Name="original_Opt_Feature_2"></asp:Parameter>
<asp:Parameter Type="String" Name="original_Opt_Feature_3"></asp:Parameter>
<asp:Parameter Type="String" Name="original_Opt_Feature_4"></asp:Parameter>
<asp:Parameter Type="String" Name="original_Opt_Feature_5"></asp:Parameter>
<asp:Parameter Type="String" Name="original_Opt_Feature_6"></asp:Parameter>
<asp:Parameter Type="String" Name="original_Opt_Feature_7"></asp:Parameter>
<asp:Parameter Type="String" Name="original_Opt_Feature_8"></asp:Parameter>
<asp:Parameter Type="String" Name="original_Company_Comm_Due"></asp:Parameter>
<asp:Parameter Type="String" Name="original_Company_Comm_Paid"></asp:Parameter>
<asp:Parameter Type="String" Name="original_column2"></asp:Parameter>
<asp:Parameter Type="String" Name="original_SIM"></asp:Parameter>
</UpdateParameters>
<InsertParameters>
<asp:Parameter Type="String" Name="Cell_Phone"></asp:Parameter>
<asp:Parameter Type="String" Name="Action_Date"></asp:Parameter>
<asp:Parameter Type="String" Name="First_Name"></asp:Parameter>
<asp:Parameter Type="String" Name="Last_Name"></asp:Parameter>
<asp:Parameter Type="String" Name="column1"></asp:Parameter>
<asp:Parameter Type="String" Name="Rate_Plan"></asp:Parameter>
<asp:Parameter Type="String" Name="Opt_Feature_1"></asp:Parameter>
<asp:Parameter Type="String" Name="Opt_Feature_2"></asp:Parameter>
<asp:Parameter Type="String" Name="Opt_Feature_3"></asp:Parameter>
<asp:Parameter Type="String" Name="Opt_Feature_4"></asp:Parameter>
<asp:Parameter Type="String" Name="Opt_Feature_5"></asp:Parameter>
<asp:Parameter Type="String" Name="Opt_Feature_6"></asp:Parameter>
<asp:Parameter Type="String" Name="Opt_Feature_7"></asp:Parameter>
<asp:Parameter Type="String" Name="Opt_Feature_8"></asp:Parameter>
<asp:Parameter Type="String" Name="Company_Comm_Due"></asp:Parameter>
<asp:Parameter Type="String" Name="Company_Comm_Paid"></asp:Parameter>
<asp:Parameter Type="String" Name="column2"></asp:Parameter>
<asp:Parameter Type="String" Name="SIM"></asp:Parameter>
</InsertParameters>
</asp:accessdatasource>
</div>
    </form>
</body>
</html>