Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Update Command Not Updating in Formview

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to selectively show certain fields based on user input using rules to gather relevant information and data from your forms. The rules feature provides you with an opportunity…

916 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