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

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 717
  • Last Modified:

GridView doesn't UPDATE. FormView on same page with same Table Updates fine.

My GridView doesn't Update.  I have a .aspx web form with a GridView and SqlDataSource.  

I went through "Configure Data Source", added a good ConnectionString, specified all columns from my table, no Where conditions, Order By "LastName", Generate INSERT, UPDATE, and DELETE statements checked, Use optimistic concurrency checked.  

On the GridView Tasks, I have Enable Paging, Enable Sorting, Enable Editing, Enable Selection all checked.

When I view the page in a browser and click the "Edit" button and change a value then click the "Update" button nothing is changed.  Everything appears to be working fine, but the GirdView or database are not updated.

As a test, I added a FormView to the same page and enabled Inserting, Updating and Deleting.  When I click the "Edit" button on the FormView and change something the database IS updated just fine.

I've gone throught the process of creating a new WebForm, adding and configuring the GridView three times with the same result.  What could I be missing.  I can post my .aspx code if that will help.

Thanks.
0
megnin
Asked:
megnin
  • 13
  • 6
1 Solution
 
CmdoProg2Commented:
The gridview and sqldatasource of your .asox page would help.
0
 
megninAuthor Commented:
Thank you.  I'll post the .aspx page in this comment and the .aspx.vb in the next.  I appreciate any advice or assistance you may offer.  I'm just learning ASP.Net and VB.Net and it seems like every line of code I need to write takes me days to figure out.
'---------------------------------------------------------------------------------------------------
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="WT_TANF.aspx.vb" Inherits="WT_TANF"
    MaintainScrollPositionOnPostback="true" %>

<!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>WELFARE TRANSITION (TANF)</title>
    <style type="text/css">
.MonotypeCorsiva {font-family:Monotype Corsiva}
UL {list-style-type:disc}
.padLeft {
padding-left:15px;
}

body {
  min-width: 630px;      /* 2x (LC fullwidth +
                            CC padding) + RC fullwidth */
}
#container {
  padding-left: 80px;   /* LC fullwidth - I changed it from 200, 190 to 80, 50 */
  padding-right: 50px;  /* RC fullwidth + CC padding */
}
#container .column {
  position: relative;
  float: left;
}
#center {
  padding: 10px 20px;    /* CC padding */
  width: 100%;
}
#left {
  width: 180px;          /* LC width */
  padding: 0 10px;       /* LC padding */
  right: 240px;          /* LC fullwidth + CC padding */
  margin-left: -100%;
}
#right {
  width: 130px;          /* RC width */
  padding: 0 10px;       /* RC padding */
  margin-right: -190px;  /* RC fullwidth + CC padding */
}
#footer {
  clear: both;
}

/*** IE Fix ***/
* html #left {
  left: 150px;           /* RC fullwidth */
}
</style>
</head>
<body>
    <form id="form1" runat="server">
        <div id="container">
            <div style="text-align: center">
                <table border="0" cellpadding="0" cellspacing="0" style="width: 515pt; text-align: center;">
                    <tr style="height: 30pt">
                        <td height="40" style="border-right: windowtext 0.5pt solid; border-top: windowtext 0.5pt solid;
                            border-left: windowtext 0.5pt solid; width: 493pt; border-bottom: windowtext 0.5pt solid;
                            height: 30pt; background-color: #99CCFF; text-align: center;">
                            <strong><span style="font-size: 11pt"><span style="font-family: Arial">WELFARE TRANSITION (TANF) PROGRAM REVIEW TOOL</span></span></strong></td>
                    </tr>
                </table>
                <br />
            </div>
            <div style="text-align: center">
                <asp:ValidationSummary ID="ValidationSummary1" runat="server" HeaderText='Please make the following corrections and click "Submit" again'
                    Width="90%" />
            </div>
            <br />
            <ol>
                <li>Review Period:&nbsp; From date:<asp:RequiredFieldValidator ID="valrReviewDateFrom"
                    runat="server" ControlToValidate="txtReviewDateFrom" ErrorMessage="From Date is Required">*</asp:RequiredFieldValidator><asp:TextBox ID="txtReviewDateFrom" runat="server" Width="85px" TabIndex="50"></asp:TextBox><asp:RegularExpressionValidator ID="valReviewDateFrom" runat="server" ControlToValidate="txtReviewDateFrom"
                        ErrorMessage='Enter "Review Date From" as MM/DD/YYYY' ValidationExpression="(0?[1-9]|1[012])[- /.](0?[1-9]|[12][0-9]|3[01])[- /.](19|20)\d\d">*</asp:RegularExpressionValidator><span
                            style="font-size: 8pt"><span style="font-family: Tahoma"><span>(MM/DD/YYYY) &nbsp;
                                &nbsp;&nbsp; </span></span></span>&nbsp;                    To date:<asp:RequiredFieldValidator ID="valrReviewDateTo" runat="server" ControlToValidate="txtReviewDateTo"
                        ErrorMessage="To Date is Required">*</asp:RequiredFieldValidator><asp:TextBox ID="txtReviewDateTo" runat="server" Width="85px" TabIndex="60"></asp:TextBox><asp:RegularExpressionValidator ID="valReviewDateTo" runat="server" ControlToValidate="txtReviewDateTo"
                        ErrorMessage='Enter "Review Date To" as MM/DD/YYYY' ValidationExpression="(0?[1-9]|1[012])[- /.](0?[1-9]|[12][0-9]|3[01])[- /.](19|20)\d\d">*</asp:RegularExpressionValidator><span
                            style="font-size: 8pt"><span style="font-family: Tahoma"><span style="font-family: Times New Roman">(MM/DD/YYYY)</span></span>&nbsp;</span> &nbsp; &nbsp; &nbsp;
                    <asp:Label ID="lblReviewID" runat="server" ForeColor="#99CCFF"></asp:Label>
                    &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;
                    </li>
                <li>Participant Last Name:&nbsp;
                    <asp:TextBox ID="txtLastName" runat="server" ToolTip="Last Name of Participant" TabIndex="70"></asp:TextBox>
                    <asp:RequiredFieldValidator ID="valLastName" runat="server" ControlToValidate="txtLastName"
                        ErrorMessage="Participant Last Name is Required">*</asp:RequiredFieldValidator>
                </li>
                <li>Participant First Name:&nbsp;
                    <asp:TextBox ID="txtFirstName" runat="server" TabIndex="80"></asp:TextBox>
                    <asp:RequiredFieldValidator ID="valFirstName" runat="server" ControlToValidate="txtFirstName"
                        ErrorMessage="Participant First Name is Required">*</asp:RequiredFieldValidator>
                    &nbsp; &nbsp;<asp:Label ID="lblError2" runat="server" ForeColor="Red" CssClass="padLeft" /></li>
                <li>SSN:&nbsp;
                    <asp:RequiredFieldValidator ID="valrSSN" runat="server" ControlToValidate="txtSSN"
                        ErrorMessage="SSN is Required">*</asp:RequiredFieldValidator>
                    <asp:TextBox ID="txtSSN" runat="server" ToolTip="XXX-XX-XXXX" Width="85px" TabIndex="90"></asp:TextBox>
                    <asp:RegularExpressionValidator ID="valSSN" runat="server" ControlToValidate="txtSSN"
                        ErrorMessage="SSN Must be 9 digits (999-99-9999) Include dashes." ValidationExpression="\d{3}-\d{2}-\d{4}">*</asp:RegularExpressionValidator><span><span><span
                            style="font-family: Tahoma"><span style="font-size: 8pt"> <span style="font-family: Times New Roman">
                                (999-99-9999)</span></span></span></span></span> &nbsp; &nbsp; &nbsp;
                    &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;
<asp:Button ID="btnFetchRecord" runat="server" Text="< Fetch Record" TabIndex="1310" CausesValidation="False" Width="120px" />
                    <asp:Button ID="btnUpdate" runat="server" Text="Update Record" Visible="False" ForeColor="Red" />
                    <asp:Label ID="lblError1" runat="server" ForeColor="Red" CssClass="padLeft" /></li>
                <li>Region: &nbsp;
                <asp:DropDownList ID="ddlRegion" runat="server" ToolTip="Location of Data: Case at a Glance (top tab)" TabIndex="100">
                    <asp:ListItem Value="0">-</asp:ListItem>
                    <asp:ListItem>20</asp:ListItem>
                    <asp:ListItem>21</asp:ListItem>
                    <asp:ListItem>22</asp:ListItem>
                    <asp:ListItem>23</asp:ListItem>
                    <asp:ListItem>24</asp:ListItem>
                </asp:DropDownList><asp:CompareValidator ID="valRegion" runat="server" ControlToValidate="ddlRegion"
                    ErrorMessage="Region is Required" Operator="NotEqual" ValueToCompare="0">*</asp:CompareValidator>
                    &nbsp;
                    &nbsp; &nbsp; County:&nbsp;
                    <asp:DropDownList ID="ddlCounty" runat="server" ToolTip="Location of Data: Case at a Glance (top tab)" TabIndex="110">
                        <asp:ListItem Value="0">-</asp:ListItem>
                        <asp:ListItem Value="5">5 - Brevard</asp:ListItem>
                        <asp:ListItem Value="6">6 - Broward</asp:ListItem>
                        <asp:ListItem Value="7">7 - Calhoun</asp:ListItem>
                        <asp:ListItem Value="50">50 - Palm Beach</asp:ListItem>
                        <asp:ListItem Value="13">13 - Dade</asp:ListItem>
                    </asp:DropDownList>
                    <asp:CompareValidator ID="valCounty" runat="server" ControlToValidate="ddlCounty"
                        ErrorMessage="County is Required" Operator="NotEqual" ValueToCompare="0">*</asp:CompareValidator>
                    &nbsp;&nbsp; One Stop:&nbsp;
                    <asp:DropDownList ID="ddlOneStop" runat="server" ToolTip="Location of Data: Case at a Glance (top tab)" TabIndex="120">
                        <asp:ListItem Value="0">-</asp:ListItem>
                        <asp:ListItem Value="4640">North - 4640</asp:ListItem>
                        <asp:ListItem Value="4645">Central - 4645</asp:ListItem>
                        <asp:ListItem Value="4660">South - 4660</asp:ListItem>
                    </asp:DropDownList>
                    <asp:CompareValidator ID="valOneStop" runat="server" ControlToValidate="ddlOneStop"
                        ErrorMessage="One Stop is Required" Operator="NotEqual" ValueToCompare="0">*</asp:CompareValidator>
                    &nbsp;&nbsp; Unit:&nbsp;
                    <asp:DropDownList ID="ddlUnit" runat="server" ToolTip="Location of Data: Case at a Glance (top tab)" TabIndex="130">
                        <asp:ListItem Value="0">-</asp:ListItem>
                        <asp:ListItem Value="420">North - 420</asp:ListItem>
                        <asp:ListItem Value="421">Central - 421</asp:ListItem>
                        <asp:ListItem Value="422">South - 422</asp:ListItem>
                    </asp:DropDownList>
                    <asp:CompareValidator ID="valUnit" runat="server" ControlToValidate="ddlUnit" ErrorMessage="Unit is Required"
                        Operator="NotEqual" ValueToCompare="0">*</asp:CompareValidator>&nbsp;&nbsp;
                    <asp:Button ID="btnNotes05" runat="server" Text="Notes" CausesValidation="False"
                        CssClass="MonotypeCorsiva" ToolTip="Click to togle Notes field on and off" UseSubmitBehavior="False" TabIndex="140" />
                        <br />
                    <asp:TextBox ID="txtNotes05" runat="server" Rows="3" Visible="False" TextMode="MultiLine"
                        ToolTip="Enter comments here." Width="95%" Style="vertical-align: baseline"
                        AutoCompleteType="Notes" Font-Names="Arial"></asp:TextBox>
                </li>
                <li>Case Manager Last Name:&nbsp;&nbsp;
                    <asp:DropDownList ID="ddlCaseManagerLName" runat="server" DataSourceID="CaseManagers"
                        DataTextField="LastName" DataValueField="LastName" TabIndex="150">
                    </asp:DropDownList>
                    <asp:CompareValidator ID="valCaseManagerLName" runat="server" ControlToValidate="ddlCaseManagerLName"
                        ErrorMessage="Case Manager Last Name is Required" Operator="NotEqual" ValueToCompare="-">*</asp:CompareValidator>
                    <asp:SqlDataSource ID="CaseManagers" runat="server" ConnectionString="<%$ ConnectionStrings:SigmaToolsConnectionString %>"
                        SelectCommand="SELECT [LastName], [FirstName] FROM [CaseManagers] ORDER BY [LastName]">
                    </asp:SqlDataSource>
                </li>
                <li>Reviewer Name:&nbsp;
                    <asp:TextBox ID="txtReviewerName" runat="server" TabIndex="160">T. L. Thomas</asp:TextBox>
                    <asp:RequiredFieldValidator ID="valReviewerName" runat="server" ControlToValidate="txtReviewerName"
                        ErrorMessage="Reviewer Name is Required">*</asp:RequiredFieldValidator></li>
                <li>Type of Review:&nbsp;
                    <asp:DropDownList ID="ddlReviewType" runat="server" TabIndex="170">
                        <asp:ListItem Value="0">-</asp:ListItem>
                        <asp:ListItem>Desk Review</asp:ListItem>
                        <asp:ListItem>On Site Review</asp:ListItem>
                    </asp:DropDownList>
                    <asp:CompareValidator ID="valReviewType" runat="server" ControlToValidate="ddlReviewType"
                        ErrorMessage="Type of Review is Required" Operator="NotEqual" ValueToCompare="0">*</asp:CompareValidator></li>
                <li>Date of Review:&nbsp;
                    <asp:RequiredFieldValidator ID="valrReviewDate" runat="server" ControlToValidate="txtReviewDate"
                        ErrorMessage="From Date is Required">*</asp:RequiredFieldValidator>
                    <asp:TextBox ID="txtReviewDate" runat="server" Width="85px" TabIndex="180"></asp:TextBox>
                    <asp:RegularExpressionValidator ID="valReviewDate" runat="server" ControlToValidate="txtReviewDate"
                        ErrorMessage="Enter Review Date as MM/DD/YYYY" ValidationExpression="(0?[1-9]|1[012])[- /.](0?[1-9]|[12][0-9]|3[01])[- /.](19|20)\d\d">*</asp:RegularExpressionValidator><span
                            style="font-size: 8pt; font-family: Tahoma">&nbsp; <span>(MM/DD/YYYY) &nbsp; &nbsp;&nbsp;
                                &nbsp; &nbsp;&nbsp;
                            </span> &nbsp;<asp:Label ID="lblReviewDateTime" runat="server" ForeColor="Blue" /></span><!-- This TOP SECTION is pretty universal to all 8 forms --><!-- Start Paste from Excel --></li>
                <li>Was the participant "Mandatory" at any time during the review period? &nbsp;
                    <asp:RadioButtonList ID="radMandatory" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="190" AutoPostBack="True">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valMandatory" runat="server" ControlToValidate="radMandatory"
                        ErrorMessage="Answer on #10 is Required">*</asp:RequiredFieldValidator></li>
                <li>If yes, date of the New Case or Reopen alert--&nbsp;
                    <asp:TextBox ID="txtDateNewCase" runat="server" Width="85px" TabIndex="200"></asp:TextBox>
                    <asp:RequiredFieldValidator ID="valDateNewCase" runat="server" ControlToValidate="txtDateNewCase"
                        ErrorMessage='Date Required if participant was "Mandatory" at any time. #11'>*</asp:RequiredFieldValidator>
                </li>
                <li>If the case was MN during the review period, was the O&O Acknowledgement Form signed
                    by the participant and retained in the case file?
                    <asp:RadioButtonList ID="radOOSigned" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="210">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                        <asp:ListItem>N/A</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valOOSigned" runat="server" ControlToValidate="radOOSigned"
                        ErrorMessage="Answer on #12 is Required">*</asp:RequiredFieldValidator>
                    </li>
                <li>If the case was MN during the review period, what is the date on the form signed
                    (date during the review period, if any)? If there was no form signed during the
                    review period, what is the most recent date? (date may not be greater than the review
                    period end date) &nbsp;&nbsp;
                    <asp:TextBox ID="txtDateFormSigned" runat="server" Width="85px" TabIndex="220"></asp:TextBox>
                    &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;
                    <br />
                    <br />
                    <ul>
                        <li><span style="font-weight: bold">ASSESSMENT</span></li>
                    </ul>
                </li>
                <li>Was the initial assessment initiated within 30 days of the New Case or Reopen alert
                    (above in #11)?
                    <asp:RadioButtonList ID="radAssessmentWithin30" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="230">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                        <asp:ListItem>N/A</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valAssessmentWithin30" runat="server" ControlToValidate="radAssessmentWithin30"
                        ErrorMessage="Answer on #14 is Required">*</asp:RequiredFieldValidator>

                    </li>
                <li><strong>If yes</strong>, did the initial assessment include an assessment of the participant's skills, prior work history and employability? &nbsp;
                <asp:RadioButtonList ID="radIncludeSkills" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="260">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                        <asp:ListItem>N/A</asp:ListItem>
                </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valIncludeSkills" runat="server" ControlToValidate="radIncludeSkills"
                        ErrorMessage="Answer on #15 is Required">*</asp:RequiredFieldValidator>

                    <br />
                    <br />
                    <ul>
                        <li><span style="font-weight: bold">IRP / CAREER PLAN</span></li>
                    </ul>
                </li>







                <li>Is a signed copy of the initial IRP or the update in the case file?
                    <asp:RadioButtonList ID="radIRPSigned" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="270">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                        <asp:ListItem>N/A</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valIRPSigned" runat="server" ControlToValidate="radIRPSigned"
                        ErrorMessage="Answer on #16 is Required">*</asp:RequiredFieldValidator>

                    </li>
                <li>If yes to #16, were employment goals identified?&nbsp;
                    <asp:RadioButtonList ID="radGoalsIdentified" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="280">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                        <asp:ListItem>N/A</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valGoalsIdentified" runat="server" ControlToValidate="radGoalsIdentified"
                        ErrorMessage="Answer on #17 is Required">*</asp:RequiredFieldValidator></li>
                <li>If yes to #16, were activities the participant was required to complete (steps,
                    goals, see LOP) identified on the signed IRP?&nbsp;
                    <asp:RadioButtonList ID="radActivitiesIdentified" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="290">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                        <asp:ListItem>N/A</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valActivitiesIdentified" runat="server" ControlToValidate="radActivitiesIdentified"
                        ErrorMessage="Answer on #18 is Required">*</asp:RequiredFieldValidator>
</li>
                <li>If yes to #16, were the number of hours for each activity (per week) identified
                    on the signed IRP?&nbsp;
                    <asp:RadioButtonList ID="radHoursIdentified" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="300">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                        <asp:ListItem>N/A</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valHoursIdentified" runat="server" ControlToValidate="radHoursIdentified"
                        ErrorMessage="Answer on #19 is Required">*</asp:RequiredFieldValidator>
</li>
                <li>If yes to #16, did the assigned activities on the signed IRP include due/anticipated
                    completion dates?&nbsp;
                    <asp:RadioButtonList ID="radActivitiesIncludeAnticipated" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="305">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                        <asp:ListItem>N/A</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valActivitiesIncludeAnticipated" runat="server" ControlToValidate="radActivitiesIncludeAnticipated"
                        ErrorMessage="Answer on #20 is Required">*</asp:RequiredFieldValidator>
    </li>
                <li>If yes to #16, were services provided to the participant by the WT program identified
                    in the signed IRP?
                    <asp:RadioButtonList ID="radServicesPrivided" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="310">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                        <asp:ListItem>N/A</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valServicesPrivided" runat="server" ControlToValidate="radServicesPrivided"
                        ErrorMessage="Answer on #21 is Required">*</asp:RequiredFieldValidator>
</li>
                <li>Please comment on the steps to self-sufficiency.&nbsp;
                    <asp:Button ID="btnStepsComment" runat="server" Text="Comment" CausesValidation="False" CssClass="MonotypeCorsiva" ToolTip="Click to togle Notes field on and off" UseSubmitBehavior="False" TabIndex="320" />
                    <br />
                    <asp:TextBox ID="txtSteps" runat="server" Rows="4" TextMode="MultiLine" ToolTip="Enter comments here." Visible="False" Width="95%" Font-Names="Arial"></asp:TextBox><br />
                    <br />
                    <ul>
                        <li><span style="font-weight: bold">EMPLOYMENT</span></li>
                    </ul>
                </li>
                <li>If the participant was employed at any time during the review period, was employment verified or documented? &nbsp;
                    <asp:RadioButtonList ID="radEmploymentVerified" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="330">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                        <asp:ListItem>N/A</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valEmploymentVerified" runat="server" ControlToValidate="radEmploymentVerified"
                        ErrorMessage="Answer on #23 is Required">*</asp:RequiredFieldValidator>
                    &nbsp; <em>If multiple employment exist, look at the most recent employment that is
                        during the review period.</em>
                        </li>
                <li>Did OSST match verification?&nbsp;
                    <asp:RadioButtonList ID="radOSSTMatch" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="340">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                        <asp:ListItem>N/A</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valOSSTMatch" runat="server" ControlToValidate="radOSSTMatch"
                        ErrorMessage="Answer on #24 is Required">*</asp:RequiredFieldValidator>
<br />
                    <br />
                    <ul>
                        <li><span style="font-weight: bold">JOB PARTICIPATION RATES (JPR)-this section uses the JPR entries reported to HHS provided by AWI reporting team.</span></li>
                    </ul>
                </li>
                <li>1st week of JPRs with hours greater than zero reported-
                    <br />
                    provide Monday date: &nbsp;<asp:TextBox ID="txtJPR1Date" runat="server" Width="85px" TabIndex="350"></asp:TextBox>
                    &nbsp; Activity code:&nbsp;
                    <asp:TextBox ID="txtJPR1Activity" runat="server" Width="50px" TabIndex="360"></asp:TextBox>
                    &nbsp; JPR hours:&nbsp;
                    <asp:TextBox ID="txtJPR1Hours" runat="server" Width="50px" TabIndex="370"></asp:TextBox>
                    <asp:Button ID="btn1stWeek2ndActivity" runat="server" Text="2nd Act." CausesValidation="False"
                        CssClass="MonotypeCorsiva" ToolTip="Click to togle fields for a 2nd Activity on and off"
                        UseSubmitBehavior="False" />&nbsp;&nbsp;<br />
                    <asp:Label ID="lblJPR1Date2" runat="server" Text="2nd Activity Date:" Visible="False"></asp:Label>&nbsp;
                    <asp:TextBox ID="txtJPR1Date2" runat="server" Visible="False" Width="85px" TabIndex="380"></asp:TextBox>&nbsp;&nbsp;
                    <asp:Label ID="lblJPR1Activity2" runat="server" Text="2nd Activity Code:" Visible="False"></asp:Label>&nbsp;
                    <asp:TextBox ID="txtJPR1Activity2" runat="server" Visible="False" Width="50px" TabIndex="390"></asp:TextBox>&nbsp;&nbsp;
                    <asp:Label ID="lblJPR1Hours2" runat="server" Text="2nd Activity JPR hours:" Visible="False"></asp:Label>&nbsp;
                    <asp:TextBox ID="txtJPR1Hours2" runat="server" Visible="False" Width="50px" TabIndex="400"></asp:TextBox>
                    </li>
                <li>Was there documentation in the case file to support hours that were entered and reported?
                    <asp:RadioButtonList ID="radJPRHoursDoc1" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="120">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                        <asp:ListItem>N/A</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valJPRHoursDoc1" runat="server" ControlToValidate="radJPRHoursDoc1"
                        ErrorMessage="Answer on #25 is Required">*</asp:RequiredFieldValidator>
