Solved

Update Command Not Updating in Formview

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
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…

856 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