Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

FormView not updating

Avatar of wsturdev
wsturdevFlag for United States of America asked on
.NET Programming
14 Comments1 Solution338 ViewsLast Modified:
I have posted my code below.

When I enter values into KT_Participate_Start_Date or KT_Participate_End_Date, they do not update in the database.

What have I done wrong?
<%@ Page Language="vb" AutoEventWireup="false" Codebehind="MainKTRecordReceiverStatus.aspx.vb"
  Inherits="KTDevelopment.KTMainItemReceiverStatus" %>

<%@ Register TagPrefix="ah" TagName="Header" Src="KTHeader.ascx" %>
<%@ Register TagPrefix="ah" TagName="KTRecordReceiverStatus" Src="KTRecordReceiverStatus.ascx" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
  <title>KT Management Web Interface</title>
  <link id="Link1" type="text/css" rel="stylesheet" href="~/Styles.css" runat="Server" />
  <meta content="JavaScript" name="vs_defaultClientScript" />
  <meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema" />


<%--  <script language="JavaScript">

            var secs
            var timerID = null
            var timerRunning = false
            var delay = 1000

            function InitializeTimer()
            {
                // Set the length of the timer, in seconds
                secs = 900
                StopTheClock()
                StartTheTimer()
            }

            function StopTheClock()
            {
                if(timerRunning)
                    clearTimeout(timerID)
                timerRunning = false
            }

            function StartTheTimer()
            {
                if (secs==0)
                {
                    StopTheClock()
                    // Here's where you put something useful that's
                    // supposed to happen after the allotted time.
                    // For example, you could display a message:
                    alert("You have not clicked Save Changes for about 15 minutes.  Please do so, or you risk losing data entered since the last save.\r\n\r\nYour session is scheduled to time-out in 5 minutes unless you save changes, go to another section or move to another page of this web site." )
//                    InitializeTimer()
                }
                else
                {
//                    self.status = secs
                    secs = secs - 1
                    timerRunning = true
                    timerID = self.setTimeout("StartTheTimer()", delay)
                }
            }
  </script>