</li>
                <li>2nd week of JPRs with hours greater than zero reported-
                    <br />
                    provide Monday date: &nbsp;
                    <asp:TextBox ID="txtJPR2Date" runat="server" Width="85px" TabIndex="410"></asp:TextBox>
                    &nbsp; Activity code:&nbsp;
                    <asp:TextBox ID="txtJPR2Activity" runat="server" Width="50px" TabIndex="420"></asp:TextBox>
                    &nbsp; JPR hours:&nbsp;
                    <asp:TextBox ID="txtJPR2Hours" runat="server" Width="50px" TabIndex="430"></asp:TextBox>
                    <asp:Button ID="btn2ndWeek2ndActivity" runat="server" Text="2nd Act." CausesValidation="False" CssClass="MonotypeCorsiva" ToolTip="Click to togle fields for a 2nd Activity on and off" UseSubmitBehavior="False" />
                    &nbsp;<br />
                    <asp:Label ID="lblJPR2Date2" runat="server" Text="2nd Activity Date:" Visible="False"></asp:Label>&nbsp;
                    <asp:TextBox ID="txtJPR2Date2" runat="server" Visible="False" Width="85px" TabIndex="440"></asp:TextBox>                    &nbsp;&nbsp;
                    <asp:Label ID="lblJPR2Activity2" runat="server" Text="2nd Activity Code:" Visible="False"></asp:Label>&nbsp;
                    <asp:TextBox ID="txtJPR2Activity2" runat="server" Visible="False" Width="50px" TabIndex="450"></asp:TextBox>                    &nbsp;&nbsp;
                    <asp:Label ID="lblJPR2Hours2" runat="server" Text="2nd Activity JPR hours:" Visible="False"></asp:Label>&nbsp;
                    <asp:TextBox ID="txtJPR2Hours2" runat="server" Visible="False" Width="50px" TabIndex="460"></asp:TextBox>
                </li>
                <li>Was there documentation in the case file to support hours that were entered and
                    reported?&nbsp;
                    <asp:RadioButtonList ID="radJPRHoursDoc2" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="120">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                        <asp:ListItem>N/A</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valJPRHoursDoc2" runat="server" ControlToValidate="radJPRHoursDoc2"
                        ErrorMessage="Answer on #28 is Required">*</asp:RequiredFieldValidator>
</li>
                <li>3rd week of JPRs with hours greater than zero reported-
                    <br />
                    provide Monday date: &nbsp;
                    <asp:TextBox ID="txtJPR3Date" runat="server" Width="85px" TabIndex="470"></asp:TextBox>
                    &nbsp; Activity code:&nbsp;
                    <asp:TextBox ID="txtJPR3Activity" runat="server" Width="50px" TabIndex="480"></asp:TextBox>
                    &nbsp; JPR hours:&nbsp;
                    <asp:TextBox ID="txtJPR3Hours" runat="server" Width="50px" TabIndex="490"></asp:TextBox>
                    <asp:Button ID="btn3rdWeek2ndActivity" runat="server" Text="2nd Act." CausesValidation="False" CssClass="MonotypeCorsiva" ToolTip="Click to togle fields for a 2nd Activity on and off" UseSubmitBehavior="False" />
                    &nbsp;<br />
                    <asp:Label ID="lblJPR3Date2" runat="server" Text="2nd Activity Date:" Visible="False"></asp:Label>&nbsp;
                    <asp:TextBox ID="txtJPR3Date2" runat="server" Visible="False" Width="85px" TabIndex="500"></asp:TextBox> &nbsp;&nbsp;
                    <asp:Label ID="lblJPR3Activity2" runat="server" Text="2nd Activity Code:" Visible="False"></asp:Label>&nbsp;
                    <asp:TextBox ID="txtJPR3Activity2" runat="server" Visible="False" Width="50px" TabIndex="510"></asp:TextBox>
                    &nbsp;&nbsp;
                    <asp:Label ID="lblJPR3Hours2" runat="server" Text="2nd Activity JPR hours:" Visible="False"></asp:Label>&nbsp;
                    <asp:TextBox ID="txtJPR3Hours2" runat="server" Visible="False" Width="50px" TabIndex="520"></asp:TextBox>
                </li>
                <li>Was there documentation in the case file to support hours that were entered and
                    reported?&nbsp;
                    <asp:RadioButtonList ID="radJPRHoursDoc3" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="120">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                        <asp:ListItem>N/A</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valJPRHoursDoc3" runat="server" ControlToValidate="radJPRHoursDoc3"
                        ErrorMessage="Answer on #30 is Required">*</asp:RequiredFieldValidator>&nbsp;
                    </li>
                <li>4th week of JPRs with hours greater than zero reported-
                    <br />
                    provide Monday date: &nbsp;
                    <asp:TextBox ID="txtJPR4Date" runat="server" Width="85px" TabIndex="530"></asp:TextBox>
                    &nbsp; Activity code:&nbsp;
                    <asp:TextBox ID="txtJPR4Activity" runat="server" Width="50px" TabIndex="540"></asp:TextBox>
                    &nbsp; JPR hours:&nbsp;
                    <asp:TextBox ID="txtJPR4Hours" runat="server" Width="50px" TabIndex="550"></asp:TextBox>
                    <asp:Button ID="btn4thWeek2ndActivity" runat="server" Text="2nd Act." CausesValidation="False"
                        CssClass="MonotypeCorsiva" ToolTip="Click to togle fields for a 2nd Activity on and off"
                        UseSubmitBehavior="False" />
                    &nbsp;<br />
                    <asp:Label ID="lblJPR4Date2" runat="server" Text="2nd Activity Date:" Visible="False"></asp:Label>&nbsp;
                    <asp:TextBox ID="txtJPR4Date2" runat="server" Visible="False" Width="85px" TabIndex="560"></asp:TextBox>                    &nbsp;&nbsp;
                    <asp:Label ID="lblJPR4Activity2" runat="server" Text="2nd Activity Code:" Visible="False"></asp:Label>&nbsp;
                    <asp:TextBox ID="txtJPR4Activity2" runat="server" Visible="False" Width="50px" TabIndex="570"></asp:TextBox>                    &nbsp;&nbsp;
                    <asp:Label ID="lblJPR4Hours2" runat="server" Text="2nd Activity JPR hours:" Visible="False"></asp:Label>&nbsp;
                    <asp:TextBox ID="txtJPR4Hours2" runat="server" Visible="False" Width="50px" TabIndex="580"></asp:TextBox>
                </li>
                <li>Was there documentation in the case file to support hours that were entered and
                    reported?&nbsp;
                    <asp:RadioButtonList ID="radJPRHoursDoc4" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="120">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                        <asp:ListItem>N/A</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valJPRHoursDoc4" runat="server" ControlToValidate="radJPRHoursDoc4"
                        ErrorMessage="Answer on #32 is Required">*</asp:RequiredFieldValidator>
                    </li>
                <li>5th week of JPRs with hours greater than zero reported-
                    <br />
                    provide Monday date: &nbsp;
                    <asp:TextBox ID="txtJPR5Date" runat="server" Width="85px" TabIndex="590"></asp:TextBox>
                    &nbsp; Activity code:&nbsp;
                    <asp:TextBox ID="txtJPR5Activity" runat="server" Width="50px" TabIndex="600"></asp:TextBox>
                    &nbsp; JPR hours:&nbsp;
                    <asp:TextBox ID="txtJPR5Hours" runat="server" Width="50px" TabIndex="610"></asp:TextBox>
                    <asp:Button ID="btn5thWeek2ndActivity" runat="server" Text="2nd Act." CausesValidation="False" CssClass="MonotypeCorsiva" ToolTip="Click to togle fields for a 2nd Activity on and off" UseSubmitBehavior="False" />
                    &nbsp;<br />
                    <asp:Label ID="lblJPR5Date2" runat="server" Text="2nd Activity Date:" Visible="False"></asp:Label>&nbsp;
                    <asp:TextBox ID="txtJPR5Date2" runat="server" Visible="False" Width="85px" TabIndex="620"></asp:TextBox>                    &nbsp;&nbsp;
                    <asp:Label ID="lblJPR5Activity2" runat="server" Text="2nd Activity Code:" Visible="False"></asp:Label>&nbsp;
                    <asp:TextBox ID="txtJPR5Activity2" runat="server" Visible="False" Width="50px" TabIndex="630"></asp:TextBox>                    &nbsp;&nbsp;
                    <asp:Label ID="lblJPR5Hours2" runat="server" Text="2nd Activity JPR hours:" Visible="False"></asp:Label>&nbsp;
                    <asp:TextBox ID="txtJPR5Hours2" runat="server" Visible="False" Width="50px" TabIndex="640"></asp:TextBox>
                </li>
                <li>Was there documentation in the case file to support hours that were entered and
                    reported?&nbsp;
                    <asp:RadioButtonList ID="radJPRHoursDoc5" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="650">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                        <asp:ListItem>N/A</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valJPRHoursDoc5" runat="server" ControlToValidate="radJPRHoursDoc5"
                        ErrorMessage="Answer on #34 is Required">*</asp:RequiredFieldValidator>
</li>
                <li>Is there any indication that the individual was assigned to workbooks for participation
                    requirements (make up work, core or core plus activity)?&nbsp;
                    <asp:RadioButtonList ID="radJPRWorkbooks" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="660">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                        <asp:ListItem>N/A</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valJPRWorkbooks" runat="server" ControlToValidate="radJPRWorkbooks"
                        ErrorMessage="Answer on #35 is Required">*</asp:RequiredFieldValidator>
                    <br />JPR Notes:
                    <asp:TextBox ID="txtJPRNotes" runat="server" Font-Names="Arial" Rows="8" TextMode="MultiLine" ToolTip="Enter Notes here." Width="95%" Font-Size="X-Small"></asp:TextBox>
<br />
                    <br />
                    <ul>
                        <li><span style="font-weight: bold">Activity Information--</span></li>
                    </ul>
                </li>
                <li>If Vocational Education was assigned any time during the review period did the assigned
                    activities meet the definition of Vocational Education? &nbsp;
                    <asp:RadioButtonList ID="radVocationalEd" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="670">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                        <asp:ListItem>N/A</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valVocationalEd" runat="server" ControlToValidate="radVocationalEd"
                        ErrorMessage="Answer on #36 is Required">*</asp:RequiredFieldValidator>
</li>
                <li>If the Work Experience Combined with Education (WEP 220) or Work Experience (220)
                    activity, was assigned anytime during the review period were the hours assigned
                    to the worksite less than or equal to (not greater) the hours resulting from the
                    calculation?&nbsp;
                    <asp:RadioButtonList ID="radWEP220HoursLess" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="680">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                        <asp:ListItem>N/A</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valWEP220HoursLess" runat="server" ControlToValidate="radWEP220HoursLess"
                        ErrorMessage="Answer on #37 is Required">*</asp:RequiredFieldValidator>
</li>
                <li>If the CWEP was assigned anytime during the review period, were the hours assigned
                    to the worksite less than or equal to (not greater) the number of hours required
                    by the calculation? &nbsp;
                    <asp:RadioButtonList ID="radCWEPHoursLess" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="690">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                        <asp:ListItem>N/A</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valCWEPHoursLess" runat="server" ControlToValidate="radCWEPHoursLess"
                        ErrorMessage="Answer on #38 is Required">*</asp:RequiredFieldValidator>
</li>
                <li>If job search/job club was one of the activities assigned during the review period,
                    did the individual participate for more than 4 consecutive weeks or six cummulative
                    weeks (during the federal fiscal year).
                    <asp:RadioButtonList ID="radParticipateOver4Weeks" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="700">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                        <asp:ListItem>N/A</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valParticipateOver4Weeks" runat="server" ControlToValidate="radParticipateOver4Weeks"
                        ErrorMessage="Answer on #39 is Required">*</asp:RequiredFieldValidator>
<br />
                    <br />
                    <ul>
                        <li><span style="font-weight: bold">Activity Process Elements</span></li>
                    </ul>
                </li>
                <li>Number of days between "Start Date" of the first activity (activity, orientation,
                    training, pre-penalty, deferral) and the referral date from DCF (open, reopen, end
                    app, end trans, etc.) based on #11. If the reopen date is before the review period,
                    enter x. If the case was applicant or non-NM, enter x. &nbsp;<span style="color: #ff0000">
                    <asp:TextBox ID="txtDaysBetweenStartAndReferral" runat="server" Width="50px" TabIndex="710"></asp:TextBox></span><br />
                    <br />
                    <ul>
                        <li><span style="font-weight: bold">DEFERRALS</span></li>
                    </ul>
                </li>
                <li>If the participant was deferred at any time during the review period from participation
                    due to a medical incapacity, was documentation in the hard file: i.e. either the
                    Medical forms or medical note signed by a licensed physician?&nbsp;
                    <asp:RadioButtonList ID="radMedicalNoteSigned" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="720">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                        <asp:ListItem>N/A</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valMedicalNoteSigned" runat="server" ControlToValidate="radMedicalNoteSigned"
                        ErrorMessage="Answer on #41 is Required">*</asp:RequiredFieldValidator>
<br />
                    <br />
                    <ul>
                        <li><span style="font-weight: bold">DIVERSION PROGRAMS</span></li>
                    </ul>
                </li>
                <li>If Up-Front Diversion cash payment was provided during the review period, is there
                    evidence that the applicant received job contacts and started the work search process
                    before the Up-Front Diversion payment or had a job prior to receiving the cash payment.
                    &nbsp;
                    <asp:RadioButtonList ID="radEvidenceOfJobContacts" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="730">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                        <asp:ListItem>N/A</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valEvidenceOfJobContacts" runat="server" ControlToValidate="radEvidenceOfJobContacts"
                        ErrorMessage="Answer on #42 is Required">*</asp:RequiredFieldValidator>
</li>
                <li>If Up-Front Diversion payment was approved, were forms 2073A, and 2075 completed
                    (or updated form once released to the RWBs)?&nbsp;
                    <asp:RadioButtonList ID="radForms2073A_2075Completed" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="740">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                        <asp:ListItem>N/A</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valForms2073A_2075Completed" runat="server" ControlToValidate="radForms2073A_2075Completed"
                        ErrorMessage="Answer on #43 is Required">*</asp:RequiredFieldValidator>
</li>
                <li>If relocation assistance was provided during the review period, was form 2279 completed?&nbsp;
                    <asp:RadioButtonList ID="radForm2279Completed" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="750">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                        <asp:ListItem>N/A</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valForm2279Completed" runat="server" ControlToValidate="radForm2279Completed"
                        ErrorMessage="Answer on #44 is Required">*</asp:RequiredFieldValidator>
</li>
                <li>If relocation assistance was provided during the review period, was there a written
                    relocation plan, including a relocation budget (form AWI 0002)?&nbsp;
                    <asp:RadioButtonList ID="radFormAWI0002" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="760">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                        <asp:ListItem>N/A</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valFormAWI0002" runat="server" ControlToValidate="radFormAWI0002"
                        ErrorMessage="Answer on #45 is Required">*</asp:RequiredFieldValidator>
</li>
                <li>If relocation assistance was provided during the review period, was the relocation
                    monitored as evidenced by a survey?&nbsp;
                    <asp:RadioButtonList ID="radRelocationMonitored" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="770">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                        <asp:ListItem>N/A</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valRelocationMonitored" runat="server" ControlToValidate="radRelocationMonitored"
                        ErrorMessage="Answer on #46 is Required">*</asp:RequiredFieldValidator>
</li>
                <li>If CASB was approved during the review period, was the individual employed at approval
                    (documentation/verification required) ?&nbsp;
                    <asp:RadioButtonList ID="radEmployedAtCASBApproval" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="780">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                        <asp:ListItem>N/A</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valEmployedAtCASBApproval" runat="server" ControlToValidate="radEmployedAtCASBApproval"
                        ErrorMessage="Answer on #47 is Required">*</asp:RequiredFieldValidator>
