0

Plz Help me

I'm creating a form-View in asp.net 2010 and successfully upload all my data on the Form View but my problem arise when i edit the data in the form, it does not update the data. Following is my code.

<%@ Page Title="" Language="VB" MasterPageFile="~/Site.master" AutoEventWireup="false" CodeFile="Default2.aspx.vb" Inherits="Default2" %>

<%@ Register assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" namespace="Microsoft.Reporting.WebForms" tagprefix="rsweb" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">
    <style type="text/css">
        .style1
        {
            font-size: large;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">
    <asp:FormView ID="FormView1" runat="server" AllowPaging="True" CellPadding="4" 
        DataKeyNames="QuotationNo" DataSourceID="AccessDataSource1" ForeColor="#333333" 
        style="font-size: large" Width="893px">
        <EditItemTemplate>
            QuotationNo:
            <asp:Label ID="QuotationNoLabel1" runat="server" 
                Text='<%# Eval("QuotationNo") %>' />
            <br />
            Procurement_Title:
            <asp:TextBox ID="Procurement_TitleTextBox" runat="server" 
                Text='<%# Bind("Procurement_Title") %>' />
            <br />
            Estimated_Cost:
            <asp:TextBox ID="Estimated_CostTextBox" runat="server" 
                Text='<%# Bind("Estimated_Cost") %>' />
            <br />
            Earmarking_Date:
            <asp:TextBox ID="Earmarking_DateTextBox" runat="server" 
                Text='<%# Bind("Earmarking_Date") %>' />
            <br />
            Approved_by_Committee_Date:
            <asp:TextBox ID="Approved_by_Committee_DateTextBox" runat="server" 
                Text='<%# Bind("Approved_by_Committee_Date") %>' />
            <br />
            Documents_Prepared:
            <asp:TextBox ID="Documents_PreparedTextBox" runat="server" 
                Text='<%# Bind("Documents_Prepared") %>' />
            <br />
            Vetted_Date:
            <asp:TextBox ID="Vetted_DateTextBox" runat="server" 
                Text='<%# Bind("Vetted_Date") %>' />
            <br />
            Launched_Date:
            <asp:TextBox ID="Launched_DateTextBox" runat="server" 
                Text='<%# Bind("Launched_Date") %>' />
            <br />
            Closing_Date:
            <asp:TextBox ID="Closing_DateTextBox" runat="server" 
                Text='<%# Bind("Closing_Date") %>' />
            <br />
            Supplier_1:
            <asp:TextBox ID="Supplier_1TextBox" runat="server" 
                Text='<%# Bind("Supplier_1") %>' />
            <br />
            Received1:
            <asp:CheckBox ID="Received1CheckBox" runat="server" 
                Checked='<%# Bind("Received1") %>' />
            <br />
            Supplier_2:
            <asp:TextBox ID="Supplier_2TextBox" runat="server" 
                Text='<%# Bind("Supplier_2") %>' />
            <br />
            Received2:
            <asp:CheckBox ID="Received2CheckBox" runat="server" 
                Checked='<%# Bind("Received2") %>' />
            <br />
            Supplier_3:
            <asp:TextBox ID="Supplier_3TextBox" runat="server" 
                Text='<%# Bind("Supplier_3") %>' />
            <br />
            Received3:
            <asp:CheckBox ID="Received3CheckBox" runat="server" 
                Checked='<%# Bind("Received3") %>' />
            <br />
            Supplier_4:
            <asp:TextBox ID="Supplier_4TextBox" runat="server" 
                Text='<%# Bind("Supplier_4") %>' />
            <br />
            Received4:
            <asp:CheckBox ID="Received4CheckBox" runat="server" 
                Checked='<%# Bind("Received4") %>' />
            <br />
            Supplier_5:
            <asp:TextBox ID="Supplier_5TextBox" runat="server" 
                Text='<%# Bind("Supplier_5") %>' />
            <br />
            Received5:
            <asp:CheckBox ID="Received5CheckBox" runat="server" 
                Checked='<%# Bind("Received5") %>' />
            <br />
            Supplier_6:
            <asp:TextBox ID="Supplier_6TextBox" runat="server" 
                Text='<%# Bind("Supplier_6") %>' />
            <br />
            Received6:
            <asp:CheckBox ID="Received6CheckBox" runat="server" 
                Checked='<%# Bind("Received6") %>' />
            <br />
            Supplier_7:
            <asp:TextBox ID="Supplier_7TextBox" runat="server" 
                Text='<%# Bind("Supplier_7") %>' />
            <br />
            Received7:
            <asp:CheckBox ID="Received7CheckBox" runat="server" 
                Checked='<%# Bind("Received7") %>' />
            <br />
            Supplier_8:
            <asp:TextBox ID="Supplier_8TextBox" runat="server" 
                Text='<%# Bind("Supplier_8") %>' />
            <br />
            Received8:
            <asp:CheckBox ID="Received8CheckBox" runat="server" 
                Checked='<%# Bind("Received8") %>' />
            <br />
            Supplier_9:
            <asp:TextBox ID="Supplier_9TextBox" runat="server" 
                Text='<%# Bind("Supplier_9") %>' />
            <br />
            Received9:
            <asp:CheckBox ID="Received9CheckBox" runat="server" 
                Checked='<%# Bind("Received9") %>' />
            <br />
            Supplier_10:
            <asp:TextBox ID="Supplier_10TextBox" runat="server" 
                Text='<%# Bind("Supplier_10") %>' />
            <br />
            Received10:
            <asp:CheckBox ID="Received10CheckBox" runat="server" 
                Checked='<%# Bind("Received10") %>' />
            <br />
            Supplier_11:
            <asp:TextBox ID="Supplier_11TextBox" runat="server" 
                Text='<%# Bind("Supplier_11") %>' />
            <br />
            Received11:
            <asp:CheckBox ID="Received11CheckBox" runat="server" 
                Checked='<%# Bind("Received11") %>' />
            <br />
            Supplier_12:
            <asp:TextBox ID="Supplier_12TextBox" runat="server" 
                Text='<%# Bind("Supplier_12") %>' />
            <br />
            Received12:
            <asp:CheckBox ID="Received12CheckBox" runat="server" 
                Checked='<%# Bind("Received12") %>' />
            <br />
            Chairperson:
            <asp:TextBox ID="ChairpersonTextBox" runat="server" 
                Text='<%# Bind("Chairperson") %>' />
            <br />
            Member1:
            <asp:TextBox ID="Member1TextBox" runat="server" Text='<%# Bind("Member1") %>' />
            <br />
            Member2:
            <asp:TextBox ID="Member2TextBox" runat="server" Text='<%# Bind("Member2") %>' />
            <br />
            EvaluationSubmitted:
            <asp:TextBox ID="EvaluationSubmittedTextBox" runat="server" 
                Text='<%# Bind("EvaluationSubmitted") %>' />
            <br />
            BidsCompletedDate:
            <asp:TextBox ID="BidsCompletedDateTextBox" runat="server" 
                Text='<%# Bind("BidsCompletedDate") %>' />
            <br />
            DateDTC:
            <asp:TextBox ID="DateDTCTextBox" runat="server" Text='<%# Bind("DateDTC") %>' />
            <br />
            DecisionDTC:
            <asp:TextBox ID="DecisionDTCTextBox" runat="server" 
                Text='<%# Bind("DecisionDTC") %>' />
            <br />
            DateRefProcurementDiv:
            <asp:TextBox ID="DateRefProcurementDivTextBox" runat="server" 
                Text='<%# Bind("DateRefProcurementDiv") %>' />
            <br />
            AwardedDate:
            <asp:TextBox ID="AwardedDateTextBox" runat="server" 
                Text='<%# Bind("AwardedDate") %>' />
            <br />
            <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" 
                CommandName="Update" Text="Update" />
            &nbsp;<asp:LinkButton ID="UpdateCancelButton" runat="server" 
                CausesValidation="False" CommandName="Cancel" Text="Cancel" />
        </EditItemTemplate>
        <EditRowStyle BackColor="#999999" />
        <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
        <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
        <InsertItemTemplate>
            QuotationNo:
            <asp:TextBox ID="QuotationNoTextBox" runat="server" 
                Text='<%# Bind("QuotationNo") %>' />
            <br />
            Procurement_Title:
            <asp:TextBox ID="Procurement_TitleTextBox" runat="server" 
                Text='<%# Bind("Procurement_Title") %>' />
            <br />
            Estimated_Cost:
            <asp:TextBox ID="Estimated_CostTextBox" runat="server" 
                Text='<%# Bind("Estimated_Cost") %>' />
            <br />
            Earmarking_Date:
            <asp:TextBox ID="Earmarking_DateTextBox" runat="server" 
                Text='<%# Bind("Earmarking_Date") %>' />
            <br />
            Approved_by_Committee_Date:
            <asp:TextBox ID="Approved_by_Committee_DateTextBox" runat="server" 
                Text='<%# Bind("Approved_by_Committee_Date") %>' />
            <br />
            Documents_Prepared:
            <asp:TextBox ID="Documents_PreparedTextBox" runat="server" 
                Text='<%# Bind("Documents_Prepared") %>' />
            <br />
            Vetted_Date:
            <asp:TextBox ID="Vetted_DateTextBox" runat="server" 
                Text='<%# Bind("Vetted_Date") %>' />
            <br />
            Launched_Date:
            <asp:TextBox ID="Launched_DateTextBox" runat="server" 
                Text='<%# Bind("Launched_Date") %>' />
            <br />
            Closing_Date:
            <asp:TextBox ID="Closing_DateTextBox" runat="server" 
                Text='<%# Bind("Closing_Date") %>' />
            <br />
            Supplier_1:
            <asp:TextBox ID="Supplier_1TextBox" runat="server" 
                Text='<%# Bind("Supplier_1") %>' />
            <br />
            Received1:
            <asp:CheckBox ID="Received1CheckBox" runat="server" 
                Checked='<%# Bind("Received1") %>' />
            <br />
            Supplier_2:
            <asp:TextBox ID="Supplier_2TextBox" runat="server" 
                Text='<%# Bind("Supplier_2") %>' />
            <br />
            Received2:
            <asp:CheckBox ID="Received2CheckBox" runat="server" 
                Checked='<%# Bind("Received2") %>' />
            <br />
            Supplier_3:
            <asp:TextBox ID="Supplier_3TextBox" runat="server" 
                Text='<%# Bind("Supplier_3") %>' />
            <br />
            Received3:
            <asp:CheckBox ID="Received3CheckBox" runat="server" 
                Checked='<%# Bind("Received3") %>' />
            <br />
            Supplier_4:
            <asp:TextBox ID="Supplier_4TextBox" runat="server" 
                Text='<%# Bind("Supplier_4") %>' />
            <br />
            Received4:
            <asp:CheckBox ID="Received4CheckBox" runat="server" 
                Checked='<%# Bind("Received4") %>' />
            <br />
            Supplier_5:
            <asp:TextBox ID="Supplier_5TextBox" runat="server" 
                Text='<%# Bind("Supplier_5") %>' />
            <br />
            Received5:
            <asp:CheckBox ID="Received5CheckBox" runat="server" 
                Checked='<%# Bind("Received5") %>' />
            <br />
            Supplier_6:
            <asp:TextBox ID="Supplier_6TextBox" runat="server" 
                Text='<%# Bind("Supplier_6") %>' />
            <br />
            Received6:
            <asp:CheckBox ID="Received6CheckBox" runat="server" 
                Checked='<%# Bind("Received6") %>' />
            <br />
            Supplier_7:
            <asp:TextBox ID="Supplier_7TextBox" runat="server" 
                Text='<%# Bind("Supplier_7") %>' />
            <br />
            Received7:
            <asp:CheckBox ID="Received7CheckBox" runat="server" 
                Checked='<%# Bind("Received7") %>' />
            <br />
            Supplier_8:
            <asp:TextBox ID="Supplier_8TextBox" runat="server" 
                Text='<%# Bind("Supplier_8") %>' />
            <br />
            Received8:
            <asp:CheckBox ID="Received8CheckBox" runat="server" 
                Checked='<%# Bind("Received8") %>' />
            <br />
            Supplier_9:
            <asp:TextBox ID="Supplier_9TextBox" runat="server" 
                Text='<%# Bind("Supplier_9") %>' />
            <br />
            Received9:
            <asp:CheckBox ID="Received9CheckBox" runat="server" 
                Checked='<%# Bind("Received9") %>' />
            <br />
            Supplier_10:
            <asp:TextBox ID="Supplier_10TextBox" runat="server" 
                Text='<%# Bind("Supplier_10") %>' />
            <br />
            Received10:
            <asp:CheckBox ID="Received10CheckBox" runat="server" 
                Checked='<%# Bind("Received10") %>' />
            <br />
            Supplier_11:
            <asp:TextBox ID="Supplier_11TextBox" runat="server" 
                Text='<%# Bind("Supplier_11") %>' />
            <br />
            Received11:
            <asp:CheckBox ID="Received11CheckBox" runat="server" 
                Checked='<%# Bind("Received11") %>' />
            <br />
            Supplier_12:
            <asp:TextBox ID="Supplier_12TextBox" runat="server" 
                Text='<%# Bind("Supplier_12") %>' />
            <br />
            Received12:
            <asp:CheckBox ID="Received12CheckBox" runat="server" 
                Checked='<%# Bind("Received12") %>' />
            <br />
            Chairperson:
            <asp:TextBox ID="ChairpersonTextBox" runat="server" 
                Text='<%# Bind("Chairperson") %>' />
            <br />
            Member1:
            <asp:TextBox ID="Member1TextBox" runat="server" Text='<%# Bind("Member1") %>' />
            <br />
            Member2:
            <asp:TextBox ID="Member2TextBox" runat="server" Text='<%# Bind("Member2") %>' />
            <br />
            EvaluationSubmitted:
            <asp:TextBox ID="EvaluationSubmittedTextBox" runat="server" 
                Text='<%# Bind("EvaluationSubmitted") %>' />
            <br />
            BidsCompletedDate:
            <asp:TextBox ID="BidsCompletedDateTextBox" runat="server" 
                Text='<%# Bind("BidsCompletedDate") %>' />
            <br />
            DateDTC:
            <asp:TextBox ID="DateDTCTextBox" runat="server" Text='<%# Bind("DateDTC") %>' />
            <br />
            DecisionDTC:
            <asp:TextBox ID="DecisionDTCTextBox" runat="server" 
                Text='<%# Bind("DecisionDTC") %>' />
            <br />
            DateRefProcurementDiv:
            <asp:TextBox ID="DateRefProcurementDivTextBox" runat="server" 
                Text='<%# Bind("DateRefProcurementDiv") %>' />
            <br />
            AwardedDate:
            <asp:TextBox ID="AwardedDateTextBox" runat="server" 
                Text='<%# Bind("AwardedDate") %>' />
            <br />
            <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" 
                CommandName="Insert" Text="Insert" />
            &nbsp;<asp:LinkButton ID="InsertCancelButton" runat="server" 
                CausesValidation="False" CommandName="Cancel" Text="Cancel" />
        </InsertItemTemplate>
        <ItemTemplate>
            <strong><span class="style1">Quotation Register:-</span></strong><br />
            <br />
            QuotationNo:
            <asp:Label ID="QuotationNoLabel" runat="server" 
                Text='<%# Eval("QuotationNo") %>' />
            <br />
            Procurement_Title:
            <asp:Label ID="Procurement_TitleLabel" runat="server" 
                Text='<%# Bind("Procurement_Title") %>' />
            <br />
            Estimated_Cost:
            <asp:Label ID="Estimated_CostLabel" runat="server" 
                Text='<%# Bind("Estimated_Cost") %>' />
            <br />
            Earmarking_Date:
            <asp:Label ID="Earmarking_DateLabel" runat="server" 
                Text='<%# Bind("Earmarking_Date") %>' />
            <br />
            Approved_by_Committee_Date:
            <asp:Label ID="Approved_by_Committee_DateLabel" runat="server" 
                Text='<%# Bind("Approved_by_Committee_Date") %>' />
            <br />
            Documents_Prepared:
            <asp:Label ID="Documents_PreparedLabel" runat="server" 
                Text='<%# Bind("Documents_Prepared") %>' />
            <br />
            Vetted_Date:
            <asp:Label ID="Vetted_DateLabel" runat="server" 
                Text='<%# Bind("Vetted_Date") %>' />
            <br />
            Launched_Date:
            <asp:Label ID="Launched_DateLabel" runat="server" 
                Text='<%# Bind("Launched_Date") %>' />
            <br />
            Closing_Date:
            <asp:Label ID="Closing_DateLabel" runat="server" 
                Text='<%# Bind("Closing_Date") %>' />
            <br />
            <strong>
            <br />
            Bids Sent To:-</strong><br />
            <br />
            Supplier_1:
            <asp:Label ID="Supplier_1Label" runat="server" 
                Text='<%# Bind("Supplier_1") %>' />
            <br />
            Received1:
            <asp:CheckBox ID="Received1CheckBox" runat="server" 
                Checked='<%# Bind("Received1") %>' Enabled="false" />
            <br />
            Supplier_2:
            <asp:Label ID="Supplier_2Label" runat="server" 
                Text='<%# Bind("Supplier_2") %>' />
            <br />
            Received2:
            <asp:CheckBox ID="Received2CheckBox" runat="server" 
                Checked='<%# Bind("Received2") %>' Enabled="false" />
            <br />
            Supplier_3:
            <asp:Label ID="Supplier_3Label" runat="server" 
                Text='<%# Bind("Supplier_3") %>' />
            <br />
            Received3:
            <asp:CheckBox ID="Received3CheckBox" runat="server" 
                Checked='<%# Bind("Received3") %>' Enabled="false" />
            <br />
            Supplier_4:
            <asp:Label ID="Supplier_4Label" runat="server" 
                Text='<%# Bind("Supplier_4") %>' />
            <br />
            Received4:
            <asp:CheckBox ID="Received4CheckBox" runat="server" 
                Checked='<%# Bind("Received4") %>' Enabled="false" />
            <br />
            Supplier_5:
            <asp:Label ID="Supplier_5Label" runat="server" 
                Text='<%# Bind("Supplier_5") %>' />
            <br />
            Received5:
            <asp:CheckBox ID="Received5CheckBox" runat="server" 
                Checked='<%# Bind("Received5") %>' Enabled="false" />
            <br />
            Supplier_6:
            <asp:Label ID="Supplier_6Label" runat="server" 
                Text='<%# Bind("Supplier_6") %>' />
            <br />
            Received6:
            <asp:CheckBox ID="Received6CheckBox" runat="server" 
                Checked='<%# Bind("Received6") %>' Enabled="false" />
            <br />
            Supplier_7:
            <asp:Label ID="Supplier_7Label" runat="server" 
                Text='<%# Bind("Supplier_7") %>' />
            <br />
            Received7:
            <asp:CheckBox ID="Received7CheckBox" runat="server" 
                Checked='<%# Bind("Received7") %>' Enabled="false" />
            <br />
            Supplier_8:
            <asp:Label ID="Supplier_8Label" runat="server" 
                Text='<%# Bind("Supplier_8") %>' />
            <br />
            Received8:
            <asp:CheckBox ID="Received8CheckBox" runat="server" 
                Checked='<%# Bind("Received8") %>' Enabled="false" />
            <br />
            Supplier_9:
            <asp:Label ID="Supplier_9Label" runat="server" 
                Text='<%# Bind("Supplier_9") %>' />
            <br />
            Received9:
            <asp:CheckBox ID="Received9CheckBox" runat="server" 
                Checked='<%# Bind("Received9") %>' Enabled="false" />
            <br />
            Supplier_10:
            <asp:Label ID="Supplier_10Label" runat="server" 
                Text='<%# Bind("Supplier_10") %>' />
            <br />
            Received10:
            <asp:CheckBox ID="Received10CheckBox" runat="server" 
                Checked='<%# Bind("Received10") %>' Enabled="false" />
            <br />
            Supplier_11:
            <asp:Label ID="Supplier_11Label" runat="server" 
                Text='<%# Bind("Supplier_11") %>' />
            <br />
            Received11:
            <asp:CheckBox ID="Received11CheckBox" runat="server" 
                Checked='<%# Bind("Received11") %>' Enabled="false" />
            <br />
            Supplier_12:
            <asp:Label ID="Supplier_12Label" runat="server" 
                Text='<%# Bind("Supplier_12") %>' />
            <br />
            Received12:
            <asp:CheckBox ID="Received12CheckBox" runat="server" 
                Checked='<%# Bind("Received12") %>' Enabled="false" />
            <br />
            <strong>
            <br />
            Evaluation Panel:-</strong><br />
            <br />
            Chairperson:
            <asp:Label ID="ChairpersonLabel" runat="server" 
                Text='<%# Bind("Chairperson") %>' />
            <br />
            Member1:
            <asp:Label ID="Member1Label" runat="server" Text='<%# Bind("Member1") %>' />
            <br />
            Member2:
            <asp:Label ID="Member2Label" runat="server" Text='<%# Bind("Member2") %>' />
            <br />
            EvaluationSubmitted:
            <asp:Label ID="EvaluationSubmittedLabel" runat="server" 
                Text='<%# Bind("EvaluationSubmitted") %>' />
            <br />
            BidsCompletedDate:
            <asp:Label ID="BidsCompletedDateLabel" runat="server" 
                Text='<%# Bind("BidsCompletedDate") %>' />
            <br />
            DateDTC:
            <asp:Label ID="DateDTCLabel" runat="server" Text='<%# Bind("DateDTC") %>' />
            <br />
            DecisionDTC:
            <asp:Label ID="DecisionDTCLabel" runat="server" 
                Text='<%# Bind("DecisionDTC") %>' />
            <br />
            DateRefProcurementDiv:
            <asp:Label ID="DateRefProcurementDivLabel" runat="server" 
                Text='<%# Bind("DateRefProcurementDiv") %>' />
            <br />
            AwardedDate:
            <asp:Label ID="AwardedDateLabel" runat="server" 
                Text='<%# Bind("AwardedDate") %>' />
            <br />
            <asp:LinkButton ID="EditButton" runat="server" CausesValidation="False" 
                CommandName="Edit" Text="Edit" />
            &nbsp;<asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False" 
                CommandName="Delete" Text="Delete" />
            &nbsp;<asp:LinkButton ID="NewButton" runat="server" CausesValidation="False" 
                CommandName="New" Text="New" />
            <br />
            <br />
        </ItemTemplate>
        <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
        <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
    </asp:FormView>
    <asp:AccessDataSource ID="AccessDataSource1" runat="server" 
        DataFile="~/App_Data/poltender1.mdb" 
        DeleteCommand="DELETE FROM [tender] WHERE (([QuotationNo] = ?) OR ([QuotationNo] IS NULL AND ? IS NULL))" 
        InsertCommand="INSERT INTO [tender] ([QuotationNo], [Procurement_Title], [Estimated_Cost], [Earmarking_Date], [Approved_by_Committee_Date], [Documents_Prepared], [Vetted_Date], [Launched_Date], [Closing_Date], [Supplier_1], [Received1], [Supplier_2], [Received2], [Supplier_3], [Received3], [Supplier_4], [Received4], [Supplier_5], [Received5], [Supplier_6], [Received6], [Supplier_7], [Received7], [Supplier_8], [Received8], [Supplier_9], [Received9], [Supplier_10], [Received10], [Supplier_11], [Received11], [Supplier_12], [Received12], [Chairperson], [Member1], [Member2], [EvaluationSubmitted], [BidsCompletedDate], [DateDTC], [DecisionDTC], [DateRefProcurementDiv], [AwardedDate]) VALUES (@QuotationNo, @Procurement_Title, @Estimated_Cost, @Earmarking_Date, @Approved_by_Committee_Date, @Documents_Prepared, @Vetted_Date, @Launched_Date, @Closing_Date, @Supplier_1, @Received1, @Supplier_2, @Received2, @Supplier_3, @Received3, @Supplier_4, @Received4, @Supplier_5, @Received5, @Supplier_6, @Received6, @Supplier_7, @Received7, @Supplier_8, @Received8, @Supplier_9, @Received9, @Supplier_10, @Received10, @Supplier_11, @Received11, @Supplier_12, @Received12, @Chairperson, @Member1, @Member2, @EvaluationSubmitted, @BidsCompletedDate, @DateDTC, @DecisionDTC, @DateRefProcurementDiv, @AwardedDate)" 
        SelectCommand="SELECT * FROM [tender]" 
        UpdateCommand="UPDATE [tender] SET [Procurement_Title] = @Procurement_Title, [Estimated_Cost] = @Estimated_Cost, [Earmarking_Date] = @Earmarking_Date, [Approved_by_Committee_Date] = @Approved_by_Committee_Date, [Documents_Prepared] = @Documents_Prepared, [Vetted_Date] = @Vetted_Date, [Launched_Date] = @Launched_Date, [Closing_Date] = @Closing_Date, [Supplier_1] = @Supplier_1, [Received1] = @Received1, [Supplier_2] = @Supplier_2, [Received2] = @Received2, [Supplier_3] = @Supplier_3, [Received3] = @Received3, [Supplier_4] = @Supplier_4, [Received4] = @Received4, [Supplier_5] = @Supplier_5, [Received5] = @Received5, [Supplier_6] = @Supplier_6, [Received6] = @Received6, [Supplier_7] = @Supplier_7, [Received7] = @Received7, [Supplier_8] = @Supplier_8, [Received8] = @Received8, [Supplier_9] = Supplier_9, [Received9] = @Received9, [Supplier_10] = @Supplier_10, [Received10] = @Received10, [Supplier_11] = @Supplier_11, [Received11] = @Received11, [Supplier_12] = @Supplier_12, [Received12] = @Received12, [Chairperson] = @Chairperson, [Member1] = @Member1, [Member2] = @Member2, [EvaluationSubmitted] = @EvaluationSubmitted, [BidsCompletedDate] = @BidsCompletedDate, [DateDTC] = @DateDTC, [DecisionDTC] = @DecisionDTC, [DateRefProcurementDiv] = @DateRefProcurementDiv, [AwardedDate] = @AwardedDate WHERE (([QuotationNo] = @QuotationNo) OR ([QuotationNo] IS NULL AND @QuotationNo IS NULL))">
        <DeleteParameters>
            <asp:Parameter Name="QuotationNo" Type="String" />
        </DeleteParameters>
        <InsertParameters>
            <asp:Parameter Name="QuotationNo" Type="String" />
            <asp:Parameter Name="Procurement_Title" Type="String" />
            <asp:Parameter Name="Estimated_Cost" Type="String" />
            <asp:Parameter Name="Earmarking_Date" Type="String" />
            <asp:Parameter Name="Approved_by_Committee_Date" Type="String" />
            <asp:Parameter Name="Documents_Prepared" Type="String" />
            <asp:Parameter Name="Vetted_Date" Type="String" />
            <asp:Parameter Name="Launched_Date" Type="String" />
            <asp:Parameter Name="Closing_Date" Type="String" />
            <asp:Parameter Name="Supplier_1" Type="String" />
            <asp:Parameter Name="Received1" Type="Boolean" />
            <asp:Parameter Name="Supplier_2" Type="String" />
            <asp:Parameter Name="Received2" Type="Boolean" />
            <asp:Parameter Name="Supplier_3" Type="String" />
            <asp:Parameter Name="Received3" Type="Boolean" />
            <asp:Parameter Name="Supplier_4" Type="String" />
            <asp:Parameter Name="Received4" Type="Boolean" />
            <asp:Parameter Name="Supplier_5" Type="String" />
            <asp:Parameter Name="Received5" Type="Boolean" />
            <asp:Parameter Name="Supplier_6" Type="String" />
            <asp:Parameter Name="Received6" Type="Boolean" />
            <asp:Parameter Name="Supplier_7" Type="String" />
            <asp:Parameter Name="Received7" Type="Boolean" />
            <asp:Parameter Name="Supplier_8" Type="String" />
            <asp:Parameter Name="Received8" Type="Boolean" />
            <asp:Parameter Name="Supplier_9" Type="String" />
            <asp:Parameter Name="Received9" Type="Boolean" />
            <asp:Parameter Name="Supplier_10" Type="String" />
            <asp:Parameter Name="Received10" Type="Boolean" />
            <asp:Parameter Name="Supplier_11" Type="String" />
            <asp:Parameter Name="Received11" Type="Boolean" />
            <asp:Parameter Name="Supplier_12" Type="String" />
            <asp:Parameter Name="Received12" Type="Boolean" />
            <asp:Parameter Name="Chairperson" Type="String" />
            <asp:Parameter Name="Member1" Type="String" />
            <asp:Parameter Name="Member2" Type="String" />
            <asp:Parameter Name="EvaluationSubmitted" Type="String" />
            <asp:Parameter Name="BidsCompletedDate" Type="String" />
            <asp:Parameter Name="DateDTC" Type="String" />
            <asp:Parameter Name="DecisionDTC" Type="String" />
            <asp:Parameter Name="DateRefProcurementDiv" Type="String" />
            <asp:Parameter Name="AwardedDate" Type="String" />
        </InsertParameters>
        <UpdateParameters>
            <asp:Parameter Name="Procurement_Title" Type="String" />
            <asp:Parameter Name="Estimated_Cost" Type="String" />
            <asp:Parameter Name="Earmarking_Date" Type="String" />
            <asp:Parameter Name="Approved_by_Committee_Date" Type="String" />
            <asp:Parameter Name="Documents_Prepared" Type="String" />
            <asp:Parameter Name="Vetted_Date" Type="String" />
            <asp:Parameter Name="Launched_Date" Type="String" />
            <asp:Parameter Name="Closing_Date" Type="String" />
            <asp:Parameter Name="Supplier_1" Type="String" />
            <asp:Parameter Name="Received1" Type="Boolean" />
            <asp:Parameter Name="Supplier_2" Type="String" />
            <asp:Parameter Name="Received2" Type="Boolean" />
            <asp:Parameter Name="Supplier_3" Type="String" />
            <asp:Parameter Name="Received3" Type="Boolean" />
            <asp:Parameter Name="Supplier_4" Type="String" />
            <asp:Parameter Name="Received4" Type="Boolean" />
            <asp:Parameter Name="Supplier_5" Type="String" />
            <asp:Parameter Name="Received5" Type="Boolean" />
            <asp:Parameter Name="Supplier_6" Type="String" />
            <asp:Parameter Name="Received6" Type="Boolean" />
            <asp:Parameter Name="Supplier_7" Type="String" />
            <asp:Parameter Name="Received7" Type="Boolean" />
            <asp:Parameter Name="Supplier_8" Type="String" />
            <asp:Parameter Name="Received8" Type="Boolean" />
            <asp:Parameter Name="Supplier_9" Type="String" />
            <asp:Parameter Name="Received9" Type="Boolean" />
            <asp:Parameter Name="Supplier_10" Type="String" />
            <asp:Parameter Name="Received10" Type="Boolean" />
            <asp:Parameter Name="Supplier_11" Type="String" />
            <asp:Parameter Name="Received11" Type="Boolean" />
            <asp:Parameter Name="Supplier_12" Type="String" />
            <asp:Parameter Name="Received12" Type="Boolean" />
            <asp:Parameter Name="Chairperson" Type="String" />
            <asp:Parameter Name="Member1" Type="String" />
            <asp:Parameter Name="Member2" Type="String" />
            <asp:Parameter Name="EvaluationSubmitted" Type="String" />
            <asp:Parameter Name="BidsCompletedDate" Type="String" />
            <asp:Parameter Name="DateDTC" Type="String" />
            <asp:Parameter Name="DecisionDTC" Type="String" />
            <asp:Parameter Name="DateRefProcurementDiv" Type="String" />
            <asp:Parameter Name="AwardedDate" Type="String" />
            <asp:Parameter Name="QuotationNo" Type="String" />
        </UpdateParameters>
    </asp:AccessDataSource>
</asp:Content>

Plz see to it if their is any problem and let me know.

Yousha

3
Contributors
2
Replies
7
Views
3 Years
Discussion Span
Last Post by ryan.ally2
0

Form View but my problem arise when i edit the data in the form, it does not update the data. Following is my code.

@Yousha

It's like 600 lines! that is alot. I'm not reading your whole code.

Since you mention it doesn't update, does an error appear when you run the code?

0

hello the problem is that it give no error.
When you click on the update button the form reload itself without your update data. The textbox that contain the data become blank after the page has been reloaded.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.