--%>
</head>
<body leftmargin="8" rightmargin="8" scroll="no">

  <div id="Div5" runat="server" style="padding-right: 10px; border-top: White 1px solid;
    padding-left: 10px; z-index: 122; left: 0px; width: 995px; vertical-align: baseline;
    border-left: White 1px solid; color: Black; position: absolute; background-color: white;
    text-align: center; font-variant: normal;">
    <form id="KTRecordReceiverStatusForm" runat="server">
      <ah:Header ID="KTRecordReceiverStatusFormHeader" runat="server" />
      <br />
      <asp:DataList DataSourceID="ReceiverNameDataSource" runat="server" Height="10px">
        <ItemTemplate>
          <div id="Div5" runat="server" style="padding-right: 0px; padding-left: 0px; padding-bottom: 0px;
            padding-top: 0px; font-size: 7pt; z-index: 122; left: 0px; width: 995px; top: 46px;
            vertical-align: baseline; color: Black; background-color: White; text-align: center;
            font-variant: normal; height: 10px;">
            for Receiver:&nbsp;
            <asp:Label ID="Receiver" Height="10px" Font-Bold="true" runat="server" Text='<%# Bind("Resource_Name") %>'></asp:Label>
          </div>
        </ItemTemplate>
      </asp:DataList>
      <asp:FormView ID="KTRecordReceiverStatusAppFormView" BorderWidth="1px" BorderColor="black"
        runat="server" DataSourceID="KTRecordReceiverStatusAppDataSource" CellPadding="4"
        ForeColor="#333333" Width="995px" DataKeyNames="ID,Apps_Cat_ID">
        <HeaderStyle BackColor="#DAA520" Font-Bold="True" ForeColor="White" />
        <PagerSettings Mode="NumericFirstLast" />
        <FooterStyle BackColor="#DAA520" Font-Bold="True" ForeColor="White" />
        <RowStyle BackColor="#DAA520" ForeColor="#333333" />
        <PagerStyle BackColor="#DAA520" ForeColor="#333333" HorizontalAlign="Center" />
        <EmptyDataTemplate>
          <center>
            <b>No applications found for the current criteria.</b></center>
          <br />
          <br />
        </EmptyDataTemplate>
        <ItemTemplate>
          <table width="100%" style="font-size: 8pt" border="0" cellpadding="0" cellspacing="0">
            <tr>
              <td width="100px">
                <table width="100%" style="font-size: 8pt" border="0" cellpadding="0" cellspacing="0"
                  cols="2">
                  <tr>
                    <td width="85px">
                      <b>Entry ID</b>
                    </td>
                    <td width="15px">
                    </td>
                  </tr>
                  <tr>
                    <td width="55px" bgcolor="blue" align="center">
                      <asp:Label ID="Apps_Cat_IDLabel" Width="75px" ForeColor="white" runat="server" Text='<%# Bind("Apps_Cat_ID") %>'></asp:Label><br />
                    </td>
                    <td width="35px">
                    </td>
                  </tr>
                </table>
              </td>
              <td width="120px">
                <b>Entry Type</b><br />
                <asp:Label ID="Entry_TypeLabel" runat="server" Text='<%# Bind("KT_Entry_Type") %>'>
                </asp:Label>
              </td>
              <td width="450px" colspan="2">
                <b>Entry Name</b><br />
                <asp:Label ID="KTIRS_Application_NameLabel" runat="server" Text='<%# Bind("Application_Name") %>'></asp:Label><br />
              </td>
              <td width="150px">
                <b>KT Project Manager</b><br />
                <asp:Label ID="KT_Project_ManagerLabel" runat="server" Text='<%# Bind("Analyst_Name") %>'></asp:Label><br />
              </td>
            </tr>
            <tr>
              <td width="100px">
                <table width="100%" style="font-size: 8pt" border="0" cellpadding="0" cellspacing="0"
                  cols="2">
                  <tr>
                    <td width="85px">
                      <asp:Label ID="WSMID" Font-Bold="true" runat="server" Text="WSM ID"></asp:Label>
                    </td>
                    <td width="15px">
                    </td>
                  </tr>
                  <tr>
                    <td id="tdWSM_ID" bgcolor="red" runat="server" width="85px" align="center">
                      <asp:Label ID="WSM_IDLabel" Width="85px" ForeColor="white" runat="server" Text='<%# Bind("WSM_ID") %>'></asp:Label><br />
                    </td>
                    <td width="35px">
                    </td>
                  </tr>
                </table>
              </td>
              <td width="120px">
                <asp:Label ID="lblComplexityDescription" Font-Bold="true" runat="server" Text="Entry Complexity"></asp:Label><br />
                <asp:Label ID="Complexity_Description" runat="server" Text='<%# Bind("Complexity_Description") %>'>
                </asp:Label>
              </td>
              <td width="150px">
                <b>Business Unit</b><br />
                <asp:Label ID="Business_Unit" runat="server" Text='<%# Bind("Business_Unit") %>'>
                </asp:Label>
              </td>
              <td width="300px">
                <b>Portfolio</b><br />
                <asp:Label ID="Portfolio" runat="server" Text='<%# Bind("Portfolio") %>'>
                </asp:Label>
              </td>
              <td width="149px">
                <asp:Label ID="email_addressLabel" runat="server" Text='<%# Bind("KT_PM_Email_Address") %>'></asp:Label><br />
                <asp:Label ID="Work_PhoneLabel" runat="server" Text='<%# Bind("Work_Phone") %>'></asp:Label><br />
              </td>
              <td style="display: none">
                <b>Application Record ID:</b><br />
                <asp:Label ID="ApplicationRecordIDLabel" runat="server" Text='<%# Bind("ID") %>'></asp:Label><br />
                <b>Lookup_To_Lst_Data_Collection_Analysts_For_KT_PM_Name:</b>
                <asp:Label ID="Lookup_To_Lst_Data_Collection_Analysts_For_KT_PM_NameLabel" runat="server"
                  Text='<%# Bind("Lookup_To_Lst_Data_Collection_Analysts_For_KT_PM_Name") %>'></asp:Label><br />
                <b>Analyst_Name:</b>
                <asp:Label ID="Analyst_NameLabel" runat="server" Text='<%# Bind("Analyst_Name") %>'></asp:Label><br />
              </td>
            </tr>
          </table>
        </ItemTemplate>
      </asp:FormView>
      <asp:FormView ID="KTRecordReceiverStatusInstanceFormView" runat="server" BorderColor="black"
        BorderWidth="1px" CellPadding="1" DataKeyNames="ID" DataSourceID="KTRecordReceiverStatusInstanceDataSource"
        Height="22px" Width="995px">
        <FooterStyle BackColor="#ffcc00" Font-Bold="True" ForeColor="White" />
        <EditRowStyle BackColor="#ffcc00" />
        <RowStyle BackColor="#ffcc00" />
        <PagerStyle BackColor="#ffcc00" ForeColor="White" HorizontalAlign="Center" />
        <EmptyDataTemplate>
          <center>
            <b>No KT instances could be found for this Entry.</b></center>
          <br />
          <br />
        </EmptyDataTemplate>
        <ItemTemplate>
          <table width="100%" style="font-size: 8pt" border="0" cellpadding="0" cellspacing="0">
            <tr>
              <td width="425px">
                <table width="100%">
                  <tr>
                    <td width="80px">
                      <b>Number</b><br />
                      <asp:Label ID="KTIRS_KT_Instance_NumberLabel" runat="server" Text='<%# Bind("KT_Instance_Number") %>'></asp:Label>
                    </td>
                    <td width="80px">
                      <b>Priority</b><br />
                      <asp:Label ID="KT_Instance_PriorityLabel" runat="server" Text='<%# iif(Eval("KT_Instance_Priority").ToString() = "1", "Primary", "Secondary") %>'></asp:Label>
                    </td>
                    <td width="275px" align="center" valign="top" style="padding-top: 2px;" colspan="3"
                      rowspan="4">
                      <table bgcolor="#ffff99" border="1" cellpadding="1" cellspacing="0" bordercolor="#DAA520">
                        <tr>
                          <td colspan="3" align="center">
                            <b>Instance Dates</b></td>
                        </tr>
                        <tr>
                          <td width="60px">
                            <b>&nbsp;</b></td>
                          <td width="80px">
                            <b>Start</b></td>
                          <td width="80px">
                            <b>End</b></td>
                        </tr>
                        <tr>
                          <td align="Right" width="60px">
                            <b>Planned</b></td>
                          <td>
                            <asp:Label ID="KT_Planned_Start_Date" Width="80px" Style="text-align: center" runat="server"
                              Text='<%# Bind("KT_Planned_Start_Date","{0:d}") %>'>
                            </asp:Label>
                          </td>
                          <td>
                            <asp:Label ID="KT_Planned_End_Date" Width="80px" Style="text-align: center" runat="server"
                              Text='<%# Bind("KT_Planned_End_Date","{0:d}") %>'>
                            </asp:Label>
                          </td>
                        </tr>
                        <tr>
                          <td align="Right" width="60px">
                            <b>Actual</b></td>
                          <td>
                            <asp:Label ID="KT_Actual_Start_Date" runat="server" Width="80px" Style="text-align: center"
                              Text='<%# Bind("KT_Actual_Start_Date","{0:d}") %>'>
                            </asp:Label>
                          </td>
                          <td>
                            <asp:Label ID="KT_Actual_End_Date" runat="server" Width="80px" Style="text-align: center"
                              Text='<%# Bind("KT_Actual_End_Date", "{0:d}") %>'>
                            </asp:Label>
                          </td>
                        </tr>
                      <tr>
                        <td  align="Right" width="60px">
                          <asp:Label ID="Participate_Start_End_Label" Font-Bold="true" runat="server" Text="Participate">
                          </asp:Label>
                        <td>
                          <asp:Textbox ID="KT_Participate_Start_Date" runat="server" Width="80px" Font-Size="8pt" Height="12px" Style="text-align: center"
                            Text='<%# Bind("KT_Participate_Start_Date","{0:d}") %>'>
                          </asp:Textbox>
                        </td>
                        <td>
                          <asp:Textbox ID="KT_Participate_End_Date" runat="server" Width="80px" Font-Size="8pt" Height="12px" Style="text-align: center"
                            Text='<%# Bind("KT_Participate_End_Date", "{0:d}") %>'>
                          </asp:Textbox>
                        </td>
                      </tr>
                      </table>
                    </td>
                  </tr>
                  <tr>
                    <td width="70px">
                      <b>Type</b><br />
                      <asp:Label ID="KT_Instance_Type" runat="server" Text='<%# Bind("KT_Instance_Type") %>'>
                      </asp:Label>
                    </td>
                    <td width="70px">
                      <b>Phase</b><br />
                      <asp:Label ID="KT_Phase" runat="server" Text='<%# Bind("KT_Phase") %>'>
                      </asp:Label>
                    </td>
                  </tr>
                  <tr>
                    <td width="425px" align="left" colspan="2" style="overflow-x: visible;">
                      <b>KT Sender Name(s)</b><br />
                      <asp:Label ID="Senders" runat="server" Text='<%# Bind("Senders") %>'></asp:Label>
                      <%--                                    <asp:Label ID="Sender" runat="server" Text="xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"></asp:Label>                