<br />
                    <br />
                    <ul>
                        <li><span style="font-weight: bold">PRE-PENALTIES and SANCTIONS</span></li>
                    </ul>
                </li>
                <li>Based on the alternative plan screen, was the 2290 mailed within 2 working days
                    of the actual date of failure?&nbsp; REVIEW MOST RECENT PRE PENALTY DURING THE REVIEW
                    PERIOD (#1).&nbsp;
                    <asp:RadioButtonList ID="radWas2290Mailed" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="790">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                        <asp:ListItem>N/A</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valWas2290Mailed" runat="server" ControlToValidate="radWas2290Mailed"
                        ErrorMessage="Answer on #48 is Required">*</asp:RequiredFieldValidator>
</li>
                <li>Based on the pre-penalty entry reviewed under #48, did the RWB attempt to contact
                    the participant orally during the 10 day contact period?&nbsp;
                    <asp:RadioButtonList ID="radRWBContact" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="800">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                        <asp:ListItem>N/A</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valRWBContact" runat="server" ControlToValidate="radRWBContact"
                        ErrorMessage="Answer on #49 is Required">*</asp:RequiredFieldValidator>
</li>
                <li>For the most recent pre-penalty/penalty entry terminated with good cause during
                    the review period (#1), do case notes clearly state good cause was determined?&nbsp;
                    <asp:RadioButtonList ID="radTerminationGoodCause" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="810">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                        <asp:ListItem>N/A</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valTerminationGoodCause" runat="server" ControlToValidate="radTerminationGoodCause"
                        ErrorMessage="Answer on #50 is Required">*</asp:RequiredFieldValidator>
</li>
                <li>For the most recent sanction requested during the review period (#1), was the sanction(s)
                    a result of two failures within a 30-day period? (y, n). If no sanction was requested
                    during the review period, check "N/A".&nbsp;
                    <asp:RadioButtonList ID="radTwoFailures" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="820">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                        <asp:ListItem>N/A</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valTwoFailures" runat="server" ControlToValidate="radTwoFailures"
                        ErrorMessage="Answer on #51 is Required">*</asp:RequiredFieldValidator>
</li>
                <li>If yes to 51, was the second failure within 30 days of the first failure?&nbsp;
                    <asp:RadioButtonList ID="radTwoIn30" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="830">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valTwoIn30" runat="server" ControlToValidate="radTwoIn30"
                        ErrorMessage="Answer on #52 is Required">*</asp:RequiredFieldValidator>
</li>
                <li>If yes to 51, was the individual allowed three working days after the date of the second failure to provide good cause?&nbsp;
                    <asp:RadioButtonList ID="radAllowed3Days" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="840">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valAllowed3Days" runat="server" ControlToValidate="radAllowed3Days"
                        ErrorMessage="Answer on #53 is Required">*</asp:RequiredFieldValidator>
</li>
                <li>If yes to 51, was the AWI WTP-2292 mailed?&nbsp;
                    <asp:RadioButtonList ID="radWTP2292Mailed" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="850">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                        <asp:ListItem>N/A</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valWTP2292Mailed" runat="server" ControlToValidate="radWTP2292Mailed"
                        ErrorMessage="Answer on #54 is Required">*</asp:RequiredFieldValidator>
<br />
                    <br />
                    <ul>
                        <li><span style="font-weight: bold">Case Notes</span></li>
                    </ul>
                </li>
                <li>Regarding any of the above finding elements, were case notes appropriately entered
                    in the system providing a clear course of action?&nbsp;
                    <asp:RadioButtonList ID="radActionCaseNotesEntered" runat="server" RepeatDirection="Horizontal" RepeatLayout="Flow" TabIndex="860">
                        <asp:ListItem>Y</asp:ListItem>
                        <asp:ListItem>N</asp:ListItem>
                        <asp:ListItem>N/A</asp:ListItem>
                    </asp:RadioButtonList>
                    <asp:RequiredFieldValidator ID="valActionCaseNotesEntered" runat="server" ControlToValidate="radActionCaseNotesEntered"
                        ErrorMessage="Answer on #55 is Required">*</asp:RequiredFieldValidator>
Please add comments
                    <br />
                    <br />
                    <br />
                    <br />
                    <ul>
                        <li><span style="font-weight: bold">COMMENTS</span></li>
                    </ul>
                </li>
            </ol>
            <asp:TextBox ID="txtFinalComments" runat="server" Rows="12" TextMode="MultiLine" Width="95%" Font-Names="Arial" TabIndex="870"></asp:TextBox>
            <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="txtFinalComments"
                ErrorMessage="Comments at the end are Required">*</asp:RequiredFieldValidator><br />
            <br />
        <div style="float:left">
            <asp:Button ID="Home" runat="server" Text="Home" PostBackUrl="~/Default.aspx" TabIndex="1000" />
            <input type="button" value=" Print this page "onclick="window.print();return false;" style="margin-left:50px" tabindex="1100"/>
        </div>
        <div style="float:right">
            <asp:Button ID="btnSubmit" runat="server" Text="Submit" TabIndex="1200" />
            <asp:Button ID="btnCancel" runat="server" Text="Cancel" TabIndex="1300" CausesValidation="False" PostBackUrl="~/Cancel.aspx" style="margin-left:50px"/>&nbsp;

        </div>
            <br />
            <br />
            <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:SigmaToolsConnectionString2 %>"
                DeleteCommand="DELETE FROM [WTP] WHERE [ReviewID] = @ReviewID"
                InsertCommand="INSERT INTO [WTP] ([ReviewDateFrom], [ReviewDateTo], [LastName], [FirstName], [SSN], [Region], [County], [OneStop], [Unit], [Notes05], [CaseManagerLName], [ReviewerName], [ReviewType], [ReviewDate], [Mandatory], [DateNewCase], [OOSigned], [DateFormSigned], [AssessmentWithin30], [IncludeSkills], [IRPSigned], [GoalsIdentified], [ActivitiesIdentified], [HoursIdentified], [ActivitiesIncludeAnticipated], [ServicesPrivided], [Steps], [EmploymentVerified], [OSSTMatch], [JPR1Date], [JPR1Activity], [JPR1Hours], [JPR1Date2], [JPR1Activity2], [JPR1Hours2], [JPRHoursDoc1], [JPR2Date], [JPR2Activity], [JPR2Hours], [JPR2Date2], [JPR2Activity2], [JPR2Hours2], [JPRHoursDoc2], [JPR3Date], [JPR3Activity], [JPR3Hours], [JPR3Date2], [JPR3Activity2], [JPR3Hours2], [JPRHoursDoc3], [JPR4Date], [JPR4Activity], [JPR4Hours], [JPR4Date2], [JPR4Activity2], [JPR4Hours2], [JPRHoursDoc4], [JPR5Date], [JPR5Activity], [JPR5Hours], [JPR5Date2], [JPR5Activity2], [JPR5Hours2], [JPRHoursDoc5], [JPRWorkbooks], [JPRNotes], [VocationalEd], [WEP220HoursLess], [CWEPHoursLess], [ParticipateOver4Weeks], [DaysBetweenStartAndReferral], [MedicalNoteSigned], [EvidenceOfJobContacts], [Form2279Completed], [FormAWI0002], [RelocationMonitored], [EmployedAtCASBApproval], [Was2290Mailed], [RWBContact], [TerminationGoodCause], [TwoFailures], [TwoIn30], [Allowed3Days], [WTP2292Mailed], [ActionCaseNotesEntered], [FinalComments], [ReviewDateTime]) VALUES (@ReviewDateFrom, @ReviewDateTo, @LastName, @FirstName, @SSN, @Region, @County, @OneStop, @Unit, @Notes05, @CaseManagerLName, @ReviewerName, @ReviewType, @ReviewDate, @Mandatory, @DateNewCase, @OOSigned, @DateFormSigned, @AssessmentWithin30, @IncludeSkills, @IRPSigned, @GoalsIdentified, @ActivitiesIdentified, @HoursIdentified, @ActivitiesIncludeAnticipated, @ServicesPrivided, @Steps, @EmploymentVerified, @OSSTMatch, @JPR1Date, @JPR1Activity, @JPR1Hours, @JPR1Date2, @JPR1Activity2, @JPR1Hours2, @JPRHoursDoc1, @JPR2Date, @JPR2Activity, @JPR2Hours, @JPR2Date2, @JPR2Activity2, @JPR2Hours2, @JPRHoursDoc2, @JPR3Date, @JPR3Activity, @JPR3Hours, @JPR3Date2, @JPR3Activity2, @JPR3Hours2, @JPRHoursDoc3, @JPR4Date, @JPR4Activity, @JPR4Hours, @JPR4Date2, @JPR4Activity2, @JPR4Hours2, @JPRHoursDoc4, @JPR5Date, @JPR5Activity, @JPR5Hours, @JPR5Date2, @JPR5Activity2, @JPR5Hours2, @JPRHoursDoc5, @JPRWorkbooks, @JPRNotes, @VocationalEd, @WEP220HoursLess, @CWEPHoursLess, @ParticipateOver4Weeks, @DaysBetweenStartAndReferral, @MedicalNoteSigned, @EvidenceOfJobContacts, @Form2279Completed, @FormAWI0002, @RelocationMonitored, @EmployedAtCASBApproval, @Was2290Mailed, @RWBContact, @TerminationGoodCause, @TwoFailures, @TwoIn30, @Allowed3Days, @WTP2292Mailed, @ActionCaseNotesEntered, @FinalComments, @ReviewDateTime)"
                SelectCommand="SELECT * FROM [WTP]"
                UpdateCommand="UPDATE [WTP] SET [ReviewDateFrom] = @ReviewDateFrom, [ReviewDateTo] = @ReviewDateTo, [LastName] = @LastName, [FirstName] = @FirstName, [SSN] = @SSN, [Region] = @Region, [County] = @County, [OneStop] = @OneStop, [Unit] = @Unit, [Notes05] = @Notes05, [CaseManagerLName] = @CaseManagerLName, [ReviewerName] = @ReviewerName, [ReviewType] = @ReviewType, [ReviewDate] = @ReviewDate, [Mandatory] = @Mandatory, [DateNewCase] = @DateNewCase, [OOSigned] = @OOSigned, [DateFormSigned] = @DateFormSigned, [AssessmentWithin30] = @AssessmentWithin30, [IncludeSkills] = @IncludeSkills, [IRPSigned] = @IRPSigned, [GoalsIdentified] = @GoalsIdentified, [ActivitiesIdentified] = @ActivitiesIdentified, [HoursIdentified] = @HoursIdentified, [ActivitiesIncludeAnticipated] = @ActivitiesIncludeAnticipated, [ServicesPrivided] = @ServicesPrivided, [Steps] = @Steps, [EmploymentVerified] = @EmploymentVerified, [OSSTMatch] = @OSSTMatch, [JPR1Date] = @JPR1Date, [JPR1Activity] = @JPR1Activity, [JPR1Hours] = @JPR1Hours, [JPR1Date2] = @JPR1Date2, [JPR1Activity2] = @JPR1Activity2, [JPR1Hours2] = @JPR1Hours2, [JPRHoursDoc1] = @JPRHoursDoc1, [JPR2Date] = @JPR2Date, [JPR2Activity] = @JPR2Activity, [JPR2Hours] = @JPR2Hours, [JPR2Date2] = @JPR2Date2, [JPR2Activity2] = @JPR2Activity2, [JPR2Hours2] = @JPR2Hours2, [JPRHoursDoc2] = @JPRHoursDoc2, [JPR3Date] = @JPR3Date, [JPR3Activity] = @JPR3Activity, [JPR3Hours] = @JPR3Hours, [JPR3Date2] = @JPR3Date2, [JPR3Activity2] = @JPR3Activity2, [JPR3Hours2] = @JPR3Hours2, [JPRHoursDoc3] = @JPRHoursDoc3, [JPR4Date] = @JPR4Date, [JPR4Activity] = @JPR4Activity, [JPR4Hours] = @JPR4Hours, [JPR4Date2] = @JPR4Date2, [JPR4Activity2] = @JPR4Activity2, [JPR4Hours2] = @JPR4Hours2, [JPRHoursDoc4] = @JPRHoursDoc4, [JPR5Date] = @JPR5Date, [JPR5Activity] = @JPR5Activity, [JPR5Hours] = @JPR5Hours, [JPR5Date2] = @JPR5Date2, [JPR5Activity2] = @JPR5Activity2, [JPR5Hours2] = @JPR5Hours2, [JPRHoursDoc5] = @JPRHoursDoc5, [JPRWorkbooks] = @JPRWorkbooks, [JPRNotes] = @JPRNotes, [VocationalEd] = @VocationalEd, [WEP220HoursLess] = @WEP220HoursLess, [CWEPHoursLess] = @CWEPHoursLess, [ParticipateOver4Weeks] = @ParticipateOver4Weeks, [DaysBetweenStartAndReferral] = @DaysBetweenStartAndReferral, [MedicalNoteSigned] = @MedicalNoteSigned, [EvidenceOfJobContacts] = @EvidenceOfJobContacts, [Form2279Completed] = @Form2279Completed, [FormAWI0002] = @FormAWI0002, [RelocationMonitored] = @RelocationMonitored, [EmployedAtCASBApproval] = @EmployedAtCASBApproval, [Was2290Mailed] = @Was2290Mailed, [RWBContact] = @RWBContact, [TerminationGoodCause] = @TerminationGoodCause, [TwoFailures] = @TwoFailures, [TwoIn30] = @TwoIn30, [Allowed3Days] = @Allowed3Days, [WTP2292Mailed] = @WTP2292Mailed, [ActionCaseNotesEntered] = @ActionCaseNotesEntered, [FinalComments] = @FinalComments, [ReviewDateTime] = @ReviewDateTime WHERE [ReviewID] = @ReviewID">
                <DeleteParameters>
                    <asp:Parameter Name="ReviewID" Type="Int32" />
                </DeleteParameters>
                <UpdateParameters>
                    <asp:Parameter Name="ReviewDateFrom" Type="DateTime" />
                    <asp:Parameter Name="ReviewDateTo" Type="DateTime" />
                    <asp:Parameter Name="LastName" Type="String" />
                    <asp:Parameter Name="FirstName" Type="String" />
                    <asp:Parameter Name="SSN" Type="String" />
                    <asp:Parameter Name="Region" Type="String" />
                    <asp:Parameter Name="County" Type="String" />
                    <asp:Parameter Name="OneStop" Type="String" />
                    <asp:Parameter Name="Unit" Type="String" />
                    <asp:Parameter Name="Notes05" Type="String" />
                    <asp:Parameter Name="CaseManagerLName" Type="String" />
                    <asp:Parameter Name="ReviewerName" Type="String" />
                    <asp:Parameter Name="ReviewType" Type="String" />
                    <asp:Parameter Name="ReviewDate" Type="DateTime" />
                    <asp:Parameter Name="Mandatory" Type="String" />
                    <asp:Parameter Name="DateNewCase" Type="DateTime" />
                    <asp:Parameter Name="OOSigned" Type="String" />
                    <asp:Parameter Name="DateFormSigned" Type="DateTime" />
                    <asp:Parameter Name="AssessmentWithin30" Type="String" />
                    <asp:Parameter Name="IncludeSkills" Type="String" />
                    <asp:Parameter Name="IRPSigned" Type="String" />
                    <asp:Parameter Name="GoalsIdentified" Type="String" />
                    <asp:Parameter Name="ActivitiesIdentified" Type="String" />
                    <asp:Parameter Name="HoursIdentified" Type="String" />
                    <asp:Parameter Name="ActivitiesIncludeAnticipated" Type="String" />
                    <asp:Parameter Name="ServicesPrivided" Type="String" />
                    <asp:Parameter Name="Steps" Type="String" />
                    <asp:Parameter Name="EmploymentVerified" Type="String" />
                    <asp:Parameter Name="OSSTMatch" Type="String" />
                    <asp:Parameter Name="JPR1Date" Type="DateTime" />
                    <asp:Parameter Name="JPR1Activity" Type="String" />
                    <asp:Parameter Name="JPR1Hours" Type="String" />
                    <asp:Parameter Name="JPR1Date2" Type="DateTime" />
                    <asp:Parameter Name="JPR1Activity2" Type="String" />
                    <asp:Parameter Name="JPR1Hours2" Type="String" />
                    <asp:Parameter Name="JPRHoursDoc1" Type="String" />
                    <asp:Parameter Name="JPR2Date" Type="DateTime" />
                    <asp:Parameter Name="JPR2Activity" Type="String" />
                    <asp:Parameter Name="JPR2Hours" Type="String" />
                    <asp:Parameter Name="JPR2Date2" Type="DateTime" />
                    <asp:Parameter Name="JPR2Activity2" Type="String" />
                    <asp:Parameter Name="JPR2Hours2" Type="String" />
                    <asp:Parameter Name="JPRHoursDoc2" Type="String" />
                    <asp:Parameter Name="JPR3Date" Type="DateTime" />
                    <asp:Parameter Name="JPR3Activity" Type="String" />
                    <asp:Parameter Name="JPR3Hours" Type="String" />
                    <asp:Parameter Name="JPR3Date2" Type="DateTime" />
                    <asp:Parameter Name="JPR3Activity2" Type="String" />
                    <asp:Parameter Name="JPR3Hours2" Type="String" />
                    <asp:Parameter Name="JPRHoursDoc3" Type="String" />
                    <asp:Parameter Name="JPR4Date" Type="DateTime" />
                    <asp:Parameter Name="JPR4Activity" Type="String" />
                    <asp:Parameter Name="JPR4Hours" Type="String" />
                    <asp:Parameter Name="JPR4Date2" Type="DateTime" />
                    <asp:Parameter Name="JPR4Activity2" Type="String" />
                    <asp:Parameter Name="JPR4Hours2" Type="String" />
                    <asp:Parameter Name="JPRHoursDoc4" Type="String" />
                    <asp:Parameter Name="JPR5Date" Type="DateTime" />
                    <asp:Parameter Name="JPR5Activity" Type="String" />
                    <asp:Parameter Name="JPR5Hours" Type="String" />
                    <asp:Parameter Name="JPR5Date2" Type="DateTime" />
                    <asp:Parameter Name="JPR5Activity2" Type="String" />
                    <asp:Parameter Name="JPR5Hours2" Type="String" />
                    <asp:Parameter Name="JPRHoursDoc5" Type="String" />
                    <asp:Parameter Name="JPRWorkbooks" Type="String" />
                    <asp:Parameter Name="JPRNotes" Type="String" />
                    <asp:Parameter Name="VocationalEd" Type="String" />
                    <asp:Parameter Name="WEP220HoursLess" Type="String" />
                    <asp:Parameter Name="CWEPHoursLess" Type="String" />
                    <asp:Parameter Name="ParticipateOver4Weeks" Type="String" />
                    <asp:Parameter Name="DaysBetweenStartAndReferral" Type="String" />
                    <asp:Parameter Name="MedicalNoteSigned" Type="String" />
                    <asp:Parameter Name="EvidenceOfJobContacts" Type="String" />
                    <asp:Parameter Name="Form2279Completed" Type="String" />
                    <asp:Parameter Name="FormAWI0002" Type="String" />
                    <asp:Parameter Name="RelocationMonitored" Type="String" />
                    <asp:Parameter Name="EmployedAtCASBApproval" Type="String" />
                    <asp:Parameter Name="Was2290Mailed" Type="String" />
                    <asp:Parameter Name="RWBContact" Type="String" />
                    <asp:Parameter Name="TerminationGoodCause" Type="String" />
                    <asp:Parameter Name="TwoFailures" Type="String" />
                    <asp:Parameter Name="TwoIn30" Type="String" />
                    <asp:Parameter Name="Allowed3Days" Type="String" />
                    <asp:Parameter Name="WTP2292Mailed" Type="String" />
                    <asp:Parameter Name="ActionCaseNotesEntered" Type="String" />
                    <asp:Parameter Name="FinalComments" Type="String" />
                    <asp:Parameter Name="ReviewDateTime" Type="DateTime" />
                    <asp:Parameter Name="ReviewID" Type="Int32" />
                </UpdateParameters>
                <InsertParameters>
                    <asp:Parameter Name="ReviewDateFrom" Type="DateTime" />
                    <asp:Parameter Name="ReviewDateTo" Type="DateTime" />
                    <asp:Parameter Name="LastName" Type="String" />
                    <asp:Parameter Name="FirstName" Type="String" />
                    <asp:Parameter Name="SSN" Type="String" />
                    <asp:Parameter Name="Region" Type="String" />
                    <asp:Parameter Name="County" Type="String" />
                    <asp:Parameter Name="OneStop" Type="String" />
                    <asp:Parameter Name="Unit" Type="String" />
                    <asp:Parameter Name="Notes05" Type="String" />
                    <asp:Parameter Name="CaseManagerLName" Type="String" />
                    <asp:Parameter Name="ReviewerName" Type="String" />
                    <asp:Parameter Name="ReviewType" Type="String" />
                    <asp:Parameter Name="ReviewDate" Type="DateTime" />
                    <asp:Parameter Name="Mandatory" Type="String" />
                    <asp:Parameter Name="DateNewCase" Type="DateTime" />
                    <asp:Parameter Name="OOSigned" Type="String" />
                    <asp:Parameter Name="DateFormSigned" Type="DateTime" />
                    <asp:Parameter Name="AssessmentWithin30" Type="String" />
                    <asp:Parameter Name="IncludeSkills" Type="String" />
                    <asp:Parameter Name="IRPSigned" Type="String" />
                    <asp:Parameter Name="GoalsIdentified" Type="String" />
                    <asp:Parameter Name="ActivitiesIdentified" Type="String" />
                    <asp:Parameter Name="HoursIdentified" Type="String" />
                    <asp:Parameter Name="ActivitiesIncludeAnticipated" Type="String" />
                    <asp:Parameter Name="ServicesPrivided" Type="String" />
                    <asp:Parameter Name="Steps" Type="String" />
                    <asp:Parameter Name="EmploymentVerified" Type="String" />
                    <asp:Parameter Name="OSSTMatch" Type="String" />
                    <asp:Parameter Name="JPR1Date" Type="DateTime" />
                    <asp:Parameter Name="JPR1Activity" Type="String" />
                    <asp:Parameter Name="JPR1Hours" Type="String" />
                    <asp:Parameter Name="JPR1Date2" Type="DateTime" />
                    <asp:Parameter Name="JPR1Activity2" Type="String" />
                    <asp:Parameter Name="JPR1Hours2" Type="String" />
                    <asp:Parameter Name="JPRHoursDoc1" Type="String" />
                    <asp:Parameter Name="JPR2Date" Type="DateTime" />
                    <asp:Parameter Name="JPR2Activity" Type="String" />
                    <asp:Parameter Name="JPR2Hours" Type="String" />
                    <asp:Parameter Name="JPR2Date2" Type="DateTime" />
                    <asp:Parameter Name="JPR2Activity2" Type="String" />
                    <asp:Parameter Name="JPR2Hours2" Type="String" />
                    <asp:Parameter Name="JPRHoursDoc2" Type="String" />
                    <asp:Parameter Name="JPR3Date" Type="DateTime" />
                    <asp:Parameter Name="JPR3Activity" Type="String" />
                    <asp:Parameter Name="JPR3Hours" Type="String" />
                    <asp:Parameter Name="JPR3Date2" Type="DateTime" />
                    <asp:Parameter Name="JPR3Activity2" Type="String" />
                    <asp:Parameter Name="JPR3Hours2" Type="String" />
                    <asp:Parameter Name="JPRHoursDoc3" Type="String" />
                    <asp:Parameter Name="JPR4Date" Type="DateTime" />
                    <asp:Parameter Name="JPR4Activity" Type="String" />
                    <asp:Parameter Name="JPR4Hours" Type="String" />
                    <asp:Parameter Name="JPR4Date2" Type="DateTime" />
                    <asp:Parameter Name="JPR4Activity2" Type="String" />
                    <asp:Parameter Name="JPR4Hours2" Type="String" />
                    <asp:Parameter Name="JPRHoursDoc4" Type="String" />
                    <asp:Parameter Name="JPR5Date" Type="DateTime" />
                    <asp:Parameter Name="JPR5Activity" Type="String" />
                    <asp:Parameter Name="JPR5Hours" Type="String" />
                    <asp:Parameter Name="JPR5Date2" Type="DateTime" />
                    <asp:Parameter Name="JPR5Activity2" Type="String" />
                    <asp:Parameter Name="JPR5Hours2" Type="String" />
                    <asp:Parameter Name="JPRHoursDoc5" Type="String" />
                    <asp:Parameter Name="JPRWorkbooks" Type="String" />
                    <asp:Parameter Name="JPRNotes" Type="String" />
                    <asp:Parameter Name="VocationalEd" Type="String" />
                    <asp:Parameter Name="WEP220HoursLess" Type="String" />
                    <asp:Parameter Name="CWEPHoursLess" Type="String" />
                    <asp:Parameter Name="ParticipateOver4Weeks" Type="String" />
                    <asp:Parameter Name="DaysBetweenStartAndReferral" Type="String" />
                    <asp:Parameter Name="MedicalNoteSigned" Type="String" />
                    <asp:Parameter Name="EvidenceOfJobContacts" Type="String" />
                    <asp:Parameter Name="Form2279Completed" Type="String" />
                    <asp:Parameter Name="FormAWI0002" Type="String" />
                    <asp:Parameter Name="RelocationMonitored" Type="String" />
                    <asp:Parameter Name="EmployedAtCASBApproval" Type="String" />
                    <asp:Parameter Name="Was2290Mailed" Type="String" />
                    <asp:Parameter Name="RWBContact" Type="String" />
                    <asp:Parameter Name="TerminationGoodCause" Type="String" />
                    <asp:Parameter Name="TwoFailures" Type="String" />
                    <asp:Parameter Name="TwoIn30" Type="String" />
                    <asp:Parameter Name="Allowed3Days" Type="String" />
                    <asp:Parameter Name="WTP2292Mailed" Type="String" />
                    <asp:Parameter Name="ActionCaseNotesEntered" Type="String" />
                    <asp:Parameter Name="FinalComments" Type="String" />
                    <asp:Parameter Name="ReviewDateTime" Type="DateTime" />
                </InsertParameters>
            </asp:SqlDataSource>
            <br />
        </div>

           <!-- End of Container -->
    </form>
    <div style="text-align: center">
        Copyright &copy; 2007 WorkForce One</div>
</body>
</html>
0
 
megninAuthor Commented:
Imports System.Data
Imports System.Data.SqlClient
Imports System.Web.UI.WebControls

Partial Class WT_TANF
    Inherits System.Web.UI.Page
    Protected Sub btnNotes05_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnNotes05.Click
        If txtNotes05.Visible = False Then
            txtNotes05.Visible = True
        Else
            txtNotes05.Visible = False
        End If
    End Sub

    Protected Sub btnStepsComment_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnStepsComment.Click
        If txtSteps.Visible = False Then
            txtSteps.Visible = True
        Else
            txtSteps.Visible = False
        End If
    End Sub

    Protected Sub btn1stWeek2ndActivity_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btn1stWeek2ndActivity.Click
        If lblJPR1Date2.Visible = False Then
            lblJPR1Date2.Visible = True
            txtJPR1Date2.Visible = True
            lblJPR1Activity2.Visible = True
            txtJPR1Activity2.Visible = True
            lblJPR1Hours2.Visible = True
            txtJPR1Hours2.Visible = True
        Else
            lblJPR1Date2.Visible = False
            txtJPR1Date2.Visible = False
            lblJPR1Activity2.Visible = False
            txtJPR1Activity2.Visible = False
            lblJPR1Hours2.Visible = False
            txtJPR1Hours2.Visible = False
        End If
    End Sub

    Protected Sub btn2ndWeek2ndActivity_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btn2ndWeek2ndActivity.Click
        If lblJPR2Date2.Visible = False Then
            lblJPR2Date2.Visible = True
            txtJPR2Date2.Visible = True
            lblJPR2Activity2.Visible = True
            txtJPR2Activity2.Visible = True
            lblJPR2Hours2.Visible = True
            txtJPR2Hours2.Visible = True
        Else
            lblJPR2Date2.Visible = False
            txtJPR2Date2.Visible = False
            lblJPR2Activity2.Visible = False
            txtJPR2Activity2.Visible = False
            lblJPR2Hours2.Visible = False
            txtJPR2Hours2.Visible = False
        End If
    End Sub

    Protected Sub btn3rdWeek2ndActivity_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btn3rdWeek2ndActivity.Click
        If lblJPR3Date2.Visible = False Then
            lblJPR3Date2.Visible = True
            txtJPR3Date2.Visible = True
            lblJPR3Activity2.Visible = True
            txtJPR3Activity2.Visible = True
            lblJPR3Hours2.Visible = True
            txtJPR3Hours2.Visible = True
        Else
            lblJPR3Date2.Visible = False
            txtJPR3Date2.Visible = False
            lblJPR3Activity2.Visible = False
            txtJPR3Activity2.Visible = False
            lblJPR3Hours2.Visible = False
            txtJPR3Hours2.Visible = False
        End If
    End Sub

    Protected Sub btn4thWeek2ndActivity_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btn4thWeek2ndActivity.Click
        If lblJPR4Date2.Visible = False Then
            lblJPR4Date2.Visible = True
            txtJPR4Date2.Visible = True
            lblJPR4Activity2.Visible = True
            txtJPR4Activity2.Visible = True
            lblJPR4Hours2.Visible = True
            txtJPR4Hours2.Visible = True
        Else
            lblJPR4Date2.Visible = False
            txtJPR4Date2.Visible = False
            lblJPR4Activity2.Visible = False
            txtJPR4Activity2.Visible = False
            lblJPR4Hours2.Visible = False
            txtJPR4Hours2.Visible = False
        End If
    End Sub

    Protected Sub btn5thWeek2ndActivity_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btn5thWeek2ndActivity.Click
        If lblJPR5Date2.Visible = False Then
            lblJPR5Date2.Visible = True
            txtJPR5Date2.Visible = True
            lblJPR5Activity2.Visible = True
            txtJPR5Activity2.Visible = True
            lblJPR5Hours2.Visible = True
            txtJPR5Hours2.Visible = True
        Else
            lblJPR5Date2.Visible = False
            txtJPR5Date2.Visible = False
            lblJPR5Activity2.Visible = False
            txtJPR5Activity2.Visible = False
            lblJPR5Hours2.Visible = False
            txtJPR5Hours2.Visible = False
        End If
    End Sub

    Protected Sub btnSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.Click

        Dim DBConn As New SqlConnection("UID=lastname;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=SigmaTools;Data Source=SQLServer;Packet Size=4096;")
        Dim DBCmd As New SqlCommand
        Dim DBAdap As New SqlDataAdapter
        Dim DS As New DataSet
        DBConn.Open()
        Try
            'Add Insert Statement


            DBCmd = New SqlCommand("INSERT INTO WTP (ReviewDateFrom,      ReviewDateTo,      LastName,      FirstName,      SSN,      Region,      County,      OneStop,      Unit,      Notes05,      CaseManagerLName,      ReviewerName,      ReviewType,      ReviewDate,      Mandatory,      DateNewCase,      OOSigned,      DateFormSigned,      AssessmentWithin30,      IncludeSkills,   IRPSigned,      GoalsIdentified,      ActivitiesIdentified,      HoursIdentified,      ActivitiesIncludeAnticipated,      ServicesPrivided,      Steps,      EmploymentVerified,      OSSTMatch,      JPR1Date,      JPR1Activity,      JPR1Hours,      JPR1Date2,      JPR1Activity2,      JPR1Hours2,      JPRHoursDoc1,      JPR2Date,      JPR2Activity,      JPR2Hours,      JPR2Date2,      JPR2Activity2,      JPR2Hours2,      JPRHoursDoc2,      JPR3Date,      JPR3Activity,      JPR3Hours,      JPR3Date2,      JPR3Activity2,      JPR3Hours2,      JPRHoursDoc3,      JPR4Date,      JPR4Activity,      JPR4Hours,      JPR4Date2,      JPR4Activity2,      JPR4Hours2,      JPRHoursDoc4,      JPR5Date,      JPR5Activity,      JPR5Hours,      JPR5Date2,      JPR5Activity2,      JPR5Hours2,      JPRHoursDoc5,      JPRWorkbooks, JPRNotes,      VocationalEd,      WEP220HoursLess,      CWEPHoursLess,      ParticipateOver4Weeks,      DaysBetweenStartAndReferral,      MedicalNoteSigned,      EvidenceOfJobContacts,  Forms2073A_2075Completed,      Form2279Completed,      FormAWI0002,      RelocationMonitored,      EmployedAtCASBApproval,      Was2290Mailed,      RWBContact,      TerminationGoodCause,      TwoFailures,      TwoIn30,      Allowed3Days,      WTP2292Mailed,      ActionCaseNotesEntered,      FinalComments,      ReviewDateTime)VALUES(@txtReviewDateFrom,      @txtReviewDateTo,      @txtLastName,      @txtFirstName,      @txtSSN,      @ddlRegion,      @ddlCounty,      @ddlOneStop,      @ddlUnit,      @txtNotes05,      @ddlCasemanagerLName,      @txtReviewerName,      @ddlReviewType,      @txtReviewDate,      @radMandatory,      @txtDateNewCase,      @radOOSigned,      @txtDateFormSigned,      @radAssessmentWithin30,      @radIncludeSkills,   @radIRPSigned,      @radGoalsIdentified,      @radActivitiesIdentified,      @radHoursIdentified,      @radActivitiesIncludeAnticipated,      @radServicesPrivided,      @txtSteps,      @radEmploymentVerified,      @radOSSTMatch,      @txtJPR1Date,      @txtJPR1Activity,      @txtJPR1Hours,      @txtJPR1Date2,      @txtJPR1Activity2,      @txtJPR1Hours2,      @radJPRHoursDoc1,      @txtJPR2Date,      @txtJPR2Activity,      @txtJPR2Hours,      @txtJPR2Date2,      @txtJPR2Activity2,      @txtJPR2Hours2,      @radJPRHoursDoc2,      @txtJPR3Date,      @txtJPR3Activity,      @txtJPR3Hours,      @txtJPR3Date2,      @txtJPR3Activity2,      @txtJPR3Hours2,      @radJPRHoursDoc3,      @txtJPR4Date,      @txtJPR4Activity,      @txtJPR4Hours,      @txtJPR4Date2,      @txtJPR4Activity2,      @txtJPR4Hours2,      @radJPRHoursDoc4,      @txtJPR5Date,      @txtJPR5Activity,      @txtJPR5Hours,      @txtJPR5Date2,      @txtJPR5Activity2,      @txtJPR5Hours2,      @radJPRHoursDoc5,      @radJPRWorkbooks, @txtJPRNotes,      @radVocationalEd,      @radWEP220HoursLess,      @radCWEPHoursLess,      @radParticipateOver4Weeks,      @txtDaysBetweenStartAndReferral,      @radMedicalNoteSigned,      @radEvidenceOfJobContacts,  @radForms2073A_2075Completed,      @radForm2279Completed,      @radFormAWI0002,      @radRelocationMonitored,      @radEmployedAtCASBApproval,      @radWas2290Mailed,      @radRWBContact,      @radTerminationGoodCause,      @radTwoFailures,      @radTwoIn30,      @radAllowed3Days,      @radWTP2292Mailed,      @radActionCaseNotesEntered,      @txtFinalComments,      GetDate())", DBConn)

            'DBCmd = New SqlCommand("INSERT INTO WTP (ReviewDateFrom,      ReviewDateTo,      LastName, FirstName, SSN, Region, County, OneStop, Unit, Notes05, CaseManagerLName, ReviewerName, ReviewType,      ReviewDate) VALUES(@txtReviewDateFrom,      @txtReviewDateTo,      @txtLastName, @txtFirstName, @txtSSN, @ddlRegion, @ddlCounty, @ddlOneStop, @ddlUnit, @txtNotes05, @txtCaseManagerLName, @txtReviewerName, @ddlReviewType,      @txtReviewDate)", DBConn)


            If txtReviewDateFrom.Text.Length <> 0 Then
                DBCmd.Parameters.Add("@txtReviewDateFrom", SqlDbType.VarChar).Value = DateTime.Parse(txtReviewDateFrom.Text)
                'DBCmd.Parameters.Add("@txtReviewDateFrom", SqlDbType.VarChar).Value = DateTime.Parse(txtReviewDateFrom.Text)
            Else
                DBCmd.Parameters.Add("@txtReviewDateFrom", SqlDbType.VarChar).Value = DBNull.Value
            End If
            If txtReviewDateTo.Text.Length <> 0 Then
                DBCmd.Parameters.Add("@txtReviewDateTo", SqlDbType.VarChar).Value = DateTime.Parse(txtReviewDateTo.Text)
                'DBCmd.Parameters.Add("@txtReviewDateTo", SqlDbType.VarChar).Value = DateTime.Parse(txtReviewDateTo.Text)
            Else
                DBCmd.Parameters.Add("@txtReviewDateTo", SqlDbType.VarChar).Value = DBNull.Value
            End If
            DBCmd.Parameters.Add("@txtLastName", SqlDbType.VarChar).Value = txtLastName.Text
            DBCmd.Parameters.Add("@txtFirstName", SqlDbType.VarChar).Value = txtFirstName.Text
            DBCmd.Parameters.Add("@txtSSN", SqlDbType.VarChar).Value = txtSSN.Text
            DBCmd.Parameters.Add("@ddlRegion", SqlDbType.VarChar).Value = ddlRegion.Text
            DBCmd.Parameters.Add("@ddlCounty", SqlDbType.VarChar).Value = ddlCounty.Text
            DBCmd.Parameters.Add("@ddlOneStop", SqlDbType.VarChar).Value = ddlOneStop.Text
            DBCmd.Parameters.Add("@ddlUnit", SqlDbType.VarChar).Value = ddlUnit.Text
            DBCmd.Parameters.Add("@txtNotes05", SqlDbType.VarChar).Value = txtNotes05.Text
            DBCmd.Parameters.Add("@ddlCaseManagerLName", SqlDbType.VarChar).Value = ddlCaseManagerLName.Text
            DBCmd.Parameters.Add("@txtReviewerName", SqlDbType.VarChar).Value = txtReviewerName.Text
            DBCmd.Parameters.Add("@ddlReviewType", SqlDbType.VarChar).Value = ddlReviewType.Text
            If txtReviewDate.Text.Length <> 0 Then
                DBCmd.Parameters.Add("@txtReviewDate", SqlDbType.VarChar).Value = DateTime.Parse(txtReviewDate.Text)
            Else
                DBCmd.Parameters.Add("@txtReviewDate", SqlDbType.VarChar).Value = DBNull.Value
            End If
            DBCmd.Parameters.Add("@radMandatory", SqlDbType.VarChar).Value = radMandatory.SelectedValue
            If txtDateNewCase.Text.Length <> 0 Then
                DBCmd.Parameters.Add("@txtDateNewCase", SqlDbType.VarChar).Value = DateTime.Parse(txtDateNewCase.Text)
            Else
                DBCmd.Parameters.Add("@txtDateNewCase", SqlDbType.VarChar).Value = DBNull.Value
            End If
            DBCmd.Parameters.Add("@radOOSigned", SqlDbType.VarChar).Value = radOOSigned.SelectedValue
            If txtDateFormSigned.Text.Length <> 0 Then
                DBCmd.Parameters.Add("@txtDateFormSigned", SqlDbType.VarChar).Value = DateTime.Parse(txtDateFormSigned.Text)
            Else
                DBCmd.Parameters.Add("@txtDateFormSigned", SqlDbType.VarChar).Value = DBNull.Value
            End If
            DBCmd.Parameters.Add("@radAssessmentWithin30", SqlDbType.VarChar).Value = radAssessmentWithin30.SelectedValue
            DBCmd.Parameters.Add("@radIncludeSkills", SqlDbType.VarChar).Value = radIncludeSkills.SelectedValue
            DBCmd.Parameters.Add("@radIRPSigned", SqlDbType.VarChar).Value = radIRPSigned.SelectedValue
            DBCmd.Parameters.Add("@radGoalsIdentified", SqlDbType.VarChar).Value = radGoalsIdentified.SelectedValue
            DBCmd.Parameters.Add("@radActivitiesIdentified", SqlDbType.VarChar).Value = radActivitiesIdentified.SelectedValue
            DBCmd.Parameters.Add("@radHoursIdentified", SqlDbType.VarChar).Value = radHoursIdentified.SelectedValue
            DBCmd.Parameters.Add("@radActivitiesIncludeAnticipated", SqlDbType.VarChar).Value = radActivitiesIncludeAnticipated.SelectedValue
            DBCmd.Parameters.Add("@radServicesPrivided", SqlDbType.VarChar).Value = radServicesPrivided.SelectedValue
            DBCmd.Parameters.Add("@txtSteps", SqlDbType.VarChar).Value = txtSteps.Text
            DBCmd.Parameters.Add("@radEmploymentVerified", SqlDbType.VarChar).Value = radEmploymentVerified.SelectedValue
            DBCmd.Parameters.Add("@radOSSTMatch", SqlDbType.VarChar).Value = radOSSTMatch.SelectedValue
            If txtJPR1Date.Text.Length <> 0 Then
                DBCmd.Parameters.Add("@txtJPR1Date", SqlDbType.VarChar).Value = DateTime.Parse(txtJPR1Date.Text)
            Else
                DBCmd.Parameters.Add("@txtJPR1Date", SqlDbType.VarChar).Value = DBNull.Value
            End If
            DBCmd.Parameters.Add("@txtJPR1Activity", SqlDbType.VarChar).Value = txtJPR1Activity.Text
            DBCmd.Parameters.Add("@txtJPR1Hours", SqlDbType.VarChar).Value = txtJPR1Hours.Text
            If txtJPR1Date2.Text.Length <> 0 Then
                DBCmd.Parameters.Add("@txtJPR1Date2", SqlDbType.VarChar).Value = DateTime.Parse(txtJPR1Date2.Text)
            Else
                DBCmd.Parameters.Add("@txtJPR1Date2", SqlDbType.VarChar).Value = DBNull.Value
            End If
            DBCmd.Parameters.Add("@txtJPR1Activity2", SqlDbType.VarChar).Value = txtJPR1Activity2.Text
            DBCmd.Parameters.Add("@txtJPR1Hours2", SqlDbType.VarChar).Value = txtJPR1Hours2.Text
            DBCmd.Parameters.Add("@radJPRHoursDoc1", SqlDbType.VarChar).Value = radJPRHoursDoc1.SelectedValue
            If txtJPR2Date.Text.Length <> 0 Then
                DBCmd.Parameters.Add("@txtJPR2Date", SqlDbType.VarChar).Value = DateTime.Parse(txtJPR2Date.Text)
            Else
                DBCmd.Parameters.Add("@txtJPR2Date", SqlDbType.VarChar).Value = DBNull.Value
            End If
            DBCmd.Parameters.Add("@txtJPR2Activity", SqlDbType.VarChar).Value = txtJPR2Activity.Text
            DBCmd.Parameters.Add("@txtJPR2Hours", SqlDbType.VarChar).Value = txtJPR2Hours.Text
            If txtJPR2Date2.Text.Length <> 0 Then
                DBCmd.Parameters.Add("@txtJPR2Date2", SqlDbType.VarChar).Value = DateTime.Parse(txtJPR2Date2.Text)
            Else
                DBCmd.Parameters.Add("@txtJPR2Date2", SqlDbType.VarChar).Value = DBNull.Value
            End If
            DBCmd.Parameters.Add("@txtJPR2Activity2", SqlDbType.VarChar).Value = txtJPR2Activity2.Text
            DBCmd.Parameters.Add("@txtJPR2Hours2", SqlDbType.VarChar).Value = txtJPR2Hours2.Text
            DBCmd.Parameters.Add("@radJPRHoursDoc2", SqlDbType.VarChar).Value = radJPRHoursDoc2.SelectedValue
            If txtJPR3Date.Text.Length <> 0 Then
                DBCmd.Parameters.Add("@txtJPR3Date", SqlDbType.VarChar).Value = DateTime.Parse(txtJPR3Date.Text)
            Else
                DBCmd.Parameters.Add("@txtJPR3Date", SqlDbType.VarChar).Value = DBNull.Value
            End If
            DBCmd.Parameters.Add("@txtJPR3Activity", SqlDbType.VarChar).Value = txtJPR3Activity.Text
            DBCmd.Parameters.Add("@txtJPR3Hours", SqlDbType.VarChar).Value = txtJPR3Hours.Text
            If txtJPR3Date2.Text.Length <> 0 Then
                DBCmd.Parameters.Add("@txtJPR3Date2", SqlDbType.VarChar).Value = DateTime.Parse(txtJPR3Date2.Text)
            Else
                DBCmd.Parameters.Add("@txtJPR3Date2", SqlDbType.VarChar).Value = DBNull.Value
            End If
            DBCmd.Parameters.Add("@txtJPR3Activity2", SqlDbType.VarChar).Value = txtJPR3Activity2.Text
            DBCmd.Parameters.Add("@txtJPR3Hours2", SqlDbType.VarChar).Value = txtJPR3Hours2.Text
            DBCmd.Parameters.Add("@radJPRHoursDoc3", SqlDbType.VarChar).Value = radJPRHoursDoc3.SelectedValue
            If txtJPR4Date.Text.Length <> 0 Then
                DBCmd.Parameters.Add("@txtJPR4Date", SqlDbType.VarChar).Value = DateTime.Parse(txtJPR4Date.Text)
            Else
                DBCmd.Parameters.Add("@txtJPR4Date", SqlDbType.VarChar).Value = DBNull.Value
            End If
            DBCmd.Parameters.Add("@txtJPR4Activity", SqlDbType.VarChar).Value = txtJPR4Activity.Text
            DBCmd.Parameters.Add("@txtJPR4Hours", SqlDbType.VarChar).Value = txtJPR4Hours.Text
            If txtJPR4Date2.Text.Length <> 0 Then
                DBCmd.Parameters.Add("@txtJPR4Date2", SqlDbType.VarChar).Value = DateTime.Parse(txtJPR4Date2.Text)
            Else
                DBCmd.Parameters.Add("@txtJPR4Date2", SqlDbType.VarChar).Value = DBNull.Value
            End If
            DBCmd.Parameters.Add("@txtJPR4Activity2", SqlDbType.VarChar).Value = txtJPR4Activity2.Text
            DBCmd.Parameters.Add("@txtJPR4Hours2", SqlDbType.VarChar).Value = txtJPR4Hours2.Text
            DBCmd.Parameters.Add("@radJPRHoursDoc4", SqlDbType.VarChar).Value = radJPRHoursDoc4.SelectedValue
            If txtJPR5Date.Text.Length <> 0 Then
                DBCmd.Parameters.Add("@txtJPR5Date", SqlDbType.VarChar).Value = DateTime.Parse(txtJPR5Date.Text)
            Else
                DBCmd.Parameters.Add("@txtJPR5Date", SqlDbType.VarChar).Value = DBNull.Value
            End If
            DBCmd.Parameters.Add("@txtJPR5Activity", SqlDbType.VarChar).Value = txtJPR5Activity.Text
            DBCmd.Parameters.Add("@txtJPR5Hours", SqlDbType.VarChar).Value = txtJPR5Hours.Text
            If txtJPR5Date2.Text.Length <> 0 Then
                DBCmd.Parameters.Add("@txtJPR5Date2", SqlDbType.VarChar).Value = DateTime.Parse(txtJPR5Date2.Text)
            Else
                DBCmd.Parameters.Add("@txtJPR5Date2", SqlDbType.VarChar).Value = DBNull.Value
            End If
            DBCmd.Parameters.Add("@txtJPR5Activity2", SqlDbType.VarChar).Value = txtJPR5Activity2.Text
            DBCmd.Parameters.Add("@txtJPR5Hours2", SqlDbType.VarChar).Value = txtJPR5Hours2.Text
            DBCmd.Parameters.Add("@radJPRHoursDoc5", SqlDbType.VarChar).Value = radJPRHoursDoc5.SelectedValue
            DBCmd.Parameters.Add("@radJPRWorkbooks", SqlDbType.VarChar).Value = radJPRWorkbooks.SelectedValue
            DBCmd.Parameters.Add("@txtJPRNotes", SqlDbType.VarChar).Value = txtJPRNotes.Text
            DBCmd.Parameters.Add("@radVocationalEd", SqlDbType.VarChar).Value = radVocationalEd.SelectedValue
            DBCmd.Parameters.Add("@radWEP220HoursLess", SqlDbType.VarChar).Value = radWEP220HoursLess.SelectedValue
            DBCmd.Parameters.Add("@radCWEPHoursLess", SqlDbType.VarChar).Value = radCWEPHoursLess.SelectedValue
            DBCmd.Parameters.Add("@radParticipateOver4Weeks", SqlDbType.VarChar).Value = radParticipateOver4Weeks.SelectedValue
            DBCmd.Parameters.Add("@txtDaysBetweenStartAndReferral", SqlDbType.VarChar).Value = txtDaysBetweenStartAndReferral.Text
            DBCmd.Parameters.Add("@radMedicalNoteSigned", SqlDbType.VarChar).Value = radMedicalNoteSigned.SelectedValue
            DBCmd.Parameters.Add("@radEvidenceOfJobContacts", SqlDbType.VarChar).Value = radEvidenceOfJobContacts.SelectedValue
            DBCmd.Parameters.Add("@radForms2073A_2075Completed", SqlDbType.VarChar).Value = radForms2073A_2075Completed.SelectedValue
            DBCmd.Parameters.Add("@radForm2279Completed", SqlDbType.VarChar).Value = radForm2279Completed.SelectedValue
            DBCmd.Parameters.Add("@radFormAWI0002", SqlDbType.VarChar).Value = radFormAWI0002.SelectedValue
            DBCmd.Parameters.Add("@radRelocationMonitored", SqlDbType.VarChar).Value = radRelocationMonitored.SelectedValue
            DBCmd.Parameters.Add("@radEmployedAtCASBApproval", SqlDbType.VarChar).Value = radEmployedAtCASBApproval.SelectedValue
            DBCmd.Parameters.Add("@radWas2290Mailed", SqlDbType.VarChar).Value = radWas2290Mailed.SelectedValue
            DBCmd.Parameters.Add("@radRWBContact", SqlDbType.VarChar).Value = radRWBContact.SelectedValue
            DBCmd.Parameters.Add("@radTerminationGoodCause", SqlDbType.VarChar).Value = radTerminationGoodCause.SelectedValue
            DBCmd.Parameters.Add("@radTwoFailures", SqlDbType.VarChar).Value = radTwoFailures.SelectedValue
            DBCmd.Parameters.Add("@radTwoIn30", SqlDbType.VarChar).Value = radTwoIn30.SelectedValue
            DBCmd.Parameters.Add("@radAllowed3Days", SqlDbType.VarChar).Value = radAllowed3Days.SelectedValue
            DBCmd.Parameters.Add("@radWTP2292Mailed", SqlDbType.VarChar).Value = radWTP2292Mailed.SelectedValue
            DBCmd.Parameters.Add("@radActionCaseNotesEntered", SqlDbType.VarChar).Value = radActionCaseNotesEntered.SelectedValue
            'DBCmd.Parameters.Add("@txtFinalComments", SqlDbType.VarChar).Value = txtFinalComments.Text
            DBCmd.Parameters.Add("@txtFinalComments", SqlDbType.VarChar).Value = txtFinalComments.Text.Trim



            DBCmd.ExecuteNonQuery()

        Catch exp As Exception
            Response.Write(exp)
        End Try
        'Close Database connection
        'and Dispose Database objects
        DBCmd.Dispose()
        DBAdap.Dispose()
        DBConn.Close()
        DBConn = Nothing

        Server.Transfer("Confirmation.aspx")

    End Sub

    Protected Sub btnFetchRecord_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnFetchRecord.Click
        'Response.Redirect(Request.Url.ToString())
        'Response.Redirect(Request.RawUrl)
        lblError1.Text = ""


        Dim DBConn As New SqlConnection("UID=lastname;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=SigmaTools;Data Source=SQLServer;Packet Size=4096;")
        Dim DBCmd As New SqlCommand
        'Dim DBAdap As New SqlDataAdapter
        Dim DS As New DataSet    'This is not used anywere.  ???

        'Test for the existance of SSN -------------------------------------------------------------------------------------------------------
        '("SELECT 1 FROM WTP WHERE SSN='" & Trim(sender.text) & "'")
        '-------------------------------------------------------------------------------------------------------------------------------------

        Try
            DBConn.Open()
            DBCmd = New SqlCommand("select ReviewDateFrom,ReviewDateTo,LastName,FirstName,SSN,Region,County,OneStop,Unit,Notes05,CaseManagerLName,ReviewerName,ReviewType,ReviewDate,Mandatory,DateNewCase,OOSigned,DateFormSigned,AssessmentWithin30,IncludeSkills,IRPSigned,GoalsIdentified,ActivitiesIdentified,HoursIdentified,ActivitiesIncludeAnticipated,ServicesPrivided,Steps,EmploymentVerified,OSSTMatch,JPR1Date,JPR1Activity,JPR1Hours,JPR1Date2,JPR1Activity2,JPR1Hours2,JPRHoursDoc1,JPR2Date,JPR2Activity,JPR2Hours,JPR2Date2,JPR2Activity2,JPR2Hours2,JPRHoursDoc2,JPR3Date,JPR3Activity,JPR3Hours,JPR3Date2,JPR3Activity2,JPR3Hours2,JPRHoursDoc3,JPR4Date,JPR4Activity,JPR4Hours,JPR4Date2,JPR4Activity2,JPR4Hours2,JPRHoursDoc4,JPR5Date,JPR5Activity,JPR5Hours,JPR5Date2,JPR5Activity2,JPR5Hours2,JPRHoursDoc5,JPRWorkbooks,JPRNotes,VocationalEd,WEP220HoursLess,CWEPHoursLess,ParticipateOver4Weeks,DaysBetweenStartAndReferral,MedicalNoteSigned,EvidenceOfJobContacts,Forms2073A_2075Completed,Form2279Completed,FormAWI0002,RelocationMonitored,EmployedAtCASBApproval,Was2290Mailed,RWBContact,TerminationGoodCause,TwoFailures,TwoIn30,Allowed3Days,WTP2292Mailed,ActionCaseNotesEntered,FinalComments, ReviewDateTime, ReviewID from WTP where SSN='" & txtSSN.Text & "'", DBConn)

            Dim dr As SqlDataReader = DBCmd.ExecuteReader

            If Not dr.HasRows Then
                btnUpdate.Visible = False
                Throw New Exception("That SSN Was Not Found")
            Else
                btnUpdate.Visible = True
            End If

            dr.Read()
            'txtLastName.Text = dr("LastName").ToString    ' and then fill all others fields you need
            'txtFirstName.Text = dr("FirstName").ToString    ' and then fill all others fields you need
            txtReviewDateFrom.Text = Date.Parse(dr("ReviewDateFrom").ToString)
            txtReviewDateTo.Text = Date.Parse(dr("ReviewDateTo").ToString)
            txtLastName.Text = dr("LastName").ToString
            txtFirstName.Text = dr("FirstName").ToString
            txtSSN.Text = dr("SSN").ToString
            ddlRegion.Text = dr("Region").ToString
            ddlCounty.Text = dr("County").ToString
            ddlOneStop.Text = dr("OneStop").ToString
            ddlUnit.Text = dr("Unit").ToString
            txtNotes05.Text = dr("Notes05").ToString
            ddlCaseManagerLName.SelectedValue = dr("CaseManagerLName")
            txtReviewerName.Text = dr("ReviewerName").ToString
            ddlReviewType.Text = dr("ReviewType").ToString
            txtReviewDate.Text = Date.Parse(dr("ReviewDate").ToString)
            If Not dr("Mandatory") = String.Empty Then
                radMandatory.SelectedValue = dr("Mandatory")
            Else
                radMandatory.SelectedIndex = -1
            End If
            'txtDateNewCase.Text = Date.Parse(dr("DateNewCase").ToString)
            If Not ((dr("DateNewCase")) Is DBNull.Value) Then
                txtJPR1Date.Text = Date.Parse(dr("DateNewCase"))
            Else
                txtDateNewCase.Text = String.Empty
            End If
            radOOSigned.SelectedValue = dr("OOSigned")
            'txtDateFormSigned.Text = Date.Parse(dr("DateFormSigned").ToString)
            If Not ((dr("DateFormSigned")) Is DBNull.Value) Then
                txtJPR1Date.Text = Date.Parse(dr("DateFormSigned"))
            Else
                txtDateFormSigned.Text = String.Empty
            End If
            radAssessmentWithin30.SelectedValue = dr("AssessmentWithin30")
            radIncludeSkills.SelectedValue = dr("IncludeSkills")
            radIRPSigned.SelectedValue = dr("IRPSigned")
            radGoalsIdentified.SelectedValue = dr("GoalsIdentified")
            radActivitiesIdentified.SelectedValue = dr("ActivitiesIdentified")
            radHoursIdentified.SelectedValue = dr("HoursIdentified")
            radActivitiesIncludeAnticipated.SelectedValue = dr("ActivitiesIncludeAnticipated")
            radServicesPrivided.SelectedValue = dr("ServicesPrivided")
            txtSteps.Text = dr("Steps").ToString
            radEmploymentVerified.SelectedValue = dr("EmploymentVerified")
            radOSSTMatch.SelectedValue = dr("OSSTMatch")
            'txtJPR1Date.Text = Date.Parse(dr("JPR1Date"))
            If Not ((dr("JPR1Date")) Is DBNull.Value) Then
                txtJPR1Date.Text = Date.Parse(dr("JPR1Date"))
            Else
                txtJPR1Date.Text = String.Empty
            End If
            txtJPR1Activity.Text = dr("JPR1Activity").ToString
            txtJPR1Hours.Text = dr("JPR1Hours").ToString
            'txtJPR1Date2.Text = Date.Parse(dr("JPR1Date2"))
            If Not ((dr("JPR1Date2")) Is DBNull.Value) Then
                txtJPR1Date2.Text = Date.Parse(dr("JPR1Date2"))
            Else
                txtJPR1Date2.Text = String.Empty
            End If

            txtJPR1Activity2.Text = dr("JPR1Activity2").ToString
            txtJPR1Hours2.Text = dr("JPR1Hours2").ToString
            radJPRHoursDoc1.SelectedValue = dr("JPRHoursDoc1")
            'txtJPR2Date.Text = Date.Parse(dr("JPR2Date"))
            If Not ((dr("JPR2Date")) Is DBNull.Value) Then
                txtJPR2Date.Text = Date.Parse(dr("JPR2Date"))
            Else
                txtJPR2Date.Text = String.Empty
            End If

            txtJPR2Activity.Text = dr("JPR2Activity").ToString
            txtJPR2Hours.Text = dr("JPR2Hours").ToString
            'txtJPR2Date2.Text = Date.Parse(dr("JPR2Date2"))
            If Not ((dr("JPR2Date2")) Is DBNull.Value) Then
                txtJPR2Date2.Text = Date.Parse(dr("JPR2Date2"))
            Else
                txtJPR2Date2.Text = String.Empty
            End If

            txtJPR2Activity2.Text = dr("JPR2Activity2").ToString
            txtJPR2Hours2.Text = dr("JPR2Hours2").ToString
            radJPRHoursDoc2.SelectedValue = dr("JPRHoursDoc2")
            'txtJPR3Date.Text = Date.Parse(dr("JPR3Date"))
            If Not ((dr("JPR3Date")) Is DBNull.Value) Then
                txtJPR3Date.Text = Date.Parse(dr("JPR3Date"))
            Else
                txtJPR3Date.Text = String.Empty
            End If

            txtJPR3Activity.Text = dr("JPR3Activity").ToString
            txtJPR3Hours.Text = dr("JPR3Hours").ToString
            'txtJPR3Date2.Text = Date.Parse(dr("JPR3Date2"))
            If Not ((dr("JPR3Date2")) Is DBNull.Value) Then
                txtJPR3Date2.Text = Date.Parse(dr("JPR3Date2"))
            Else
                txtJPR3Date2.Text = String.Empty
            End If

            txtJPR3Activity2.Text = dr("JPR3Activity2").ToString
            txtJPR3Hours2.Text = dr("JPR3Hours2").ToString
            radJPRHoursDoc3.SelectedValue = dr("JPRHoursDoc3")
            'txtJPR4Date.Text = Date.Parse(dr("JPR4Date"))
            If Not ((dr("JPR4Date")) Is DBNull.Value) Then
                txtJPR4Date.Text = Date.Parse(dr("JPR4Date"))
            Else
                txtJPR4Date.Text = String.Empty
            End If

            txtJPR4Activity.Text = dr("JPR4Activity").ToString
            txtJPR4Hours.Text = dr("JPR4Hours").ToString
            'txtJPR4Date2.Text = Date.Parse(dr("JPR4Date2"))
            If Not ((dr("JPR4Date2")) Is DBNull.Value) Then
                txtJPR4Date2.Text = Date.Parse(dr("JPR4Date2"))
            Else
                txtJPR4Date2.Text = String.Empty
            End If

            txtJPR4Activity2.Text = dr("JPR4Activity2").ToString
            txtJPR4Hours2.Text = dr("JPR4Hours2").ToString
            radJPRHoursDoc4.SelectedValue = dr("JPRHoursDoc4")
            'txtJPR5Date.Text = Date.Parse(dr("JPR5Date"))
            If Not ((dr("JPR5Date")) Is DBNull.Value) Then
                txtJPR5Date.Text = Date.Parse(dr("JPR5Date"))
            Else
                txtJPR5Date.Text = String.Empty
            End If

            txtJPR5Activity.Text = dr("JPR5Activity").ToString
            txtJPR5Hours.Text = dr("JPR5Hours").ToString
            'txtJPR5Date2.Text = Date.Parse(dr("JPR5Date2"))
            If Not ((dr("JPR5Date2")) Is DBNull.Value) Then
                txtJPR5Date2.Text = Date.Parse(dr("JPR5Date2"))
            Else
                txtJPR5Date2.Text = String.Empty
            End If

            txtJPR5Activity2.Text = dr("JPR5Activity2").ToString
            txtJPR5Hours2.Text = dr("JPR5Hours2").ToString
            radJPRHoursDoc5.SelectedValue = dr("JPRHoursDoc5")
            radJPRWorkbooks.SelectedValue = dr("JPRWorkbooks")
            txtJPRNotes.Text = dr("JPRNotes").ToString
            radVocationalEd.SelectedValue = dr("VocationalEd")
            radWEP220HoursLess.SelectedValue = dr("WEP220HoursLess")
            radCWEPHoursLess.SelectedValue = dr("CWEPHoursLess")
            radParticipateOver4Weeks.SelectedValue = dr("ParticipateOver4Weeks")
            txtDaysBetweenStartAndReferral.Text = dr("DaysBetweenStartAndReferral").ToString
            radMedicalNoteSigned.SelectedValue = dr("MedicalNoteSigned")
            radEvidenceOfJobContacts.SelectedValue = dr("EvidenceOfJobContacts")
            radForms2073A_2075Completed.SelectedValue = dr("Forms2073A_2075Completed")
            radForm2279Completed.SelectedValue = dr("Form2279Completed")
            radFormAWI0002.SelectedValue = dr("FormAWI0002")
            radRelocationMonitored.SelectedValue = dr("RelocationMonitored")
            radEmployedAtCASBApproval.SelectedValue = dr("EmployedAtCASBApproval")
            radWas2290Mailed.SelectedValue = dr("Was2290Mailed")
            radRWBContact.SelectedValue = dr("RWBContact")
            radTerminationGoodCause.SelectedValue = dr("TerminationGoodCause")
            radTwoFailures.SelectedValue = dr("TwoFailures")
            radTwoIn30.SelectedValue = dr("TwoIn30")
            radAllowed3Days.SelectedValue = dr("Allowed3Days")
            radWTP2292Mailed.SelectedValue = dr("WTP2292Mailed")
            radActionCaseNotesEntered.SelectedValue = dr("ActionCaseNotesEntered")
            txtFinalComments.Text = dr("FinalComments").ToString
            lblReviewDateTime.Text = "Data Entry Date: " & Format(Date.Parse(dr("ReviewDateTime").ToString), "MM/dd/yyy")
            lblReviewID.Text = "Review ID: " & dr("ReviewID")

        Catch ex As Exception
            lblError1.Text = ex.Message
        End Try
        'Close Database connection
        'and Dispose Database objects
        DBCmd.Dispose()
        'DBAdap.Dispose()
        DBConn.Close()
        DBConn = Nothing

    End Sub

    Protected Sub radMandatory_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles radMandatory.SelectedIndexChanged
        'On #10, if "Y" then a date in #11 is Required, enable the ValidationControl.
        If radMandatory.SelectedValue = "Y" Then
            valDateNewCase.Enabled = True
        Else
            valDateNewCase.Enabled = False
        End If
    End Sub

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        lblError1.Text = ""
        lblError2.Text = ""

    End Sub

    Protected Sub btnUpdate_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnUpdate.Click

        'Add UPDATE Statements here

        lblError2.Text = "Record Updated (simulated)"

    End Sub
End Class
0
Technology Partners: We Want Your Opinion!

We value your feedback.

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

 
megninAuthor Commented:
Cr@p, I'm sorry, the previous two posts are for the same table and attempt to make a page update the table, but a different web form.  In the above I have the form which Inserts new records and I've added some code to retrieve or "Fetch" an existing record and try to make changes and update that record with the changes.  I'm still working on the Update part of that, but that one is not related to my GridView question.  I appoligize for the mistake.  The code below contains the non-working GridView and working FormView in question...
0
 
megninAuthor Commented:
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="WT_Review.aspx.vb" Inherits="WT_Review" %>

<!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>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        &nbsp;<br />
        <br />
        <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
            AutoGenerateColumns="False" CellPadding="4" DataKeyNames="ReviewID" DataSourceID="SqlDataSource2"
            ForeColor="#333333" GridLines="None" DataMember="DefaultView">
            <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <Columns>
                <asp:CommandField ShowEditButton="True" ShowSelectButton="True" />
                <asp:BoundField DataField="ReviewID" HeaderText="ReviewID" InsertVisible="False"
                    ReadOnly="True" SortExpression="ReviewID" />
                <asp:BoundField DataField="ReviewDateFrom" DataFormatString="{0:d}" HeaderText="ReviewDateFrom"
                    HtmlEncode="False" SortExpression="ReviewDateFrom">
                    <ItemStyle Wrap="False" />
                </asp:BoundField>
                <asp:BoundField DataField="ReviewDateTo" DataFormatString="{0:d}" HeaderText="ReviewDateTo"
                    HtmlEncode="False" SortExpression="ReviewDateTo">
                    <ItemStyle Wrap="False" />
                </asp:BoundField>
                <asp:BoundField DataField="LastName" HeaderText="LastName" SortExpression="LastName">
                    <ItemStyle Wrap="False" />
                </asp:BoundField>
                <asp:BoundField DataField="FirstName" HeaderText="FirstName" SortExpression="FirstName">
                    <ItemStyle Wrap="False" />
                </asp:BoundField>
                <asp:BoundField DataField="SSN" HeaderText="SSN" SortExpression="SSN">
                    <ItemStyle Wrap="False" />
                </asp:BoundField>
                <asp:BoundField DataField="Region" HeaderText="Region" SortExpression="Region">
                    <ItemStyle HorizontalAlign="Center" />
                </asp:BoundField>
                <asp:BoundField DataField="County" HeaderText="County" SortExpression="County">
                    <ItemStyle HorizontalAlign="Center" />
                </asp:BoundField>
                <asp:BoundField DataField="OneStop" HeaderText="OneStop" SortExpression="OneStop" />
                <asp:BoundField DataField="Unit" HeaderText="Unit" SortExpression="Unit" />
                <asp:BoundField DataField="Notes05" HeaderText="Notes05" SortExpression="Notes05">
                    <ItemStyle Wrap="False" />
                </asp:BoundField>
                <asp:BoundField DataField="CaseManagerLName" HeaderText="CaseManagerLName" SortExpression="CaseManagerLName">
                    <ItemStyle Wrap="False" />
                </asp:BoundField>
                <asp:BoundField DataField="ReviewerName" HeaderText="ReviewerName" SortExpression="ReviewerName">
                    <ItemStyle Wrap="False" />
                </asp:BoundField>
                <asp:BoundField DataField="ReviewType" HeaderText="ReviewType" SortExpression="ReviewType">
                    <ItemStyle Wrap="False" />
                </asp:BoundField>
                <asp:BoundField DataField="ReviewDate" DataFormatString="{0:d}" HeaderText="ReviewDate"
                    HtmlEncode="False" SortExpression="ReviewDate">
                    <ItemStyle Wrap="False" />
                </asp:BoundField>
                <asp:BoundField DataField="Mandatory" HeaderText="Mandatory" SortExpression="Mandatory" />
                <asp:BoundField DataField="DateNewCase" DataFormatString="{0:d}" HeaderText="DateNewCase"
                    HtmlEncode="False" SortExpression="DateNewCase">
                    <ItemStyle Wrap="False" />
                </asp:BoundField>
                <asp:BoundField DataField="OOSigned" HeaderText="OOSigned" SortExpression="OOSigned" />
                <asp:BoundField DataField="DateFormSigned" DataFormatString="{0:d}" HeaderText="DateFormSigned"
                    HtmlEncode="False" SortExpression="DateFormSigned">
                    <ItemStyle Wrap="False" />
                </asp:BoundField>
                <asp:BoundField DataField="AssessmentWithin30" HeaderText="AssessmentWithin30" SortExpression="AssessmentWithin30" />
                <asp:BoundField DataField="IncludeSkills" HeaderText="IncludeSkills" SortExpression="IncludeSkills" />
                <asp:BoundField DataField="IRPSigned" HeaderText="IRPSigned" SortExpression="IRPSigned" />
                <asp:BoundField DataField="GoalsIdentified" HeaderText="GoalsIdentified" SortExpression="GoalsIdentified" />
                <asp:BoundField DataField="ActivitiesIdentified" HeaderText="ActivitiesIdentified"
                    SortExpression="ActivitiesIdentified" />
                <asp:BoundField DataField="HoursIdentified" HeaderText="HoursIdentified" SortExpression="HoursIdentified" />
                <asp:BoundField DataField="ActivitiesIncludeAnticipated" HeaderText="ActivitiesIncludeAnticipated"
                    SortExpression="ActivitiesIncludeAnticipated" />
                <asp:BoundField DataField="ServicesPrivided" HeaderText="ServicesPrivided" SortExpression="ServicesPrivided" />
                <asp:BoundField DataField="Steps" HeaderText="Steps" SortExpression="Steps">
                    <ItemStyle Wrap="False" />
                </asp:BoundField>
                <asp:BoundField DataField="EmploymentVerified" HeaderText="EmploymentVerified" SortExpression="EmploymentVerified" />
                <asp:BoundField DataField="OSSTMatch" HeaderText="OSSTMatch" SortExpression="OSSTMatch" />
                <asp:BoundField DataField="JPR1Date" DataFormatString="{0:d}" HeaderText="JPR1Date"
                    HtmlEncode="False" SortExpression="JPR1Date">
                    <ItemStyle Wrap="False" />
                </asp:BoundField>
                <asp:BoundField DataField="JPR1Activity" HeaderText="JPR1Activity" SortExpression="JPR1Activity" />
                <asp:BoundField DataField="JPR1Hours" HeaderText="JPR1Hours" SortExpression="JPR1Hours" />
                <asp:BoundField DataField="JPR1Date2" DataFormatString="{0:d}" HeaderText="JPR1Date2"
                    HtmlEncode="False" SortExpression="JPR1Date2">
                    <ItemStyle Wrap="False" />
                </asp:BoundField>
                <asp:BoundField DataField="JPR1Activity2" HeaderText="JPR1Activity2" SortExpression="JPR1Activity2" />
                <asp:BoundField DataField="JPR1Hours2" HeaderText="JPR1Hours2" SortExpression="JPR1Hours2" />
                <asp:BoundField DataField="JPRHoursDoc1" HeaderText="JPRHoursDoc1" SortExpression="JPRHoursDoc1" />
                <asp:BoundField DataField="JPR2Date" DataFormatString="{0:d}" HeaderText="JPR2Date"
                    HtmlEncode="False" SortExpression="JPR2Date">
                    <ItemStyle Wrap="False" />
                </asp:BoundField>
                <asp:BoundField DataField="JPR2Activity" HeaderText="JPR2Activity" SortExpression="JPR2Activity" />
                <asp:BoundField DataField="JPR2Hours" HeaderText="JPR2Hours" SortExpression="JPR2Hours" />
                <asp:BoundField DataField="JPR2Date2" DataFormatString="{0:d}" HeaderText="JPR2Date2"
                    HtmlEncode="False" SortExpression="JPR2Date2">
                    <ItemStyle Wrap="False" />
                </asp:BoundField>
                <asp:BoundField DataField="JPR2Activity2" HeaderText="JPR2Activity2" SortExpression="JPR2Activity2" />
                <asp:BoundField DataField="JPR2Hours2" HeaderText="JPR2Hours2" SortExpression="JPR2Hours2" />
                <asp:BoundField DataField="JPRHoursDoc2" HeaderText="JPRHoursDoc2" SortExpression="JPRHoursDoc2" />
                <asp:BoundField DataField="JPR3Date" DataFormatString="{0:d}" HeaderText="JPR3Date"
                    HtmlEncode="False" SortExpression="JPR3Date">
                    <ItemStyle Wrap="False" />
                </asp:BoundField>
                <asp:BoundField DataField="JPR3Activity" HeaderText="JPR3Activity" SortExpression="JPR3Activity" />
                <asp:BoundField DataField="JPR3Hours" HeaderText="JPR3Hours" SortExpression="JPR3Hours" />
                <asp:BoundField DataField="JPR3Date2" DataFormatString="{0:d}" HeaderText="JPR3Date2"
                    HtmlEncode="False" SortExpression="JPR3Date2">
                    <ItemStyle Wrap="False" />
                </asp:BoundField>
                <asp:BoundField DataField="JPR3Activity2" HeaderText="JPR3Activity2" SortExpression="JPR3Activity2" />
                <asp:BoundField DataField="JPR3Hours2" HeaderText="JPR3Hours2" SortExpression="JPR3Hours2" />
                <asp:BoundField DataField="JPRHoursDoc3" HeaderText="JPRHoursDoc3" SortExpression="JPRHoursDoc3" />
                <asp:BoundField DataField="JPR4Date" DataFormatString="{0:d}" HeaderText="JPR4Date"
                    HtmlEncode="False" SortExpression="JPR4Date">
                    <ItemStyle Wrap="False" />
                </asp:BoundField>
                <asp:BoundField DataField="JPR4Activity" HeaderText="JPR4Activity" SortExpression="JPR4Activity" />
                <asp:BoundField DataField="JPR4Hours" HeaderText="JPR4Hours" SortExpression="JPR4Hours" />
                <asp:BoundField DataField="JPR4Date2" DataFormatString="{0:d}" HeaderText="JPR4Date2"
                    HtmlEncode="False" SortExpression="JPR4Date2">
                    <ItemStyle Wrap="False" />
                </asp:BoundField>
                <asp:BoundField DataField="JPR4Activity2" HeaderText="JPR4Activity2" SortExpression="JPR4Activity2" />
                <asp:BoundField DataField="JPR4Hours2" HeaderText="JPR4Hours2" SortExpression="JPR4Hours2" />
                <asp:BoundField DataField="JPRHoursDoc4" HeaderText="JPRHoursDoc4" SortExpression="JPRHoursDoc4" />
                <asp:BoundField DataField="JPR5Date" DataFormatString="{0:d}" HeaderText="JPR5Date"
                    HtmlEncode="False" SortExpression="JPR5Date">
                    <ItemStyle Wrap="False" />
                </asp:BoundField>
                <asp:BoundField DataField="JPR5Activity" HeaderText="JPR5Activity" SortExpression="JPR5Activity" />
                <asp:BoundField DataField="JPR5Hours" HeaderText="JPR5Hours" SortExpression="JPR5Hours" />
                <asp:BoundField DataField="JPR5Date2" HeaderText="JPR5Date2" SortExpression="JPR5Date2">
                    <ItemStyle Wrap="False" />
                </asp:BoundField>
                <asp:BoundField DataField="JPR5Activity2" HeaderText="JPR5Activity2" SortExpression="JPR5Activity2" />
                <asp:BoundField DataField="JPR5Hours2" DataFormatString="{0:d}" HeaderText="JPR5Hours2"
                    HtmlEncode="False" SortExpression="JPR5Hours2" />
                <asp:BoundField DataField="JPRHoursDoc5" HeaderText="JPRHoursDoc5" SortExpression="JPRHoursDoc5" />
                <asp:BoundField DataField="JPRWorkbooks" HeaderText="JPRWorkbooks" SortExpression="JPRWorkbooks" />
                <asp:BoundField DataField="JPRNotes" HeaderText="JPRNotes" SortExpression="JPRNotes">
                    <ItemStyle Wrap="False" />
                </asp:BoundField>
                <asp:BoundField DataField="VocationalEd" HeaderText="VocationalEd" SortExpression="VocationalEd" />
                <asp:BoundField DataField="WEP220HoursLess" HeaderText="WEP220HoursLess" SortExpression="WEP220HoursLess" />
                <asp:BoundField DataField="CWEPHoursLess" HeaderText="CWEPHoursLess" SortExpression="CWEPHoursLess" />
                <asp:BoundField DataField="ParticipateOver4Weeks" HeaderText="ParticipateOver4Weeks"
                    SortExpression="ParticipateOver4Weeks" />
                <asp:BoundField DataField="DaysBetweenStartAndReferral" HeaderText="DaysBetweenStartAndReferral"
                    SortExpression="DaysBetweenStartAndReferral" />
                <asp:BoundField DataField="MedicalNoteSigned" HeaderText="MedicalNoteSigned" SortExpression="MedicalNoteSigned" />
                <asp:BoundField DataField="EvidenceOfJobContacts" HeaderText="EvidenceOfJobContacts"
                    SortExpression="EvidenceOfJobContacts" />
                <asp:BoundField DataField="Forms2073A_2075Completed" HeaderText="Forms2073A_2075Completed"
                    SortExpression="Forms2073A_2075Completed" />
                <asp:BoundField DataField="Form2279Completed" HeaderText="Form2279Completed" SortExpression="Form2279Completed" />
                <asp:BoundField DataField="FormAWI0002" HeaderText="FormAWI0002" SortExpression="FormAWI0002" />
                <asp:BoundField DataField="RelocationMonitored" HeaderText="RelocationMonitored"
                    SortExpression="RelocationMonitored" />
                <asp:BoundField DataField="EmployedAtCASBApproval" HeaderText="EmployedAtCASBApproval"
                    SortExpression="EmployedAtCASBApproval" />
                <asp:BoundField DataField="Was2290Mailed" HeaderText="Was2290Mailed" SortExpression="Was2290Mailed" />
                <asp:BoundField DataField="RWBContact" HeaderText="RWBContact" SortExpression="RWBContact" />
                <asp:BoundField DataField="TerminationGoodCause" HeaderText="TerminationGoodCause"
                    SortExpression="TerminationGoodCause" />
                <asp:BoundField DataField="TwoFailures" HeaderText="TwoFailures" SortExpression="TwoFailures" />
                <asp:BoundField DataField="TwoIn30" HeaderText="TwoIn30" SortExpression="TwoIn30" />
                <asp:BoundField DataField="Allowed3Days" HeaderText="Allowed3Days" SortExpression="Allowed3Days" />
                <asp:BoundField DataField="WTP2292Mailed" HeaderText="WTP2292Mailed" SortExpression="WTP2292Mailed" />
                <asp:BoundField DataField="ActionCaseNotesEntered" HeaderText="ActionCaseNotesEntered"
                    SortExpression="ActionCaseNotesEntered" />
                <asp:BoundField DataField="FinalComments" HeaderText="FinalComments" SortExpression="FinalComments">
                    <ItemStyle Wrap="False" />
                </asp:BoundField>
                <asp:BoundField DataField="ReviewDateTime" DataFormatString="{0:d}" HeaderText="ReviewDateTime"
                    HtmlEncode="False" SortExpression="ReviewDateTime">
                    <ItemStyle Wrap="False" />
                </asp:BoundField>
            </Columns>
            <RowStyle BackColor="#E3EAEB" Wrap="False" />
            <EditRowStyle BackColor="#7C6F57" />
            <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" Wrap="True" />
            <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Left" />
            <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <AlternatingRowStyle BackColor="White" />
            <PagerSettings Mode="NumericFirstLast" />
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:SigmaToolsConnectionString %>"
            DeleteCommand="DELETE FROM [WTP] WHERE [ReviewID] = @original_ReviewID AND [ReviewDateFrom] = @original_ReviewDateFrom AND [ReviewDateTo] = @original_ReviewDateTo AND [LastName] = @original_LastName AND [FirstName] = @original_FirstName AND [SSN] = @original_SSN AND [Region] = @original_Region AND [County] = @original_County AND [OneStop] = @original_OneStop AND [Unit] = @original_Unit AND [Notes05] = @original_Notes05 AND [CaseManagerLName] = @original_CaseManagerLName AND [ReviewerName] = @original_ReviewerName AND [ReviewType] = @original_ReviewType AND [ReviewDate] = @original_ReviewDate AND [Mandatory] = @original_Mandatory AND [DateNewCase] = @original_DateNewCase AND [OOSigned] = @original_OOSigned AND [DateFormSigned] = @original_DateFormSigned AND [AssessmentWithin30] = @original_AssessmentWithin30 AND [IncludeSkills] = @original_IncludeSkills AND [IRPSigned] = @original_IRPSigned AND [GoalsIdentified] = @original_GoalsIdentified AND [ActivitiesIdentified] = @original_ActivitiesIdentified AND [HoursIdentified] = @original_HoursIdentified AND [ActivitiesIncludeAnticipated] = @original_ActivitiesIncludeAnticipated AND [ServicesPrivided] = @original_ServicesPrivided AND [Steps] = @original_Steps AND [EmploymentVerified] = @original_EmploymentVerified AND [OSSTMatch] = @original_OSSTMatch AND [JPR1Date] = @original_JPR1Date AND [JPR1Activity] = @original_JPR1Activity AND [JPR1Hours] = @original_JPR1Hours AND [JPR1Date2] = @original_JPR1Date2 AND [JPR1Activity2] = @original_JPR1Activity2 AND [JPR1Hours2] = @original_JPR1Hours2 AND [JPRHoursDoc1] = @original_JPRHoursDoc1 AND [JPR2Date] = @original_JPR2Date AND [JPR2Activity] = @original_JPR2Activity AND [JPR2Hours] = @original_JPR2Hours AND [JPR2Date2] = @original_JPR2Date2 AND [JPR2Activity2] = @original_JPR2Activity2 AND [JPR2Hours2] = @original_JPR2Hours2 AND [JPRHoursDoc2] = @original_JPRHoursDoc2 AND [JPR3Date] = @original_JPR3Date AND [JPR3Activity] = @original_JPR3Activity AND [JPR3Hours] = @original_JPR3Hours AND [JPR3Date2] = @original_JPR3Date2 AND [JPR3Activity2] = @original_JPR3Activity2 AND [JPR3Hours2] = @original_JPR3Hours2 AND [JPRHoursDoc3] = @original_JPRHoursDoc3 AND [JPR4Date] = @original_JPR4Date AND [JPR4Activity] = @original_JPR4Activity AND [JPR4Hours] = @original_JPR4Hours AND [JPR4Date2] = @original_JPR4Date2 AND [JPR4Activity2] = @original_JPR4Activity2 AND [JPR4Hours2] = @original_JPR4Hours2 AND [JPRHoursDoc4] = @original_JPRHoursDoc4 AND [JPR5Date] = @original_JPR5Date AND [JPR5Activity] = @original_JPR5Activity AND [JPR5Hours] = @original_JPR5Hours AND [JPR5Date2] = @original_JPR5Date2 AND [JPR5Activity2] = @original_JPR5Activity2 AND [JPR5Hours2] = @original_JPR5Hours2 AND [JPRHoursDoc5] = @original_JPRHoursDoc5 AND [JPRWorkbooks] = @original_JPRWorkbooks AND [JPRNotes] = @original_JPRNotes AND [VocationalEd] = @original_VocationalEd AND [WEP220HoursLess] = @original_WEP220HoursLess AND [CWEPHoursLess] = @original_CWEPHoursLess AND [ParticipateOver4Weeks] = @original_ParticipateOver4Weeks AND [DaysBetweenStartAndReferral] = @original_DaysBetweenStartAndReferral AND [MedicalNoteSigned] = @original_MedicalNoteSigned AND [EvidenceOfJobContacts] = @original_EvidenceOfJobContacts AND [Forms2073A_2075Completed] = @original_Forms2073A_2075Completed AND [Form2279Completed] = @original_Form2279Completed AND [FormAWI0002] = @original_FormAWI0002 AND [RelocationMonitored] = @original_RelocationMonitored AND [EmployedAtCASBApproval] = @original_EmployedAtCASBApproval AND [Was2290Mailed] = @original_Was2290Mailed AND [RWBContact] = @original_RWBContact AND [TerminationGoodCause] = @original_TerminationGoodCause AND [TwoFailures] = @original_TwoFailures AND [TwoIn30] = @original_TwoIn30 AND [Allowed3Days] = @original_Allowed3Days AND [WTP2292Mailed] = @original_WTP2292Mailed AND [ActionCaseNotesEntered] = @original_ActionCaseNotesEntered AND [FinalComments] = @original_FinalComments AND [ReviewDateTime] = @original_ReviewDateTime" InsertCommand="INSERT INTO [WTP] ([ReviewDateFrom], [ReviewDateTo], [LastName], [FirstName], [SSN], [Region], [County], [OneStop], [Unit], [Notes05], [CaseManagerLName], [ReviewerName], [ReviewType], [ReviewDate], [Mandatory], [DateNewCase], [OOSigned], [DateFormSigned], [AssessmentWithin30], [IncludeSkills], [IRPSigned], [GoalsIdentified], [ActivitiesIdentified], [HoursIdentified], [ActivitiesIncludeAnticipated], [ServicesPrivided], [Steps], [EmploymentVerified], [OSSTMatch], [JPR1Date], [JPR1Activity], [JPR1Hours], [JPR1Date2], [JPR1Activity2], [JPR1Hours2], [JPRHoursDoc1], [JPR2Date], [JPR2Activity], [JPR2Hours], [JPR2Date2], [JPR2Activity2], [JPR2Hours2], [JPRHoursDoc2], [JPR3Date], [JPR3Activity], [JPR3Hours], [JPR3Date2], [JPR3Activity2], [JPR3Hours2], [JPRHoursDoc3], [JPR4Date], [JPR4Activity], [JPR4Hours], [JPR4Date2], [JPR4Activity2], [JPR4Hours2], [JPRHoursDoc4], [JPR5Date], [JPR5Activity], [JPR5Hours], [JPR5Date2], [JPR5Activity2], [JPR5Hours2], [JPRHoursDoc5], [JPRWorkbooks], [JPRNotes], [VocationalEd], [WEP220HoursLess], [CWEPHoursLess], [ParticipateOver4Weeks], [DaysBetweenStartAndReferral], [MedicalNoteSigned], [EvidenceOfJobContacts], [Forms2073A_2075Completed], [Form2279Completed], [FormAWI0002], [RelocationMonitored], [EmployedAtCASBApproval], [Was2290Mailed], [RWBContact], [TerminationGoodCause], [TwoFailures], [TwoIn30], [Allowed3Days], [WTP2292Mailed], [ActionCaseNotesEntered], [FinalComments], [ReviewDateTime]) VALUES (@ReviewDateFrom, @ReviewDateTo, @LastName, @FirstName, @SSN, @Region, @County, @OneStop, @Unit, @Notes05, @CaseManagerLName, @ReviewerName, @ReviewType, @ReviewDate, @Mandatory, @DateNewCase, @OOSigned, @DateFormSigned, @AssessmentWithin30, @IncludeSkills, @IRPSigned, @GoalsIdentified, @ActivitiesIdentified, @HoursIdentified, @ActivitiesIncludeAnticipated, @ServicesPrivided, @Steps, @EmploymentVerified, @OSSTMatch, @JPR1Date, @JPR1Activity, @JPR1Hours, @JPR1Date2, @JPR1Activity2, @JPR1Hours2, @JPRHoursDoc1, @JPR2Date, @JPR2Activity, @JPR2Hours, @JPR2Date2, @JPR2Activity2, @JPR2Hours2, @JPRHoursDoc2, @JPR3Date, @JPR3Activity, @JPR3Hours, @JPR3Date2, @JPR3Activity2, @JPR3Hours2, @JPRHoursDoc3, @JPR4Date, @JPR4Activity, @JPR4Hours, @JPR4Date2, @JPR4Activity2, @JPR4Hours2, @JPRHoursDoc4, @JPR5Date, @JPR5Activity, @JPR5Hours, @JPR5Date2, @JPR5Activity2, @JPR5Hours2, @JPRHoursDoc5, @JPRWorkbooks, @JPRNotes, @VocationalEd, @WEP220HoursLess, @CWEPHoursLess, @ParticipateOver4Weeks, @DaysBetweenStartAndReferral, @MedicalNoteSigned, @EvidenceOfJobContacts, @Forms2073A_2075Completed, @Form2279Completed, @FormAWI0002, @RelocationMonitored, @EmployedAtCASBApproval, @Was2290Mailed, @RWBContact, @TerminationGoodCause, @TwoFailures, @TwoIn30, @Allowed3Days, @WTP2292Mailed, @ActionCaseNotesEntered, @FinalComments, @ReviewDateTime)"
            SelectCommand="SELECT * FROM [WTP] ORDER BY [LastName]" UpdateCommand="UPDATE [WTP] SET [ReviewDateFrom] = @ReviewDateFrom, [ReviewDateTo] = @ReviewDateTo, [LastName] = @LastName, [FirstName] = @FirstName, [SSN] = @SSN, [Region] = @Region, [County] = @County, [OneStop] = @OneStop, [Unit] = @Unit, [Notes05] = @Notes05, [CaseManagerLName] = @CaseManagerLName, [ReviewerName] = @ReviewerName, [ReviewType] = @ReviewType, [ReviewDate] = @ReviewDate, [Mandatory] = @Mandatory, [DateNewCase] = @DateNewCase, [OOSigned] = @OOSigned, [DateFormSigned] = @DateFormSigned, [AssessmentWithin30] = @AssessmentWithin30, [IncludeSkills] = @IncludeSkills, [IRPSigned] = @IRPSigned, [GoalsIdentified] = @GoalsIdentified, [ActivitiesIdentified] = @ActivitiesIdentified, [HoursIdentified] = @HoursIdentified, [ActivitiesIncludeAnticipated] = @ActivitiesIncludeAnticipated, [ServicesPrivided] = @ServicesPrivided, [Steps] = @Steps, [EmploymentVerified] = @EmploymentVerified, [OSSTMatch] = @OSSTMatch, [JPR1Date] = @JPR1Date, [JPR1Activity] = @JPR1Activity, [JPR1Hours] = @JPR1Hours, [JPR1Date2] = @JPR1Date2, [JPR1Activity2] = @JPR1Activity2, [JPR1Hours2] = @JPR1Hours2, [JPRHoursDoc1] = @JPRHoursDoc1, [JPR2Date] = @JPR2Date, [JPR2Activity] = @JPR2Activity, [JPR2Hours] = @JPR2Hours, [JPR2Date2] = @JPR2Date2, [JPR2Activity2] = @JPR2Activity2, [JPR2Hours2] = @JPR2Hours2, [JPRHoursDoc2] = @JPRHoursDoc2, [JPR3Date] = @JPR3Date, [JPR3Activity] = @JPR3Activity, [JPR3Hours] = @JPR3Hours, [JPR3Date2] = @JPR3Date2, [JPR3Activity2] = @JPR3Activity2, [JPR3Hours2] = @JPR3Hours2, [JPRHoursDoc3] = @JPRHoursDoc3, [JPR4Date] = @JPR4Date, [JPR4Activity] = @JPR4Activity, [JPR4Hours] = @JPR4Hours, [JPR4Date2] = @JPR4Date2, [JPR4Activity2] = @JPR4Activity2, [JPR4Hours2] = @JPR4Hours2, [JPRHoursDoc4] = @JPRHoursDoc4, [JPR5Date] = @JPR5Date, [JPR5Activity] = @JPR5Activity, [JPR5Hours] = @JPR5Hours, [JPR5Date2] = @JPR5Date2, [JPR5Activity2] = @JPR5Activity2, [JPR5Hours2] = @JPR5Hours2, [JPRHoursDoc5] = @JPRHoursDoc5, [JPRWorkbooks] = @JPRWorkbooks, [JPRNotes] = @JPRNotes, [VocationalEd] = @VocationalEd, [WEP220HoursLess] = @WEP220HoursLess, [CWEPHoursLess] = @CWEPHoursLess, [ParticipateOver4Weeks] = @ParticipateOver4Weeks, [DaysBetweenStartAndReferral] = @DaysBetweenStartAndReferral, [MedicalNoteSigned] = @MedicalNoteSigned, [EvidenceOfJobContacts] = @EvidenceOfJobContacts, [Forms2073A_2075Completed] = @Forms2073A_2075Completed, [Form2279Completed] = @Form2279Completed, [FormAWI0002] = @FormAWI0002, [RelocationMonitored] = @RelocationMonitored, [EmployedAtCASBApproval] = @EmployedAtCASBApproval, [Was2290Mailed] = @Was2290Mailed, [RWBContact] = @RWBContact, [TerminationGoodCause] = @TerminationGoodCause, [TwoFailures] = @TwoFailures, [TwoIn30] = @TwoIn30, [Allowed3Days] = @Allowed3Days, [WTP2292Mailed] = @WTP2292Mailed, [ActionCaseNotesEntered] = @ActionCaseNotesEntered, [FinalComments] = @FinalComments, [ReviewDateTime] = @ReviewDateTime WHERE [ReviewID] = @original_ReviewID AND [ReviewDateFrom] = @original_ReviewDateFrom AND [ReviewDateTo] = @original_ReviewDateTo AND [LastName] = @original_LastName AND [FirstName] = @original_FirstName AND [SSN] = @original_SSN AND [Region] = @original_Region AND [County] = @original_County AND [OneStop] = @original_OneStop AND [Unit] = @original_Unit AND [Notes05] = @original_Notes05 AND [CaseManagerLName] = @original_CaseManagerLName AND [ReviewerName] = @original_ReviewerName AND [ReviewType] = @original_ReviewType AND [ReviewDate] = @original_ReviewDate AND [Mandatory] = @original_Mandatory AND [DateNewCase] = @original_DateNewCase AND [OOSigned] = @original_OOSigned AND [DateFormSigned] = @original_DateFormSigned AND [AssessmentWithin30] = @original_AssessmentWithin30 AND [IncludeSkills] = @original_IncludeSkills AND [IRPSigned] = @original_IRPSigned AND [GoalsIdentified] = @original_GoalsIdentified AND [ActivitiesIdentified] = @original_ActivitiesIdentified AND [HoursIdentified] = @original_HoursIdentified AND [ActivitiesIncludeAnticipated] = @original_ActivitiesIncludeAnticipated AND [ServicesPrivided] = @original_ServicesPrivided AND [Steps] = @original_Steps AND [EmploymentVerified] = @original_EmploymentVerified AND [OSSTMatch] = @original_OSSTMatch AND [JPR1Date] = @original_JPR1Date AND [JPR1Activity] = @original_JPR1Activity AND [JPR1Hours] = @original_JPR1Hours AND [JPR1Date2] = @original_JPR1Date2 AND [JPR1Activity2] = @original_JPR1Activity2 AND [JPR1Hours2] = @original_JPR1Hours2 AND [JPRHoursDoc1] = @original_JPRHoursDoc1 AND [JPR2Date] = @original_JPR2Date AND [JPR2Activity] = @original_JPR2Activity AND [JPR2Hours] = @original_JPR2Hours AND [JPR2Date2] = @original_JPR2Date2 AND [JPR2Activity2] = @original_JPR2Activity2 AND [JPR2Hours2] = @original_JPR2Hours2 AND [JPRHoursDoc2] = @original_JPRHoursDoc2 AND [JPR3Date] = @original_JPR3Date AND [JPR3Activity] = @original_JPR3Activity AND [JPR3Hours] = @original_JPR3Hours AND [JPR3Date2] = @original_JPR3Date2 AND [JPR3Activity2] = @original_JPR3Activity2 AND [JPR3Hours2] = @original_JPR3Hours2 AND [JPRHoursDoc3] = @original_JPRHoursDoc3 AND [JPR4Date] = @original_JPR4Date AND [JPR4Activity] = @original_JPR4Activity AND [JPR4Hours] = @original_JPR4Hours AND [JPR4Date2] = @original_JPR4Date2 AND [JPR4Activity2] = @original_JPR4Activity2 AND [JPR4Hours2] = @original_JPR4Hours2 AND [JPRHoursDoc4] = @original_JPRHoursDoc4 AND [JPR5Date] = @original_JPR5Date AND [JPR5Activity] = @original_JPR5Activity AND [JPR5Hours] = @original_JPR5Hours AND [JPR5Date2] = @original_JPR5Date2 AND [JPR5Activity2] = @original_JPR5Activity2 AND [JPR5Hours2] = @original_JPR5Hours2 AND [JPRHoursDoc5] = @original_JPRHoursDoc5 AND [JPRWorkbooks] = @original_JPRWorkbooks AND [JPRNotes] = @original_JPRNotes AND [VocationalEd] = @original_VocationalEd AND [WEP220HoursLess] = @original_WEP220HoursLess AND [CWEPHoursLess] = @original_CWEPHoursLess AND [ParticipateOver4Weeks] = @original_ParticipateOver4Weeks AND [DaysBetweenStartAndReferral] = @original_DaysBetweenStartAndReferral AND [MedicalNoteSigned] = @original_MedicalNoteSigned AND [EvidenceOfJobContacts] = @original_EvidenceOfJobContacts AND [Forms2073A_2075Completed] = @original_Forms2073A_2075Completed AND [Form2279Completed] = @original_Form2279Completed AND [FormAWI0002] = @original_FormAWI0002 AND [RelocationMonitored] = @original_RelocationMonitored AND [EmployedAtCASBApproval] = @original_EmployedAtCASBApproval AND [Was2290Mailed] = @original_Was2290Mailed AND [RWBContact] = @original_RWBContact AND [TerminationGoodCause] = @original_TerminationGoodCause AND [TwoFailures] = @original_TwoFailures AND [TwoIn30] = @original_TwoIn30 AND [Allowed3Days] = @original_Allowed3Days AND [WTP2292Mailed] = @original_WTP2292Mailed AND [ActionCaseNotesEntered] = @original_ActionCaseNotesEntered AND [FinalComments] = @original_FinalComments AND [ReviewDateTime] = @original_ReviewDateTime" ConflictDetection="CompareAllValues" OldValuesParameterFormatString="original_{0}">
            <DeleteParameters>
                <asp:Parameter Name="original_ReviewID" Type="Int32" />
                <asp:Parameter Name="original_ReviewDateFrom" Type="DateTime" />
                <asp:Parameter Name="original_ReviewDateTo" Type="DateTime" />
                <asp:Parameter Name="original_LastName" Type="String" />
                <asp:Parameter Name="original_FirstName" Type="String" />
                <asp:Parameter Name="original_SSN" Type="String" />
                <asp:Parameter Name="original_Region" Type="String" />
                <asp:Parameter Name="original_County" Type="String" />
                <asp:Parameter Name="original_OneStop" Type="String" />
                <asp:Parameter Name="original_Unit" Type="String" />
                <asp:Parameter Name="original_Notes05" Type="String" />
                <asp:Parameter Name="original_CaseManagerLName" Type="String" />
                <asp:Parameter Name="original_ReviewerName" Type="String" />
                <asp:Parameter Name="original_ReviewType" Type="String" />
                <asp:Parameter Name="original_ReviewDate" Type="DateTime" />
                <asp:Parameter Name="original_Mandatory" Type="String" />
                <asp:Parameter Name="original_DateNewCase" Type="DateTime" />
                <asp:Parameter Name="original_OOSigned" Type="String" />
                <asp:Parameter Name="original_DateFormSigned" Type="DateTime" />
                <asp:Parameter Name="original_AssessmentWithin30" Type="String" />
                <asp:Parameter Name="original_IncludeSkills" Type="String" />
                <asp:Parameter Name="original_IRPSigned" Type="String" />
                <asp:Parameter Name="original_GoalsIdentified" Type="String" />
                <asp:Parameter Name="original_ActivitiesIdentified" Type="String" />
                <asp:Parameter Name="original_HoursIdentified" Type="String" />
                <asp:Parameter Name="original_ActivitiesIncludeAnticipated" Type="String" />
                <asp:Parameter Name="original_ServicesPrivided" Type="String" />
                <asp:Parameter Name="original_Steps" Type="String" />
                <asp:Parameter Name="original_EmploymentVerified" Type="String" />
                <asp:Parameter Name="original_OSSTMatch" Type="String" />
                <asp:Parameter Name="original_JPR1Date" Type="DateTime" />
                <asp:Parameter Name="original_JPR1Activity" Type="String" />
                <asp:Parameter Name="original_JPR1Hours" Type="String" />
                <asp:Parameter Name="original_JPR1Date2" Type="DateTime" />
                <asp:Parameter Name="original_JPR1Activity2" Type="String" />
                <asp:Parameter Name="original_JPR1Hours2" Type="String" />
                <asp:Parameter Name="original_JPRHoursDoc1" Type="String" />
                <asp:Parameter Name="original_JPR2Date" Type="DateTime" />
                <asp:Parameter Name="original_JPR2Activity" Type="String" />
                <asp:Parameter Name="original_JPR2Hours" Type="String" />
                <asp:Parameter Name="original_JPR2Date2" Type="DateTime" />
                <asp:Parameter Name="original_JPR2Activity2" Type="String" />
                <asp:Parameter Name="original_JPR2Hours2" Type="String" />
                <asp:Parameter Name="original_JPRHoursDoc2" Type="String" />
                <asp:Parameter Name="original_JPR3Date" Type="DateTime" />
                <asp:Parameter Name="original_JPR3Activity" Type="String" />
                <asp:Parameter Name="original_JPR3Hours" Type="String" />
                <asp:Parameter Name="original_JPR3Date2" Type="DateTime" />
                <asp:Parameter Name="original_JPR3Activity2" Type="String" />
                <asp:Parameter Name="original_JPR3Hours2" Type="String" />
                <asp:Parameter Name="original_JPRHoursDoc3" Type="String" />
                <asp:Parameter Name="original_JPR4Date" Type="DateTime" />
                <asp:Parameter Name="original_JPR4Activity" Type="String" />
                <asp:Parameter Name="original_JPR4Hours" Type="String" />
                <asp:Parameter Name="original_JPR4Date2" Type="DateTime" />
                <asp:Parameter Name="original_JPR4Activity2" Type="String" />
                <asp:Parameter Name="original_JPR4Hours2" Type="String" />
                <asp:Parameter Name="original_JPRHoursDoc4" Type="String" />
                <asp:Parameter Name="original_JPR5Date" Type="DateTime" />
                <asp:Parameter Name="original_JPR5Activity" Type="String" />
                <asp:Parameter Name="original_JPR5Hours" Type="String" />
                <asp:Parameter Name="original_JPR5Date2" Type="DateTime" />
                <asp:Parameter Name="original_JPR5Activity2" Type="String" />
                <asp:Parameter Name="original_JPR5Hours2" Type="String" />
                <asp:Parameter Name="original_JPRHoursDoc5" Type="String" />
                <asp:Parameter Name="original_JPRWorkbooks" Type="String" />
                <asp:Parameter Name="original_JPRNotes" Type="String" />
                <asp:Parameter Name="original_VocationalEd" Type="String" />
                <asp:Parameter Name="original_WEP220HoursLess" Type="String" />
                <asp:Parameter Name="original_CWEPHoursLess" Type="String" />
                <asp:Parameter Name="original_ParticipateOver4Weeks" Type="String" />
                <asp:Parameter Name="original_DaysBetweenStartAndReferral" Type="String" />
                <asp:Parameter Name="original_MedicalNoteSigned" Type="String" />
                <asp:Parameter Name="original_EvidenceOfJobContacts" Type="String" />
                <asp:Parameter Name="original_Forms2073A_2075Completed" Type="String" />
                <asp:Parameter Name="original_Form2279Completed" Type="String" />
                <asp:Parameter Name="original_FormAWI0002" Type="String" />
                <asp:Parameter Name="original_RelocationMonitored" Type="String" />
                <asp:Parameter Name="original_EmployedAtCASBApproval" Type="String" />
                <asp:Parameter Name="original_Was2290Mailed" Type="String" />
                <asp:Parameter Name="original_RWBContact" Type="String" />
                <asp:Parameter Name="original_TerminationGoodCause" Type="String" />
                <asp:Parameter Name="original_TwoFailures" Type="String" />
                <asp:Parameter Name="original_TwoIn30" Type="String" />
                <asp:Parameter Name="original_Allowed3Days" Type="String" />
                <asp:Parameter Name="original_WTP2292Mailed" Type="String" />
                <asp:Parameter Name="original_ActionCaseNotesEntered" Type="String" />
                <asp:Parameter Name="original_FinalComments" Type="String" />
                <asp:Parameter Name="original_ReviewDateTime" Type="DateTime" />
            </DeleteParameters>
            <UpdateParameters>
                <asp:Parameter Name="ReviewDateFrom" Type="DateTime" />
                <asp:Parameter Name="ReviewDateTo" Type="DateTime" />
                <asp:Parameter Name="LastName" Type="String" />
                <asp:Parameter Name="FirstName" Type="String" />
                <asp:Parameter Name="SSN" Type="String" />
                <asp:Parameter Name="Region" Type="String" />
                <asp:Parameter Name="County" Type="String" />
                <asp:Parameter Name="OneStop" Type="String" />
                <asp:Parameter Name="Unit" Type="String" />
                <asp:Parameter Name="Notes05" Type="String" />
                <asp:Parameter Name="CaseManagerLName" Type="String" />
                <asp:Parameter Name="ReviewerName" Type="String" />
                <asp:Parameter Name="ReviewType" Type="String" />
                <asp:Parameter Name="ReviewDate" Type="DateTime" />
                <asp:Parameter Name="Mandatory" Type="String" />
                <asp:Parameter Name="DateNewCase" Type="DateTime" />
                <asp:Parameter Name="OOSigned" Type="String" />
                <asp:Parameter Name="DateFormSigned" Type="DateTime" />
                <asp:Parameter Name="AssessmentWithin30" Type="String" />
                <asp:Parameter Name="IncludeSkills" Type="String" />
                <asp:Parameter Name="IRPSigned" Type="String" />
                <asp:Parameter Name="GoalsIdentified" Type="String" />
                <asp:Parameter Name="ActivitiesIdentified" Type="String" />
                <asp:Parameter Name="HoursIdentified" Type="String" />
                <asp:Parameter Name="ActivitiesIncludeAnticipated" Type="String" />
                <asp:Parameter Name="ServicesPrivided" Type="String" />
                <asp:Parameter Name="Steps" Type="String" />
                <asp:Parameter Name="EmploymentVerified" Type="String" />
                <asp:Parameter Name="OSSTMatch" Type="String" />
                <asp:Parameter Name="JPR1Date" Type="DateTime" />
                <asp:Parameter Name="JPR1Activity" Type="String" />
                <asp:Parameter Name="JPR1Hours" Type="String" />
                <asp:Parameter Name="JPR1Date2" Type="DateTime" />
                <asp:Parameter Name="JPR1Activity2" Type="String" />
                <asp:Parameter Name="JPR1Hours2" Type="String" />
                <asp:Parameter Name="JPRHoursDoc1" Type="String" />
                <asp:Parameter Name="JPR2Date" Type="DateTime" />
                <asp:Parameter Name="JPR2Activity" Type="String" />
                <asp:Parameter Name="JPR2Hours" Type="String" />
                <asp:Parameter Name="JPR2Date2" Type="DateTime" />
                <asp:Parameter Name="JPR2Activity2" Type="String" />
                <asp:Parameter Name="JPR2Hours2" Type="String" />
                <asp:Parameter Name="JPRHoursDoc2" Type="String" />
                <asp:Parameter Name="JPR3Date" Type="DateTime" />
                <asp:Parameter Name="JPR3Activity" Type="String" />
                <asp:Parameter Name="JPR3Hours" Type="String" />
                <asp:Parameter Name="JPR3Date2" Type="DateTime" />
                <asp:Parameter Name="JPR3Activity2" Type="String" />
                <asp:Parameter Name="JPR3Hours2" Type="String" />
                <asp:Parameter Name="JPRHoursDoc3" Type="String" />
                <asp:Parameter Name="JPR4Date" Type="DateTime" />
                <asp:Parameter Name="JPR4Activity" Type="String" />
                <asp:Parameter Name="JPR4Hours" Type="String" />
                <asp:Parameter Name="JPR4Date2" Type="DateTime" />
                <asp:Parameter Name="JPR4Activity2" Type="String" />
                <asp:Parameter Name="JPR4Hours2" Type="String" />
                <asp:Parameter Name="JPRHoursDoc4" Type="String" />
                <asp:Parameter Name="JPR5Date" Type="DateTime" />
                <asp:Parameter Name="JPR5Activity" Type="String" />
                <asp:Parameter Name="JPR5Hours" Type="String" />
                <asp:Parameter Name="JPR5Date2" Type="DateTime" />
                <asp:Parameter Name="JPR5Activity2" Type="String" />
                <asp:Parameter Name="JPR5Hours2" Type="String" />
                <asp:Parameter Name="JPRHoursDoc5" Type="String" />
                <asp:Parameter Name="JPRWorkbooks" Type="String" />
                <asp:Parameter Name="JPRNotes" Type="String" />
                <asp:Parameter Name="VocationalEd" Type="String" />
                <asp:Parameter Name="WEP220HoursLess" Type="String" />
                <asp:Parameter Name="CWEPHoursLess" Type="String" />
                <asp:Parameter Name="ParticipateOver4Weeks" Type="String" />
                <asp:Parameter Name="DaysBetweenStartAndReferral" Type="String" />
                <asp:Parameter Name="MedicalNoteSigned" Type="String" />
                <asp:Parameter Name="EvidenceOfJobContacts" Type="String" />
                <asp:Parameter Name="Forms2073A_2075Completed" Type="String" />
                <asp:Parameter Name="Form2279Completed" Type="String" />
                <asp:Parameter Name="FormAWI0002" Type="String" />
                <asp:Parameter Name="RelocationMonitored" Type="String" />
                <asp:Parameter Name="EmployedAtCASBApproval" Type="String" />
                <asp:Parameter Name="Was2290Mailed" Type="String" />
                <asp:Parameter Name="RWBContact" Type="String" />
                <asp:Parameter Name="TerminationGoodCause" Type="String" />
                <asp:Parameter Name="TwoFailures" Type="String" />
                <asp:Parameter Name="TwoIn30" Type="String" />
                <asp:Parameter Name="Allowed3Days" Type="String" />
                <asp:Parameter Name="WTP2292Mailed" Type="String" />
                <asp:Parameter Name="ActionCaseNotesEntered" Type="String" />
                <asp:Parameter Name="FinalComments" Type="String" />
                <asp:Parameter Name="ReviewDateTime" Type="DateTime" />
                <asp:Parameter Name="original_ReviewID" Type="Int32" />
                <asp:Parameter Name="original_ReviewDateFrom" Type="DateTime" />
                <asp:Parameter Name="original_ReviewDateTo" Type="DateTime" />
                <asp:Parameter Name="original_LastName" Type="String" />
                <asp:Parameter Name="original_FirstName" Type="String" />
                <asp:Parameter Name="original_SSN" Type="String" />
                <asp:Parameter Name="original_Region" Type="String" />
                <asp:Parameter Name="original_County" Type="String" />
                <asp:Parameter Name="original_OneStop" Type="String" />
                <asp:Parameter Name="original_Unit" Type="String" />
                <asp:Parameter Name="original_Notes05" Type="String" />
                <asp:Parameter Name="original_CaseManagerLName" Type="String" />
                <asp:Parameter Name="original_ReviewerName" Type="String" />
                <asp:Parameter Name="original_ReviewType" Type="String" />
                <asp:Parameter Name="original_ReviewDate" Type="DateTime" />
                <asp:Parameter Name="original_Mandatory" Type="String" />
                <asp:Parameter Name="original_DateNewCase" Type="DateTime" />
                <asp:Parameter Name="original_OOSigned" Type="String" />
                <asp:Parameter Name="original_DateFormSigned" Type="DateTime" />
                <asp:Parameter Name="original_AssessmentWithin30" Type="String" />
                <asp:Parameter Name="original_IncludeSkills" Type="String" />
                <asp:Parameter Name="original_IRPSigned" Type="String" />
                <asp:Parameter Name="original_GoalsIdentified" Type="String" />
                <asp:Parameter Name="original_ActivitiesIdentified" Type="String" />
                <asp:Parameter Name="original_HoursIdentified" Type="String" />
                <asp:Parameter Name="original_ActivitiesIncludeAnticipated" Type="String" />
                <asp:Parameter Name="original_ServicesPrivided" Type="String" />
                <asp:Parameter Name="original_Steps" Type="String" />
                <asp:Parameter Name="original_EmploymentVerified" Type="String" />
                <asp:Parameter Name="original_OSSTMatch" Type="String" />
                <asp:Parameter Name="original_JPR1Date" Type="DateTime" />
                <asp:Parameter Name="original_JPR1Activity" Type="String" />
                <asp:Parameter Name="original_JPR1Hours" Type="String" />
                <asp:Parameter Name="original_JPR1Date2" Type="DateTime" />
                <asp:Parameter Name="original_JPR1Activity2" Type="String" />
                <asp:Parameter Name="original_JPR1Hours2" Type="String" />
                <asp:Parameter Name="original_JPRHoursDoc1" Type="String" />
                <asp:Parameter Name="original_JPR2Date" Type="DateTime" />
                <asp:Parameter Name="original_JPR2Activity" Type="String" />
                <asp:Parameter Name="original_JPR2Hours" Type="String" />
                <asp:Parameter Name="original_JPR2Date2" Type="DateTime" />
                <asp:Parameter Name="original_JPR2Activity2" Type="String" />
                <asp:Parameter Name="original_JPR2Hours2" Type="String" />
                <asp:Parameter Name="original_JPRHoursDoc2" Type="String" />
                <asp:Parameter Name="original_JPR3Date" Type="DateTime" />
                <asp:Parameter Name="original_JPR3Activity" Type="String" />
                <asp:Parameter Name="original_JPR3Hours" Type="String" />
                <asp:Parameter Name="original_JPR3Date2" Type="DateTime" />
                <asp:Parameter Name="original_JPR3Activity2" Type="String" />
                <asp:Parameter Name="original_JPR3Hours2" Type="String" />
                <asp:Parameter Name="original_JPRHoursDoc3" Type="String" />
                <asp:Parameter Name="original_JPR4Date" Type="DateTime" />
                <asp:Parameter Name="original_JPR4Activity" Type="String" />
                <asp:Parameter Name="original_JPR4Hours" Type="String" />
                <asp:Parameter Name="original_JPR4Date2" Type="DateTime" />
                <asp:Parameter Name="original_JPR4Activity2" Type="String" />
                <asp:Parameter Name="original_JPR4Hours2" Type="String" />
                <asp:Parameter Name="original_JPRHoursDoc4" Type="String" />
                <asp:Parameter Name="original_JPR5Date" Type="DateTime" />
                <asp:Parameter Name="original_JPR5Activity" Type="String" />
                <asp:Parameter Name="original_JPR5Hours" Type="String" />
                <asp:Parameter Name="original_JPR5Date2" Type="DateTime" />
                <asp:Parameter Name="original_JPR5Activity2" Type="String" />
                <asp:Parameter Name="original_JPR5Hours2" Type="String" />
                <asp:Parameter Name="original_JPRHoursDoc5" Type="String" />
                <asp:Parameter Name="original_JPRWorkbooks" Type="String" />
                <asp:Parameter Name="original_JPRNotes" Type="String" />
                <asp:Parameter Name="original_VocationalEd" Type="String" />
                <asp:Parameter Name="original_WEP220HoursLess" Type="String" />
                <asp:Parameter Name="original_CWEPHoursLess" Type="String" />
                <asp:Parameter Name="original_ParticipateOver4Weeks" Type="String" />
                <asp:Parameter Name="original_DaysBetweenStartAndReferral" Type="String" />
                <asp:Parameter Name="original_MedicalNoteSigned" Type="String" />
                <asp:Parameter Name="original_EvidenceOfJobContacts" Type="String" />
                <asp:Parameter Name="original_Forms2073A_2075Completed" Type="String" />
                <asp:Parameter Name="original_Form2279Completed" Type="String" />
                <asp:Parameter Name="original_FormAWI0002" Type="String" />
                <asp:Parameter Name="original_RelocationMonitored" Type="String" />
                <asp:Parameter Name="original_EmployedAtCASBApproval" Type="String" />
                <asp:Parameter Name="original_Was2290Mailed" Type="String" />
                <asp:Parameter Name="original_RWBContact" Type="String" />
                <asp:Parameter Name="original_TerminationGoodCause" Type="String" />
                <asp:Parameter Name="original_TwoFailures" Type="String" />
                <asp:Parameter Name="original_TwoIn30" Type="String" />
                <asp:Parameter Name="original_Allowed3Days" Type="String" />
                <asp:Parameter Name="original_WTP2292Mailed" Type="String" />
                <asp:Parameter Name="original_ActionCaseNotesEntered" Type="String" />
                <asp:Parameter Name="original_FinalComments" Type="String" />
                <asp:Parameter Name="original_ReviewDateTime" Type="DateTime" />
            </UpdateParameters>
            <InsertParameters>
                <asp:Parameter Name="ReviewDateFrom" Type="DateTime" />
                <asp:Parameter Name="ReviewDateTo" Type="DateTime" />
                <asp:Parameter Name="LastName" Type="String" />
                <asp:Parameter Name="FirstName" Type="String" />
                <asp:Parameter Name="SSN" Type="String" />
                <asp:Parameter Name="Region" Type="String" />
                <asp:Parameter Name="County" Type="String" />
                <asp:Parameter Name="OneStop" Type="String" />
                <asp:Parameter Name="Unit" Type="String" />
                <asp:Parameter Name="Notes05" Type="String" />
                <asp:Parameter Name="CaseManagerLName" Type="String" />
                <asp:Parameter Name="ReviewerName" Type="String" />
                <asp:Parameter Name="ReviewType" Type="String" />
                <asp:Parameter Name="ReviewDate" Type="DateTime" />
                <asp:Parameter Name="Mandatory" Type="String" />
                <asp:Parameter Name="DateNewCase" Type="DateTime" />
                <asp:Parameter Name="OOSigned" Type="String" />
                <asp:Parameter Name="DateFormSigned" Type="DateTime" />
                <asp:Parameter Name="AssessmentWithin30" Type="String" />
                <asp:Parameter Name="IncludeSkills" Type="String" />
                <asp:Parameter Name="IRPSigned" Type="String" />
                <asp:Parameter Name="GoalsIdentified" Type="String" />
                <asp:Parameter Name="ActivitiesIdentified" Type="String" />
                <asp:Parameter Name="HoursIdentified" Type="String" />
                <asp:Parameter Name="ActivitiesIncludeAnticipated" Type="String" />
                <asp:Parameter Name="ServicesPrivided" Type="String" />
                <asp:Parameter Name="Steps" Type="String" />
                <asp:Parameter Name="EmploymentVerified" Type="String" />
                <asp:Parameter Name="OSSTMatch" Type="String" />
                <asp:Parameter Name="JPR1Date" Type="DateTime" />
                <asp:Parameter Name="JPR1Activity" Type="String" />
                <asp:Parameter Name="JPR1Hours" Type="String" />
                <asp:Parameter Name="JPR1Date2" Type="DateTime" />
                <asp:Parameter Name="JPR1Activity2" Type="String" />
                <asp:Parameter Name="JPR1Hours2" Type="String" />
                <asp:Parameter Name="JPRHoursDoc1" Type="String" />
                <asp:Parameter Name="JPR2Date" Type="DateTime" />
                <asp:Parameter Name="JPR2Activity" Type="String" />
                <asp:Parameter Name="JPR2Hours" Type="String" />
                <asp:Parameter Name="JPR2Date2" Type="DateTime" />
                <asp:Parameter Name="JPR2Activity2" Type="String" />
                <asp:Parameter Name="JPR2Hours2" Type="String" />
                <asp:Parameter Name="JPRHoursDoc2" Type="String" />
                <asp:Parameter Name="JPR3Date" Type="DateTime" />
                <asp:Parameter Name="JPR3Activity" Type="String" />
                <asp:Parameter Name="JPR3Hours" Type="String" />
                <asp:Parameter Name="JPR3Date2" Type="DateTime" />
                <asp:Parameter Name="JPR3Activity2" Type="String" />
                <asp:Parameter Name="JPR3Hours2" Type="String" />
                <asp:Parameter Name="JPRHoursDoc3" Type="String" />
                <asp:Parameter Name="JPR4Date" Type="DateTime" />
                <asp:Parameter Name="JPR4Activity" Type="String" />
                <asp:Parameter Name="JPR4Hours" Type="String" />
                <asp:Parameter Name="JPR4Date2" Type="DateTime" />
                <asp:Parameter Name="JPR4Activity2" Type="String" />
                <asp:Parameter Name="JPR4Hours2" Type="String" />
                <asp:Parameter Name="JPRHoursDoc4" Type="String" />
                <asp:Parameter Name="JPR5Date" Type="DateTime" />
                <asp:Parameter Name="JPR5Activity" Type="String" />
                <asp:Parameter Name="JPR5Hours" Type="String" />
                <asp:Parameter Name="JPR5Date2" Type="DateTime" />
                <asp:Parameter Name="JPR5Activity2" Type="String" />
                <asp:Parameter Name="JPR5Hours2" Type="String" />
                <asp:Parameter Name="JPRHoursDoc5" Type="String" />
                <asp:Parameter Name="JPRWorkbooks" Type="String" />
                <asp:Parameter Name="JPRNotes" Type="String" />
                <asp:Parameter Name="VocationalEd" Type="String" />
                <asp:Parameter Name="WEP220HoursLess" Type="String" />
                <asp:Parameter Name="CWEPHoursLess" Type="String" />
                <asp:Parameter Name="ParticipateOver4Weeks" Type="String" />
                <asp:Parameter Name="DaysBetweenStartAndReferral" Type="String" />
                <asp:Parameter Name="MedicalNoteSigned" Type="String" />
                <asp:Parameter Name="EvidenceOfJobContacts" Type="String" />
                <asp:Parameter Name="Forms2073A_2075Completed" Type="String" />
                <asp:Parameter Name="Form2279Completed" Type="String" />
                <asp:Parameter Name="FormAWI0002" Type="String" />
                <asp:Parameter Name="RelocationMonitored" Type="String" />
                <asp:Parameter Name="EmployedAtCASBApproval" Type="String" />
                <asp:Parameter Name="Was2290Mailed" Type="String" />
                <asp:Parameter Name="RWBContact" Type="String" />
                <asp:Parameter Name="TerminationGoodCause" Type="String" />
                <asp:Parameter Name="TwoFailures" Type="String" />
                <asp:Parameter Name="TwoIn30" Type="String" />
                <asp:Parameter Name="Allowed3Days" Type="String" />
                <asp:Parameter Name="WTP2292Mailed" Type="String" />
                <asp:Parameter Name="ActionCaseNotesEntered" Type="String" />
                <asp:Parameter Name="FinalComments" Type="String" />
                <asp:Parameter Name="ReviewDateTime" Type="DateTime" />
            </InsertParameters>
        </asp:SqlDataSource>
        &nbsp;<br />
        <asp:FormView ID="FormView1" runat="server" DataKeyNames="ReviewID" DataSourceID="SqlDataSource1">
            <EditItemTemplate>
                ReviewID:
                <asp:Label ID="ReviewIDLabel1" runat="server" Text='<%# Eval("ReviewID") %>'></asp:Label><br />
                ReviewDateFrom:
                <asp:TextBox ID="ReviewDateFromTextBox" runat="server" Text='<%# Bind("ReviewDateFrom") %>'>
                </asp:TextBox><br />
                ReviewDateTo:
                <asp:TextBox ID="ReviewDateToTextBox" runat="server" Text='<%# Bind("ReviewDateTo") %>'>
                </asp:TextBox><br />
                LastName:
                <asp:TextBox ID="LastNameTextBox" runat="server" Text='<%# Bind("LastName") %>'>
                </asp:TextBox><br />
                FirstName:
                <asp:TextBox ID="FirstNameTextBox" runat="server" Text='<%# Bind("FirstName") %>'>
                </asp:TextBox><br />
                SSN:
                <asp:TextBox ID="SSNTextBox" runat="server" Text='<%# Bind("SSN") %>'>
                </asp:TextBox><br />
                Notes05:
                <asp:TextBox ID="Notes05TextBox" runat="server" Text='<%# Bind("Notes05") %>'>
                </asp:TextBox><br />
                <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
                    Text="Update">
                </asp:LinkButton>
                <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
                    Text="Cancel">
                </asp:LinkButton>
            </EditItemTemplate>
            <InsertItemTemplate>
                ReviewDateFrom:
                <asp:TextBox ID="ReviewDateFromTextBox" runat="server" Text='<%# Bind("ReviewDateFrom") %>'>
                </asp:TextBox><br />
                ReviewDateTo:
                <asp:TextBox ID="ReviewDateToTextBox" runat="server" Text='<%# Bind("ReviewDateTo") %>'>
                </asp:TextBox><br />
                LastName:
                <asp:TextBox ID="LastNameTextBox" runat="server" Text='<%# Bind("LastName") %>'>
                </asp:TextBox><br />
                FirstName:
                <asp:TextBox ID="FirstNameTextBox" runat="server" Text='<%# Bind("FirstName") %>'>
                </asp:TextBox><br />
                SSN:
                <asp:TextBox ID="SSNTextBox" runat="server" Text='<%# Bind("SSN") %>'>
                </asp:TextBox><br />
                Notes05:
                <asp:TextBox ID="Notes05TextBox" runat="server" Text='<%# Bind("Notes05") %>'>
                </asp:TextBox><br />
                <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
                    Text="Insert">
                </asp:LinkButton>
                <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
                    Text="Cancel">
                </asp:LinkButton>
            </InsertItemTemplate>
            <ItemTemplate>
                ReviewID:
                <asp:Label ID="ReviewIDLabel" runat="server" Text='<%# Eval("ReviewID") %>'></asp:Label><br />
                ReviewDateFrom:
                <asp:Label ID="ReviewDateFromLabel" runat="server" Text='<%# Bind("ReviewDateFrom") %>'>
                </asp:Label><br />
                ReviewDateTo:
                <asp:Label ID="ReviewDateToLabel" runat="server" Text='<%# Bind("ReviewDateTo") %>'>
                </asp:Label><br />
                LastName:
                <asp:Label ID="LastNameLabel" runat="server" Text='<%# Bind("LastName") %>'></asp:Label><br />
                FirstName:
                <asp:Label ID="FirstNameLabel" runat="server" Text='<%# Bind("FirstName") %>'></asp:Label><br />
                SSN:
                <asp:Label ID="SSNLabel" runat="server" Text='<%# Bind("SSN") %>'></asp:Label><br />
                Notes05:
                <asp:Label ID="Notes05Label" runat="server" Text='<%# Bind("Notes05") %>'></asp:Label><br />
                <asp:LinkButton ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit"
                    Text="Edit">
                </asp:LinkButton>
                <asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False" CommandName="Delete"
                    Text="Delete">
                </asp:LinkButton>
                <asp:LinkButton ID="NewButton" runat="server" CausesValidation="False" CommandName="New"
                    Text="New">
                </asp:LinkButton>
            </ItemTemplate>
        </asp:FormView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues"
            ConnectionString="<%$ ConnectionStrings:SigmaToolsConnectionString %>" DeleteCommand="DELETE FROM [WTP] WHERE [ReviewID] = @original_ReviewID AND [ReviewDateFrom] = @original_ReviewDateFrom AND [ReviewDateTo] = @original_ReviewDateTo AND [LastName] = @original_LastName AND [FirstName] = @original_FirstName AND [SSN] = @original_SSN AND [Notes05] = @original_Notes05"
            InsertCommand="INSERT INTO [WTP] ([ReviewDateFrom], [ReviewDateTo], [LastName], [FirstName], [SSN], [Notes05]) VALUES (@ReviewDateFrom, @ReviewDateTo, @LastName, @FirstName, @SSN, @Notes05)"
            OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT [ReviewID], [ReviewDateFrom], [ReviewDateTo], [LastName], [FirstName], [SSN], [Notes05] FROM [WTP] WHERE ([ReviewID] = @ReviewID)"
            UpdateCommand="UPDATE [WTP] SET [ReviewDateFrom] = @ReviewDateFrom, [ReviewDateTo] = @ReviewDateTo, [LastName] = @LastName, [FirstName] = @FirstName, [SSN] = @SSN, [Notes05] = @Notes05 WHERE [ReviewID] = @original_ReviewID AND [ReviewDateFrom] = @original_ReviewDateFrom AND [ReviewDateTo] = @original_ReviewDateTo AND [LastName] = @original_LastName AND [FirstName] = @original_FirstName AND [SSN] = @original_SSN AND [Notes05] = @original_Notes05">
            <DeleteParameters>
                <asp:Parameter Name="original_ReviewID" Type="Int32" />
                <asp:Parameter Name="original_ReviewDateFrom" Type="DateTime" />
                <asp:Parameter Name="original_ReviewDateTo" Type="DateTime" />
                <asp:Parameter Name="original_LastName" Type="String" />
                <asp:Parameter Name="original_FirstName" Type="String" />
                <asp:Parameter Name="original_SSN" Type="String" />
                <asp:Parameter Name="original_Notes05" Type="String" />
            </DeleteParameters>
            <UpdateParameters>
                <asp:Parameter Name="ReviewDateFrom" Type="DateTime" />
                <asp:Parameter Name="ReviewDateTo" Type="DateTime" />
                <asp:Parameter Name="LastName" Type="String" />
                <asp:Parameter Name="FirstName" Type="String" />
                <asp:Parameter Name="SSN" Type="String" />
                <asp:Parameter Name="Notes05" Type="String" />
                <asp:Parameter Name="original_ReviewID" Type="Int32" />
                <asp:Parameter Name="original_ReviewDateFrom" Type="DateTime" />
                <asp:Parameter Name="original_ReviewDateTo" Type="DateTime" />
                <asp:Parameter Name="original_LastName" Type="String" />
                <asp:Parameter Name="original_FirstName" Type="String" />
                <asp:Parameter Name="original_SSN" Type="String" />
                <asp:Parameter Name="original_Notes05" Type="String" />
            </UpdateParameters>
            <SelectParameters>
                <asp:ControlParameter ControlID="GridView1" Name="ReviewID" PropertyName="SelectedValue"
                    Type="Int32" />
            </SelectParameters>
            <InsertParameters>
                <asp:Parameter Name="ReviewDateFrom" Type="DateTime" />
                <asp:Parameter Name="ReviewDateTo" Type="DateTime" />
                <asp:Parameter Name="LastName" Type="String" />
                <asp:Parameter Name="FirstName" Type="String" />
                <asp:Parameter Name="SSN" Type="String" />
                <asp:Parameter Name="Notes05" Type="String" />
            </InsertParameters>
        </asp:SqlDataSource>
   
    </div>
    </form>
</body>
</html>
0
 
megninAuthor Commented:
Again I apologize.  Of the three long code posts above, only the third one is related to the question.  The first two are a different attempt at doing the same thing a different way.
0
 
CmdoProg2Commented:
Did you send the right page?  There is no gridview on this page.
0
 
CmdoProg2Commented:
Please Ignore my comment,  I didn't get your updated comments before I sent it.  I'll take look at comment ID 19669285.
0
 
megninAuthor Commented:
Sorry about that.  I'm trying to do the same thing (Allow a user to update the WTP table) two different ways.  On the other one I'm trying to do the Insert new record, "Fetch" existing record and Update it all on the same form.
Comment ID 19669285 is the one with the GridView I'm having trouble with.
When I do a successful record Update using the FormView, it is still not reflected in the GridView.  I'm not sure how to get the updated data to refresh into the GridView.  Is that related to the Update problem?  Perhaps something missing causing both problems?
0
 
megninAuthor Commented:
Correction... after some testing I found that the FormView is not updating the database either.  I'm not sure if it could be a permissions thing or not.  I can edit the database from within Visual Studio 2005 from "Server Explorer".
0
 
megninAuthor Commented:
In SQL Server Enterprise Manager, in Database Role Properties, Database role: public has SELECT, INSERT and UPDATE all selected for all the tables in the database.
0
 
megninAuthor Commented:
Correction Update... I've been experimenting with enabling Edit in the GridView and Not enabling Edit in the GridView, but enabling Edit in the FormView.
With only Select enabled in the GridView (Edit not enabled in the GridView), the FormView Edit does not affect the database, I can click "Edit" in the FormView and make a change and click "Update" but the change is not written to the database.

Then I enable Edit in the GridView and the FormView edit works again.
I enabled Edit in the GridView and edited a record with the FormView and the change was written to the database.
0
 
megninAuthor Commented:
Oh... Edit/Update still did not work if I did it in the GridView.  The buttons work.  When I click Edit in the GridView, the lables change to Textboxes for input, but any changes I make are not written to the database when I click "Update" on the GridView.  I'm sorry if I'm sounding redundant.  I just want what I'm doing to be clear.
0
 
CmdoProg2Commented:
If it was a permission problem, an exception would have been raised and can be handled in GridView1.RowUpdated event.  It's not matching a record on the database.  Here are two debugging modules I used to capture what is being passed/returned to the SQLDataSource.


  Protected Sub GridView1_RowUpdating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdateEventArgs) Handles GridView1.RowUpdating
    Response.Write("<strong>Keys</strong><br />")
    For Each k As DictionaryEntry In e.Keys
      Response.Write(String.Format("{0}: '{1}'<br />", k.Key, k.Value))
    Next
    Response.Write("<br /><strong>Old</strong><br />")
    For Each o As DictionaryEntry In e.OldValues
      Response.Write(String.Format("{0}: '{1}'<br />", o.Key, o.Value))
    Next
    Response.Write("<br /><strong>new</strong><br />")
    For Each n As DictionaryEntry In e.NewValues
      Response.Write(String.Format("{0}: '{1}'<br />", n.Key, n.Value))
    Next
  End Sub


  Protected Sub GridView1_RowUpdated(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdatedEventArgs) Handles GridView1.RowUpdated
    If e.Exception Is Nothing Then
     response.Write(string.Format("Number of Records Updated: {0} <br />", e.AffectedRows)
    Else
      ' Handle exception here

      ' Stops proprogation of the exception
      e.ExceptionHandled = True
    End If
  End Sub
0
 
CmdoProg2Commented:
Opps, missing parenthesis on response statement

  Protected Sub GridView1_RowUpdated(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdatedEventArgs) Handles GridView1.RowUpdated
    If e.Exception Is Nothing Then
     response.Write(string.Format("Number of Records Updated: {0} <br />", e.AffectedRows))
    Else
      ' Handle exception here

      ' Stops proprogation of the exception
      e.ExceptionHandled = True
    End If
  End Sub
0
 
megninAuthor Commented:
I'm not sure if this is related.  On the GridView when I select "Edit Templates", there is only "EmptyDataTemplate" and "PagerTemplate".

On the FormView, there are ItemTemplate, FooterTemplate, EditItemTemplate, etc...

On the Properties of the GridView's SqlDatasource the settings are:
Behavior
DataSourceMode                      DataSet
EnableViewState                     True
Cache

CacheDuration                       Infinite
CacheExpirationPolicy               Absolute

CacheKeyDependency
EnableCaching                       False
SqlCacheDependency
Data
(Expressions)
CancelSelectOnNullParameter         True

ConflictDetection                   CompareAllValues

ConnectionString                    Data Source=BETASERVE;Initial Catalog=SigmaTools;Integrated Security=True
DeleteCommandType                   Text

DeleteQuery                         (Query)
FilterExpression
FilterParameters                    (Collection)

InsertCommandType                   Text

InsertQuery                         (Query)

OldValuesParameterFormatString      original_{0}
ProviderName

SelectCommandType                   Text

SelectQuery                         (Query)
SortParameterName

UpdateCommandType                   Text

UpdateQuery                         (Query)
Misc

(ID)                                SqlDataSource2

Here is the UpdateQuery from the Properties:

UPDATE WTP SET ReviewDateFrom = @ReviewDateFrom, ReviewDateTo = @ReviewDateTo, LastName = @LastName, FirstName = @FirstName, SSN = @SSN, Region = @Region, County = @County, OneStop = @OneStop, Unit = @Unit, Notes05 = @Notes05, CaseManagerLName = @CaseManagerLName, ReviewerName = @ReviewerName, ReviewType = @ReviewType, ReviewDate = @ReviewDate, Mandatory = @Mandatory, DateNewCase = @DateNewCase, OOSigned = @OOSigned, DateFormSigned = @DateFormSigned, AssessmentWithin30 = @AssessmentWithin30, IncludeSkills = @IncludeSkills, IRPSigned = @IRPSigned, GoalsIdentified = @GoalsIdentified, ActivitiesIdentified = @ActivitiesIdentified, HoursIdentified = @HoursIdentified, ActivitiesIncludeAnticipated = @ActivitiesIncludeAnticipated, ServicesPrivided = @ServicesPrivided, Steps = @Steps, EmploymentVerified = @EmploymentVerified, OSSTMatch = @OSSTMatch, JPR1Date = @JPR1Date, JPR1Activity = @JPR1Activity, JPR1Hours = @JPR1Hours, JPR1Date2 = @JPR1Date2, JPR1Activity2 = @JPR1Activity2, JPR1Hours2 = @JPR1Hours2, JPRHoursDoc1 = @JPRHoursDoc1, JPR2Date = @JPR2Date, JPR2Activity = @JPR2Activity, JPR2Hours = @JPR2Hours, JPR2Date2 = @JPR2Date2, JPR2Activity2 = @JPR2Activity2, JPR2Hours2 = @JPR2Hours2, JPRHoursDoc2 = @JPRHoursDoc2, JPR3Date = @JPR3Date, JPR3Activity = @JPR3Activity, JPR3Hours = @JPR3Hours, JPR3Date2 = @JPR3Date2, JPR3Activity2 = @JPR3Activity2, JPR3Hours2 = @JPR3Hours2, JPRHoursDoc3 = @JPRHoursDoc3, JPR4Date = @JPR4Date, JPR4Activity = @JPR4Activity, JPR4Hours = @JPR4Hours, JPR4Date2 = @JPR4Date2, JPR4Activity2 = @JPR4Activity2, JPR4Hours2 = @JPR4Hours2, JPRHoursDoc4 = @JPRHoursDoc4, JPR5Date = @JPR5Date, JPR5Activity = @JPR5Activity, JPR5Hours = @JPR5Hours, JPR5Date2 = @JPR5Date2, JPR5Activity2 = @JPR5Activity2, JPR5Hours2 = @JPR5Hours2, JPRHoursDoc5 = @JPRHoursDoc5, JPRWorkbooks = @JPRWorkbooks, JPRNotes = @JPRNotes, VocationalEd = @VocationalEd, WEP220HoursLess = @WEP220HoursLess, CWEPHoursLess = @CWEPHoursLess, ParticipateOver4Weeks = @ParticipateOver4Weeks, DaysBetweenStartAndReferral = @DaysBetweenStartAndReferral, MedicalNoteSigned = @MedicalNoteSigned, EvidenceOfJobContacts = @EvidenceOfJobContacts, Forms2073A_2075Completed = @Forms2073A_2075Completed, Form2279Completed = @Form2279Completed, FormAWI0002 = @FormAWI0002, RelocationMonitored = @RelocationMonitored, EmployedAtCASBApproval = @EmployedAtCASBApproval, Was2290Mailed = @Was2290Mailed, RWBContact = @RWBContact, TerminationGoodCause = @TerminationGoodCause, TwoFailures = @TwoFailures, TwoIn30 = @TwoIn30, Allowed3Days = @Allowed3Days, WTP2292Mailed = @WTP2292Mailed, ActionCaseNotesEntered = @ActionCaseNotesEntered, FinalComments = @FinalComments, ReviewDateTime = @ReviewDateTime WHERE (ReviewID = @original_ReviewID) AND (ReviewDateFrom = @original_ReviewDateFrom) AND (ReviewDateTo = @original_ReviewDateTo) AND (LastName = @original_LastName) AND (FirstName = @original_FirstName) AND (SSN = @original_SSN) AND (Region = @original_Region) AND (County = @original_County) AND (OneStop = @original_OneStop) AND (Unit = @original_Unit) AND (Notes05 = @original_Notes05) AND (CaseManagerLName = @original_CaseManagerLName) AND (ReviewerName = @original_ReviewerName) AND (ReviewType = @original_ReviewType) AND (ReviewDate = @original_ReviewDate) AND (Mandatory = @original_Mandatory) AND (DateNewCase = @original_DateNewCase) AND (OOSigned = @original_OOSigned) AND (DateFormSigned = @original_DateFormSigned) AND (AssessmentWithin30 = @original_AssessmentWithin30) AND (IncludeSkills = @original_IncludeSkills) AND (IRPSigned = @original_IRPSigned) AND (GoalsIdentified = @original_GoalsIdentified) AND (ActivitiesIdentified = @original_ActivitiesIdentified) AND (HoursIdentified = @original_HoursIdentified) AND (ActivitiesIncludeAnticipated = @original_ActivitiesIncludeAnticipated) AND (ServicesPrivided = @original_ServicesPrivided) AND (Steps = @original_Steps) AND (EmploymentVerified = @original_EmploymentVerified) AND (OSSTMatch = @original_OSSTMatch) AND (JPR1Date = @original_JPR1Date) AND (JPR1Activity = @original_JPR1Activity) AND (JPR1Hours = @original_JPR1Hours) AND (JPR1Date2 = @original_JPR1Date2) AND (JPR1Activity2 = @original_JPR1Activity2) AND (JPR1Hours2 = @original_JPR1Hours2) AND (JPRHoursDoc1 = @original_JPRHoursDoc1) AND (JPR2Date = @original_JPR2Date) AND (JPR2Activity = @original_JPR2Activity) AND (JPR2Hours = @original_JPR2Hours) AND (JPR2Date2 = @original_JPR2Date2) AND (JPR2Activity2 = @original_JPR2Activity2) AND (JPR2Hours2 = @original_JPR2Hours2) AND (JPRHoursDoc2 = @original_JPRHoursDoc2) AND (JPR3Date = @original_JPR3Date) AND (JPR3Activity = @original_JPR3Activity) AND (JPR3Hours = @original_JPR3Hours) AND (JPR3Date2 = @original_JPR3Date2) AND (JPR3Activity2 = @original_JPR3Activity2) AND (JPR3Hours2 = @original_JPR3Hours2) AND (JPRHoursDoc3 = @original_JPRHoursDoc3) AND (JPR4Date = @original_JPR4Date) AND (JPR4Activity = @original_JPR4Activity) AND (JPR4Hours = @original_JPR4Hours) AND (JPR4Date2 = @original_JPR4Date2) AND (JPR4Activity2 = @original_JPR4Activity2) AND (JPR4Hours2 = @original_JPR4Hours2) AND (JPRHoursDoc4 = @original_JPRHoursDoc4) AND (JPR5Date = @original_JPR5Date) AND (JPR5Activity = @original_JPR5Activity) AND (JPR5Hours = @original_JPR5Hours) AND (JPR5Date2 = @original_JPR5Date2) AND (JPR5Activity2 = @original_JPR5Activity2) AND (JPR5Hours2 = @original_JPR5Hours2) AND (JPRHoursDoc5 = @original_JPRHoursDoc5) AND (JPRWorkbooks = @original_JPRWorkbooks) AND (JPRNotes = @original_JPRNotes) AND (VocationalEd = @original_VocationalEd) AND (WEP220HoursLess = @original_WEP220HoursLess) AND (CWEPHoursLess = @original_CWEPHoursLess) AND (ParticipateOver4Weeks = @original_ParticipateOver4Weeks) AND (DaysBetweenStartAndReferral = @original_DaysBetweenStartAndReferral) AND (MedicalNoteSigned = @original_MedicalNoteSigned) AND (EvidenceOfJobContacts = @original_EvidenceOfJobContacts) AND (Forms2073A_2075Completed = @original_Forms2073A_2075Completed) AND (Form2279Completed = @original_Form2279Completed) AND (FormAWI0002 = @original_FormAWI0002) AND (RelocationMonitored = @original_RelocationMonitored) AND (EmployedAtCASBApproval = @original_EmployedAtCASBApproval) AND (Was2290Mailed = @original_Was2290Mailed) AND (RWBContact = @original_RWBContact) AND (TerminationGoodCause = @original_TerminationGoodCause) AND (TwoFailures = @original_TwoFailures) AND (TwoIn30 = @original_TwoIn30) AND (Allowed3Days = @original_Allowed3Days) AND (WTP2292Mailed = @original_WTP2292Mailed) AND (ActionCaseNotesEntered = @original_ActionCaseNotesEntered) AND (FinalComments = @original_FinalComments) AND (ReviewDateTime = @original_ReviewDateTime)

Are those "AND"s suppose to be there?

0
 
megninAuthor Commented:
Oh, I just got your debugging modules.  I'll double check the record names and..., but I would think that since the GridView generates all the code automatically that shouldn't be a problem unless I changed the database structure since creating the GridView.  I'll re-create the whole GridView page in case that did happen.  No real loss, it doesn't work anyway. ;-)
0
 
CmdoProg2Commented:
The "AND"s are for optimistic updates in case someone else updates the record after the your selection.


0
 
megninAuthor Commented:
Ahh.  Okay.  Well, I deleted the .aspx page and created it again from scratch.  This time instead of adding a GridView to the page and selecting a datasource, etc. I just dragged the table from the Server Explorer onto the design view and it created the GridView with all the table columns.  
Now it seems to be working.  I changed a couple of records and the database was updated.
I appreciate your help and for pointing me in the right direction.  I had found a missing data field in the table while messing with the other form and added it to the database, but I don't remember if I had created the GridView before or after that.  Looks like it could have been before the database structure change.
Anyway... Thank you and I'm going to close this question.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 13
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now