I have been using gridviews to edit and delete data from my database and successfully made several pages to interact with my database. I am having a problem with my final page though. I do not get any errors when I run the page, but the data will not update or delete. I have included code below. I am hoping I just am overlooking something small and somebody will be able to notice my mistake.



<asp:GridView ID="GridView1" DataKeyNames="Date_Required,ItemNo,Purchase_Order_ No" runat="server" AutoGenerateColumns="False" DataSourceID="AccessDataSource3">

<Columns>

<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />

<asp:BoundField DataField="Date_Shipped" DataFormatString="{0:MM/dd/yyyy}" HeaderText="Date_Shipped"

HtmlEncode="False" SortExpression="Date_Shipped" />

<asp:BoundField DataField="Date_Required" DataFormatString="{0:MM/dd/yyyy}" HeaderText="Date_Required"

HtmlEncode="False" ReadOnly="True" SortExpression="Date_Required" />

<asp:BoundField DataField="Quantity_Shipped" HeaderText="Quantity_Shipped" SortExpression="Quantity_Shipped" ReadOnly="false" />

<asp:BoundField DataField="ItemNo" HeaderText="ItemNo" ReadOnly="True" SortExpression="ItemNo" />

<asp:BoundField DataField="Purchase_Order_No" HeaderText="Purchase_Order_No" ReadOnly="True"

SortExpression="Purchase_Order_No" />

<asp:BoundField DataField="Container_No" HeaderText="Container_No" SortExpression="Container_No" />

</Columns>

</asp:GridView>

<asp:AccessDataSource DataSourceMode="dataset" ID="AccessDataSource3" runat="server" DataFile="~/App_Data/customerandproduct.mdb"

DeleteCommand="DELETE * FROM [Shipment_Part] Where( [BolNo] = @BolNo AND [ItemNo] = @ItemNo AND [Date_Required] = @Date_Required AND [Purchase_Order_No] = @Purchase_Order_No)"

SelectCommand="SELECT [Date_Shipped], [Date_Required], [Quantity_Shipped], [ItemNo], [Purchase_Order_No], [Container_No], [BolNo] FROM [Shipment_part] WHERE ([BolNo] = ?)"

UpdateCommand="UPDATE [Shipment_Part] SET [Date_Shipped] = @Date_Shipped, [Quantity_Shipped] = @Quantity_Shipped, [Container_No] = @Container_No Where ([BolNo] = @BolNo AND [ItemNo] = @ItemNo AND [Date_Required] = @Date_Required AND [Purchase_Order_No] = @Purchase_Order_No)" >

<SelectParameters>

<asp:ControlParameter ControlID="DropDownList1" Name="BolNo" PropertyName="SelectedValue"

Type="String" />

</SelectParameters>

<UpdateParameters>

<asp:Parameter Name="Date_Shipped" Type="String" ></asp:Parameter>

<asp:Parameter Name="Quantity_Shipped" Type="Int64" ></asp:Parameter>

<asp:Parameter Name="Container_No" Type="String" ></asp:Parameter>

<asp:Parameter Name="BolNo" Type="String" ></asp:Parameter>

<asp:Parameter Name="ItemNo" Type="String" ></asp:Parameter>

<asp:Parameter Name="Date_Required" Type="String" ></asp:Parameter>

<asp:Parameter Name="Purchase_Order_No" Type="String" ></asp:Parameter>


</UpdateParameters>

</asp:AccessDataSource>