Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Update Command Not Updating in Formview

Posted on 2008-06-23
1
Medium Priority
?
298 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 1500 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

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

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

This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses

578 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