Solved

Update Command Not Updating in Formview

Posted on 2008-06-23
1
291 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
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Introduction A frequently used term in Object-Oriented design is "SOLID" which is a mnemonic acronym that covers five principles of OO design.  These principles do not stand alone; there is interplay among them.  And they are not laws, merely princ…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to choose which pages of your form are visible to your users based on their inputs. The page rules feature provides you with an opportunity to create if:then statements for y…

773 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