Solved

Update Command Not Updating in Formview

Posted on 2008-06-23
1
293 Views
Last Modified: 2013-11-26
I have a FormView attached to a sql database.  I have changed the item template to display in a table and I have set some properties to Visible = False.  I don't know if those changes are causing this, but the update command doesn't appear to be working because I Edit and Update a record but the changes are not saved.  There are no erros that are being reported.  I have attached the code down below.

Thanks for your help.
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Order_Entry.aspx.vb" Inherits="Order_Entry" %>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Untitled Page</title>
    <style type="text/css">
        #form1
        {
            margin-right: 472px;
        }
    </style>
</head>
<body bgcolor="#000000">
    <form id="form1" runat="server">
    <div>
    
        IMS
    
    </div>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:IMSwebConnectionString %>" 
        OldValuesParameterFormatString="original_{0}" 
        SelectCommand="SELECT * FROM [tblOrders_Web]" 
        ConflictDetection="CompareAllValues" 
        DeleteCommand="DELETE FROM [tblOrders_Web] WHERE [orderID] = @original_orderID AND [timeSubmitted] = @original_timeSubmitted AND [repID] = @original_repID AND [salesRep] = @original_salesRep AND [customer] = @original_customer AND [address] = @original_address AND [cityStateZip] = @original_cityStateZip AND [contact] = @original_contact AND [phone] = @original_phone AND [forecastMachineId] = @original_forecastMachineId AND [forecastId] = @original_forecastId AND [forecastModel] = @original_forecastModel AND [comments] = @original_comments AND [neededDate] = @original_neededDate AND [saleType] = @original_saleType AND [networking] = @original_networking AND [stairs] = @original_stairs AND [stairCount] = @original_stairCount AND [deliveryMethod] = @original_deliveryMethod AND [model] = @original_model AND [modelWhseSN] = @original_modelWhseSN AND [modelShopSN] = @original_modelShopSN AND [modelDelSN] = @original_modelDelSN AND [equipId] = @original_equipId AND [meterShop] = @original_meterShop AND [m6] = @original_m6 AND [m7] = @original_m7 AND [m8] = @original_m8 AND [m3] = @original_m3 AND [m4] = @original_m4 AND [m5] = @original_m5 AND [meterDel] = @original_meterDel AND [accessory1] = @original_accessory1 AND [a1WhseSN] = @original_a1WhseSN AND [a1ShopSN] = @original_a1ShopSN AND [a1DelSN] = @original_a1DelSN AND [accessory2] = @original_accessory2 AND [a2WhseSN] = @original_a2WhseSN AND [a2ShopSN] = @original_a2ShopSN AND [a2DelSN] = @original_a2DelSN AND [accessory3] = @original_accessory3 AND [a3WhseSN] = @original_a3WhseSN AND [a3ShopSN] = @original_a3ShopSN AND [a3DelSN] = @original_a3DelSN AND [accessory4] = @original_accessory4 AND [a4WhseSN] = @original_a4WhseSN AND [a4ShopSN] = @original_a4ShopSN AND [a4DelSN] = @original_a4DelSN AND [accessory5] = @original_accessory5 AND [a5WhseSN] = @original_a5WhseSN AND [a5ShopSN] = @original_a5ShopSN AND [a5DelSN] = @original_a5DelSN AND [accessory6] = @original_accessory6 AND [a6WhseSN] = @original_a6WhseSN AND [a6ShopSN] = @original_a6ShopSN AND [a6DelSN] = @original_a6DelSN AND [accessory7] = @original_accessory7 AND [a7WhseSN] = @original_a7WhseSN AND [a7ShopSN] = @original_a7ShopSN AND [a7DelSN] = @original_a7DelSN AND [accessory8] = @original_accessory8 AND [a8WhseSN] = @original_a8WhseSN AND [a8ShopSN] = @original_a8ShopSN AND [a8DelSN] = @original_a8DelSN AND [accessory9] = @original_accessory9 AND [a9WhseSN] = @original_a9WhseSN AND [a9ShopSN] = @original_a9ShopSN AND [a9DelSN] = @original_a9DelSN AND [accessory10] = @original_accessory10 AND [a10WhseSN] = @original_a10WhseSN AND [a10ShopSN] = @original_a10ShopSN AND [a10DelSN] = @original_a10DelSN AND [accessory11] = @original_accessory11 AND [a11WhseSN] = @original_a11WhseSN AND [a11ShopSN] = @original_a11ShopSN AND [a11DelSN] = @original_a11DelSN AND [accessory12] = @original_accessory12 AND [a12WhseSN] = @original_a12WhseSN AND [a12ShopSN] = @original_a12ShopSN AND [a12DelSN] = @original_a12DelSN AND [accessory13] = @original_accessory13 AND [a13WhseSN] = @original_a13WhseSN AND [a13ShopSN] = @original_a13ShopSN AND [a13DelSN] = @original_a13DelSN AND [accessory14] = @original_accessory14 AND [a14WhseSN] = @original_a14WhseSN AND [a14ShopSN] = @original_a14ShopSN AND [a14DelSN] = @original_a14DelSN AND [estDelTime] = @original_estDelTime AND [placement] = @original_placement AND [m1] = @original_m1 AND [m2] = @original_m2" 
        InsertCommand="INSERT INTO [tblOrders_Web] ([orderID], [timeSubmitted], [repID], [salesRep], [customer], [address], [cityStateZip], [contact], [phone], [forecastMachineId], [forecastId], [forecastModel], [comments], [neededDate], [saleType], [networking], [stairs], [stairCount], [deliveryMethod], [model], [modelWhseSN], [modelShopSN], [modelDelSN], [equipId], [meterShop], [m6], [m7], [m8], [m3], [m4], [m5], [meterDel], [accessory1], [a1WhseSN], [a1ShopSN], [a1DelSN], [accessory2], [a2WhseSN], [a2ShopSN], [a2DelSN], [accessory3], [a3WhseSN], [a3ShopSN], [a3DelSN], [accessory4], [a4WhseSN], [a4ShopSN], [a4DelSN], [accessory5], [a5WhseSN], [a5ShopSN], [a5DelSN], [accessory6], [a6WhseSN], [a6ShopSN], [a6DelSN], [accessory7], [a7WhseSN], [a7ShopSN], [a7DelSN], [accessory8], [a8WhseSN], [a8ShopSN], [a8DelSN], [accessory9], [a9WhseSN], [a9ShopSN], [a9DelSN], [accessory10], [a10WhseSN], [a10ShopSN], [a10DelSN], [accessory11], [a11WhseSN], [a11ShopSN], [a11DelSN], [accessory12], [a12WhseSN], [a12ShopSN], [a12DelSN], [accessory13], [a13WhseSN], [a13ShopSN], [a13DelSN], [accessory14], [a14WhseSN], [a14ShopSN], [a14DelSN], [estDelTime], [placement], [m1], [m2]) VALUES (@orderID, @timeSubmitted, @repID, @salesRep, @customer, @address, @cityStateZip, @contact, @phone, @forecastMachineId, @forecastId, @forecastModel, @comments, @neededDate, @saleType, @networking, @stairs, @stairCount, @deliveryMethod, @model, @modelWhseSN, @modelShopSN, @modelDelSN, @equipId, @meterShop, @m6, @m7, @m8, @m3, @m4, @m5, @meterDel, @accessory1, @a1WhseSN, @a1ShopSN, @a1DelSN, @accessory2, @a2WhseSN, @a2ShopSN, @a2DelSN, @accessory3, @a3WhseSN, @a3ShopSN, @a3DelSN, @accessory4, @a4WhseSN, @a4ShopSN, @a4DelSN, @accessory5, @a5WhseSN, @a5ShopSN, @a5DelSN, @accessory6, @a6WhseSN, @a6ShopSN, @a6DelSN, @accessory7, @a7WhseSN, @a7ShopSN, @a7DelSN, @accessory8, @a8WhseSN, @a8ShopSN, @a8DelSN, @accessory9, @a9WhseSN, @a9ShopSN, @a9DelSN, @accessory10, @a10WhseSN, @a10ShopSN, @a10DelSN, @accessory11, @a11WhseSN, @a11ShopSN, @a11DelSN, @accessory12, @a12WhseSN, @a12ShopSN, @a12DelSN, @accessory13, @a13WhseSN, @a13ShopSN, @a13DelSN, @accessory14, @a14WhseSN, @a14ShopSN, @a14DelSN, @estDelTime, @placement, @m1, @m2)" 
        UpdateCommand="UPDATE [tblOrders_Web] SET [timeSubmitted] = @timeSubmitted, [repID] = @repID, [salesRep] = @salesRep, [customer] = @customer, [address] = @address, [cityStateZip] = @cityStateZip, [contact] = @contact, [phone] = @phone, [forecastMachineId] = @forecastMachineId, [forecastId] = @forecastId, [forecastModel] = @forecastModel, [comments] = @comments, [neededDate] = @neededDate, [saleType] = @saleType, [networking] = @networking, [stairs] = @stairs, [stairCount] = @stairCount, [deliveryMethod] = @deliveryMethod, [model] = @model, [modelWhseSN] = @modelWhseSN, [modelShopSN] = @modelShopSN, [modelDelSN] = @modelDelSN, [equipId] = @equipId, [meterShop] = @meterShop, [m6] = @m6, [m7] = @m7, [m8] = @m8, [m3] = @m3, [m4] = @m4, [m5] = @m5, [meterDel] = @meterDel, [accessory1] = @accessory1, [a1WhseSN] = @a1WhseSN, [a1ShopSN] = @a1ShopSN, [a1DelSN] = @a1DelSN, [accessory2] = @accessory2, [a2WhseSN] = @a2WhseSN, [a2ShopSN] = @a2ShopSN, [a2DelSN] = @a2DelSN, [accessory3] = @accessory3, [a3WhseSN] = @a3WhseSN, [a3ShopSN] = @a3ShopSN, [a3DelSN] = @a3DelSN, [accessory4] = @accessory4, [a4WhseSN] = @a4WhseSN, [a4ShopSN] = @a4ShopSN, [a4DelSN] = @a4DelSN, [accessory5] = @accessory5, [a5WhseSN] = @a5WhseSN, [a5ShopSN] = @a5ShopSN, [a5DelSN] = @a5DelSN, [accessory6] = @accessory6, [a6WhseSN] = @a6WhseSN, [a6ShopSN] = @a6ShopSN, [a6DelSN] = @a6DelSN, [accessory7] = @accessory7, [a7WhseSN] = @a7WhseSN, [a7ShopSN] = @a7ShopSN, [a7DelSN] = @a7DelSN, [accessory8] = @accessory8, [a8WhseSN] = @a8WhseSN, [a8ShopSN] = @a8ShopSN, [a8DelSN] = @a8DelSN, [accessory9] = @accessory9, [a9WhseSN] = @a9WhseSN, [a9ShopSN] = @a9ShopSN, [a9DelSN] = @a9DelSN, [accessory10] = @accessory10, [a10WhseSN] = @a10WhseSN, [a10ShopSN] = @a10ShopSN, [a10DelSN] = @a10DelSN, [accessory11] = @accessory11, [a11WhseSN] = @a11WhseSN, [a11ShopSN] = @a11ShopSN, [a11DelSN] = @a11DelSN, [accessory12] = @accessory12, [a12WhseSN] = @a12WhseSN, [a12ShopSN] = @a12ShopSN, [a12DelSN] = @a12DelSN, [accessory13] = @accessory13, [a13WhseSN] = @a13WhseSN, [a13ShopSN] = @a13ShopSN, [a13DelSN] = @a13DelSN, [accessory14] = @accessory14, [a14WhseSN] = @a14WhseSN, [a14ShopSN] = @a14ShopSN, [a14DelSN] = @a14DelSN, [estDelTime] = @estDelTime, [placement] = @placement, [m1] = @m1, [m2] = @m2 WHERE [orderID] = @original_orderID AND [timeSubmitted] = @original_timeSubmitted AND [repID] = @original_repID AND [salesRep] = @original_salesRep AND [customer] = @original_customer AND [address] = @original_address AND [cityStateZip] = @original_cityStateZip AND [contact] = @original_contact AND [phone] = @original_phone AND [forecastMachineId] = @original_forecastMachineId AND [forecastId] = @original_forecastId AND [forecastModel] = @original_forecastModel AND [comments] = @original_comments AND [neededDate] = @original_neededDate AND [saleType] = @original_saleType AND [networking] = @original_networking AND [stairs] = @original_stairs AND [stairCount] = @original_stairCount AND [deliveryMethod] = @original_deliveryMethod AND [model] = @original_model AND [modelWhseSN] = @original_modelWhseSN AND [modelShopSN] = @original_modelShopSN AND [modelDelSN] = @original_modelDelSN AND [equipId] = @original_equipId AND [meterShop] = @original_meterShop AND [m6] = @original_m6 AND [m7] = @original_m7 AND [m8] = @original_m8 AND [m3] = @original_m3 AND [m4] = @original_m4 AND [m5] = @original_m5 AND [meterDel] = @original_meterDel AND [accessory1] = @original_accessory1 AND [a1WhseSN] = @original_a1WhseSN AND [a1ShopSN] = @original_a1ShopSN AND [a1DelSN] = @original_a1DelSN AND [accessory2] = @original_accessory2 AND [a2WhseSN] = @original_a2WhseSN AND [a2ShopSN] = @original_a2ShopSN AND [a2DelSN] = @original_a2DelSN AND [accessory3] = @original_accessory3 AND [a3WhseSN] = @original_a3WhseSN AND [a3ShopSN] = @original_a3ShopSN AND [a3DelSN] = @original_a3DelSN AND [accessory4] = @original_accessory4 AND [a4WhseSN] = @original_a4WhseSN AND [a4ShopSN] = @original_a4ShopSN AND [a4DelSN] = @original_a4DelSN AND [accessory5] = @original_accessory5 AND [a5WhseSN] = @original_a5WhseSN AND [a5ShopSN] = @original_a5ShopSN AND [a5DelSN] = @original_a5DelSN AND [accessory6] = @original_accessory6 AND [a6WhseSN] = @original_a6WhseSN AND [a6ShopSN] = @original_a6ShopSN AND [a6DelSN] = @original_a6DelSN AND [accessory7] = @original_accessory7 AND [a7WhseSN] = @original_a7WhseSN AND [a7ShopSN] = @original_a7ShopSN AND [a7DelSN] = @original_a7DelSN AND [accessory8] = @original_accessory8 AND [a8WhseSN] = @original_a8WhseSN AND [a8ShopSN] = @original_a8ShopSN AND [a8DelSN] = @original_a8DelSN AND [accessory9] = @original_accessory9 AND [a9WhseSN] = @original_a9WhseSN AND [a9ShopSN] = @original_a9ShopSN AND [a9DelSN] = @original_a9DelSN AND [accessory10] = @original_accessory10 AND [a10WhseSN] = @original_a10WhseSN AND [a10ShopSN] = @original_a10ShopSN AND [a10DelSN] = @original_a10DelSN AND [accessory11] = @original_accessory11 AND [a11WhseSN] = @original_a11WhseSN AND [a11ShopSN] = @original_a11ShopSN AND [a11DelSN] = @original_a11DelSN AND [accessory12] = @original_accessory12 AND [a12WhseSN] = @original_a12WhseSN AND [a12ShopSN] = @original_a12ShopSN AND [a12DelSN] = @original_a12DelSN AND [accessory13] = @original_accessory13 AND [a13WhseSN] = @original_a13WhseSN AND [a13ShopSN] = @original_a13ShopSN AND [a13DelSN] = @original_a13DelSN AND [accessory14] = @original_accessory14 AND [a14WhseSN] = @original_a14WhseSN AND [a14ShopSN] = @original_a14ShopSN AND [a14DelSN] = @original_a14DelSN AND [estDelTime] = @original_estDelTime AND [placement] = @original_placement AND [m1] = @original_m1 AND [m2] = @original_m2">
        <DeleteParameters>
            <asp:Parameter Name="original_orderID" Type="String" />
            <asp:Parameter Name="original_timeSubmitted" Type="String" />
            <asp:Parameter Name="original_repID" Type="Int16" />
            <asp:Parameter Name="original_salesRep" Type="String" />
            <asp:Parameter Name="original_customer" Type="String" />
            <asp:Parameter Name="original_address" Type="String" />
            <asp:Parameter Name="original_cityStateZip" Type="String" />
            <asp:Parameter Name="original_contact" Type="String" />
            <asp:Parameter Name="original_phone" Type="String" />
            <asp:Parameter Name="original_forecastMachineId" Type="String" />
            <asp:Parameter Name="original_forecastId" Type="String" />
            <asp:Parameter Name="original_forecastModel" Type="String" />
            <asp:Parameter Name="original_comments" Type="String" />
            <asp:Parameter Name="original_neededDate" Type="DateTime" />
            <asp:Parameter Name="original_saleType" Type="String" />
            <asp:Parameter Name="original_networking" Type="String" />
            <asp:Parameter Name="original_stairs" Type="String" />
            <asp:Parameter Name="original_stairCount" Type="Int16" />
            <asp:Parameter Name="original_deliveryMethod" Type="String" />
            <asp:Parameter Name="original_model" Type="String" />
            <asp:Parameter Name="original_modelWhseSN" Type="String" />
            <asp:Parameter Name="original_modelShopSN" Type="String" />
            <asp:Parameter Name="original_modelDelSN" Type="String" />
            <asp:Parameter Name="original_equipId" Type="String" />
            <asp:Parameter Name="original_meterShop" Type="String" />
            <asp:Parameter Name="original_m6" Type="String" />
            <asp:Parameter Name="original_m7" Type="String" />
            <asp:Parameter Name="original_m8" Type="String" />
            <asp:Parameter Name="original_m3" Type="String" />
            <asp:Parameter Name="original_m4" Type="String" />
            <asp:Parameter Name="original_m5" Type="String" />
            <asp:Parameter Name="original_meterDel" Type="String" />
            <asp:Parameter Name="original_accessory1" Type="String" />
            <asp:Parameter Name="original_a1WhseSN" Type="String" />
            <asp:Parameter Name="original_a1ShopSN" Type="String" />
            <asp:Parameter Name="original_a1DelSN" Type="String" />
            <asp:Parameter Name="original_accessory2" Type="String" />
            <asp:Parameter Name="original_a2WhseSN" Type="String" />
            <asp:Parameter Name="original_a2ShopSN" Type="String" />
            <asp:Parameter Name="original_a2DelSN" Type="String" />
            <asp:Parameter Name="original_accessory3" Type="String" />
            <asp:Parameter Name="original_a3WhseSN" Type="String" />
            <asp:Parameter Name="original_a3ShopSN" Type="String" />
            <asp:Parameter Name="original_a3DelSN" Type="String" />
            <asp:Parameter Name="original_accessory4" Type="String" />
            <asp:Parameter Name="original_a4WhseSN" Type="String" />
            <asp:Parameter Name="original_a4ShopSN" Type="String" />
            <asp:Parameter Name="original_a4DelSN" Type="String" />
            <asp:Parameter Name="original_accessory5" Type="String" />
            <asp:Parameter Name="original_a5WhseSN" Type="String" />
            <asp:Parameter Name="original_a5ShopSN" Type="String" />
            <asp:Parameter Name="original_a5DelSN" Type="String" />
            <asp:Parameter Name="original_accessory6" Type="String" />
            <asp:Parameter Name="original_a6WhseSN" Type="String" />
            <asp:Parameter Name="original_a6ShopSN" Type="String" />
            <asp:Parameter Name="original_a6DelSN" Type="String" />
            <asp:Parameter Name="original_accessory7" Type="String" />
            <asp:Parameter Name="original_a7WhseSN" Type="String" />
            <asp:Parameter Name="original_a7ShopSN" Type="String" />
            <asp:Parameter Name="original_a7DelSN" Type="String" />
            <asp:Parameter Name="original_accessory8" Type="String" />
            <asp:Parameter Name="original_a8WhseSN" Type="String" />
            <asp:Parameter Name="original_a8ShopSN" Type="String" />
            <asp:Parameter Name="original_a8DelSN" Type="String" />
            <asp:Parameter Name="original_accessory9" Type="String" />
            <asp:Parameter Name="original_a9WhseSN" Type="String" />
            <asp:Parameter Name="original_a9ShopSN" Type="String" />
            <asp:Parameter Name="original_a9DelSN" Type="String" />
            <asp:Parameter Name="original_accessory10" Type="String" />
            <asp:Parameter Name="original_a10WhseSN" Type="String" />
            <asp:Parameter Name="original_a10ShopSN" Type="String" />
            <asp:Parameter Name="original_a10DelSN" Type="String" />
            <asp:Parameter Name="original_accessory11" Type="String" />
            <asp:Parameter Name="original_a11WhseSN" Type="String" />
            <asp:Parameter Name="original_a11ShopSN" Type="String" />
            <asp:Parameter Name="original_a11DelSN" Type="String" />
            <asp:Parameter Name="original_accessory12" Type="String" />
            <asp:Parameter Name="original_a12WhseSN" Type="String" />
            <asp:Parameter Name="original_a12ShopSN" Type="String" />
            <asp:Parameter Name="original_a12DelSN" Type="String" />
            <asp:Parameter Name="original_accessory13" Type="String" />
            <asp:Parameter Name="original_a13WhseSN" Type="String" />
            <asp:Parameter Name="original_a13ShopSN" Type="String" />
            <asp:Parameter Name="original_a13DelSN" Type="String" />
            <asp:Parameter Name="original_accessory14" Type="String" />
            <asp:Parameter Name="original_a14WhseSN" Type="String" />
            <asp:Parameter Name="original_a14ShopSN" Type="String" />
            <asp:Parameter Name="original_a14DelSN" Type="String" />
            <asp:Parameter Name="original_estDelTime" Type="String" />
            <asp:Parameter Name="original_placement" Type="Int32" />
            <asp:Parameter Name="original_m1" Type="String" />
            <asp:Parameter Name="original_m2" Type="String" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="timeSubmitted" Type="String" />
            <asp:Parameter Name="repID" Type="Int16" />
            <asp:Parameter Name="salesRep" Type="String" />
            <asp:Parameter Name="customer" Type="String" />
            <asp:Parameter Name="address" Type="String" />
            <asp:Parameter Name="cityStateZip" Type="String" />
            <asp:Parameter Name="contact" Type="String" />
            <asp:Parameter Name="phone" Type="String" />
            <asp:Parameter Name="forecastMachineId" Type="String" />
            <asp:Parameter Name="forecastId" Type="String" />
            <asp:Parameter Name="forecastModel" Type="String" />
            <asp:Parameter Name="comments" Type="String" />
            <asp:Parameter Name="neededDate" Type="DateTime" />
            <asp:Parameter Name="saleType" Type="String" />
            <asp:Parameter Name="networking" Type="String" />
            <asp:Parameter Name="stairs" Type="String" />
            <asp:Parameter Name="stairCount" Type="Int16" />
            <asp:Parameter Name="deliveryMethod" Type="String" />
            <asp:Parameter Name="model" Type="String" />
            <asp:Parameter Name="modelWhseSN" Type="String" />
            <asp:Parameter Name="modelShopSN" Type="String" />
            <asp:Parameter Name="modelDelSN" Type="String" />
            <asp:Parameter Name="equipId" Type="String" />
            <asp:Parameter Name="meterShop" Type="String" />
            <asp:Parameter Name="m6" Type="String" />
            <asp:Parameter Name="m7" Type="String" />
            <asp:Parameter Name="m8" Type="String" />
            <asp:Parameter Name="m3" Type="String" />
            <asp:Parameter Name="m4" Type="String" />
            <asp:Parameter Name="m5" Type="String" />
            <asp:Parameter Name="meterDel" Type="String" />
            <asp:Parameter Name="accessory1" Type="String" />
            <asp:Parameter Name="a1WhseSN" Type="String" />
            <asp:Parameter Name="a1ShopSN" Type="String" />
            <asp:Parameter Name="a1DelSN" Type="String" />
            <asp:Parameter Name="accessory2" Type="String" />
            <asp:Parameter Name="a2WhseSN" Type="String" />
            <asp:Parameter Name="a2ShopSN" Type="String" />
            <asp:Parameter Name="a2DelSN" Type="String" />
            <asp:Parameter Name="accessory3" Type="String" />
            <asp:Parameter Name="a3WhseSN" Type="String" />
            <asp:Parameter Name="a3ShopSN" Type="String" />
            <asp:Parameter Name="a3DelSN" Type="String" />
            <asp:Parameter Name="accessory4" Type="String" />
            <asp:Parameter Name="a4WhseSN" Type="String" />
            <asp:Parameter Name="a4ShopSN" Type="String" />
            <asp:Parameter Name="a4DelSN" Type="String" />
            <asp:Parameter Name="accessory5" Type="String" />
            <asp:Parameter Name="a5WhseSN" Type="String" />
            <asp:Parameter Name="a5ShopSN" Type="String" />
            <asp:Parameter Name="a5DelSN" Type="String" />
            <asp:Parameter Name="accessory6" Type="String" />
            <asp:Parameter Name="a6WhseSN" Type="String" />
            <asp:Parameter Name="a6ShopSN" Type="String" />
            <asp:Parameter Name="a6DelSN" Type="String" />
            <asp:Parameter Name="accessory7" Type="String" />
            <asp:Parameter Name="a7WhseSN" Type="String" />
            <asp:Parameter Name="a7ShopSN" Type="String" />
            <asp:Parameter Name="a7DelSN" Type="String" />
            <asp:Parameter Name="accessory8" Type="String" />
            <asp:Parameter Name="a8WhseSN" Type="String" />
            <asp:Parameter Name="a8ShopSN" Type="String" />
            <asp:Parameter Name="a8DelSN" Type="String" />
            <asp:Parameter Name="accessory9" Type="String" />
            <asp:Parameter Name="a9WhseSN" Type="String" />
            <asp:Parameter Name="a9ShopSN" Type="String" />
            <asp:Parameter Name="a9DelSN" Type="String" />
            <asp:Parameter Name="accessory10" Type="String" />
            <asp:Parameter Name="a10WhseSN" Type="String" />
            <asp:Parameter Name="a10ShopSN" Type="String" />
            <asp:Parameter Name="a10DelSN" Type="String" />
            <asp:Parameter Name="accessory11" Type="String" />
            <asp:Parameter Name="a11WhseSN" Type="String" />
            <asp:Parameter Name="a11ShopSN" Type="String" />
            <asp:Parameter Name="a11DelSN" Type="String" />
            <asp:Parameter Name="accessory12" Type="String" />
            <asp:Parameter Name="a12WhseSN" Type="String" />
            <asp:Parameter Name="a12ShopSN" Type="String" />
            <asp:Parameter Name="a12DelSN" Type="String" />
            <asp:Parameter Name="accessory13" Type="String" />
            <asp:Parameter Name="a13WhseSN" Type="String" />
            <asp:Parameter Name="a13ShopSN" Type="String" />
            <asp:Parameter Name="a13DelSN" Type="String" />
            <asp:Parameter Name="accessory14" Type="String" />
            <asp:Parameter Name="a14WhseSN" Type="String" />
            <asp:Parameter Name="a14ShopSN" Type="String" />
            <asp:Parameter Name="a14DelSN" Type="String" />
            <asp:Parameter Name="estDelTime" Type="String" />
            <asp:Parameter Name="placement" Type="Int32" />
            <asp:Parameter Name="m1" Type="String" />
            <asp:Parameter Name="m2" Type="String" />
            <asp:Parameter Name="original_orderID" Type="String" />
            <asp:Parameter Name="original_timeSubmitted" Type="String" />
            <asp:Parameter Name="original_repID" Type="Int16" />
            <asp:Parameter Name="original_salesRep" Type="String" />
            <asp:Parameter Name="original_customer" Type="String" />
            <asp:Parameter Name="original_address" Type="String" />
            <asp:Parameter Name="original_cityStateZip" Type="String" />
            <asp:Parameter Name="original_contact" Type="String" />
            <asp:Parameter Name="original_phone" Type="String" />
            <asp:Parameter Name="original_forecastMachineId" Type="String" />
            <asp:Parameter Name="original_forecastId" Type="String" />
            <asp:Parameter Name="original_forecastModel" Type="String" />
            <asp:Parameter Name="original_comments" Type="String" />
            <asp:Parameter Name="original_neededDate" Type="DateTime" />
            <asp:Parameter Name="original_saleType" Type="String" />
            <asp:Parameter Name="original_networking" Type="String" />
            <asp:Parameter Name="original_stairs" Type="String" />
            <asp:Parameter Name="original_stairCount" Type="Int16" />
            <asp:Parameter Name="original_deliveryMethod" Type="String" />
            <asp:Parameter Name="original_model" Type="String" />
            <asp:Parameter Name="original_modelWhseSN" Type="String" />
            <asp:Parameter Name="original_modelShopSN" Type="String" />
            <asp:Parameter Name="original_modelDelSN" Type="String" />
            <asp:Parameter Name="original_equipId" Type="String" />
            <asp:Parameter Name="original_meterShop" Type="String" />
            <asp:Parameter Name="original_m6" Type="String" />
            <asp:Parameter Name="original_m7" Type="String" />
            <asp:Parameter Name="original_m8" Type="String" />
            <asp:Parameter Name="original_m3" Type="String" />
            <asp:Parameter Name="original_m4" Type="String" />
            <asp:Parameter Name="original_m5" Type="String" />
            <asp:Parameter Name="original_meterDel" Type="String" />
            <asp:Parameter Name="original_accessory1" Type="String" />
            <asp:Parameter Name="original_a1WhseSN" Type="String" />
            <asp:Parameter Name="original_a1ShopSN" Type="String" />
            <asp:Parameter Name="original_a1DelSN" Type="String" />
            <asp:Parameter Name="original_accessory2" Type="String" />
            <asp:Parameter Name="original_a2WhseSN" Type="String" />
            <asp:Parameter Name="original_a2ShopSN" Type="String" />
            <asp:Parameter Name="original_a2DelSN" Type="String" />
            <asp:Parameter Name="original_accessory3" Type="String" />
            <asp:Parameter Name="original_a3WhseSN" Type="String" />
            <asp:Parameter Name="original_a3ShopSN" Type="String" />
            <asp:Parameter Name="original_a3DelSN" Type="String" />
            <asp:Parameter Name="original_accessory4" Type="String" />
            <asp:Parameter Name="original_a4WhseSN" Type="String" />
            <asp:Parameter Name="original_a4ShopSN" Type="String" />
            <asp:Parameter Name="original_a4DelSN" Type="String" />
            <asp:Parameter Name="original_accessory5" Type="String" />
            <asp:Parameter Name="original_a5WhseSN" Type="String" />
            <asp:Parameter Name="original_a5ShopSN" Type="String" />
            <asp:Parameter Name="original_a5DelSN" Type="String" />
            <asp:Parameter Name="original_accessory6" Type="String" />
            <asp:Parameter Name="original_a6WhseSN" Type="String" />
            <asp:Parameter Name="original_a6ShopSN" Type="String" />
            <asp:Parameter Name="original_a6DelSN" Type="String" />
            <asp:Parameter Name="original_accessory7" Type="String" />
            <asp:Parameter Name="original_a7WhseSN" Type="String" />
            <asp:Parameter Name="original_a7ShopSN" Type="String" />
            <asp:Parameter Name="original_a7DelSN" Type="String" />
            <asp:Parameter Name="original_accessory8" Type="String" />
            <asp:Parameter Name="original_a8WhseSN" Type="String" />
            <asp:Parameter Name="original_a8ShopSN" Type="String" />
            <asp:Parameter Name="original_a8DelSN" Type="String" />
            <asp:Parameter Name="original_accessory9" Type="String" />
            <asp:Parameter Name="original_a9WhseSN" Type="String" />
            <asp:Parameter Name="original_a9ShopSN" Type="String" />
            <asp:Parameter Name="original_a9DelSN" Type="String" />
            <asp:Parameter Name="original_accessory10" Type="String" />
            <asp:Parameter Name="original_a10WhseSN" Type="String" />
            <asp:Parameter Name="original_a10ShopSN" Type="String" />
            <asp:Parameter Name="original_a10DelSN" Type="String" />
            <asp:Parameter Name="original_accessory11" Type="String" />
            <asp:Parameter Name="original_a11WhseSN" Type="String" />
            <asp:Parameter Name="original_a11ShopSN" Type="String" />
            <asp:Parameter Name="original_a11DelSN" Type="String" />
            <asp:Parameter Name="original_accessory12" Type="String" />
            <asp:Parameter Name="original_a12WhseSN" Type="String" />
            <asp:Parameter Name="original_a12ShopSN" Type="String" />
            <asp:Parameter Name="original_a12DelSN" Type="String" />
            <asp:Parameter Name="original_accessory13" Type="String" />
            <asp:Parameter Name="original_a13WhseSN" Type="String" />
            <asp:Parameter Name="original_a13ShopSN" Type="String" />
            <asp:Parameter Name="original_a13DelSN" Type="String" />
            <asp:Parameter Name="original_accessory14" Type="String" />
            <asp:Parameter Name="original_a14WhseSN" Type="String" />
            <asp:Parameter Name="original_a14ShopSN" Type="String" />
            <asp:Parameter Name="original_a14DelSN" Type="String" />
            <asp:Parameter Name="original_estDelTime" Type="String" />
            <asp:Parameter Name="original_placement" Type="Int32" />
            <asp:Parameter Name="original_m1" Type="String" />
            <asp:Parameter Name="original_m2" Type="String" />
        </UpdateParameters>
        <InsertParameters>
            <asp:Parameter Name="orderID" Type="String" />
            <asp:Parameter Name="timeSubmitted" Type="String" />
            <asp:Parameter Name="repID" Type="Int16" />
            <asp:Parameter Name="salesRep" Type="String" />
            <asp:Parameter Name="customer" Type="String" />
            <asp:Parameter Name="address" Type="String" />
            <asp:Parameter Name="cityStateZip" Type="String" />
            <asp:Parameter Name="contact" Type="String" />
            <asp:Parameter Name="phone" Type="String" />
            <asp:Parameter Name="forecastMachineId" Type="String" />
            <asp:Parameter Name="forecastId" Type="String" />
            <asp:Parameter Name="forecastModel" Type="String" />
            <asp:Parameter Name="comments" Type="String" />
            <asp:Parameter Name="neededDate" Type="DateTime" />
            <asp:Parameter Name="saleType" Type="String" />
            <asp:Parameter Name="networking" Type="String" />
            <asp:Parameter Name="stairs" Type="String" />
            <asp:Parameter Name="stairCount" Type="Int16" />
            <asp:Parameter Name="deliveryMethod" Type="String" />
            <asp:Parameter Name="model" Type="String" />
            <asp:Parameter Name="modelWhseSN" Type="String" />
            <asp:Parameter Name="modelShopSN" Type="String" />
            <asp:Parameter Name="modelDelSN" Type="String" />
            <asp:Parameter Name="equipId" Type="String" />
            <asp:Parameter Name="meterShop" Type="String" />
            <asp:Parameter Name="m6" Type="String" />
            <asp:Parameter Name="m7" Type="String" />
            <asp:Parameter Name="m8" Type="String" />
            <asp:Parameter Name="m3" Type="String" />
            <asp:Parameter Name="m4" Type="String" />
            <asp:Parameter Name="m5" Type="String" />
            <asp:Parameter Name="meterDel" Type="String" />
            <asp:Parameter Name="accessory1" Type="String" />
            <asp:Parameter Name="a1WhseSN" Type="String" />
            <asp:Parameter Name="a1ShopSN" Type="String" />
            <asp:Parameter Name="a1DelSN" Type="String" />
            <asp:Parameter Name="accessory2" Type="String" />
            <asp:Parameter Name="a2WhseSN" Type="String" />
            <asp:Parameter Name="a2ShopSN" Type="String" />
            <asp:Parameter Name="a2DelSN" Type="String" />
            <asp:Parameter Name="accessory3" Type="String" />
            <asp:Parameter Name="a3WhseSN" Type="String" />
            <asp:Parameter Name="a3ShopSN" Type="String" />
            <asp:Parameter Name="a3DelSN" Type="String" />
            <asp:Parameter Name="accessory4" Type="String" />
            <asp:Parameter Name="a4WhseSN" Type="String" />
            <asp:Parameter Name="a4ShopSN" Type="String" />
            <asp:Parameter Name="a4DelSN" Type="String" />
            <asp:Parameter Name="accessory5" Type="String" />
            <asp:Parameter Name="a5WhseSN" Type="String" />
            <asp:Parameter Name="a5ShopSN" Type="String" />
            <asp:Parameter Name="a5DelSN" Type="String" />
            <asp:Parameter Name="accessory6" Type="String" />
            <asp:Parameter Name="a6WhseSN" Type="String" />
            <asp:Parameter Name="a6ShopSN" Type="String" />
            <asp:Parameter Name="a6DelSN" Type="String" />
            <asp:Parameter Name="accessory7" Type="String" />
            <asp:Parameter Name="a7WhseSN" Type="String" />
            <asp:Parameter Name="a7ShopSN" Type="String" />
            <asp:Parameter Name="a7DelSN" Type="String" />
            <asp:Parameter Name="accessory8" Type="String" />
            <asp:Parameter Name="a8WhseSN" Type="String" />
            <asp:Parameter Name="a8ShopSN" Type="String" />
            <asp:Parameter Name="a8DelSN" Type="String" />
            <asp:Parameter Name="accessory9" Type="String" />
            <asp:Parameter Name="a9WhseSN" Type="String" />
            <asp:Parameter Name="a9ShopSN" Type="String" />
            <asp:Parameter Name="a9DelSN" Type="String" />
            <asp:Parameter Name="accessory10" Type="String" />
            <asp:Parameter Name="a10WhseSN" Type="String" />
            <asp:Parameter Name="a10ShopSN" Type="String" />
            <asp:Parameter Name="a10DelSN" Type="String" />
            <asp:Parameter Name="accessory11" Type="String" />
            <asp:Parameter Name="a11WhseSN" Type="String" />
            <asp:Parameter Name="a11ShopSN" Type="String" />
            <asp:Parameter Name="a11DelSN" Type="String" />
            <asp:Parameter Name="accessory12" Type="String" />
            <asp:Parameter Name="a12WhseSN" Type="String" />
            <asp:Parameter Name="a12ShopSN" Type="String" />
            <asp:Parameter Name="a12DelSN" Type="String" />
            <asp:Parameter Name="accessory13" Type="String" />
            <asp:Parameter Name="a13WhseSN" Type="String" />
            <asp:Parameter Name="a13ShopSN" Type="String" />
            <asp:Parameter Name="a13DelSN" Type="String" />
            <asp:Parameter Name="accessory14" Type="String" />
            <asp:Parameter Name="a14WhseSN" Type="String" />
            <asp:Parameter Name="a14ShopSN" Type="String" />
            <asp:Parameter Name="a14DelSN" Type="String" />
            <asp:Parameter Name="estDelTime" Type="String" />
            <asp:Parameter Name="placement" Type="Int32" />
            <asp:Parameter Name="m1" Type="String" />
            <asp:Parameter Name="m2" Type="String" />
        </InsertParameters>
    </asp:SqlDataSource>
    <asp:FormView ID="FormView2" runat="server" DataKeyNames="orderID" 
        DataSourceID="SqlDataSource1" ForeColor="White">
        <EditItemTemplate>
            
            <%--<tr id="orderIDrow" runat="server" visible="false" ><td align="right"><b>Order Id:</b></td>       <td><%#Eval("orderID")%></td> </tr>
            <tr><td align="right"><b>Time Submitted:</b></td>       <td><%#Eval("timeSubmitted")%></td></tr>
            <tr><td align="right"><b>Rep Id:</b></td>       <td><%#Eval("repID")%></td></tr>
            <tr><td align="right"><b>Sales Rep:</b></td>       <td><%#Eval("salesRep")%></td></tr>
            <tr><td align="right"><b>Customer:</b></td>       <td><%#Eval("customer")%></td></tr>
            <tr><td align="right"><b>Address:</b></td>       <td><%#Eval("address")%></td></tr>--%>
            
            orderID:
            <asp:Label ID="orderIDLabel1" runat="server" Text='<%# Eval("orderID") %>' />
            <br />
            timeSubmitted:
            <asp:TextBox ID="timeSubmittedTextBox" runat="server" 
                Text='<%# Bind("timeSubmitted") %>' />
            <br />
            repID:
            <asp:TextBox ID="repIDTextBox" runat="server" Text='<%# Bind("repID") %>' />
            <br />
            salesRep:
            <asp:TextBox ID="salesRepTextBox" runat="server" 
                Text='<%# Bind("salesRep") %>' />
            <br />
            customer:
            <asp:TextBox ID="customerTextBox" runat="server" 
                Text='<%# Bind("customer") %>' />
            <br />
            address:
            <asp:TextBox ID="addressTextBox" runat="server" Text='<%# Bind("address") %>' />
            <br />
            cityStateZip:
            <asp:TextBox ID="cityStateZipTextBox" runat="server" 
                Text='<%# Bind("cityStateZip") %>' />
            <br />
            contact:
            <asp:TextBox ID="contactTextBox" runat="server" Text='<%# Bind("contact") %>' />
            <br />
            phone:
            <asp:TextBox ID="phoneTextBox" runat="server" Text='<%# Bind("phone") %>' />
            <br />
            forecastMachineId:
            <asp:TextBox ID="forecastMachineIdTextBox" runat="server" 
                Text='<%# Bind("forecastMachineId") %>' />
            <br />
            forecastId:
            <asp:TextBox ID="forecastIdTextBox" runat="server" 
                Text='<%# Bind("forecastId") %>' />
            <br />
            forecastModel:
            <asp:TextBox ID="forecastModelTextBox" runat="server" 
                Text='<%# Bind("forecastModel") %>' />
            <br />
            comments:
            <asp:TextBox ID="commentsTextBox" runat="server" 
                Text='<%# Bind("comments") %>' />
            <br />
            neededDate:
            <asp:TextBox ID="neededDateTextBox" runat="server" 
                Text='<%# Bind("neededDate") %>' />
            <br />
            saleType:
            <asp:TextBox ID="saleTypeTextBox" runat="server" 
                Text='<%# Bind("saleType") %>' />
            <br />
            networking:
            <asp:TextBox ID="networkingTextBox" runat="server" 
                Text='<%# Bind("networking") %>' />
            <br />
            stairs:
            <asp:TextBox ID="stairsTextBox" runat="server" Text='<%# Bind("stairs") %>' />
            <br />
            stairCount:
            <asp:TextBox ID="stairCountTextBox" runat="server" 
                Text='<%# Bind("stairCount") %>' />
            <br />
            deliveryMethod:
            <asp:TextBox ID="deliveryMethodTextBox" runat="server" 
                Text='<%# Bind("deliveryMethod") %>' />
            <br />
            model:
            <asp:TextBox ID="modelTextBox" runat="server" Text='<%# Bind("model") %>' />
            <br />
            modelWhseSN:
            <asp:TextBox ID="modelWhseSNTextBox" runat="server" 
                Text='<%# Bind("modelWhseSN") %>' />
            <br />
            modelShopSN:
            <asp:TextBox ID="modelShopSNTextBox" runat="server" 
                Text='<%# Bind("modelShopSN") %>' />
            <br />
            modelDelSN:
            <asp:TextBox ID="modelDelSNTextBox" runat="server" 
                Text='<%# Bind("modelDelSN") %>' />
            <br />
            equipId:
            <asp:TextBox ID="equipIdTextBox" runat="server" Text='<%# Bind("equipId") %>' />
            <br />
            meterShop:
            <asp:TextBox ID="meterShopTextBox" runat="server" 
                Text='<%# Bind("meterShop") %>' />
            <br />
            m6:
            <asp:TextBox ID="m6TextBox" runat="server" Text='<%# Bind("m6") %>' />
            <br />
            m7:
            <asp:TextBox ID="m7TextBox" runat="server" Text='<%# Bind("m7") %>' />
            <br />
            m8:
            <asp:TextBox ID="m8TextBox" runat="server" Text='<%# Bind("m8") %>' />
            <br />
            m3:
            <asp:TextBox ID="m3TextBox" runat="server" Text='<%# Bind("m3") %>' />
            <br />
            m4:
            <asp:TextBox ID="m4TextBox" runat="server" Text='<%# Bind("m4") %>' />
            <br />
            m5:
            <asp:TextBox ID="m5TextBox" runat="server" Text='<%# Bind("m5") %>' />
            <br />
            meterDel:
            <asp:TextBox ID="meterDelTextBox" runat="server" 
                Text='<%# Bind("meterDel") %>' />
            <br />
            accessory1:
            <asp:TextBox ID="accessory1TextBox" runat="server" 
                Text='<%# Bind("accessory1") %>' />
            <br />
            a1WhseSN:
            <asp:TextBox ID="a1WhseSNTextBox" runat="server" 
                Text='<%# Bind("a1WhseSN") %>' />
            <br />
            a1ShopSN:
            <asp:TextBox ID="a1ShopSNTextBox" runat="server" 
                Text='<%# Bind("a1ShopSN") %>' />
            <br />
            a1DelSN:
            <asp:TextBox ID="a1DelSNTextBox" runat="server" Text='<%# Bind("a1DelSN") %>' />
            <br />
            accessory2:
            <asp:TextBox ID="accessory2TextBox" runat="server" 
                Text='<%# Bind("accessory2") %>' />
            <br />
            a2WhseSN:
            <asp:TextBox ID="a2WhseSNTextBox" runat="server" 
                Text='<%# Bind("a2WhseSN") %>' />
            <br />
            a2ShopSN:
            <asp:TextBox ID="a2ShopSNTextBox" runat="server" 
                Text='<%# Bind("a2ShopSN") %>' />
            <br />
            a2DelSN:
            <asp:TextBox ID="a2DelSNTextBox" runat="server" Text='<%# Bind("a2DelSN") %>' />
            <br />
            accessory3:
            <asp:TextBox ID="accessory3TextBox" runat="server" 
                Text='<%# Bind("accessory3") %>' />
            <br />
            a3WhseSN:
            <asp:TextBox ID="a3WhseSNTextBox" runat="server" 
                Text='<%# Bind("a3WhseSN") %>' />
            <br />
            a3ShopSN:
            <asp:TextBox ID="a3ShopSNTextBox" runat="server" 
                Text='<%# Bind("a3ShopSN") %>' />
            <br />
            a3DelSN:
            <asp:TextBox ID="a3DelSNTextBox" runat="server" Text='<%# Bind("a3DelSN") %>' />
            <br />
            accessory4:
            <asp:TextBox ID="accessory4TextBox" runat="server" 
                Text='<%# Bind("accessory4") %>' />
            <br />
            a4WhseSN:
            <asp:TextBox ID="a4WhseSNTextBox" runat="server" 
                Text='<%# Bind("a4WhseSN") %>' />
            <br />
            a4ShopSN:
            <asp:TextBox ID="a4ShopSNTextBox" runat="server" 
                Text='<%# Bind("a4ShopSN") %>' />
            <br />
            a4DelSN:
            <asp:TextBox ID="a4DelSNTextBox" runat="server" Text='<%# Bind("a4DelSN") %>' />
            <br />
            accessory5:
            <asp:TextBox ID="accessory5TextBox" runat="server" 
                Text='<%# Bind("accessory5") %>' />
            <br />
            a5WhseSN:
            <asp:TextBox ID="a5WhseSNTextBox" runat="server" 
                Text='<%# Bind("a5WhseSN") %>' />
            <br />
            a5ShopSN:
            <asp:TextBox ID="a5ShopSNTextBox" runat="server" 
                Text='<%# Bind("a5ShopSN") %>' />
            <br />
            a5DelSN:
            <asp:TextBox ID="a5DelSNTextBox" runat="server" Text='<%# Bind("a5DelSN") %>' />
            <br />
            accessory6:
            <asp:TextBox ID="accessory6TextBox" runat="server" 
                Text='<%# Bind("accessory6") %>' />
            <br />
            a6WhseSN:
            <asp:TextBox ID="a6WhseSNTextBox" runat="server" 
                Text='<%# Bind("a6WhseSN") %>' />
            <br />
            a6ShopSN:
            <asp:TextBox ID="a6ShopSNTextBox" runat="server" 
                Text='<%# Bind("a6ShopSN") %>' />
            <br />
            a6DelSN:
            <asp:TextBox ID="a6DelSNTextBox" runat="server" Text='<%# Bind("a6DelSN") %>' />
            <br />
            accessory7:
            <asp:TextBox ID="accessory7TextBox" runat="server" 
                Text='<%# Bind("accessory7") %>' />
            <br />
            a7WhseSN:
            <asp:TextBox ID="a7WhseSNTextBox" runat="server" 
                Text='<%# Bind("a7WhseSN") %>' />
            <br />
            a7ShopSN:
            <asp:TextBox ID="a7ShopSNTextBox" runat="server" 
                Text='<%# Bind("a7ShopSN") %>' />
            <br />
            a7DelSN:
            <asp:TextBox ID="a7DelSNTextBox" runat="server" Text='<%# Bind("a7DelSN") %>' />
            <br />
            accessory8:
            <asp:TextBox ID="accessory8TextBox" runat="server" 
                Text='<%# Bind("accessory8") %>' />
            <br />
            a8WhseSN:
            <asp:TextBox ID="a8WhseSNTextBox" runat="server" 
                Text='<%# Bind("a8WhseSN") %>' />
            <br />
            a8ShopSN:
            <asp:TextBox ID="a8ShopSNTextBox" runat="server" 
                Text='<%# Bind("a8ShopSN") %>' />
            <br />
            a8DelSN:
            <asp:TextBox ID="a8DelSNTextBox" runat="server" Text='<%# Bind("a8DelSN") %>' />
            <br />
            accessory9:
            <asp:TextBox ID="accessory9TextBox" runat="server" 
                Text='<%# Bind("accessory9") %>' />
            <br />
            a9WhseSN:
            <asp:TextBox ID="a9WhseSNTextBox" runat="server" 
                Text='<%# Bind("a9WhseSN") %>' />
            <br />
            a9ShopSN:
            <asp:TextBox ID="a9ShopSNTextBox" runat="server" 
                Text='<%# Bind("a9ShopSN") %>' />
            <br />
            a9DelSN:
            <asp:TextBox ID="a9DelSNTextBox" runat="server" Text='<%# Bind("a9DelSN") %>' />
            <br />
            accessory10:
            <asp:TextBox ID="accessory10TextBox" runat="server" 
                Text='<%# Bind("accessory10") %>' />
            <br />
            a10WhseSN:
            <asp:TextBox ID="a10WhseSNTextBox" runat="server" 
                Text='<%# Bind("a10WhseSN") %>' />
            <br />
            a10ShopSN:
            <asp:TextBox ID="a10ShopSNTextBox" runat="server" 
                Text='<%# Bind("a10ShopSN") %>' />
            <br />
            a10DelSN:
            <asp:TextBox ID="a10DelSNTextBox" runat="server" 
                Text='<%# Bind("a10DelSN") %>' />
            <br />
            accessory11:
            <asp:TextBox ID="accessory11TextBox" runat="server" 
                Text='<%# Bind("accessory11") %>' />
            <br />
            a11WhseSN:
            <asp:TextBox ID="a11WhseSNTextBox" runat="server" 
                Text='<%# Bind("a11WhseSN") %>' />
            <br />
            a11ShopSN:
            <asp:TextBox ID="a11ShopSNTextBox" runat="server" 
                Text='<%# Bind("a11ShopSN") %>' />
            <br />
            a11DelSN:
            <asp:TextBox ID="a11DelSNTextBox" runat="server" 
                Text='<%# Bind("a11DelSN") %>' />
            <br />
            accessory12:
            <asp:TextBox ID="accessory12TextBox" runat="server" 
                Text='<%# Bind("accessory12") %>' />
            <br />
            a12WhseSN:
            <asp:TextBox ID="a12WhseSNTextBox" runat="server" 
                Text='<%# Bind("a12WhseSN") %>' />
            <br />
            a12ShopSN:
            <asp:TextBox ID="a12ShopSNTextBox" runat="server" 
                Text='<%# Bind("a12ShopSN") %>' />
            <br />
            a12DelSN:
            <asp:TextBox ID="a12DelSNTextBox" runat="server" 
                Text='<%# Bind("a12DelSN") %>' />
            <br />
            accessory13:
            <asp:TextBox ID="accessory13TextBox" runat="server" 
                Text='<%# Bind("accessory13") %>' />
            <br />
            a13WhseSN:
            <asp:TextBox ID="a13WhseSNTextBox" runat="server" 
                Text='<%# Bind("a13WhseSN") %>' />
            <br />
            a13ShopSN:
            <asp:TextBox ID="a13ShopSNTextBox" runat="server" 
                Text='<%# Bind("a13ShopSN") %>' />
            <br />
            a13DelSN:
            <asp:TextBox ID="a13DelSNTextBox" runat="server" 
                Text='<%# Bind("a13DelSN") %>' />
            <br />
            accessory14:
            <asp:TextBox ID="accessory14TextBox" runat="server" 
                Text='<%# Bind("accessory14") %>' />
            <br />
            a14WhseSN:
            <asp:TextBox ID="a14WhseSNTextBox" runat="server" 
                Text='<%# Bind("a14WhseSN") %>' />
            <br />
            a14ShopSN:
            <asp:TextBox ID="a14ShopSNTextBox" runat="server" 
                Text='<%# Bind("a14ShopSN") %>' />
            <br />
            a14DelSN:
            <asp:TextBox ID="a14DelSNTextBox" runat="server" 
                Text='<%# Bind("a14DelSN") %>' />
            <br />
            estDelTime:
            <asp:TextBox ID="estDelTimeTextBox" runat="server" 
                Text='<%# Bind("estDelTime") %>' />
            <br />
            placement:
            <asp:TextBox ID="placementTextBox" runat="server" 
                Text='<%# Bind("placement") %>' />
            <br />
            m1:
            <asp:TextBox ID="m1TextBox" runat="server" Text='<%# Bind("m1") %>' />
            <br />
            m2:
            <asp:TextBox ID="m2TextBox" runat="server" Text='<%# Bind("m2") %>' />
            <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>
        <InsertItemTemplate>
            orderID:
            <asp:TextBox ID="orderIDTextBox" runat="server" Text='<%# Bind("orderID") %>' />
            <br />
            timeSubmitted:
            <asp:TextBox ID="timeSubmittedTextBox" runat="server" 
                Text='<%# Bind("timeSubmitted") %>' />
            <br />
            repID:
            <asp:TextBox ID="repIDTextBox" runat="server" Text='<%# Bind("repID") %>' />
            <br />
            salesRep:
            <asp:TextBox ID="salesRepTextBox" runat="server" 
                Text='<%# Bind("salesRep") %>' />
            <br />
            customer:
            <asp:TextBox ID="customerTextBox" runat="server" 
                Text='<%# Bind("customer") %>' />
            <br />
            address:
            <asp:TextBox ID="addressTextBox" runat="server" Text='<%# Bind("address") %>' />
            <br />
            cityStateZip:
            <asp:TextBox ID="cityStateZipTextBox" runat="server" 
                Text='<%# Bind("cityStateZip") %>' />
            <br />
            contact:
            <asp:TextBox ID="contactTextBox" runat="server" Text='<%# Bind("contact") %>' />
            <br />
            phone:
            <asp:TextBox ID="phoneTextBox" runat="server" Text='<%# Bind("phone") %>' />
            <br />
            forecastMachineId:
            <asp:TextBox ID="forecastMachineIdTextBox" runat="server" 
                Text='<%# Bind("forecastMachineId") %>' />
            <br />
            forecastId:
            <asp:TextBox ID="forecastIdTextBox" runat="server" 
                Text='<%# Bind("forecastId") %>' />
            <br />
            forecastModel:
            <asp:TextBox ID="forecastModelTextBox" runat="server" 
                Text='<%# Bind("forecastModel") %>' />
            <br />
            comments:
            <asp:TextBox ID="commentsTextBox" runat="server" 
                Text='<%# Bind("comments") %>' />
            <br />
            neededDate:
            <asp:TextBox ID="neededDateTextBox" runat="server" 
                Text='<%# Bind("neededDate") %>' />
            <br />
            saleType:
            <asp:TextBox ID="saleTypeTextBox" runat="server" 
                Text='<%# Bind("saleType") %>' />
            <br />
            networking:
            <asp:TextBox ID="networkingTextBox" runat="server" 
                Text='<%# Bind("networking") %>' />
            <br />
            stairs:
            <asp:TextBox ID="stairsTextBox" runat="server" Text='<%# Bind("stairs") %>' />
            <br />
            stairCount:
            <asp:TextBox ID="stairCountTextBox" runat="server" 
                Text='<%# Bind("stairCount") %>' />
            <br />
            deliveryMethod:
            <asp:TextBox ID="deliveryMethodTextBox" runat="server" 
                Text='<%# Bind("deliveryMethod") %>' />
            <br />
            model:
            <asp:TextBox ID="modelTextBox" runat="server" Text='<%# Bind("model") %>' />
            <br />
            modelWhseSN:
            <asp:TextBox ID="modelWhseSNTextBox" runat="server" 
                Text='<%# Bind("modelWhseSN") %>' />
            <br />
            modelShopSN:
            <asp:TextBox ID="modelShopSNTextBox" runat="server" 
                Text='<%# Bind("modelShopSN") %>' />
            <br />
            modelDelSN:
            <asp:TextBox ID="modelDelSNTextBox" runat="server" 
                Text='<%# Bind("modelDelSN") %>' />
            <br />
            equipId:
            <asp:TextBox ID="equipIdTextBox" runat="server" Text='<%# Bind("equipId") %>' />
            <br />
            meterShop:
            <asp:TextBox ID="meterShopTextBox" runat="server" 
                Text='<%# Bind("meterShop") %>' />
            <br />
            m6:
            <asp:TextBox ID="m6TextBox" runat="server" Text='<%# Bind("m6") %>' />
            <br />
            m7:
            <asp:TextBox ID="m7TextBox" runat="server" Text='<%# Bind("m7") %>' />
            <br />
            m8:
            <asp:TextBox ID="m8TextBox" runat="server" Text='<%# Bind("m8") %>' />
            <br />
            m3:
            <asp:TextBox ID="m3TextBox" runat="server" Text='<%# Bind("m3") %>' />
            <br />
            m4:
            <asp:TextBox ID="m4TextBox" runat="server" Text='<%# Bind("m4") %>' />
            <br />
            m5:
            <asp:TextBox ID="m5TextBox" runat="server" Text='<%# Bind("m5") %>' />
            <br />
            meterDel:
            <asp:TextBox ID="meterDelTextBox" runat="server" 
                Text='<%# Bind("meterDel") %>' />
            <br />
            accessory1:
            <asp:TextBox ID="accessory1TextBox" runat="server" 
                Text='<%# Bind("accessory1") %>' />
            <br />
            a1WhseSN:
            <asp:TextBox ID="a1WhseSNTextBox" runat="server" 
                Text='<%# Bind("a1WhseSN") %>' />
            <br />
            a1ShopSN:
            <asp:TextBox ID="a1ShopSNTextBox" runat="server" 
                Text='<%# Bind("a1ShopSN") %>' />
            <br />
            a1DelSN:
            <asp:TextBox ID="a1DelSNTextBox" runat="server" Text='<%# Bind("a1DelSN") %>' />
            <br />
            accessory2:
            <asp:TextBox ID="accessory2TextBox" runat="server" 
                Text='<%# Bind("accessory2") %>' />
            <br />
            a2WhseSN:
            <asp:TextBox ID="a2WhseSNTextBox" runat="server" 
                Text='<%# Bind("a2WhseSN") %>' />
            <br />
            a2ShopSN:
            <asp:TextBox ID="a2ShopSNTextBox" runat="server" 
                Text='<%# Bind("a2ShopSN") %>' />
            <br />
            a2DelSN:
            <asp:TextBox ID="a2DelSNTextBox" runat="server" Text='<%# Bind("a2DelSN") %>' />
            <br />
            accessory3:
            <asp:TextBox ID="accessory3TextBox" runat="server" 
                Text='<%# Bind("accessory3") %>' />
            <br />
            a3WhseSN:
            <asp:TextBox ID="a3WhseSNTextBox" runat="server" 
                Text='<%# Bind("a3WhseSN") %>' />
            <br />
            a3ShopSN:
            <asp:TextBox ID="a3ShopSNTextBox" runat="server" 
                Text='<%# Bind("a3ShopSN") %>' />
            <br />
            a3DelSN:
            <asp:TextBox ID="a3DelSNTextBox" runat="server" Text='<%# Bind("a3DelSN") %>' />
            <br />
            accessory4:
            <asp:TextBox ID="accessory4TextBox" runat="server" 
                Text='<%# Bind("accessory4") %>' />
            <br />
            a4WhseSN:
            <asp:TextBox ID="a4WhseSNTextBox" runat="server" 
                Text='<%# Bind("a4WhseSN") %>' />
            <br />
            a4ShopSN:
            <asp:TextBox ID="a4ShopSNTextBox" runat="server" 
                Text='<%# Bind("a4ShopSN") %>' />
            <br />
            a4DelSN:
            <asp:TextBox ID="a4DelSNTextBox" runat="server" Text='<%# Bind("a4DelSN") %>' />
            <br />
            accessory5:
            <asp:TextBox ID="accessory5TextBox" runat="server" 
                Text='<%# Bind("accessory5") %>' />
            <br />
            a5WhseSN:
            <asp:TextBox ID="a5WhseSNTextBox" runat="server" 
                Text='<%# Bind("a5WhseSN") %>' />
            <br />
            a5ShopSN:
            <asp:TextBox ID="a5ShopSNTextBox" runat="server" 
                Text='<%# Bind("a5ShopSN") %>' />
            <br />
            a5DelSN:
            <asp:TextBox ID="a5DelSNTextBox" runat="server" Text='<%# Bind("a5DelSN") %>' />
            <br />
            accessory6:
            <asp:TextBox ID="accessory6TextBox" runat="server" 
                Text='<%# Bind("accessory6") %>' />
            <br />
            a6WhseSN:
            <asp:TextBox ID="a6WhseSNTextBox" runat="server" 
                Text='<%# Bind("a6WhseSN") %>' />
            <br />
            a6ShopSN:
            <asp:TextBox ID="a6ShopSNTextBox" runat="server" 
                Text='<%# Bind("a6ShopSN") %>' />
            <br />
            a6DelSN:
            <asp:TextBox ID="a6DelSNTextBox" runat="server" Text='<%# Bind("a6DelSN") %>' />
            <br />
            accessory7:
            <asp:TextBox ID="accessory7TextBox" runat="server" 
                Text='<%# Bind("accessory7") %>' />
            <br />
            a7WhseSN:
            <asp:TextBox ID="a7WhseSNTextBox" runat="server" 
                Text='<%# Bind("a7WhseSN") %>' />
            <br />
            a7ShopSN:
            <asp:TextBox ID="a7ShopSNTextBox" runat="server" 
                Text='<%# Bind("a7ShopSN") %>' />
            <br />
            a7DelSN:
            <asp:TextBox ID="a7DelSNTextBox" runat="server" Text='<%# Bind("a7DelSN") %>' />
            <br />
            accessory8:
            <asp:TextBox ID="accessory8TextBox" runat="server" 
                Text='<%# Bind("accessory8") %>' />
            <br />
            a8WhseSN:
            <asp:TextBox ID="a8WhseSNTextBox" runat="server" 
                Text='<%# Bind("a8WhseSN") %>' />
            <br />
            a8ShopSN:
            <asp:TextBox ID="a8ShopSNTextBox" runat="server" 
                Text='<%# Bind("a8ShopSN") %>' />
            <br />
            a8DelSN:
            <asp:TextBox ID="a8DelSNTextBox" runat="server" Text='<%# Bind("a8DelSN") %>' />
            <br />
            accessory9:
            <asp:TextBox ID="accessory9TextBox" runat="server" 
                Text='<%# Bind("accessory9") %>' />
            <br />
            a9WhseSN:
            <asp:TextBox ID="a9WhseSNTextBox" runat="server" 
                Text='<%# Bind("a9WhseSN") %>' />
            <br />
            a9ShopSN:
            <asp:TextBox ID="a9ShopSNTextBox" runat="server" 
                Text='<%# Bind("a9ShopSN") %>' />
            <br />
            a9DelSN:
            <asp:TextBox ID="a9DelSNTextBox" runat="server" Text='<%# Bind("a9DelSN") %>' />
            <br />
            accessory10:
            <asp:TextBox ID="accessory10TextBox" runat="server" 
                Text='<%# Bind("accessory10") %>' />
            <br />
            a10WhseSN:
            <asp:TextBox ID="a10WhseSNTextBox" runat="server" 
                Text='<%# Bind("a10WhseSN") %>' />
            <br />
            a10ShopSN:
            <asp:TextBox ID="a10ShopSNTextBox" runat="server" 
                Text='<%# Bind("a10ShopSN") %>' />
            <br />
            a10DelSN:
            <asp:TextBox ID="a10DelSNTextBox" runat="server" 
                Text='<%# Bind("a10DelSN") %>' />
            <br />
            accessory11:
            <asp:TextBox ID="accessory11TextBox" runat="server" 
                Text='<%# Bind("accessory11") %>' />
            <br />
            a11WhseSN:
            <asp:TextBox ID="a11WhseSNTextBox" runat="server" 
                Text='<%# Bind("a11WhseSN") %>' />
            <br />
            a11ShopSN:
            <asp:TextBox ID="a11ShopSNTextBox" runat="server" 
                Text='<%# Bind("a11ShopSN") %>' />
            <br />
            a11DelSN:
            <asp:TextBox ID="a11DelSNTextBox" runat="server" 
                Text='<%# Bind("a11DelSN") %>' />
            <br />
            accessory12:
            <asp:TextBox ID="accessory12TextBox" runat="server" 
                Text='<%# Bind("accessory12") %>' />
            <br />
            a12WhseSN:
            <asp:TextBox ID="a12WhseSNTextBox" runat="server" 
                Text='<%# Bind("a12WhseSN") %>' />
            <br />
            a12ShopSN:
            <asp:TextBox ID="a12ShopSNTextBox" runat="server" 
                Text='<%# Bind("a12ShopSN") %>' />
            <br />
            a12DelSN:
            <asp:TextBox ID="a12DelSNTextBox" runat="server" 
                Text='<%# Bind("a12DelSN") %>' />
            <br />
            accessory13:
            <asp:TextBox ID="accessory13TextBox" runat="server" 
                Text='<%# Bind("accessory13") %>' />
            <br />
            a13WhseSN:
            <asp:TextBox ID="a13WhseSNTextBox" runat="server" 
                Text='<%# Bind("a13WhseSN") %>' />
            <br />
            a13ShopSN:
            <asp:TextBox ID="a13ShopSNTextBox" runat="server" 
                Text='<%# Bind("a13ShopSN") %>' />
            <br />
            a13DelSN:
            <asp:TextBox ID="a13DelSNTextBox" runat="server" 
                Text='<%# Bind("a13DelSN") %>' />
            <br />
            accessory14:
            <asp:TextBox ID="accessory14TextBox" runat="server" 
                Text='<%# Bind("accessory14") %>' />
            <br />
            a14WhseSN:
            <asp:TextBox ID="a14WhseSNTextBox" runat="server" 
                Text='<%# Bind("a14WhseSN") %>' />
            <br />
            a14ShopSN:
            <asp:TextBox ID="a14ShopSNTextBox" runat="server" 
                Text='<%# Bind("a14ShopSN") %>' />
            <br />
            a14DelSN:
            <asp:TextBox ID="a14DelSNTextBox" runat="server" 
                Text='<%# Bind("a14DelSN") %>' />
            <br />
            estDelTime:
            <asp:TextBox ID="estDelTimeTextBox" runat="server" 
                Text='<%# Bind("estDelTime") %>' />
            <br />
            placement:
            <asp:TextBox ID="placementTextBox" runat="server" 
                Text='<%# Bind("placement") %>' />
            <br />
            m1:
            <asp:TextBox ID="m1TextBox" runat="server" Text='<%# Bind("m1") %>' />
            <br />
            m2:
            <asp:TextBox ID="m2TextBox" runat="server" Text='<%# Bind("m2") %>' />
            <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>
            
            <table> 
           <%-- make some rows not visible need id and runat--%>
           
            <tr id="orderIDrow" runat="server" visible="false" ><td align="right"><b>Order Id:</b></td>       <td><%#Eval("orderID")%></td> </tr>
            <tr><td align="right"><b>Time Submitted:</b></td>       <td><%#Eval("timeSubmitted")%></td></tr>
            <tr><td align="right"><b>Rep Id:</b></td>       <td><%#Eval("repID")%></td></tr>
            <tr><td align="right"><b>Sales Rep:</b></td>       <td><%#Eval("salesRep")%></td></tr>
            <tr><td align="right"><b>Customer:</b></td>       <td><%#Eval("customer")%></td></tr>
            <tr><td align="right"><b>Address:</b></td>       <td><%#Eval("address")%></td></tr>
            <tr><td align="right"><b>City, State, Zip:</b></td>       <td><%#Eval("cityStateZip")%></td></tr>
            <tr><td align="right"><b>Contact:</b></td>       <td><%#Eval("contact")%></td></tr>
            <tr><td align="right"><b>Phone:</b></td>       <td><%#Eval("phone")%></td></tr>
            <tr><td align="right"><b>forecastMachineId:</b></td>       <td><%#Eval("forecastMachineId")%></td></tr>
            <tr><td align="right"><b>forecastId:</b></td>       <td><%#Eval("forecastId")%></td></tr>
            <tr><td align="right"><b>forecastModel:</b></td>       <td><%#Eval("forecastModel")%></td></tr>
            <tr><td align="right"><b>Comments:</b></td>       <td><%#Eval("comments")%></td></tr>
            <tr><td align="right"><b>Delivery Date:</b></td>       <td><%#Eval("neededDate")%></td></tr>
            <tr><td align="right"><b>Sale Type:</b></td>       <td><%#Eval("saleType")%></td></tr>
            <tr><td align="right"><b>Networking Required:</b></td>       <td><%#Eval("networking")%></td></tr>
            <tr><td align="right"><b>Stairs:</b></td>       <td><%#Eval("stairs")%></td></tr>
            <tr><td align="right"><b>Stair Count:</b></td>       <td><%#Eval("stairCount")%></td></tr>
            <tr><td align="right"><b>Delivery Method:</b></td>       <td><%#Eval("deliveryMethod")%></td></tr>
            <tr><td align="right"><b>Model:</b></td>       <td><%#Eval("model")%></td></tr>
            <tr id="modelWhseSNrow" runat="server" visible="false"><td align="right"><b>modelWhseSN:</b></td>       <td><%#Eval("modelWhseSN")%></td></tr>
            <tr id="modelShopSNrow" runat="server" visible="false"><td align="right"><b>modelShopSN:</b></td>       <td><%#Eval("modelShopSN")%></td></tr>
            <tr><td align="right"><b>modelDelSN:</b></td>       <td><%#Eval("modelDelSN")%></td></tr>
            <tr><td align="right"><b>equipId:</b></td>       <td><%#Eval("equipId")%></td></tr>
            <tr><td align="right"><b>meterShop:</b></td>       <td><%#Eval("meterShop")%></td></tr>
            <tr><td align="right"><b>m6:</b></td>       <td><%#Eval("m6")%></td></tr>
            <tr><td align="right"><b>m7:</b></td>       <td><%#Eval("m7")%></td></tr>
            <tr><td align="right"><b>m8:</b></td>       <td><%#Eval("m8")%></td></tr>
            <tr><td align="right"><b>m3:</b></td>       <td><%#Eval("m3")%></td></tr>
            <tr><td align="right"><b>m4:</b></td>       <td><%#Eval("m4")%></td></tr>
            <tr><td align="right"><b>m5:</b></td>       <td><%#Eval("m5")%></td></tr>
            <tr><td align="right"><b>meterDel:</b></td>       <td><%#Eval("meterDel")%></td></tr>
            
            <tr><td align="right"><b>Accessory:</b></td>       <td><%#Eval("accessory1")%></td></tr>
            <tr><td align="right"><b>a1WhseSN:</b></td>       <td><%#Eval("a1WhseSN")%></td></tr>
            <tr><td align="right"><b>a1ShopSN:</b></td>       <td><%#Eval("a1ShopSN")%></td></tr>
            <tr><td align="right"><b>a1DelSN:</b></td>       <td><%#Eval("a1DelSN")%></td></tr>
            
            <tr><td align="right"><b>Accessory:</b></td>       <td><%#Eval("accessory2")%></td></tr>
            <tr><td align="right"><b>a2WhseSN:</b></td>       <td><%#Eval("a2WhseSN")%></td></tr>
            <tr><td align="right"><b>a2ShopSN:</b></td>       <td><%#Eval("a2ShopSN")%></td></tr>
            <tr><td align="right"><b>a2DelSN:</b></td>       <td><%#Eval("a2DelSN")%></td></tr>
            
            <tr><td align="right"><b>Accessory:</b></td>       <td><%#Eval("accessory3")%></td></tr>
            <tr><td align="right"><b>a3WhseSN:</b></td>       <td><%#Eval("a3WhseSN")%></td></tr>
            <tr><td align="right"><b>a3ShopSN:</b></td>       <td><%#Eval("a3ShopSN")%></td></tr>
            <tr><td align="right"><b>a3DelSN:</b></td>       <td><%#Eval("a3DelSN")%></td></tr>
            
            <tr><td align="right"><b>Accessory:</b></td>       <td><%#Eval("accessory4")%></td></tr>
            <tr><td align="right"><b>a4WhseSN:</b></td>       <td><%#Eval("a4WhseSN")%></td></tr>
            <tr><td align="right"><b>a4ShopSN:</b></td>       <td><%#Eval("a4ShopSN")%></td></tr>
            <tr><td align="right"><b>a4DelSN:</b></td>       <td><%#Eval("a4DelSN")%></td></tr>
            
            <tr><td align="right"><b>Accessory:</b></td>       <td><%#Eval("accessory5")%></td></tr>
            <tr><td align="right"><b>a5WhseSN:</b></td>       <td><%#Eval("a5WhseSN")%></td></tr>
            <tr><td align="right"><b>a5ShopSN:</b></td>       <td><%#Eval("a5ShopSN")%></td></tr>
            <tr><td align="right"><b>a5DelSN:</b></td>       <td><%#Eval("a5DelSN")%></td></tr>
            
            <tr><td align="right"><b>Accessory:</b></td>       <td><%#Eval("accessory6")%></td></tr>
            <tr><td align="right"><b>a6WhseSN:</b></td>       <td><%#Eval("a6WhseSN")%></td></tr>
            <tr><td align="right"><b>a6ShopSN:</b></td>       <td><%#Eval("a6ShopSN")%></td></tr>
            <tr><td align="right"><b>a6DelSN:</b></td>       <td><%#Eval("a6DelSN")%></td></tr>
            
            <tr><td align="right"><b>Accessory:</b></td>       <td><%#Eval("accessory7")%></td></tr>
            <tr><td align="right"><b>a7WhseSN:</b></td>       <td><%#Eval("a7WhseSN")%></td></tr>
            <tr><td align="right"><b>a7ShopSN:</b></td>       <td><%#Eval("a7ShopSN")%></td></tr>
            <tr><td align="right"><b>a7DelSN:</b></td>       <td><%#Eval("a7DelSN")%></td></tr>
            
            <tr><td align="right"><b>Accessory:</b></td>       <td><%#Eval("accessory8")%></td></tr>
            <tr><td align="right"><b>a8WhseSN:</b></td>       <td><%#Eval("a8WhseSN")%></td></tr>
            <tr><td align="right"><b>a8ShopSN:</b></td>       <td><%#Eval("a8ShopSN")%></td></tr>
            <tr><td align="right"><b>a8DelSN:</b></td>       <td><%#Eval("a8DelSN")%></td></tr>
            
            <tr><td align="right"><b>Accessory:</b></td>       <td><%#Eval("accessory9")%></td></tr>
            <tr><td align="right"><b>a9WhseSN:</b></td>       <td><%#Eval("a9WhseSN")%></td></tr>
            <tr><td align="right"><b>a9ShopSN:</b></td>       <td><%#Eval("a9ShopSN")%></td></tr>
            <tr><td align="right"><b>a9DelSN:</b></td>       <td><%#Eval("a9DelSN")%></td></tr>
            
            <tr><td align="right"><b>Accessory:</b></td>       <td><%#Eval("accessory10")%></td></tr>
            <tr><td align="right"><b>a10WhseSN:</b></td>       <td><%#Eval("a10WhseSN")%></td></tr>
            <tr><td align="right"><b>a10ShopSN:</b></td>       <td><%#Eval("a10ShopSN")%></td></tr>
            <tr><td align="right"><b>a10DelSN:</b></td>       <td><%#Eval("a10DelSN")%></td></tr>
            
            <tr><td align="right"><b>Accessory:</b></td>       <td><%#Eval("accessory11")%></td></tr>
            <tr><td align="right"><b>a11WhseSN:</b></td>       <td><%#Eval("a11WhseSN")%></td></tr>
            <tr><td align="right"><b>a11ShopSN:</b></td>       <td><%#Eval("a11ShopSN")%></td></tr>
            <tr><td align="right"><b>a11DelSN:</b></td>       <td><%#Eval("a11DelSN")%></td></tr>
            
            <tr><td align="right"><b>Accessory:</b></td>       <td><%#Eval("accessory12")%></td></tr>
            <tr><td align="right"><b>a12WhseSN:</b></td>       <td><%#Eval("a12WhseSN")%></td></tr>
            <tr><td align="right"><b>a12ShopSN:</b></td>       <td><%#Eval("a12ShopSN")%></td></tr>
            <tr><td align="right"><b>a12DelSN:</b></td>       <td><%#Eval("a12DelSN")%></td></tr>
            
            <tr><td align="right"><b>Accessory:</b></td>       <td><%#Eval("accessory13")%></td></tr>
            <tr><td align="right"><b>a13WhseSN:</b></td>       <td><%#Eval("a13WhseSN")%></td></tr>
            <tr><td align="right"><b>a13ShopSN:</b></td>       <td><%#Eval("a13ShopSN")%></td></tr>
            <tr><td align="right"><b>a13DelSN:</b></td>       <td><%#Eval("a13DelSN")%></td></tr>
            
            <tr><td align="right"><b>Accessory:</b></td>       <td><%#Eval("accessory14")%></td></tr>
            <tr><td align="right"><b>a14WhseSN:</b></td>       <td><%#Eval("a14WhseSN")%></td></tr>
            <tr><td align="right"><b>a14ShopSN:</b></td>       <td><%#Eval("a14ShopSN")%></td></tr>
            <tr><td align="right"><b>a14DelSN:</b></td>       <td><%#Eval("a14DelSN")%></td></tr>
            
            <tr><td align="right"><b>estDelTime:</b></td>       <td><%#Eval("estDelTime")%></td></tr>
            <tr><td align="right"><b>placement:</b></td>       <td><%#Eval("placement")%></td></tr>
            <tr><td align="right"><b>m1:</b></td>       <td><%#Eval("m1")%></td></tr>
            <tr><td align="right"><b>m2:</b></td>       <td><%#Eval("m2")%></td></tr>
            
            
            </table>
           
            
          
            <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" />
        </ItemTemplate>
    </asp:FormView>
    c<asp:Label Text='<%# Eval("orderID") %>' runat="server" id="orderIDLabel" />
    </form>
</body>
</html>

Open in new window

0
Comment
Question by:toddpotter
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 7

Accepted Solution

by:
maXXXeE earned 500 total points
ID: 21853692
You have not mapped your controls for update parameters.

so, your "UpdateParameters" in SqlDataSource control should be like this:
        <UpdateParameters>
            <asp:ControlParameter Name="timeSubmitted" ControlID="timeSubmittedTextBox" Type="String" />

All the Parameters required for update query should be mapped to respective Controls in your FormView
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how the fundamental information of how to create a table.

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question