Solved

Update Command Not Updating in Formview

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

Thanks for your help.
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Order_Entry.aspx.vb" Inherits="Order_Entry" %>
 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

    <title>Untitled Page</title>

    <style type="text/css">

        #form1

        {

            margin-right: 472px;

        }

    </style>

</head>

<body bgcolor="#000000">

    <form id="form1" runat="server">

    <div>

    

        IMS

    

    </div>

    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 

        ConnectionString="<%$ ConnectionStrings:IMSwebConnectionString %>" 

        OldValuesParameterFormatString="original_{0}" 

        SelectCommand="SELECT * FROM [tblOrders_Web]" 

        ConflictDetection="CompareAllValues" 

        DeleteCommand="DELETE FROM [tblOrders_Web] WHERE [orderID] = @original_orderID AND [timeSubmitted] = @original_timeSubmitted AND [repID] = @original_repID AND [salesRep] = @original_salesRep AND [customer] = @original_customer AND [address] = @original_address AND [cityStateZip] = @original_cityStateZip AND [contact] = @original_contact AND [phone] = @original_phone AND [forecastMachineId] = @original_forecastMachineId AND [forecastId] = @original_forecastId AND [forecastModel] = @original_forecastModel AND [comments] = @original_comments AND [neededDate] = @original_neededDate AND [saleType] = @original_saleType AND [networking] = @original_networking AND [stairs] = @original_stairs AND [stairCount] = @original_stairCount AND [deliveryMethod] = @original_deliveryMethod AND [model] = @original_model AND [modelWhseSN] = @original_modelWhseSN AND [modelShopSN] = @original_modelShopSN AND [modelDelSN] = @original_modelDelSN AND [equipId] = @original_equipId AND [meterShop] = @original_meterShop AND [m6] = @original_m6 AND [m7] = @original_m7 AND [m8] = @original_m8 AND [m3] = @original_m3 AND [m4] = @original_m4 AND [m5] = @original_m5 AND [meterDel] = @original_meterDel AND [accessory1] = @original_accessory1 AND [a1WhseSN] = @original_a1WhseSN AND [a1ShopSN] = @original_a1ShopSN AND [a1DelSN] = @original_a1DelSN AND [accessory2] = @original_accessory2 AND [a2WhseSN] = @original_a2WhseSN AND [a2ShopSN] = @original_a2ShopSN AND [a2DelSN] = @original_a2DelSN AND [accessory3] = @original_accessory3 AND [a3WhseSN] = @original_a3WhseSN AND [a3ShopSN] = @original_a3ShopSN AND [a3DelSN] = @original_a3DelSN AND [accessory4] = @original_accessory4 AND [a4WhseSN] = @original_a4WhseSN AND [a4ShopSN] = @original_a4ShopSN AND [a4DelSN] = @original_a4DelSN AND [accessory5] = @original_accessory5 AND [a5WhseSN] = @original_a5WhseSN AND [a5ShopSN] = @original_a5ShopSN AND [a5DelSN] = @original_a5DelSN AND [accessory6] = @original_accessory6 AND [a6WhseSN] = @original_a6WhseSN AND [a6ShopSN] = @original_a6ShopSN AND [a6DelSN] = @original_a6DelSN AND [accessory7] = @original_accessory7 AND [a7WhseSN] = @original_a7WhseSN AND [a7ShopSN] = @original_a7ShopSN AND [a7DelSN] = @original_a7DelSN AND [accessory8] = @original_accessory8 AND [a8WhseSN] = @original_a8WhseSN AND [a8ShopSN] = @original_a8ShopSN AND [a8DelSN] = @original_a8DelSN AND [accessory9] = @original_accessory9 AND [a9WhseSN] = @original_a9WhseSN AND [a9ShopSN] = @original_a9ShopSN AND [a9DelSN] = @original_a9DelSN AND [accessory10] = @original_accessory10 AND [a10WhseSN] = @original_a10WhseSN AND [a10ShopSN] = @original_a10ShopSN AND [a10DelSN] = @original_a10DelSN AND [accessory11] = @original_accessory11 AND [a11WhseSN] = @original_a11WhseSN AND [a11ShopSN] = @original_a11ShopSN AND [a11DelSN] = @original_a11DelSN AND [accessory12] = @original_accessory12 AND [a12WhseSN] = @original_a12WhseSN AND [a12ShopSN] = @original_a12ShopSN AND [a12DelSN] = @original_a12DelSN AND [accessory13] = @original_accessory13 AND [a13WhseSN] = @original_a13WhseSN AND [a13ShopSN] = @original_a13ShopSN AND [a13DelSN] = @original_a13DelSN AND [accessory14] = @original_accessory14 AND [a14WhseSN] = @original_a14WhseSN AND [a14ShopSN] = @original_a14ShopSN AND [a14DelSN] = @original_a14DelSN AND [estDelTime] = @original_estDelTime AND [placement] = @original_placement AND [m1] = @original_m1 AND [m2] = @original_m2" 

        InsertCommand="INSERT INTO [tblOrders_Web] ([orderID], [timeSubmitted], [repID], [salesRep], [customer], [address], [cityStateZip], [contact], [phone], [forecastMachineId], [forecastId], [forecastModel], [comments], [neededDate], [saleType], [networking], [stairs], [stairCount], [deliveryMethod], [model], [modelWhseSN], [modelShopSN], [modelDelSN], [equipId], [meterShop], [m6], [m7], [m8], [m3], [m4], [m5], [meterDel], [accessory1], [a1WhseSN], [a1ShopSN], [a1DelSN], [accessory2], [a2WhseSN], [a2ShopSN], [a2DelSN], [accessory3], [a3WhseSN], [a3ShopSN], [a3DelSN], [accessory4], [a4WhseSN], [a4ShopSN], [a4DelSN], [accessory5], [a5WhseSN], [a5ShopSN], [a5DelSN], [accessory6], [a6WhseSN], [a6ShopSN], [a6DelSN], [accessory7], [a7WhseSN], [a7ShopSN], [a7DelSN], [accessory8], [a8WhseSN], [a8ShopSN], [a8DelSN], [accessory9], [a9WhseSN], [a9ShopSN], [a9DelSN], [accessory10], [a10WhseSN], [a10ShopSN], [a10DelSN], [accessory11], [a11WhseSN], [a11ShopSN], [a11DelSN], [accessory12], [a12WhseSN], [a12ShopSN], [a12DelSN], [accessory13], [a13WhseSN], [a13ShopSN], [a13DelSN], [accessory14], [a14WhseSN], [a14ShopSN], [a14DelSN], [estDelTime], [placement], [m1], [m2]) VALUES (@orderID, @timeSubmitted, @repID, @salesRep, @customer, @address, @cityStateZip, @contact, @phone, @forecastMachineId, @forecastId, @forecastModel, @comments, @neededDate, @saleType, @networking, @stairs, @stairCount, @deliveryMethod, @model, @modelWhseSN, @modelShopSN, @modelDelSN, @equipId, @meterShop, @m6, @m7, @m8, @m3, @m4, @m5, @meterDel, @accessory1, @a1WhseSN, @a1ShopSN, @a1DelSN, @accessory2, @a2WhseSN, @a2ShopSN, @a2DelSN, @accessory3, @a3WhseSN, @a3ShopSN, @a3DelSN, @accessory4, @a4WhseSN, @a4ShopSN, @a4DelSN, @accessory5, @a5WhseSN, @a5ShopSN, @a5DelSN, @accessory6, @a6WhseSN, @a6ShopSN, @a6DelSN, @accessory7, @a7WhseSN, @a7ShopSN, @a7DelSN, @accessory8, @a8WhseSN, @a8ShopSN, @a8DelSN, @accessory9, @a9WhseSN, @a9ShopSN, @a9DelSN, @accessory10, @a10WhseSN, @a10ShopSN, @a10DelSN, @accessory11, @a11WhseSN, @a11ShopSN, @a11DelSN, @accessory12, @a12WhseSN, @a12ShopSN, @a12DelSN, @accessory13, @a13WhseSN, @a13ShopSN, @a13DelSN, @accessory14, @a14WhseSN, @a14ShopSN, @a14DelSN, @estDelTime, @placement, @m1, @m2)" 

        UpdateCommand="UPDATE [tblOrders_Web] SET [timeSubmitted] = @timeSubmitted, [repID] = @repID, [salesRep] = @salesRep, [customer] = @customer, [address] = @address, [cityStateZip] = @cityStateZip, [contact] = @contact, [phone] = @phone, [forecastMachineId] = @forecastMachineId, [forecastId] = @forecastId, [forecastModel] = @forecastModel, [comments] = @comments, [neededDate] = @neededDate, [saleType] = @saleType, [networking] = @networking, [stairs] = @stairs, [stairCount] = @stairCount, [deliveryMethod] = @deliveryMethod, [model] = @model, [modelWhseSN] = @modelWhseSN, [modelShopSN] = @modelShopSN, [modelDelSN] = @modelDelSN, [equipId] = @equipId, [meterShop] = @meterShop, [m6] = @m6, [m7] = @m7, [m8] = @m8, [m3] = @m3, [m4] = @m4, [m5] = @m5, [meterDel] = @meterDel, [accessory1] = @accessory1, [a1WhseSN] = @a1WhseSN, [a1ShopSN] = @a1ShopSN, [a1DelSN] = @a1DelSN, [accessory2] = @accessory2, [a2WhseSN] = @a2WhseSN, [a2ShopSN] = @a2ShopSN, [a2DelSN] = @a2DelSN, [accessory3] = @accessory3, [a3WhseSN] = @a3WhseSN, [a3ShopSN] = @a3ShopSN, [a3DelSN] = @a3DelSN, [accessory4] = @accessory4, [a4WhseSN] = @a4WhseSN, [a4ShopSN] = @a4ShopSN, [a4DelSN] = @a4DelSN, [accessory5] = @accessory5, [a5WhseSN] = @a5WhseSN, [a5ShopSN] = @a5ShopSN, [a5DelSN] = @a5DelSN, [accessory6] = @accessory6, [a6WhseSN] = @a6WhseSN, [a6ShopSN] = @a6ShopSN, [a6DelSN] = @a6DelSN, [accessory7] = @accessory7, [a7WhseSN] = @a7WhseSN, [a7ShopSN] = @a7ShopSN, [a7DelSN] = @a7DelSN, [accessory8] = @accessory8, [a8WhseSN] = @a8WhseSN, [a8ShopSN] = @a8ShopSN, [a8DelSN] = @a8DelSN, [accessory9] = @accessory9, [a9WhseSN] = @a9WhseSN, [a9ShopSN] = @a9ShopSN, [a9DelSN] = @a9DelSN, [accessory10] = @accessory10, [a10WhseSN] = @a10WhseSN, [a10ShopSN] = @a10ShopSN, [a10DelSN] = @a10DelSN, [accessory11] = @accessory11, [a11WhseSN] = @a11WhseSN, [a11ShopSN] = @a11ShopSN, [a11DelSN] = @a11DelSN, [accessory12] = @accessory12, [a12WhseSN] = @a12WhseSN, [a12ShopSN] = @a12ShopSN, [a12DelSN] = @a12DelSN, [accessory13] = @accessory13, [a13WhseSN] = @a13WhseSN, [a13ShopSN] = @a13ShopSN, [a13DelSN] = @a13DelSN, [accessory14] = @accessory14, [a14WhseSN] = @a14WhseSN, [a14ShopSN] = @a14ShopSN, [a14DelSN] = @a14DelSN, [estDelTime] = @estDelTime, [placement] = @placement, [m1] = @m1, [m2] = @m2 WHERE [orderID] = @original_orderID AND [timeSubmitted] = @original_timeSubmitted AND [repID] = @original_repID AND [salesRep] = @original_salesRep AND [customer] = @original_customer AND [address] = @original_address AND [cityStateZip] = @original_cityStateZip AND [contact] = @original_contact AND [phone] = @original_phone AND [forecastMachineId] = @original_forecastMachineId AND [forecastId] = @original_forecastId AND [forecastModel] = @original_forecastModel AND [comments] = @original_comments AND [neededDate] = @original_neededDate AND [saleType] = @original_saleType AND [networking] = @original_networking AND [stairs] = @original_stairs AND [stairCount] = @original_stairCount AND [deliveryMethod] = @original_deliveryMethod AND [model] = @original_model AND [modelWhseSN] = @original_modelWhseSN AND [modelShopSN] = @original_modelShopSN AND [modelDelSN] = @original_modelDelSN AND [equipId] = @original_equipId AND [meterShop] = @original_meterShop AND [m6] = @original_m6 AND [m7] = @original_m7 AND [m8] = @original_m8 AND [m3] = @original_m3 AND [m4] = @original_m4 AND [m5] = @original_m5 AND [meterDel] = @original_meterDel AND [accessory1] = @original_accessory1 AND [a1WhseSN] = @original_a1WhseSN AND [a1ShopSN] = @original_a1ShopSN AND [a1DelSN] = @original_a1DelSN AND [accessory2] = @original_accessory2 AND [a2WhseSN] = @original_a2WhseSN AND [a2ShopSN] = @original_a2ShopSN AND [a2DelSN] = @original_a2DelSN AND [accessory3] = @original_accessory3 AND [a3WhseSN] = @original_a3WhseSN AND [a3ShopSN] = @original_a3ShopSN AND [a3DelSN] = @original_a3DelSN AND [accessory4] = @original_accessory4 AND [a4WhseSN] = @original_a4WhseSN AND [a4ShopSN] = @original_a4ShopSN AND [a4DelSN] = @original_a4DelSN AND [accessory5] = @original_accessory5 AND [a5WhseSN] = @original_a5WhseSN AND [a5ShopSN] = @original_a5ShopSN AND [a5DelSN] = @original_a5DelSN AND [accessory6] = @original_accessory6 AND [a6WhseSN] = @original_a6WhseSN AND [a6ShopSN] = @original_a6ShopSN AND [a6DelSN] = @original_a6DelSN AND [accessory7] = @original_accessory7 AND [a7WhseSN] = @original_a7WhseSN AND [a7ShopSN] = @original_a7ShopSN AND [a7DelSN] = @original_a7DelSN AND [accessory8] = @original_accessory8 AND [a8WhseSN] = @original_a8WhseSN AND [a8ShopSN] = @original_a8ShopSN AND [a8DelSN] = @original_a8DelSN AND [accessory9] = @original_accessory9 AND [a9WhseSN] = @original_a9WhseSN AND [a9ShopSN] = @original_a9ShopSN AND [a9DelSN] = @original_a9DelSN AND [accessory10] = @original_accessory10 AND [a10WhseSN] = @original_a10WhseSN AND [a10ShopSN] = @original_a10ShopSN AND [a10DelSN] = @original_a10DelSN AND [accessory11] = @original_accessory11 AND [a11WhseSN] = @original_a11WhseSN AND [a11ShopSN] = @original_a11ShopSN AND [a11DelSN] = @original_a11DelSN AND [accessory12] = @original_accessory12 AND [a12WhseSN] = @original_a12WhseSN AND [a12ShopSN] = @original_a12ShopSN AND [a12DelSN] = @original_a12DelSN AND [accessory13] = @original_accessory13 AND [a13WhseSN] = @original_a13WhseSN AND [a13ShopSN] = @original_a13ShopSN AND [a13DelSN] = @original_a13DelSN AND [accessory14] = @original_accessory14 AND [a14WhseSN] = @original_a14WhseSN AND [a14ShopSN] = @original_a14ShopSN AND [a14DelSN] = @original_a14DelSN AND [estDelTime] = @original_estDelTime AND [placement] = @original_placement AND [m1] = @original_m1 AND [m2] = @original_m2">

        <DeleteParameters>

            <asp:Parameter Name="original_orderID" Type="String" />

            <asp:Parameter Name="original_timeSubmitted" Type="String" />

            <asp:Parameter Name="original_repID" Type="Int16" />

            <asp:Parameter Name="original_salesRep" Type="String" />

            <asp:Parameter Name="original_customer" Type="String" />

            <asp:Parameter Name="original_address" Type="String" />

            <asp:Parameter Name="original_cityStateZip" Type="String" />

            <asp:Parameter Name="original_contact" Type="String" />

            <asp:Parameter Name="original_phone" Type="String" />

            <asp:Parameter Name="original_forecastMachineId" Type="String" />

            <asp:Parameter Name="original_forecastId" Type="String" />

            <asp:Parameter Name="original_forecastModel" Type="String" />

            <asp:Parameter Name="original_comments" Type="String" />

            <asp:Parameter Name="original_neededDate" Type="DateTime" />

            <asp:Parameter Name="original_saleType" Type="String" />

            <asp:Parameter Name="original_networking" Type="String" />

            <asp:Parameter Name="original_stairs" Type="String" />

            <asp:Parameter Name="original_stairCount" Type="Int16" />

            <asp:Parameter Name="original_deliveryMethod" Type="String" />

            <asp:Parameter Name="original_model" Type="String" />

            <asp:Parameter Name="original_modelWhseSN" Type="String" />

            <asp:Parameter Name="original_modelShopSN" Type="String" />

            <asp:Parameter Name="original_modelDelSN" Type="String" />

            <asp:Parameter Name="original_equipId" Type="String" />

            <asp:Parameter Name="original_meterShop" Type="String" />

            <asp:Parameter Name="original_m6" Type="String" />

            <asp:Parameter Name="original_m7" Type="String" />

            <asp:Parameter Name="original_m8" Type="String" />

            <asp:Parameter Name="original_m3" Type="String" />

            <asp:Parameter Name="original_m4" Type="String" />

            <asp:Parameter Name="original_m5" Type="String" />

            <asp:Parameter Name="original_meterDel" Type="String" />

            <asp:Parameter Name="original_accessory1" Type="String" />

            <asp:Parameter Name="original_a1WhseSN" Type="String" />

            <asp:Parameter Name="original_a1ShopSN" Type="String" />

            <asp:Parameter Name="original_a1DelSN" Type="String" />

            <asp:Parameter Name="original_accessory2" Type="String" />

            <asp:Parameter Name="original_a2WhseSN" Type="String" />

            <asp:Parameter Name="original_a2ShopSN" Type="String" />

            <asp:Parameter Name="original_a2DelSN" Type="String" />

            <asp:Parameter Name="original_accessory3" Type="String" />

            <asp:Parameter Name="original_a3WhseSN" Type="String" />

            <asp:Parameter Name="original_a3ShopSN" Type="String" />

            <asp:Parameter Name="original_a3DelSN" Type="String" />

            <asp:Parameter Name="original_accessory4" Type="String" />

            <asp:Parameter Name="original_a4WhseSN" Type="String" />

            <asp:Parameter Name="original_a4ShopSN" Type="String" />

            <asp:Parameter Name="original_a4DelSN" Type="String" />

            <asp:Parameter Name="original_accessory5" Type="String" />

            <asp:Parameter Name="original_a5WhseSN" Type="String" />

            <asp:Parameter Name="original_a5ShopSN" Type="String" />

            <asp:Parameter Name="original_a5DelSN" Type="String" />

            <asp:Parameter Name="original_accessory6" Type="String" />

            <asp:Parameter Name="original_a6WhseSN" Type="String" />

            <asp:Parameter Name="original_a6ShopSN" Type="String" />

            <asp:Parameter Name="original_a6DelSN" Type="String" />

            <asp:Parameter Name="original_accessory7" Type="String" />

            <asp:Parameter Name="original_a7WhseSN" Type="String" />

            <asp:Parameter Name="original_a7ShopSN" Type="String" />

            <asp:Parameter Name="original_a7DelSN" Type="String" />

            <asp:Parameter Name="original_accessory8" Type="String" />

            <asp:Parameter Name="original_a8WhseSN" Type="String" />

            <asp:Parameter Name="original_a8ShopSN" Type="String" />

            <asp:Parameter Name="original_a8DelSN" Type="String" />

            <asp:Parameter Name="original_accessory9" Type="String" />

            <asp:Parameter Name="original_a9WhseSN" Type="String" />

            <asp:Parameter Name="original_a9ShopSN" Type="String" />

            <asp:Parameter Name="original_a9DelSN" Type="String" />

            <asp:Parameter Name="original_accessory10" Type="String" />

            <asp:Parameter Name="original_a10WhseSN" Type="String" />

            <asp:Parameter Name="original_a10ShopSN" Type="String" />

            <asp:Parameter Name="original_a10DelSN" Type="String" />

            <asp:Parameter Name="original_accessory11" Type="String" />

            <asp:Parameter Name="original_a11WhseSN" Type="String" />

            <asp:Parameter Name="original_a11ShopSN" Type="String" />

            <asp:Parameter Name="original_a11DelSN" Type="String" />

            <asp:Parameter Name="original_accessory12" Type="String" />

            <asp:Parameter Name="original_a12WhseSN" Type="String" />

            <asp:Parameter Name="original_a12ShopSN" Type="String" />

            <asp:Parameter Name="original_a12DelSN" Type="String" />

            <asp:Parameter Name="original_accessory13" Type="String" />

            <asp:Parameter Name="original_a13WhseSN" Type="String" />

            <asp:Parameter Name="original_a13ShopSN" Type="String" />

            <asp:Parameter Name="original_a13DelSN" Type="String" />

            <asp:Parameter Name="original_accessory14" Type="String" />

            <asp:Parameter Name="original_a14WhseSN" Type="String" />

            <asp:Parameter Name="original_a14ShopSN" Type="String" />

            <asp:Parameter Name="original_a14DelSN" Type="String" />

            <asp:Parameter Name="original_estDelTime" Type="String" />

            <asp:Parameter Name="original_placement" Type="Int32" />

            <asp:Parameter Name="original_m1" Type="String" />

            <asp:Parameter Name="original_m2" Type="String" />

        </DeleteParameters>

        <UpdateParameters>

            <asp:Parameter Name="timeSubmitted" Type="String" />

            <asp:Parameter Name="repID" Type="Int16" />

            <asp:Parameter Name="salesRep" Type="String" />

            <asp:Parameter Name="customer" Type="String" />

            <asp:Parameter Name="address" Type="String" />

            <asp:Parameter Name="cityStateZip" Type="String" />

            <asp:Parameter Name="contact" Type="String" />

            <asp:Parameter Name="phone" Type="String" />

            <asp:Parameter Name="forecastMachineId" Type="String" />

            <asp:Parameter Name="forecastId" Type="String" />

            <asp:Parameter Name="forecastModel" Type="String" />

            <asp:Parameter Name="comments" Type="String" />

            <asp:Parameter Name="neededDate" Type="DateTime" />

            <asp:Parameter Name="saleType" Type="String" />

            <asp:Parameter Name="networking" Type="String" />

            <asp:Parameter Name="stairs" Type="String" />

            <asp:Parameter Name="stairCount" Type="Int16" />

            <asp:Parameter Name="deliveryMethod" Type="String" />

            <asp:Parameter Name="model" Type="String" />

            <asp:Parameter Name="modelWhseSN" Type="String" />

            <asp:Parameter Name="modelShopSN" Type="String" />

            <asp:Parameter Name="modelDelSN" Type="String" />

            <asp:Parameter Name="equipId" Type="String" />

            <asp:Parameter Name="meterShop" Type="String" />

            <asp:Parameter Name="m6" Type="String" />

            <asp:Parameter Name="m7" Type="String" />

            <asp:Parameter Name="m8" Type="String" />

            <asp:Parameter Name="m3" Type="String" />

            <asp:Parameter Name="m4" Type="String" />

            <asp:Parameter Name="m5" Type="String" />

            <asp:Parameter Name="meterDel" Type="String" />

            <asp:Parameter Name="accessory1" Type="String" />

            <asp:Parameter Name="a1WhseSN" Type="String" />

            <asp:Parameter Name="a1ShopSN" Type="String" />

            <asp:Parameter Name="a1DelSN" Type="String" />

            <asp:Parameter Name="accessory2" Type="String" />

            <asp:Parameter Name="a2WhseSN" Type="String" />

            <asp:Parameter Name="a2ShopSN" Type="String" />

            <asp:Parameter Name="a2DelSN" Type="String" />

            <asp:Parameter Name="accessory3" Type="String" />

            <asp:Parameter Name="a3WhseSN" Type="String" />

            <asp:Parameter Name="a3ShopSN" Type="String" />

            <asp:Parameter Name="a3DelSN" Type="String" />

            <asp:Parameter Name="accessory4" Type="String" />

            <asp:Parameter Name="a4WhseSN" Type="String" />

            <asp:Parameter Name="a4ShopSN" Type="String" />

            <asp:Parameter Name="a4DelSN" Type="String" />

            <asp:Parameter Name="accessory5" Type="String" />

            <asp:Parameter Name="a5WhseSN" Type="String" />

            <asp:Parameter Name="a5ShopSN" Type="String" />

            <asp:Parameter Name="a5DelSN" Type="String" />

            <asp:Parameter Name="accessory6" Type="String" />

            <asp:Parameter Name="a6WhseSN" Type="String" />

            <asp:Parameter Name="a6ShopSN" Type="String" />

            <asp:Parameter Name="a6DelSN" Type="String" />

            <asp:Parameter Name="accessory7" Type="String" />

            <asp:Parameter Name="a7WhseSN" Type="String" />

            <asp:Parameter Name="a7ShopSN" Type="String" />

            <asp:Parameter Name="a7DelSN" Type="String" />

            <asp:Parameter Name="accessory8" Type="String" />

            <asp:Parameter Name="a8WhseSN" Type="String" />

            <asp:Parameter Name="a8ShopSN" Type="String" />

            <asp:Parameter Name="a8DelSN" Type="String" />

            <asp:Parameter Name="accessory9" Type="String" />

            <asp:Parameter Name="a9WhseSN" Type="String" />

            <asp:Parameter Name="a9ShopSN" Type="String" />

            <asp:Parameter Name="a9DelSN" Type="String" />

            <asp:Parameter Name="accessory10" Type="String" />

            <asp:Parameter Name="a10WhseSN" Type="String" />

            <asp:Parameter Name="a10ShopSN" Type="String" />

            <asp:Parameter Name="a10DelSN" Type="String" />

            <asp:Parameter Name="accessory11" Type="String" />

            <asp:Parameter Name="a11WhseSN" Type="String" />

            <asp:Parameter Name="a11ShopSN" Type="String" />

            <asp:Parameter Name="a11DelSN" Type="String" />

            <asp:Parameter Name="accessory12" Type="String" />

            <asp:Parameter Name="a12WhseSN" Type="String" />

            <asp:Parameter Name="a12ShopSN" Type="String" />

            <asp:Parameter Name="a12DelSN" Type="String" />

            <asp:Parameter Name="accessory13" Type="String" />

            <asp:Parameter Name="a13WhseSN" Type="String" />

            <asp:Parameter Name="a13ShopSN" Type="String" />

            <asp:Parameter Name="a13DelSN" Type="String" />

            <asp:Parameter Name="accessory14" Type="String" />

            <asp:Parameter Name="a14WhseSN" Type="String" />

            <asp:Parameter Name="a14ShopSN" Type="String" />

            <asp:Parameter Name="a14DelSN" Type="String" />

            <asp:Parameter Name="estDelTime" Type="String" />

            <asp:Parameter Name="placement" Type="Int32" />

            <asp:Parameter Name="m1" Type="String" />

            <asp:Parameter Name="m2" Type="String" />

            <asp:Parameter Name="original_orderID" Type="String" />

            <asp:Parameter Name="original_timeSubmitted" Type="String" />

            <asp:Parameter Name="original_repID" Type="Int16" />

            <asp:Parameter Name="original_salesRep" Type="String" />

            <asp:Parameter Name="original_customer" Type="String" />

            <asp:Parameter Name="original_address" Type="String" />

            <asp:Parameter Name="original_cityStateZip" Type="String" />

            <asp:Parameter Name="original_contact" Type="String" />

            <asp:Parameter Name="original_phone" Type="String" />

            <asp:Parameter Name="original_forecastMachineId" Type="String" />

            <asp:Parameter Name="original_forecastId" Type="String" />

            <asp:Parameter Name="original_forecastModel" Type="String" />

            <asp:Parameter Name="original_comments" Type="String" />

            <asp:Parameter Name="original_neededDate" Type="DateTime" />

            <asp:Parameter Name="original_saleType" Type="String" />

            <asp:Parameter Name="original_networking" Type="String" />

            <asp:Parameter Name="original_stairs" Type="String" />

            <asp:Parameter Name="original_stairCount" Type="Int16" />

            <asp:Parameter Name="original_deliveryMethod" Type="String" />

            <asp:Parameter Name="original_model" Type="String" />

            <asp:Parameter Name="original_modelWhseSN" Type="String" />

            <asp:Parameter Name="original_modelShopSN" Type="String" />

            <asp:Parameter Name="original_modelDelSN" Type="String" />

            <asp:Parameter Name="original_equipId" Type="String" />

            <asp:Parameter Name="original_meterShop" Type="String" />

            <asp:Parameter Name="original_m6" Type="String" />

            <asp:Parameter Name="original_m7" Type="String" />

            <asp:Parameter Name="original_m8" Type="String" />

            <asp:Parameter Name="original_m3" Type="String" />

            <asp:Parameter Name="original_m4" Type="String" />

            <asp:Parameter Name="original_m5" Type="String" />

            <asp:Parameter Name="original_meterDel" Type="String" />

            <asp:Parameter Name="original_accessory1" Type="String" />

            <asp:Parameter Name="original_a1WhseSN" Type="String" />

            <asp:Parameter Name="original_a1ShopSN" Type="String" />

            <asp:Parameter Name="original_a1DelSN" Type="String" />

            <asp:Parameter Name="original_accessory2" Type="String" />

            <asp:Parameter Name="original_a2WhseSN" Type="String" />

            <asp:Parameter Name="original_a2ShopSN" Type="String" />

            <asp:Parameter Name="original_a2DelSN" Type="String" />

            <asp:Parameter Name="original_accessory3" Type="String" />

            <asp:Parameter Name="original_a3WhseSN" Type="String" />

            <asp:Parameter Name="original_a3ShopSN" Type="String" />

            <asp:Parameter Name="original_a3DelSN" Type="String" />

            <asp:Parameter Name="original_accessory4" Type="String" />

            <asp:Parameter Name="original_a4WhseSN" Type="String" />

            <asp:Parameter Name="original_a4ShopSN" Type="String" />

            <asp:Parameter Name="original_a4DelSN" Type="String" />

            <asp:Parameter Name="original_accessory5" Type="String" />

            <asp:Parameter Name="original_a5WhseSN" Type="String" />

            <asp:Parameter Name="original_a5ShopSN" Type="String" />

            <asp:Parameter Name="original_a5DelSN" Type="String" />

            <asp:Parameter Name="original_accessory6" Type="String" />

            <asp:Parameter Name="original_a6WhseSN" Type="String" />

            <asp:Parameter Name="original_a6ShopSN" Type="String" />

            <asp:Parameter Name="original_a6DelSN" Type="String" />

            <asp:Parameter Name="original_accessory7" Type="String" />

            <asp:Parameter Name="original_a7WhseSN" Type="String" />

            <asp:Parameter Name="original_a7ShopSN" Type="String" />

            <asp:Parameter Name="original_a7DelSN" Type="String" />

            <asp:Parameter Name="original_accessory8" Type="String" />

            <asp:Parameter Name="original_a8WhseSN" Type="String" />

            <asp:Parameter Name="original_a8ShopSN" Type="String" />

            <asp:Parameter Name="original_a8DelSN" Type="String" />

            <asp:Parameter Name="original_accessory9" Type="String" />

            <asp:Parameter Name="original_a9WhseSN" Type="String" />

            <asp:Parameter Name="original_a9ShopSN" Type="String" />

            <asp:Parameter Name="original_a9DelSN" Type="String" />

            <asp:Parameter Name="original_accessory10" Type="String" />

            <asp:Parameter Name="original_a10WhseSN" Type="String" />

            <asp:Parameter Name="original_a10ShopSN" Type="String" />

            <asp:Parameter Name="original_a10DelSN" Type="String" />

            <asp:Parameter Name="original_accessory11" Type="String" />

            <asp:Parameter Name="original_a11WhseSN" Type="String" />

            <asp:Parameter Name="original_a11ShopSN" Type="String" />

            <asp:Parameter Name="original_a11DelSN" Type="String" />

            <asp:Parameter Name="original_accessory12" Type="String" />

            <asp:Parameter Name="original_a12WhseSN" Type="String" />

            <asp:Parameter Name="original_a12ShopSN" Type="String" />

            <asp:Parameter Name="original_a12DelSN" Type="String" />

            <asp:Parameter Name="original_accessory13" Type="String" />

            <asp:Parameter Name="original_a13WhseSN" Type="String" />

            <asp:Parameter Name="original_a13ShopSN" Type="String" />

            <asp:Parameter Name="original_a13DelSN" Type="String" />

            <asp:Parameter Name="original_accessory14" Type="String" />

            <asp:Parameter Name="original_a14WhseSN" Type="String" />

            <asp:Parameter Name="original_a14ShopSN" Type="String" />

            <asp:Parameter Name="original_a14DelSN" Type="String" />

            <asp:Parameter Name="original_estDelTime" Type="String" />

            <asp:Parameter Name="original_placement" Type="Int32" />

            <asp:Parameter Name="original_m1" Type="String" />

            <asp:Parameter Name="original_m2" Type="String" />

        </UpdateParameters>

        <InsertParameters>

            <asp:Parameter Name="orderID" Type="String" />

            <asp:Parameter Name="timeSubmitted" Type="String" />

            <asp:Parameter Name="repID" Type="Int16" />

            <asp:Parameter Name="salesRep" Type="String" />

            <asp:Parameter Name="customer" Type="String" />

            <asp:Parameter Name="address" Type="String" />

            <asp:Parameter Name="cityStateZip" Type="String" />

            <asp:Parameter Name="contact" Type="String" />

            <asp:Parameter Name="phone" Type="String" />

            <asp:Parameter Name="forecastMachineId" Type="String" />

            <asp:Parameter Name="forecastId" Type="String" />

            <asp:Parameter Name="forecastModel" Type="String" />

            <asp:Parameter Name="comments" Type="String" />

            <asp:Parameter Name="neededDate" Type="DateTime" />

            <asp:Parameter Name="saleType" Type="String" />

            <asp:Parameter Name="networking" Type="String" />

            <asp:Parameter Name="stairs" Type="String" />

            <asp:Parameter Name="stairCount" Type="Int16" />

            <asp:Parameter Name="deliveryMethod" Type="String" />

            <asp:Parameter Name="model" Type="String" />

            <asp:Parameter Name="modelWhseSN" Type="String" />

            <asp:Parameter Name="modelShopSN" Type="String" />

            <asp:Parameter Name="modelDelSN" Type="String" />

            <asp:Parameter Name="equipId" Type="String" />

            <asp:Parameter Name="meterShop" Type="String" />

            <asp:Parameter Name="m6" Type="String" />

            <asp:Parameter Name="m7" Type="String" />

            <asp:Parameter Name="m8" Type="String" />

            <asp:Parameter Name="m3" Type="String" />

            <asp:Parameter Name="m4" Type="String" />

            <asp:Parameter Name="m5" Type="String" />

            <asp:Parameter Name="meterDel" Type="String" />

            <asp:Parameter Name="accessory1" Type="String" />

            <asp:Parameter Name="a1WhseSN" Type="String" />

            <asp:Parameter Name="a1ShopSN" Type="String" />

            <asp:Parameter Name="a1DelSN" Type="String" />

            <asp:Parameter Name="accessory2" Type="String" />

            <asp:Parameter Name="a2WhseSN" Type="String" />

            <asp:Parameter Name="a2ShopSN" Type="String" />

            <asp:Parameter Name="a2DelSN" Type="String" />

            <asp:Parameter Name="accessory3" Type="String" />

            <asp:Parameter Name="a3WhseSN" Type="String" />

            <asp:Parameter Name="a3ShopSN" Type="String" />

            <asp:Parameter Name="a3DelSN" Type="String" />

            <asp:Parameter Name="accessory4" Type="String" />

            <asp:Parameter Name="a4WhseSN" Type="String" />

            <asp:Parameter Name="a4ShopSN" Type="String" />

            <asp:Parameter Name="a4DelSN" Type="String" />

            <asp:Parameter Name="accessory5" Type="String" />

            <asp:Parameter Name="a5WhseSN" Type="String" />

            <asp:Parameter Name="a5ShopSN" Type="String" />

            <asp:Parameter Name="a5DelSN" Type="String" />

            <asp:Parameter Name="accessory6" Type="String" />

            <asp:Parameter Name="a6WhseSN" Type="String" />

            <asp:Parameter Name="a6ShopSN" Type="String" />

            <asp:Parameter Name="a6DelSN" Type="String" />

            <asp:Parameter Name="accessory7" Type="String" />

            <asp:Parameter Name="a7WhseSN" Type="String" />

            <asp:Parameter Name="a7ShopSN" Type="String" />

            <asp:Parameter Name="a7DelSN" Type="String" />

            <asp:Parameter Name="accessory8" Type="String" />

            <asp:Parameter Name="a8WhseSN" Type="String" />

            <asp:Parameter Name="a8ShopSN" Type="String" />

            <asp:Parameter Name="a8DelSN" Type="String" />

            <asp:Parameter Name="accessory9" Type="String" />

            <asp:Parameter Name="a9WhseSN" Type="String" />

            <asp:Parameter Name="a9ShopSN" Type="String" />

            <asp:Parameter Name="a9DelSN" Type="String" />

            <asp:Parameter Name="accessory10" Type="String" />

            <asp:Parameter Name="a10WhseSN" Type="String" />

            <asp:Parameter Name="a10ShopSN" Type="String" />

            <asp:Parameter Name="a10DelSN" Type="String" />

            <asp:Parameter Name="accessory11" Type="String" />

            <asp:Parameter Name="a11WhseSN" Type="String" />

            <asp:Parameter Name="a11ShopSN" Type="String" />

            <asp:Parameter Name="a11DelSN" Type="String" />

            <asp:Parameter Name="accessory12" Type="String" />

            <asp:Parameter Name="a12WhseSN" Type="String" />

            <asp:Parameter Name="a12ShopSN" Type="String" />

            <asp:Parameter Name="a12DelSN" Type="String" />

            <asp:Parameter Name="accessory13" Type="String" />

            <asp:Parameter Name="a13WhseSN" Type="String" />

            <asp:Parameter Name="a13ShopSN" Type="String" />

            <asp:Parameter Name="a13DelSN" Type="String" />

            <asp:Parameter Name="accessory14" Type="String" />

            <asp:Parameter Name="a14WhseSN" Type="String" />

            <asp:Parameter Name="a14ShopSN" Type="String" />

            <asp:Parameter Name="a14DelSN" Type="String" />

            <asp:Parameter Name="estDelTime" Type="String" />

            <asp:Parameter Name="placement" Type="Int32" />

            <asp:Parameter Name="m1" Type="String" />

            <asp:Parameter Name="m2" Type="String" />

        </InsertParameters>

    </asp:SqlDataSource>

    <asp:FormView ID="FormView2" runat="server" DataKeyNames="orderID" 

        DataSourceID="SqlDataSource1" ForeColor="White">

        <EditItemTemplate>

            

            <%--<tr id="orderIDrow" runat="server" visible="false" ><td align="right"><b>Order Id:</b></td>       <td><%#Eval("orderID")%></td> </tr>

            <tr><td align="right"><b>Time Submitted:</b></td>       <td><%#Eval("timeSubmitted")%></td></tr>

            <tr><td align="right"><b>Rep Id:</b></td>       <td><%#Eval("repID")%></td></tr>

            <tr><td align="right"><b>Sales Rep:</b></td>       <td><%#Eval("salesRep")%></td></tr>

            <tr><td align="right"><b>Customer:</b></td>       <td><%#Eval("customer")%></td></tr>

            <tr><td align="right"><b>Address:</b></td>       <td><%#Eval("address")%></td></tr>--%>

            

            orderID:

            <asp:Label ID="orderIDLabel1" runat="server" Text='<%# Eval("orderID") %>' />

            <br />

            timeSubmitted:

            <asp:TextBox ID="timeSubmittedTextBox" runat="server" 

                Text='<%# Bind("timeSubmitted") %>' />

            <br />

            repID:

            <asp:TextBox ID="repIDTextBox" runat="server" Text='<%# Bind("repID") %>' />

            <br />

            salesRep:

            <asp:TextBox ID="salesRepTextBox" runat="server" 

                Text='<%# Bind("salesRep") %>' />

            <br />

            customer:

            <asp:TextBox ID="customerTextBox" runat="server" 

                Text='<%# Bind("customer") %>' />

            <br />

            address:

            <asp:TextBox ID="addressTextBox" runat="server" Text='<%# Bind("address") %>' />

            <br />

            cityStateZip:

            <asp:TextBox ID="cityStateZipTextBox" runat="server" 

                Text='<%# Bind("cityStateZip") %>' />

            <br />

            contact:

            <asp:TextBox ID="contactTextBox" runat="server" Text='<%# Bind("contact") %>' />

            <br />

            phone:

            <asp:TextBox ID="phoneTextBox" runat="server" Text='<%# Bind("phone") %>' />

            <br />

            forecastMachineId:

            <asp:TextBox ID="forecastMachineIdTextBox" runat="server" 

                Text='<%# Bind("forecastMachineId") %>' />

            <br />

            forecastId:

            <asp:TextBox ID="forecastIdTextBox" runat="server" 

                Text='<%# Bind("forecastId") %>' />

            <br />

            forecastModel:

            <asp:TextBox ID="forecastModelTextBox" runat="server" 

                Text='<%# Bind("forecastModel") %>' />

            <br />

            comments:

            <asp:TextBox ID="commentsTextBox" runat="server" 

                Text='<%# Bind("comments") %>' />

            <br />

            neededDate:

            <asp:TextBox ID="neededDateTextBox" runat="server" 

                Text='<%# Bind("neededDate") %>' />

            <br />

            saleType:

            <asp:TextBox ID="saleTypeTextBox" runat="server" 

                Text='<%# Bind("saleType") %>' />

            <br />

            networking:

            <asp:TextBox ID="networkingTextBox" runat="server" 

                Text='<%# Bind("networking") %>' />

            <br />

            stairs:

            <asp:TextBox ID="stairsTextBox" runat="server" Text='<%# Bind("stairs") %>' />

            <br />

            stairCount:

            <asp:TextBox ID="stairCountTextBox" runat="server" 

                Text='<%# Bind("stairCount") %>' />

            <br />

            deliveryMethod:

            <asp:TextBox ID="deliveryMethodTextBox" runat="server" 

                Text='<%# Bind("deliveryMethod") %>' />

            <br />

            model:

            <asp:TextBox ID="modelTextBox" runat="server" Text='<%# Bind("model") %>' />

            <br />

            modelWhseSN:

            <asp:TextBox ID="modelWhseSNTextBox" runat="server" 

                Text='<%# Bind("modelWhseSN") %>' />

            <br />

            modelShopSN:

            <asp:TextBox ID="modelShopSNTextBox" runat="server" 

                Text='<%# Bind("modelShopSN") %>' />

            <br />

            modelDelSN:

            <asp:TextBox ID="modelDelSNTextBox" runat="server" 

                Text='<%# Bind("modelDelSN") %>' />

            <br />

            equipId:

            <asp:TextBox ID="equipIdTextBox" runat="server" Text='<%# Bind("equipId") %>' />

            <br />

            meterShop:

            <asp:TextBox ID="meterShopTextBox" runat="server" 

                Text='<%# Bind("meterShop") %>' />

            <br />

            m6:

            <asp:TextBox ID="m6TextBox" runat="server" Text='<%# Bind("m6") %>' />

            <br />

            m7:

            <asp:TextBox ID="m7TextBox" runat="server" Text='<%# Bind("m7") %>' />

            <br />

            m8:

            <asp:TextBox ID="m8TextBox" runat="server" Text='<%# Bind("m8") %>' />

            <br />

            m3:

            <asp:TextBox ID="m3TextBox" runat="server" Text='<%# Bind("m3") %>' />

            <br />

            m4:

            <asp:TextBox ID="m4TextBox" runat="server" Text='<%# Bind("m4") %>' />

            <br />

            m5:

            <asp:TextBox ID="m5TextBox" runat="server" Text='<%# Bind("m5") %>' />

            <br />

            meterDel:

            <asp:TextBox ID="meterDelTextBox" runat="server" 

                Text='<%# Bind("meterDel") %>' />

            <br />

            accessory1:

            <asp:TextBox ID="accessory1TextBox" runat="server" 

                Text='<%# Bind("accessory1") %>' />

            <br />

            a1WhseSN:

            <asp:TextBox ID="a1WhseSNTextBox" runat="server" 

                Text='<%# Bind("a1WhseSN") %>' />

            <br />

            a1ShopSN:

            <asp:TextBox ID="a1ShopSNTextBox" runat="server" 

                Text='<%# Bind("a1ShopSN") %>' />

            <br />

            a1DelSN:

            <asp:TextBox ID="a1DelSNTextBox" runat="server" Text='<%# Bind("a1DelSN") %>' />

            <br />

            accessory2:

            <asp:TextBox ID="accessory2TextBox" runat="server" 

                Text='<%# Bind("accessory2") %>' />

            <br />

            a2WhseSN:

            <asp:TextBox ID="a2WhseSNTextBox" runat="server" 

                Text='<%# Bind("a2WhseSN") %>' />

            <br />

            a2ShopSN:

            <asp:TextBox ID="a2ShopSNTextBox" runat="server" 

                Text='<%# Bind("a2ShopSN") %>' />

            <br />

            a2DelSN:

            <asp:TextBox ID="a2DelSNTextBox" runat="server" Text='<%# Bind("a2DelSN") %>' />

            <br />

            accessory3:

            <asp:TextBox ID="accessory3TextBox" runat="server" 

                Text='<%# Bind("accessory3") %>' />

            <br />

            a3WhseSN:

            <asp:TextBox ID="a3WhseSNTextBox" runat="server" 

                Text='<%# Bind("a3WhseSN") %>' />

            <br />

            a3ShopSN:

            <asp:TextBox ID="a3ShopSNTextBox" runat="server" 

                Text='<%# Bind("a3ShopSN") %>' />

            <br />

            a3DelSN:

            <asp:TextBox ID="a3DelSNTextBox" runat="server" Text='<%# Bind("a3DelSN") %>' />

            <br />

            accessory4:

            <asp:TextBox ID="accessory4TextBox" runat="server" 

                Text='<%# Bind("accessory4") %>' />

            <br />

            a4WhseSN:

            <asp:TextBox ID="a4WhseSNTextBox" runat="server" 

                Text='<%# Bind("a4WhseSN") %>' />

            <br />

            a4ShopSN:

            <asp:TextBox ID="a4ShopSNTextBox" runat="server" 

                Text='<%# Bind("a4ShopSN") %>' />

            <br />

            a4DelSN:

            <asp:TextBox ID="a4DelSNTextBox" runat="server" Text='<%# Bind("a4DelSN") %>' />

            <br />

            accessory5:

            <asp:TextBox ID="accessory5TextBox" runat="server" 

                Text='<%# Bind("accessory5") %>' />

            <br />

            a5WhseSN:

            <asp:TextBox ID="a5WhseSNTextBox" runat="server" 

                Text='<%# Bind("a5WhseSN") %>' />

            <br />

            a5ShopSN:

            <asp:TextBox ID="a5ShopSNTextBox" runat="server" 

                Text='<%# Bind("a5ShopSN") %>' />

            <br />

            a5DelSN:

            <asp:TextBox ID="a5DelSNTextBox" runat="server" Text='<%# Bind("a5DelSN") %>' />

            <br />

            accessory6:

            <asp:TextBox ID="accessory6TextBox" runat="server" 

                Text='<%# Bind("accessory6") %>' />

            <br />

            a6WhseSN:

            <asp:TextBox ID="a6WhseSNTextBox" runat="server" 

                Text='<%# Bind("a6WhseSN") %>' />

            <br />

            a6ShopSN:

            <asp:TextBox ID="a6ShopSNTextBox" runat="server" 

                Text='<%# Bind("a6ShopSN") %>' />

            <br />

            a6DelSN:

            <asp:TextBox ID="a6DelSNTextBox" runat="server" Text='<%# Bind("a6DelSN") %>' />

            <br />

            accessory7:

            <asp:TextBox ID="accessory7TextBox" runat="server" 

                Text='<%# Bind("accessory7") %>' />

            <br />

            a7WhseSN:

            <asp:TextBox ID="a7WhseSNTextBox" runat="server" 

                Text='<%# Bind("a7WhseSN") %>' />

            <br />

            a7ShopSN:

            <asp:TextBox ID="a7ShopSNTextBox" runat="server" 

                Text='<%# Bind("a7ShopSN") %>' />

            <br />

            a7DelSN:

            <asp:TextBox ID="a7DelSNTextBox" runat="server" Text='<%# Bind("a7DelSN") %>' />

            <br />

            accessory8:

            <asp:TextBox ID="accessory8TextBox" runat="server" 

                Text='<%# Bind("accessory8") %>' />

            <br />

            a8WhseSN:

            <asp:TextBox ID="a8WhseSNTextBox" runat="server" 

                Text='<%# Bind("a8WhseSN") %>' />

            <br />

            a8ShopSN:

            <asp:TextBox ID="a8ShopSNTextBox" runat="server" 

                Text='<%# Bind("a8ShopSN") %>' />

            <br />

            a8DelSN:

            <asp:TextBox ID="a8DelSNTextBox" runat="server" Text='<%# Bind("a8DelSN") %>' />

            <br />

            accessory9:

            <asp:TextBox ID="accessory9TextBox" runat="server" 

                Text='<%# Bind("accessory9") %>' />

            <br />

            a9WhseSN:

            <asp:TextBox ID="a9WhseSNTextBox" runat="server" 

                Text='<%# Bind("a9WhseSN") %>' />

            <br />

            a9ShopSN:

            <asp:TextBox ID="a9ShopSNTextBox" runat="server" 

                Text='<%# Bind("a9ShopSN") %>' />

            <br />

            a9DelSN:

            <asp:TextBox ID="a9DelSNTextBox" runat="server" Text='<%# Bind("a9DelSN") %>' />

            <br />

            accessory10:

            <asp:TextBox ID="accessory10TextBox" runat="server" 

                Text='<%# Bind("accessory10") %>' />

            <br />

            a10WhseSN:

            <asp:TextBox ID="a10WhseSNTextBox" runat="server" 

                Text='<%# Bind("a10WhseSN") %>' />

            <br />

            a10ShopSN:

            <asp:TextBox ID="a10ShopSNTextBox" runat="server" 

                Text='<%# Bind("a10ShopSN") %>' />

            <br />

            a10DelSN:

            <asp:TextBox ID="a10DelSNTextBox" runat="server" 

                Text='<%# Bind("a10DelSN") %>' />

            <br />

            accessory11:

            <asp:TextBox ID="accessory11TextBox" runat="server" 

                Text='<%# Bind("accessory11") %>' />

            <br />

            a11WhseSN:

            <asp:TextBox ID="a11WhseSNTextBox" runat="server" 

                Text='<%# Bind("a11WhseSN") %>' />

            <br />

            a11ShopSN:

            <asp:TextBox ID="a11ShopSNTextBox" runat="server" 

                Text='<%# Bind("a11ShopSN") %>' />

            <br />

            a11DelSN:

            <asp:TextBox ID="a11DelSNTextBox" runat="server" 

                Text='<%# Bind("a11DelSN") %>' />

            <br />

            accessory12:

            <asp:TextBox ID="accessory12TextBox" runat="server" 

                Text='<%# Bind("accessory12") %>' />

            <br />

            a12WhseSN:

            <asp:TextBox ID="a12WhseSNTextBox" runat="server" 

                Text='<%# Bind("a12WhseSN") %>' />

            <br />

            a12ShopSN:

            <asp:TextBox ID="a12ShopSNTextBox" runat="server" 

                Text='<%# Bind("a12ShopSN") %>' />

            <br />

            a12DelSN:

            <asp:TextBox ID="a12DelSNTextBox" runat="server" 

                Text='<%# Bind("a12DelSN") %>' />

            <br />

            accessory13:

            <asp:TextBox ID="accessory13TextBox" runat="server" 

                Text='<%# Bind("accessory13") %>' />

            <br />

            a13WhseSN:

            <asp:TextBox ID="a13WhseSNTextBox" runat="server" 

                Text='<%# Bind("a13WhseSN") %>' />

            <br />

            a13ShopSN:

            <asp:TextBox ID="a13ShopSNTextBox" runat="server" 

                Text='<%# Bind("a13ShopSN") %>' />

            <br />

            a13DelSN:

            <asp:TextBox ID="a13DelSNTextBox" runat="server" 

                Text='<%# Bind("a13DelSN") %>' />

            <br />

            accessory14:

            <asp:TextBox ID="accessory14TextBox" runat="server" 

                Text='<%# Bind("accessory14") %>' />

            <br />

            a14WhseSN:

            <asp:TextBox ID="a14WhseSNTextBox" runat="server" 

                Text='<%# Bind("a14WhseSN") %>' />

            <br />

            a14ShopSN:

            <asp:TextBox ID="a14ShopSNTextBox" runat="server" 

                Text='<%# Bind("a14ShopSN") %>' />

            <br />

            a14DelSN:

            <asp:TextBox ID="a14DelSNTextBox" runat="server" 

                Text='<%# Bind("a14DelSN") %>' />

            <br />

            estDelTime:

            <asp:TextBox ID="estDelTimeTextBox" runat="server" 

                Text='<%# Bind("estDelTime") %>' />

            <br />

            placement:

            <asp:TextBox ID="placementTextBox" runat="server" 

                Text='<%# Bind("placement") %>' />

            <br />

            m1:

            <asp:TextBox ID="m1TextBox" runat="server" Text='<%# Bind("m1") %>' />

            <br />

            m2:

            <asp:TextBox ID="m2TextBox" runat="server" Text='<%# Bind("m2") %>' />

            <br />

            <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" 

                CommandName="Update" Text="Update" />

            &nbsp;<asp:LinkButton ID="UpdateCancelButton" runat="server" 

                CausesValidation="False" CommandName="Cancel" Text="Cancel" />

        </EditItemTemplate>

        <InsertItemTemplate>

            orderID:

            <asp:TextBox ID="orderIDTextBox" runat="server" Text='<%# Bind("orderID") %>' />

            <br />

            timeSubmitted:

            <asp:TextBox ID="timeSubmittedTextBox" runat="server" 

                Text='<%# Bind("timeSubmitted") %>' />

            <br />

            repID:

            <asp:TextBox ID="repIDTextBox" runat="server" Text='<%# Bind("repID") %>' />

            <br />

            salesRep:

            <asp:TextBox ID="salesRepTextBox" runat="server" 

                Text='<%# Bind("salesRep") %>' />

            <br />

            customer:

            <asp:TextBox ID="customerTextBox" runat="server" 

                Text='<%# Bind("customer") %>' />

            <br />

            address:

            <asp:TextBox ID="addressTextBox" runat="server" Text='<%# Bind("address") %>' />

            <br />

            cityStateZip:

            <asp:TextBox ID="cityStateZipTextBox" runat="server" 

                Text='<%# Bind("cityStateZip") %>' />

            <br />

            contact:

            <asp:TextBox ID="contactTextBox" runat="server" Text='<%# Bind("contact") %>' />

            <br />

            phone:

            <asp:TextBox ID="phoneTextBox" runat="server" Text='<%# Bind("phone") %>' />

            <br />

            forecastMachineId:

            <asp:TextBox ID="forecastMachineIdTextBox" runat="server" 

                Text='<%# Bind("forecastMachineId") %>' />

            <br />

            forecastId:

            <asp:TextBox ID="forecastIdTextBox" runat="server" 

                Text='<%# Bind("forecastId") %>' />

            <br />

            forecastModel:

            <asp:TextBox ID="forecastModelTextBox" runat="server" 

                Text='<%# Bind("forecastModel") %>' />

            <br />

            comments:

            <asp:TextBox ID="commentsTextBox" runat="server" 

                Text='<%# Bind("comments") %>' />

            <br />

            neededDate:

            <asp:TextBox ID="neededDateTextBox" runat="server" 

                Text='<%# Bind("neededDate") %>' />

            <br />

            saleType:

            <asp:TextBox ID="saleTypeTextBox" runat="server" 

                Text='<%# Bind("saleType") %>' />

            <br />

            networking:

            <asp:TextBox ID="networkingTextBox" runat="server" 

                Text='<%# Bind("networking") %>' />

            <br />

            stairs:

            <asp:TextBox ID="stairsTextBox" runat="server" Text='<%# Bind("stairs") %>' />

            <br />

            stairCount:

            <asp:TextBox ID="stairCountTextBox" runat="server" 

                Text='<%# Bind("stairCount") %>' />

            <br />

            deliveryMethod:

            <asp:TextBox ID="deliveryMethodTextBox" runat="server" 

                Text='<%# Bind("deliveryMethod") %>' />

            <br />

            model:

            <asp:TextBox ID="modelTextBox" runat="server" Text='<%# Bind("model") %>' />

            <br />

            modelWhseSN:

            <asp:TextBox ID="modelWhseSNTextBox" runat="server" 

                Text='<%# Bind("modelWhseSN") %>' />

            <br />

            modelShopSN:

            <asp:TextBox ID="modelShopSNTextBox" runat="server" 

                Text='<%# Bind("modelShopSN") %>' />

            <br />

            modelDelSN:

            <asp:TextBox ID="modelDelSNTextBox" runat="server" 

                Text='<%# Bind("modelDelSN") %>' />

            <br />

            equipId:

            <asp:TextBox ID="equipIdTextBox" runat="server" Text='<%# Bind("equipId") %>' />

            <br />

            meterShop:

            <asp:TextBox ID="meterShopTextBox" runat="server" 

                Text='<%# Bind("meterShop") %>' />

            <br />

            m6:

            <asp:TextBox ID="m6TextBox" runat="server" Text='<%# Bind("m6") %>' />

            <br />

            m7:

            <asp:TextBox ID="m7TextBox" runat="server" Text='<%# Bind("m7") %>' />

            <br />

            m8:

            <asp:TextBox ID="m8TextBox" runat="server" Text='<%# Bind("m8") %>' />

            <br />

            m3:

            <asp:TextBox ID="m3TextBox" runat="server" Text='<%# Bind("m3") %>' />

            <br />

            m4:

            <asp:TextBox ID="m4TextBox" runat="server" Text='<%# Bind("m4") %>' />

            <br />

            m5:

            <asp:TextBox ID="m5TextBox" runat="server" Text='<%# Bind("m5") %>' />

            <br />

            meterDel:

            <asp:TextBox ID="meterDelTextBox" runat="server" 

                Text='<%# Bind("meterDel") %>' />

            <br />

            accessory1:

            <asp:TextBox ID="accessory1TextBox" runat="server" 

                Text='<%# Bind("accessory1") %>' />

            <br />

            a1WhseSN:

            <asp:TextBox ID="a1WhseSNTextBox" runat="server" 

                Text='<%# Bind("a1WhseSN") %>' />

            <br />

            a1ShopSN:

            <asp:TextBox ID="a1ShopSNTextBox" runat="server" 

                Text='<%# Bind("a1ShopSN") %>' />

            <br />

            a1DelSN:

            <asp:TextBox ID="a1DelSNTextBox" runat="server" Text='<%# Bind("a1DelSN") %>' />

            <br />

            accessory2:

            <asp:TextBox ID="accessory2TextBox" runat="server" 

                Text='<%# Bind("accessory2") %>' />

            <br />

            a2WhseSN:

            <asp:TextBox ID="a2WhseSNTextBox" runat="server" 

                Text='<%# Bind("a2WhseSN") %>' />

            <br />

            a2ShopSN:

            <asp:TextBox ID="a2ShopSNTextBox" runat="server" 

                Text='<%# Bind("a2ShopSN") %>' />

            <br />

            a2DelSN:

            <asp:TextBox ID="a2DelSNTextBox" runat="server" Text='<%# Bind("a2DelSN") %>' />

            <br />

            accessory3:

            <asp:TextBox ID="accessory3TextBox" runat="server" 

                Text='<%# Bind("accessory3") %>' />

            <br />

            a3WhseSN:

            <asp:TextBox ID="a3WhseSNTextBox" runat="server" 

                Text='<%# Bind("a3WhseSN") %>' />

            <br />

            a3ShopSN:

            <asp:TextBox ID="a3ShopSNTextBox" runat="server" 

                Text='<%# Bind("a3ShopSN") %>' />

            <br />

            a3DelSN:

            <asp:TextBox ID="a3DelSNTextBox" runat="server" Text='<%# Bind("a3DelSN") %>' />

            <br />

            accessory4:

            <asp:TextBox ID="accessory4TextBox" runat="server" 

                Text='<%# Bind("accessory4") %>' />

            <br />

            a4WhseSN:

            <asp:TextBox ID="a4WhseSNTextBox" runat="server" 

                Text='<%# Bind("a4WhseSN") %>' />

            <br />

            a4ShopSN:

            <asp:TextBox ID="a4ShopSNTextBox" runat="server" 

                Text='<%# Bind("a4ShopSN") %>' />

            <br />

            a4DelSN:

            <asp:TextBox ID="a4DelSNTextBox" runat="server" Text='<%# Bind("a4DelSN") %>' />

            <br />

            accessory5:

            <asp:TextBox ID="accessory5TextBox" runat="server" 

                Text='<%# Bind("accessory5") %>' />

            <br />

            a5WhseSN:

            <asp:TextBox ID="a5WhseSNTextBox" runat="server" 

                Text='<%# Bind("a5WhseSN") %>' />

            <br />

            a5ShopSN:

            <asp:TextBox ID="a5ShopSNTextBox" runat="server" 

                Text='<%# Bind("a5ShopSN") %>' />

            <br />

            a5DelSN:

            <asp:TextBox ID="a5DelSNTextBox" runat="server" Text='<%# Bind("a5DelSN") %>' />

            <br />

            accessory6:

            <asp:TextBox ID="accessory6TextBox" runat="server" 

                Text='<%# Bind("accessory6") %>' />

            <br />

            a6WhseSN:

            <asp:TextBox ID="a6WhseSNTextBox" runat="server" 

                Text='<%# Bind("a6WhseSN") %>' />

            <br />

            a6ShopSN:

            <asp:TextBox ID="a6ShopSNTextBox" runat="server" 

                Text='<%# Bind("a6ShopSN") %>' />

            <br />

            a6DelSN:

            <asp:TextBox ID="a6DelSNTextBox" runat="server" Text='<%# Bind("a6DelSN") %>' />

            <br />

            accessory7:

            <asp:TextBox ID="accessory7TextBox" runat="server" 

                Text='<%# Bind("accessory7") %>' />

            <br />

            a7WhseSN:

            <asp:TextBox ID="a7WhseSNTextBox" runat="server" 

                Text='<%# Bind("a7WhseSN") %>' />

            <br />

            a7ShopSN:

            <asp:TextBox ID="a7ShopSNTextBox" runat="server" 

                Text='<%# Bind("a7ShopSN") %>' />

            <br />

            a7DelSN:

            <asp:TextBox ID="a7DelSNTextBox" runat="server" Text='<%# Bind("a7DelSN") %>' />

            <br />

            accessory8:

            <asp:TextBox ID="accessory8TextBox" runat="server" 

                Text='<%# Bind("accessory8") %>' />

            <br />

            a8WhseSN:

            <asp:TextBox ID="a8WhseSNTextBox" runat="server" 

                Text='<%# Bind("a8WhseSN") %>' />

            <br />

            a8ShopSN:

            <asp:TextBox ID="a8ShopSNTextBox" runat="server" 

                Text='<%# Bind("a8ShopSN") %>' />

            <br />

            a8DelSN:

            <asp:TextBox ID="a8DelSNTextBox" runat="server" Text='<%# Bind("a8DelSN") %>' />

            <br />

            accessory9:

            <asp:TextBox ID="accessory9TextBox" runat="server" 

                Text='<%# Bind("accessory9") %>' />

            <br />

            a9WhseSN:

            <asp:TextBox ID="a9WhseSNTextBox" runat="server" 

                Text='<%# Bind("a9WhseSN") %>' />

            <br />

            a9ShopSN:

            <asp:TextBox ID="a9ShopSNTextBox" runat="server" 

                Text='<%# Bind("a9ShopSN") %>' />

            <br />

            a9DelSN:

            <asp:TextBox ID="a9DelSNTextBox" runat="server" Text='<%# Bind("a9DelSN") %>' />

            <br />

            accessory10:

            <asp:TextBox ID="accessory10TextBox" runat="server" 

                Text='<%# Bind("accessory10") %>' />

            <br />

            a10WhseSN:

            <asp:TextBox ID="a10WhseSNTextBox" runat="server" 

                Text='<%# Bind("a10WhseSN") %>' />

            <br />

            a10ShopSN:

            <asp:TextBox ID="a10ShopSNTextBox" runat="server" 

                Text='<%# Bind("a10ShopSN") %>' />

            <br />

            a10DelSN:

            <asp:TextBox ID="a10DelSNTextBox" runat="server" 

                Text='<%# Bind("a10DelSN") %>' />

            <br />

            accessory11:

            <asp:TextBox ID="accessory11TextBox" runat="server" 

                Text='<%# Bind("accessory11") %>' />

            <br />

            a11WhseSN:

            <asp:TextBox ID="a11WhseSNTextBox" runat="server" 

                Text='<%# Bind("a11WhseSN") %>' />

            <br />

            a11ShopSN:

            <asp:TextBox ID="a11ShopSNTextBox" runat="server" 

                Text='<%# Bind("a11ShopSN") %>' />

            <br />

            a11DelSN:

            <asp:TextBox ID="a11DelSNTextBox" runat="server" 

                Text='<%# Bind("a11DelSN") %>' />

            <br />

            accessory12:

            <asp:TextBox ID="accessory12TextBox" runat="server" 

                Text='<%# Bind("accessory12") %>' />

            <br />

            a12WhseSN:

            <asp:TextBox ID="a12WhseSNTextBox" runat="server" 

                Text='<%# Bind("a12WhseSN") %>' />

            <br />

            a12ShopSN:

            <asp:TextBox ID="a12ShopSNTextBox" runat="server" 

                Text='<%# Bind("a12ShopSN") %>' />

            <br />

            a12DelSN:

            <asp:TextBox ID="a12DelSNTextBox" runat="server" 

                Text='<%# Bind("a12DelSN") %>' />

            <br />

            accessory13:

            <asp:TextBox ID="accessory13TextBox" runat="server" 

                Text='<%# Bind("accessory13") %>' />

            <br />

            a13WhseSN:

            <asp:TextBox ID="a13WhseSNTextBox" runat="server" 

                Text='<%# Bind("a13WhseSN") %>' />

            <br />

            a13ShopSN:

            <asp:TextBox ID="a13ShopSNTextBox" runat="server" 

                Text='<%# Bind("a13ShopSN") %>' />

            <br />

            a13DelSN:

            <asp:TextBox ID="a13DelSNTextBox" runat="server" 

                Text='<%# Bind("a13DelSN") %>' />

            <br />

            accessory14:

            <asp:TextBox ID="accessory14TextBox" runat="server" 

                Text='<%# Bind("accessory14") %>' />

            <br />

            a14WhseSN:

            <asp:TextBox ID="a14WhseSNTextBox" runat="server" 

                Text='<%# Bind("a14WhseSN") %>' />

            <br />

            a14ShopSN:

            <asp:TextBox ID="a14ShopSNTextBox" runat="server" 

                Text='<%# Bind("a14ShopSN") %>' />

            <br />

            a14DelSN:

            <asp:TextBox ID="a14DelSNTextBox" runat="server" 

                Text='<%# Bind("a14DelSN") %>' />

            <br />

            estDelTime:

            <asp:TextBox ID="estDelTimeTextBox" runat="server" 

                Text='<%# Bind("estDelTime") %>' />

            <br />

            placement:

            <asp:TextBox ID="placementTextBox" runat="server" 

                Text='<%# Bind("placement") %>' />

            <br />

            m1:

            <asp:TextBox ID="m1TextBox" runat="server" Text='<%# Bind("m1") %>' />

            <br />

            m2:

            <asp:TextBox ID="m2TextBox" runat="server" Text='<%# Bind("m2") %>' />

            <br />

            <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" 

                CommandName="Insert" Text="Insert" />

            &nbsp;<asp:LinkButton ID="InsertCancelButton" runat="server" 

                CausesValidation="False" CommandName="Cancel" Text="Cancel" />

        </InsertItemTemplate>

        <ItemTemplate>

            

            <table> 

           <%-- make some rows not visible need id and runat--%>

           

            <tr id="orderIDrow" runat="server" visible="false" ><td align="right"><b>Order Id:</b></td>       <td><%#Eval("orderID")%></td> </tr>

            <tr><td align="right"><b>Time Submitted:</b></td>       <td><%#Eval("timeSubmitted")%></td></tr>

            <tr><td align="right"><b>Rep Id:</b></td>       <td><%#Eval("repID")%></td></tr>

            <tr><td align="right"><b>Sales Rep:</b></td>       <td><%#Eval("salesRep")%></td></tr>

            <tr><td align="right"><b>Customer:</b></td>       <td><%#Eval("customer")%></td></tr>

            <tr><td align="right"><b>Address:</b></td>       <td><%#Eval("address")%></td></tr>

            <tr><td align="right"><b>City, State, Zip:</b></td>       <td><%#Eval("cityStateZip")%></td></tr>

            <tr><td align="right"><b>Contact:</b></td>       <td><%#Eval("contact")%></td></tr>

            <tr><td align="right"><b>Phone:</b></td>       <td><%#Eval("phone")%></td></tr>

            <tr><td align="right"><b>forecastMachineId:</b></td>       <td><%#Eval("forecastMachineId")%></td></tr>

            <tr><td align="right"><b>forecastId:</b></td>       <td><%#Eval("forecastId")%></td></tr>

            <tr><td align="right"><b>forecastModel:</b></td>       <td><%#Eval("forecastModel")%></td></tr>

            <tr><td align="right"><b>Comments:</b></td>       <td><%#Eval("comments")%></td></tr>

            <tr><td align="right"><b>Delivery Date:</b></td>       <td><%#Eval("neededDate")%></td></tr>

            <tr><td align="right"><b>Sale Type:</b></td>       <td><%#Eval("saleType")%></td></tr>

            <tr><td align="right"><b>Networking Required:</b></td>       <td><%#Eval("networking")%></td></tr>

            <tr><td align="right"><b>Stairs:</b></td>       <td><%#Eval("stairs")%></td></tr>

            <tr><td align="right"><b>Stair Count:</b></td>       <td><%#Eval("stairCount")%></td></tr>

            <tr><td align="right"><b>Delivery Method:</b></td>       <td><%#Eval("deliveryMethod")%></td></tr>

            <tr><td align="right"><b>Model:</b></td>       <td><%#Eval("model")%></td></tr>

            <tr id="modelWhseSNrow" runat="server" visible="false"><td align="right"><b>modelWhseSN:</b></td>       <td><%#Eval("modelWhseSN")%></td></tr>

            <tr id="modelShopSNrow" runat="server" visible="false"><td align="right"><b>modelShopSN:</b></td>       <td><%#Eval("modelShopSN")%></td></tr>

            <tr><td align="right"><b>modelDelSN:</b></td>       <td><%#Eval("modelDelSN")%></td></tr>

            <tr><td align="right"><b>equipId:</b></td>       <td><%#Eval("equipId")%></td></tr>

            <tr><td align="right"><b>meterShop:</b></td>       <td><%#Eval("meterShop")%></td></tr>

            <tr><td align="right"><b>m6:</b></td>       <td><%#Eval("m6")%></td></tr>

            <tr><td align="right"><b>m7:</b></td>       <td><%#Eval("m7")%></td></tr>

            <tr><td align="right"><b>m8:</b></td>       <td><%#Eval("m8")%></td></tr>

            <tr><td align="right"><b>m3:</b></td>       <td><%#Eval("m3")%></td></tr>

            <tr><td align="right"><b>m4:</b></td>       <td><%#Eval("m4")%></td></tr>

            <tr><td align="right"><b>m5:</b></td>       <td><%#Eval("m5")%></td></tr>

            <tr><td align="right"><b>meterDel:</b></td>       <td><%#Eval("meterDel")%></td></tr>

            

            <tr><td align="right"><b>Accessory:</b></td>       <td><%#Eval("accessory1")%></td></tr>

            <tr><td align="right"><b>a1WhseSN:</b></td>       <td><%#Eval("a1WhseSN")%></td></tr>

            <tr><td align="right"><b>a1ShopSN:</b></td>       <td><%#Eval("a1ShopSN")%></td></tr>

            <tr><td align="right"><b>a1DelSN:</b></td>       <td><%#Eval("a1DelSN")%></td></tr>

            

            <tr><td align="right"><b>Accessory:</b></td>       <td><%#Eval("accessory2")%></td></tr>

            <tr><td align="right"><b>a2WhseSN:</b></td>       <td><%#Eval("a2WhseSN")%></td></tr>

            <tr><td align="right"><b>a2ShopSN:</b></td>       <td><%#Eval("a2ShopSN")%></td></tr>

            <tr><td align="right"><b>a2DelSN:</b></td>       <td><%#Eval("a2DelSN")%></td></tr>

            

            <tr><td align="right"><b>Accessory:</b></td>       <td><%#Eval("accessory3")%></td></tr>

            <tr><td align="right"><b>a3WhseSN:</b></td>       <td><%#Eval("a3WhseSN")%></td></tr>

            <tr><td align="right"><b>a3ShopSN:</b></td>       <td><%#Eval("a3ShopSN")%></td></tr>

            <tr><td align="right"><b>a3DelSN:</b></td>       <td><%#Eval("a3DelSN")%></td></tr>

            

            <tr><td align="right"><b>Accessory:</b></td>       <td><%#Eval("accessory4")%></td></tr>

            <tr><td align="right"><b>a4WhseSN:</b></td>       <td><%#Eval("a4WhseSN")%></td></tr>

            <tr><td align="right"><b>a4ShopSN:</b></td>       <td><%#Eval("a4ShopSN")%></td></tr>

            <tr><td align="right"><b>a4DelSN:</b></td>       <td><%#Eval("a4DelSN")%></td></tr>

            

            <tr><td align="right"><b>Accessory:</b></td>       <td><%#Eval("accessory5")%></td></tr>

            <tr><td align="right"><b>a5WhseSN:</b></td>       <td><%#Eval("a5WhseSN")%></td></tr>

            <tr><td align="right"><b>a5ShopSN:</b></td>       <td><%#Eval("a5ShopSN")%></td></tr>

            <tr><td align="right"><b>a5DelSN:</b></td>       <td><%#Eval("a5DelSN")%></td></tr>

            

            <tr><td align="right"><b>Accessory:</b></td>       <td><%#Eval("accessory6")%></td></tr>

            <tr><td align="right"><b>a6WhseSN:</b></td>       <td><%#Eval("a6WhseSN")%></td></tr>

            <tr><td align="right"><b>a6ShopSN:</b></td>       <td><%#Eval("a6ShopSN")%></td></tr>

            <tr><td align="right"><b>a6DelSN:</b></td>       <td><%#Eval("a6DelSN")%></td></tr>

            

            <tr><td align="right"><b>Accessory:</b></td>       <td><%#Eval("accessory7")%></td></tr>

            <tr><td align="right"><b>a7WhseSN:</b></td>       <td><%#Eval("a7WhseSN")%></td></tr>

            <tr><td align="right"><b>a7ShopSN:</b></td>       <td><%#Eval("a7ShopSN")%></td></tr>

            <tr><td align="right"><b>a7DelSN:</b></td>       <td><%#Eval("a7DelSN")%></td></tr>

            

            <tr><td align="right"><b>Accessory:</b></td>       <td><%#Eval("accessory8")%></td></tr>

            <tr><td align="right"><b>a8WhseSN:</b></td>       <td><%#Eval("a8WhseSN")%></td></tr>

            <tr><td align="right"><b>a8ShopSN:</b></td>       <td><%#Eval("a8ShopSN")%></td></tr>

            <tr><td align="right"><b>a8DelSN:</b></td>       <td><%#Eval("a8DelSN")%></td></tr>

            

            <tr><td align="right"><b>Accessory:</b></td>       <td><%#Eval("accessory9")%></td></tr>

            <tr><td align="right"><b>a9WhseSN:</b></td>       <td><%#Eval("a9WhseSN")%></td></tr>

            <tr><td align="right"><b>a9ShopSN:</b></td>       <td><%#Eval("a9ShopSN")%></td></tr>

            <tr><td align="right"><b>a9DelSN:</b></td>       <td><%#Eval("a9DelSN")%></td></tr>

            

            <tr><td align="right"><b>Accessory:</b></td>       <td><%#Eval("accessory10")%></td></tr>

            <tr><td align="right"><b>a10WhseSN:</b></td>       <td><%#Eval("a10WhseSN")%></td></tr>

            <tr><td align="right"><b>a10ShopSN:</b></td>       <td><%#Eval("a10ShopSN")%></td></tr>

            <tr><td align="right"><b>a10DelSN:</b></td>       <td><%#Eval("a10DelSN")%></td></tr>

            

            <tr><td align="right"><b>Accessory:</b></td>       <td><%#Eval("accessory11")%></td></tr>

            <tr><td align="right"><b>a11WhseSN:</b></td>       <td><%#Eval("a11WhseSN")%></td></tr>

            <tr><td align="right"><b>a11ShopSN:</b></td>       <td><%#Eval("a11ShopSN")%></td></tr>

            <tr><td align="right"><b>a11DelSN:</b></td>       <td><%#Eval("a11DelSN")%></td></tr>

            

            <tr><td align="right"><b>Accessory:</b></td>       <td><%#Eval("accessory12")%></td></tr>

            <tr><td align="right"><b>a12WhseSN:</b></td>       <td><%#Eval("a12WhseSN")%></td></tr>

            <tr><td align="right"><b>a12ShopSN:</b></td>       <td><%#Eval("a12ShopSN")%></td></tr>

            <tr><td align="right"><b>a12DelSN:</b></td>       <td><%#Eval("a12DelSN")%></td></tr>

            

            <tr><td align="right"><b>Accessory:</b></td>       <td><%#Eval("accessory13")%></td></tr>

            <tr><td align="right"><b>a13WhseSN:</b></td>       <td><%#Eval("a13WhseSN")%></td></tr>

            <tr><td align="right"><b>a13ShopSN:</b></td>       <td><%#Eval("a13ShopSN")%></td></tr>

            <tr><td align="right"><b>a13DelSN:</b></td>       <td><%#Eval("a13DelSN")%></td></tr>

            

            <tr><td align="right"><b>Accessory:</b></td>       <td><%#Eval("accessory14")%></td></tr>

            <tr><td align="right"><b>a14WhseSN:</b></td>       <td><%#Eval("a14WhseSN")%></td></tr>

            <tr><td align="right"><b>a14ShopSN:</b></td>       <td><%#Eval("a14ShopSN")%></td></tr>

            <tr><td align="right"><b>a14DelSN:</b></td>       <td><%#Eval("a14DelSN")%></td></tr>

            

            <tr><td align="right"><b>estDelTime:</b></td>       <td><%#Eval("estDelTime")%></td></tr>

            <tr><td align="right"><b>placement:</b></td>       <td><%#Eval("placement")%></td></tr>

            <tr><td align="right"><b>m1:</b></td>       <td><%#Eval("m1")%></td></tr>

            <tr><td align="right"><b>m2:</b></td>       <td><%#Eval("m2")%></td></tr>

            

            

            </table>

           

            

          

            <br />

            <asp:LinkButton ID="EditButton" runat="server" CausesValidation="False" 

                CommandName="Edit" Text="Edit" />

            &nbsp;<asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False" 

                CommandName="Delete" Text="Delete" />

            &nbsp;<asp:LinkButton ID="NewButton" runat="server" CausesValidation="False" 

                CommandName="New" Text="New" />

        </ItemTemplate>

    </asp:FormView>

    c<asp:Label Text='<%# Eval("orderID") %>' runat="server" id="orderIDLabel" />

    </form>

</body>

</html>

Open in new window

0
Comment
Question by:toddpotter
1 Comment
 
LVL 7

Accepted Solution

by:
maXXXeE earned 500 total points
Comment Utility
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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

728 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now