--%>
                    </td>
                  </tr>
                </table>
              </td>
              <td>
                <table width="565px" bgcolor="#ffcc33" border="1" cellpadding="1" cellspacing="0"
                  bordercolor="#cc6600">
                  <tr>
                    <td width="25%">
                      <b>Percent of Schedule</b></td>
                    <td width="27%">
                      Progress Summary</td>
                    <td width="18%">
                      This KT Instance</td>
                    <td width="14%">
                      This Entry</td>
                    <td width="16%">
                      This Receiver</td>
                    <tr>
                      <td align="center" bordercolor="#cc6600">
                        <asp:Label ID="Percent_Control" runat="server" Text='' Font-Size="Larger" Font-Bold="true">
                        </asp:Label>
                      </td>
                      <td bgcolor="white" bordercolor="#cc6600">
                        Overall % Complete
                        <br />
                        Observe % Complete
                        <br />
                        Participate % Complete
                        <br />
                        Perform % Complete
                      </td>
                      <td align="center" bgcolor="white" bordercolor="#cc6600">
                        <asp:FormView ID="FormView5" runat="server"
                          CellPadding="4" DataSourceID="ThisInstanceDataSource">
                          <ItemTemplate>
                            <asp:Label ID="Total_Percent_CompleteLabel" runat="server" Text='<%# Format_Progress_For_KTIRS(Eval("Total_Percent_Complete"))%>'></asp:Label><br />
                            <asp:Label ID="AvgOfObserve_Percent_CompleteLabel" runat="server" Text='<%# Format_Progress_For_KTIRS(Eval("AvgOfObserve_Percent_Complete")) %>'></asp:Label><br />
                            <asp:Label ID="AvgOfParticipate_Percent_CompleteLabel" runat="server" Text='<%# Format_Progress_For_KTIRS(Eval("AvgOfParticipate_Percent_Complete")) %>'></asp:Label><br />
                            <asp:Label ID="AvgOfPerform_Percent_CompleteLabel" runat="server" Text='<%# Format_Progress_For_KTIRS(Eval("AvgOfPerform_Percent_Complete")) %>'></asp:Label><br />
                          </ItemTemplate>
                        </asp:FormView>
                      </td>
                      <td align="center" bgcolor="white" bordercolor="#cc6600">
                        <asp:FormView ID="FormView6" runat="server"
                          CellPadding="4" DataSourceID="ThisAppDataSource">
                          <ItemTemplate>
                            <asp:Label ID="Total_Percent_CompleteLabel" runat="server" Text='<%# Format_Progress_For_KTIRS(Eval("Total_Percent_Complete")) %>'></asp:Label><br />
                            <asp:Label ID="AvgOfObserve_Percent_CompleteLabel" runat="server" Text='<%# Format_Progress_For_KTIRS(Eval("AvgOfObserve_Percent_Complete")) %>'></asp:Label><br />
                            <asp:Label ID="AvgOfParticipate_Percent_CompleteLabel" runat="server" Text='<%# Format_Progress_For_KTIRS(Eval("AvgOfParticipate_Percent_Complete")) %>'></asp:Label><br />
                            <asp:Label ID="AvgOfPerform_Percent_CompleteLabel" runat="server" Text='<%# Format_Progress_For_KTIRS(Eval("AvgOfPerform_Percent_Complete")) %>'></asp:Label><br />
                          </ItemTemplate>
                        </asp:FormView>
                      </td>
                      <td align="center" bgcolor="white" bordercolor="#cc6600">
                        <asp:FormView ID="FormView1" runat="server"
                          CellPadding="4" DataSourceID="ThisReceiverDataSource">
                          <ItemTemplate>
                            <asp:Label ID="Total_Percent_CompleteLabel" runat="server" Text='<%# Format_Progress_For_KTIRS(Eval("Total_Percent_Complete")) %>'></asp:Label><br />
                            <asp:Label ID="AvgOfObserve_Percent_CompleteLabel" runat="server" Text='<%# Format_Progress_For_KTIRS(Eval("AvgOfObserve_Percent_Complete")) %>'></asp:Label><br />
                            <asp:Label ID="AvgOfParticipate_Percent_CompleteLabel" runat="server" Text='<%# Format_Progress_For_KTIRS(Eval("AvgOfParticipate_Percent_Complete")) %>'></asp:Label><br />
                            <asp:Label ID="AvgOfPerform_Percent_CompleteLabel" runat="server" Text='<%# Format_Progress_For_KTIRS(Eval("AvgOfPerform_Percent_Complete")) %>'></asp:Label><br />
                          </ItemTemplate>
                        </asp:FormView>
                      </td>
                    </tr>
                </table>
              </td>
              <td style="display: none">
                ID:
                <asp:Label ID="IDLabel" runat="server" Text='<%# Bind("ID") %>'></asp:Label><br />
                Lookup_To_Tbl_KT_Entries_For_Entry_ID:
                <asp:Label ID="Lookup_To_Tbl_KT_Entries_For_Entry_IDLabel" runat="server" Text='<%# Bind("Lookup_To_Tbl_KT_Entries_For_Entry_ID") %>'>
                </asp:Label><br />
                Lookup_To_Lst_Data_Collection_Analysts_For_KT_PM_Name:
                <asp:Label ID="Lookup_To_Lst_Data_Collection_Analysts_For_KT_PM_NameLabel" runat="server"
                  Text='<%# Bind("Lookup_To_Lst_Data_Collection_Analysts_For_KT_PM_Name") %>'>
                </asp:Label><br />
                <br />
                KT_Instance_Comments:
                <asp:Label ID="KT_Instance_CommentsLabel" runat="server" Text='<%# Bind("KT_Instance_Comments") %>'>
                </asp:Label><br />
                KT_Observe_complete:
                <asp:Label ID="KT_Observe_completeLabel" runat="server" Text='<%# Bind("KT_Observe_complete") %>'>
                </asp:Label><br />
                KT_Participate_complete:
                <asp:Label ID="KT_Participate_completeLabel" runat="server" Text='<%# Bind("KT_Participate_complete") %>'>
                </asp:Label><br />
                KT_Perform_complete:
                <asp:Label ID="KT_Perform_completeLabel" runat="server" Text='<%# Bind("KT_Perform_complete") %>'>
                </asp:Label><br />
                Lookup_To_Lst_KT_Status_For_KT_Status_ID:
                <asp:Label ID="Lookup_To_Lst_KT_Status_For_KT_Status_IDLabel" runat="server" Text='<%# Bind("Lookup_To_Lst_KT_Status_For_KT_Status_ID") %>'>
                </asp:Label><br />
              </td>
            </tr>
          </table>
        </ItemTemplate>
        <HeaderStyle BackColor="#FFA700" Font-Bold="True" ForeColor="White" />
      </asp:FormView>
      <ah:KTRecordReceiverStatus ID="KTRecordReceiverStatus1" runat="server" />
      <table border="1px" bordercolor="black" cellpadding="0" cellspacing="0" style="font-size: 8pt;
        font-family: Arial; padding-top: 0px; padding-bottom: 0px;" width="995px">
        <tr style="font-size: 8pt; font-family: Arial; padding-top: 0px; padding-bottom: 0px;">
          <td bgcolor="#DAA520" bordercolor="#DAA520" style="height: 41px;" width="150px">
            <b>&nbsp;&nbsp;Entry Navigator:</b><br />
            <asp:Label ID="applicationLabel" Width="150px" Text="0" runat="server"></asp:Label>
          </td>
          <td bgcolor="#DAA520" bordercolor="#DAA520" style="height: 41px; width: 275px;">
            <asp:DropDownList ID="locaterecord" runat="server" Width="250px" AutoPostBack="True"
              DataSourceID="KTIRSLocateDataSource" DataValueField="ID" DataTextField="Text">
            </asp:DropDownList>
          </td>
          <td bgcolor="#DAA520" bordercolor="#DAA520" style="height: 41px; width: 128px;">
            <asp:FormView ID="AppsFooter" Width="125px" runat="server" DataSourceID="KTRecordReceiverStatusAppDataSource"
              AllowPaging="True" CellPadding="2" ForeColor="#333333">
              <PagerSettings Mode="NumericFirstLast" />
              <FooterStyle BackColor="#DAA520" Font-Bold="True" ForeColor="White" />
              <RowStyle BackColor="#DAA520" ForeColor="#333333" />
              <PagerStyle BackColor="#DAA520" HorizontalAlign="Center" ForeColor="Black" Font-Bold="true"  CssClass="navigator" Font-Underline="True" />
              <ItemTemplate>
              </ItemTemplate>
              <HeaderStyle BackColor="#DAA520" Font-Bold="True" ForeColor="White" />
            </asp:FormView>
          </td>
          <td bgcolor="#ffcc00" bordercolor="#DAA520" style="height: 41px; border-left-color: Black;
            border-right-color: #FFA700; width: 150px;">
            <b>&nbsp;&nbsp;KT Instance Navigator:</b><br />
            <asp:Label ID="InstanceLabel" Text="0" runat="server"></asp:Label>
          </td>
          <td bgcolor="#ffcc00" bordercolor="#ffcc00" style="height: 41px" width="275px">
            <asp:FormView ID="KTInstanceFooter" runat="server" DataSourceID="KTRecordReceiverStatusInstanceDataSource"
              CellPadding="2" ForeColor="#333333" AllowPaging="True">
              <ItemTemplate>
              </ItemTemplate>
              <FooterStyle BackColor="#ffcc00" Font-Bold="True" ForeColor="White" />
              <EditRowStyle BackColor="#ffcc00" />
              <RowStyle BackColor="#ffcc00" />
              <PagerStyle BackColor="#ffcc00" CssClass="navigator" Font-Bold="true" Font-Underline="True"
                ForeColor="Black" HorizontalAlign="Center" />
              <HeaderStyle BackColor="#ffcc00" Font-Bold="True" ForeColor="White" />
              <PagerSettings Mode="NumericFirstLast" />
            </asp:FormView>
          </td>
          <td align="center" bgcolor="#99cc99" bordercolor="#99cc99" width="60px" style="height: 41px">
            <asp:Button ID="HelpBtn" Height="19px" Font-Names="Arial" Font-Size="8pt" runat="server"
              Width="100%" Text="Help"></asp:Button>
            <asp:Button ID="FeedbackBtn" runat="server" Font-Names="Arial" Font-Size="8pt" Height="19px"
              OnClientClick="var retvalue = window.showModalDialog('KTReceiverFeedbackForm.aspx','','dialogTop: 100px; dialogHeight: 475px; dialogWidth: 855px; center: yes; edge: Raised; help: no; status: no; resizable: no;'); return false;"
              Text="Feedback" Width="100%" />
          </td>
        </tr>
      </table>
      <!--                All data sources below this area           -->
      <asp:SqlDataSource ID="KTRecordReceiverStatusAppDataSource" runat="server" ProviderName="System.Data.SqlClient"
        SelectCommand="select distinct * from Qry_KT_Entries_Filtered_By_Receiver where email_address=@email_address  order by application_name">
        <SelectParameters>
          <asp:SessionParameter Name="email_address" SessionField="strUserID" />
        </SelectParameters>
      </asp:SqlDataSource>
      <asp:SqlDataSource ID="KTIRSLocateDataSource" runat="server" ProviderName="System.Data.SqlClient"
        SelectCommand="SELECT str(id)+'    '+[Instance num] as id, [Application Name] + '    ' + [Instance num] as text FROM Qry_Locate_By_Which_Filtered_By_Receiver WHERE  Receiver in (select resource_name from tbl_resources where email_address=@email_address) order by [application name], [instance num], Receiver">
        <SelectParameters>
          <asp:SessionParameter Name="email_address" SessionField="strUserID" />
        </SelectParameters>
      </asp:SqlDataSource>
      <asp:SqlDataSource ID="KTRecordReceiverStatusInstanceDataSource" runat="server" 
        SelectCommand="SELECT     Qry_KT_Instances_For_Receiver_Web_Interface.ID, Qry_KT_Instances_For_Receiver_Web_Interface.Lookup_To_Tbl_KT_Entries_For_Entry_ID, &#13;&#10;                      Qry_KT_Instances_For_Receiver_Web_Interface.Lookup_To_Lst_Data_Collection_Analysts_For_KT_PM_Name, &#13;&#10;                      Qry_KT_Instances_For_Receiver_Web_Interface.Lookup_To_Lst_KT_Instance_Types_For_KT_Instance_Type, &#13;&#10;                      Qry_KT_Instances_For_Receiver_Web_Interface.KT_Instance_Number, Qry_KT_Instances_For_Receiver_Web_Interface.KT_Instance_Priority, &#13;&#10;                      Qry_KT_Instances_For_Receiver_Web_Interface.KT_Planned_Start_Date, Qry_KT_Instances_For_Receiver_Web_Interface.KT_Planned_End_Date, &#13;&#10;                      Qry_KT_Instances_For_Receiver_Web_Interface.KT_Actual_Start_Date, Qry_KT_Instances_For_Receiver_Web_Interface.KT_Actual_End_Date, &#13;&#10;                      Qry_KT_Instances_For_Receiver_Web_Interface.KT_Instance_Comments, Qry_KT_Instances_For_Receiver_Web_Interface.KT_Observe_complete, &#13;&#10;                      Qry_KT_Instances_For_Receiver_Web_Interface.KT_Participate_complete, Qry_KT_Instances_For_Receiver_Web_Interface.KT_Perform_complete, &#13;&#10;                      Qry_KT_Instances_For_Receiver_Web_Interface.Lookup_To_Lst_KT_Status_For_KT_Status_ID, &#13;&#10;                      Qry_KT_Instances_For_Receiver_Web_Interface.Lookup_To_Lst_KT_Phases_For_KT_Phase, &#13;&#10;                      Qry_KT_Instances_For_Receiver_Web_Interface.KT_Instance_Type, Qry_KT_Instances_For_Receiver_Web_Interface.KT_Phase, &#13;&#10;                      Qry_KT_Instances_For_Receiver_Web_Interface.email_address, Qry_KT_Instances_For_Receiver_Web_Interface.Support_Role, &#13;&#10;                      dbo.Assemble_List_Of_KT_Senders_For_KT_Instance(Qry_KT_Instances_For_Receiver_Web_Interface.KT_Instance_Number) AS Senders, &#13;&#10;                      Qry_KT_Instances_For_Receiver_Web_Interface.KT_Participate_Start_Date, &#13;&#10;                      Qry_KT_Instances_For_Receiver_Web_Interface.KT_Participate_End_Date&#13;&#10;FROM         Qry_KT_Instances_For_Receiver_Web_Interface LEFT OUTER JOIN&#13;&#10;                      Qry_KT_Receivers_By_KT_Instance ON Qry_KT_Instances_For_Receiver_Web_Interface.ID = Qry_KT_Receivers_By_KT_Instance.ID &#13;&#10;WHERE ([Lookup_To_Tbl_KT_Entries_For_Entry_ID] = @Lookup_To_Tbl_KT_Entries_For_Entry_ID) AND email_address = @email_address"
        EnableViewState="False" 
        UpdateCommand="UPDATE Tbl_KT_Instances&#13;&#10;   SET KT_Participate_Start_Date = @KT_Participate_Start_Date&#13;&#10;      ,KT_Participate_End_Date = @KT_Participate_End_Date&#13;&#10; WHERE ID = @KT_Instance_ID">
        <SelectParameters>
          <asp:ControlParameter ControlID="KTRecordReceiverStatusAppFormView" Name="Lookup_To_Tbl_KT_Entries_For_Entry_ID"
            PropertyName="SelectedValue" Type="Int32" />
          <asp:SessionParameter Name="email_address" SessionField="strUserID" />
        </SelectParameters>
        <UpdateParameters>
              <asp:ControlParameter ControlID="KT_Participate_Start_Date" Name="KT_Participate_Start_Date"
                  Type="String" />
              <asp:ControlParameter ControlID="KT_Participate_End_Date" Name="KT_Participate_End_Date"
                  Type="String" />
              <asp:SessionParameter Name="KT_Instance_ID" SessionField="intKTInstanceID" />
          </UpdateParameters>
      </asp:SqlDataSource>
      <asp:SqlDataSource ID="TypesDataSource" runat="server" SelectCommand="select * from Qry_KT_Instance_Types">
      </asp:SqlDataSource>
      <asp:SqlDataSource ID="PhasesDataSource" runat="server" SelectCommand="select * from Qry_Lst_kt_phases">
      </asp:SqlDataSource>
      <asp:SqlDataSource ID="ReceiverNameDataSource" runat="server" SelectCommand="select Resource_Name from Tbl_Resources where email_Address=@email_address"
        EnableViewState="false">
        <SelectParameters>
          <asp:SessionParameter Name="email_address" SessionField="strUserID" />
        </SelectParameters>
      </asp:SqlDataSource>
      <asp:SqlDataSource ID="ThisInstanceDataSource" runat="server" SelectCommand="select * from Qry_KT_Percent_Complete_By_Instance where instance_id=@KT_Instance_ID"
        EnableViewState="false">
        <SelectParameters>
          <asp:ControlParameter ControlID="KTRecordReceiverStatusInstanceFormView" Name="KT_Instance_ID"
            PropertyName="SelectedValue" Type="Int32" />
        </SelectParameters>
      </asp:SqlDataSource>
      <asp:SqlDataSource ID="ThisAppDataSource" runat="server" SelectCommand="select * from Qry_KT_Percent_Complete_By_Entry WHERE ([Lookup_To_Tbl_KT_Entries_For_Entry_ID] = @Lookup_To_Tbl_KT_Entries_For_Entry_ID)"
        EnableViewState="false">
        <SelectParameters>
          <asp:ControlParameter ControlID="KTRecordReceiverStatusAppFormView" Name="Lookup_To_Tbl_KT_Entries_For_Entry_ID"
            PropertyName="SelectedValue" Type="Int32" />
        </SelectParameters>
      </asp:SqlDataSource>
      <asp:SqlDataSource ID="ThisReceiverDatasource" runat="server" SelectCommand="select * from Qry_KT_Percent_Complete_By_Receiver WHERE ( email_Address=@email_address)"
        EnableViewState="false">
        <SelectParameters>
          <asp:SessionParameter Name="email_address" SessionField="strUserID" />
        </SelectParameters>
      </asp:SqlDataSource>
      &nbsp; &nbsp;
    </form>
  </div>
</body>
</html>
ASKER CERTIFIED SOLUTION
Avatar of strickdd
strickddFlag of United States of America image

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 14 Comments.
See Answers