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" />
<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" />
<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" />
<asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False"
CommandName="Delete" Text="Delete" />
<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
