Answered by:
Update button not taking new textbox values
Question
-
User2037455357 posted
Hello there,
I have a form with a combination of textboxes and dropdowns.
I have an update button that takes the new values and updates a table via a stored proc in sql server.
I can see the dropdown values are updating fine in the table, BUT. All the text boxes are only taking original values, not user imput.
see aspx code below.
<%@ Page Title="" Language="C#" MasterPageFile="~/Master.Master" AutoEventWireup="true" CodeBehind="Client_Rep_Details.aspx.cs" Inherits="TestDropdowns.Client_Rep_Details" %> <asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server"> <script src="js/bootstrap.min.js"></script> <link href="css/bootstrap.min.css" rel="stylesheet" /> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css"> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script> <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <style> .Center { width: 100%; text-align: center; } .GridViewCenter { margin-left: auto; margin-right: auto; height: 200px; width: 800px; overflow: auto; } .Panel_SearchContract { /*padding:20pc 0px 24px 10px;*/ ; margin-left:auto; margin-right:auto; margin-top:auto; margin-bottom:auto; width: 1000px; height: 600px; background-color: white; border: 1px solid black; left: 0px; top: 0px; } .modalbackground { background-color:black; filter:alpha(opacity=90); opacity:0.6; z-index:20; } .HiddenButton { display:none; } .DropdownOverFlow { max-height:310px; height:auto; height:310px; width:300px; overflow-x: hidden; overflow-y: scroll; margin-left:auto; margin-right:auto; ; /*margin-left:52%;*/ text-align:left; /*border:solid 1px;*/ } .CheckBoxListCenter { margin-left: auto; margin-right: auto; height: 300px; width: 235px; overflow: auto; background-color:lightblue } .productsServicesList { background-color: #eeeeee; padding: 3px; border: solid 1px #bbbbbb; vertical-align: top; text-align: left; overflow: auto; height: 170px; width: 230px; } .Panel_ProductsServices { /*padding:20pc 0px 24px 10px;*/ ; /*margin-left:auto;*/ /*margin-right:auto;*/ margin:auto; width: 600px; height: 520px; background-color: white; border: 1px solid black; left: 0px; top: 0px; } </style> <script type="text/javascript"> function SearchContractPanel() { document.getElementById('<%=OpenSearchContractPanel.ClientID %>').click(); } </script> <script type="text/javascript"> function CancelContract() { document.getElementById('<%=CancelContract_bnt.ClientID %>').click(); } </script> <asp:ScriptManager ID="ScriptManager1" EnablePartialRendering="true" runat="server"></asp:ScriptManager> <asp:Panel ID="Panel_SearchContract" runat="server" DefaultButton="ClientRepDet_SearchContractPanel_btn" CssClass="Panel_SearchContract" style="display:none;"> <asp:UpdatePanel ID="UpdatePanel1" runat="server"> <ContentTemplate> <div> <table class ="Center"> <tr> <td> <br /><br /> <asp:Label ID="Label35" runat="server" Text="Search Contract" Font-Size="30" Font-Bold="True" ForeColor="#3366FF"></asp:Label> <br /> </td> </tr> <tr> <td> <br /> <asp:Button ID="ClientRepDet_SearchContractPanel_btn" runat="server" class="btn btn-primary btn-md" Text="Search" OnClick="ClientRepDet_SearchContractPanel_btn_Click"/> <asp:Button ID="ClientRepDet_CancelPanel_btn" OnClientClick="CancelContract(); return false;" runat="server" Cssclass="btn btn-primary btn-md" Text="Cancel"/> <%--<asp:LinkButton ID="RiskAssCL_LinkBtn_Comment1" OnClientClick="Comment1(); return false;" runat="server">Add/Amend Comment</asp:LinkButton>--%> <br /><br /> <asp:Label ID="ClientRepDet_SearchContractPanel_TestSQL" runat="server" ></asp:Label> <br /><br /> </td> </tr> <tr> <td> <%--LEFT COLUMN--%> <asp:Label ID="Label36" runat="server" Text="Legal Name" Width="120px" style="text-align:right;"></asp:Label> <asp:TextBox ID="ClientRepDet_SearchContract_LegalName_TxtBox" runat="server" Width="200px"></asp:TextBox> <%--MIDDLE COLUMN--%> <asp:Label ID="Label37" runat="server" Text="Analyst" Width="120px" style="text-align:right"></asp:Label> <asp:DropDownList ID="ClientRepDet_SearchContract_Analyst_DropDwnLst" runat="server" Width="200px"></asp:DropDownList> <%--RIGHT COLUMN--%> <asp:Label ID="Label38" runat="server" Text="Review Status" Width="120px" style="text-align:right"></asp:Label> <asp:DropDownList ID="ClientRepDet_SearchContract_ReviewStatad_DropDwnLst" runat="server" Width="200px" DataSourceID="ReviewStatus_DataSource" DataTextField="Review_Status" DataValueField="ID"></asp:DropDownList> <asp:SqlDataSource runat="server" ID="ReviewStatus_DataSource" ConnectionString='<%$ ConnectionStrings:Risk_AssessmentConnectionString %>' SelectCommand="SELECT [ID], [Review_Status] FROM [Repository_Review_Status]"></asp:SqlDataSource> <br /><br /> </td> </tr> <tr> <td> <%--LEFT COLUMN--%> <asp:Label ID="Label39" runat="server" Text="CW Number" Width="120px" style="text-align:right;"></asp:Label> <asp:TextBox ID="ClientRepDet_SearchContract_CwNumber_TxtBox" runat="server" Width="200px"></asp:TextBox> <%--MIDDLE COLUMN--%> <asp:Label ID="Label40" runat="server" Text="Contract Status" Width="120px" style="text-align:right"></asp:Label> <asp:DropDownList ID="ClientRepDet_SearchContract_ContractStatus_DropDwnLst" runat="server" Width="200px" DataSourceID="ContractStatus_DataSource" DataTextField="Countract_Status" DataValueField="ID"></asp:DropDownList> <asp:SqlDataSource runat="server" ID="ContractStatus_DataSource" ConnectionString='<%$ ConnectionStrings:Risk_AssessmentConnectionString %>' SelectCommand="SELECT [ID], [Countract_Status] FROM [Repository_Contract_Status]"></asp:SqlDataSource> <%--RIGHT COLUMN--%> <asp:Label ID="Label41" runat="server" Text="Reviewed By" Width="120px" style="text-align:right"></asp:Label> <asp:DropDownList ID="ClientRepDet_SearchContract_ReviewedBy_DropDwnLst" runat="server" Width="200px"></asp:DropDownList> <br /><br /> </td> </tr> <tr> <td> <%--LEFT COLUMN--%> <asp:Label ID="Label42" runat="server" Text="ICA Number" Width="120px" style="text-align:right;"></asp:Label> <asp:TextBox ID="ClientRepDet_SearchContract_ICANumber_TxtBox" runat="server" Width="200px"></asp:TextBox> <%--MIDDLE COLUMN--%> <asp:Label ID="Label43" runat="server" Text="Allocated To" Width="120px" style="text-align:right"></asp:Label> <asp:DropDownList ID="ClientRepDet_SearchContract_AllocatedTo_DropDwnLst" runat="server" Width="200px"></asp:DropDownList> <%--RIGHT COLUMN--%> <asp:Label ID="Label44" runat="server" Text="Count" Width="120px" style="text-align:right"></asp:Label> <asp:TextBox ID="ClientRepDet_SearchContract_SearchCount_TxtBox" runat="server" Width="200px"></asp:TextBox> </td> </tr> </table> </div> <br /><br /> <div class="GridViewCenter"> <%-- <div style ="height:200px; width:1000px; overflow:auto; align-content:center;">--%> <asp:GridView ID="SearchContract_GridView" runat="server" GridLines="None" Style="margin-left: auto; border-style: none; border: none; margin-right: auto" AutoGenerateColumns="false" AlternatingRowStyle-BackColor="#C2D69B"> <Columns> <asp:HyperLinkField DataTextField="Legal_Name" HeaderStyle-CssClass="text-left" ItemStyle-CssClass="text-left" DataNavigateUrlFields="Client_ID" ItemStyle-Width="450px" HeaderText="CompanyName" DataNavigateUrlFormatString="Client_Rep_Details.aspx?SearchContract_ClientId={0}" SortExpression="Legal_Name"> <HeaderStyle HorizontalAlign="Left" Font-Names="Tahoma"></HeaderStyle> </asp:HyperLinkField> <%--<asp:BoundField HeaderStyle-CssClass="text-left" ItemStyle-CssClass="text-left" DataField="User_Name" HeaderText="User_Name" ItemStyle-Width="130px" SortExpression="User_Name"></asp:BoundField>--%> <%--<asp:BoundField HeaderStyle-CssClass="text-left" ItemStyle-CssClass="text-left" DataField="Legal_Name" HeaderText="Legal_Name" ItemStyle-Width="130px" SortExpression="Legal_Name"></asp:BoundField>--%> <%--<asp:BoundField HeaderStyle-CssClass="text-left" ItemStyle-CssClass="text-left" DataField="ICA_Number" HeaderText="ICA_Number" ItemStyle-Width="130px" SortExpression="ICA_Number"></asp:BoundField>--%> <asp:BoundField HeaderStyle-CssClass="text-left" ItemStyle-CssClass="text-left" DataField="Incorporation_Number" HeaderText="Incorporation_Number" ItemStyle-Width="130px" SortExpression="Incorporation_Number"></asp:BoundField> <%--<asp:BoundField HeaderStyle-CssClass="text-left" ItemStyle-CssClass="text-left" DataField="CW_Number" HeaderText="CW_Number" ItemStyle-Width="130px" SortExpression="CW_Number"></asp:BoundField>--%> <asp:BoundField HeaderStyle-CssClass="text-left" ItemStyle-CssClass="text-left" DataField="Active_Company_Status" HeaderText="Status" ItemStyle-Width="130px" SortExpression="Active_Company_Status"></asp:BoundField> </Columns> </asp:GridView> <asp:SqlDataSource runat="server" ID="SearchContracts" ConnectionString='<%$ ConnectionStrings:Risk_AssessmentConnectionString %>' SelectCommand="SELECT [User_Name], [Legal_Name], [ICA_Number], [Incorporation_Number], [CW_Number], [Active_Company_Status], [Review_Status], [Assigned_To], [Reviewed_By], [Client_ID] FROM [vw_Repository_Clients]"></asp:SqlDataSource> </div> </ContentTemplate> </asp:UpdatePanel> </asp:Panel> <ajaxToolkit:ModalPopupExtender ID="ModalPopupExtender_SearchContract" runat="server" BackgroundCssClass="modalbackground" PopupControlID="Panel_SearchContract" TargetControlID="ClientRepDet_SearchContract_btn"></ajaxToolkit:ModalPopupExtender> <asp:Panel ID="Panel_ProductsServices" CssClass="Panel_ProductsServices" style="display:none;" runat="server"> <div style="text-align:center;"> <br /> <asp:Label ID="Label45" runat="server" Text="Products & Services" Font-Size="30" Font-Bold="True" ForeColor="#3366FF"></asp:Label> <br /> <br /> </div> <div class="DropdownOverFlow"> <asp:CheckBoxList ID="Panel_ProductsServices_ChkBoxLst" CssClass="CheckBoxListCenter" runat="server" DataSourceID="ProductsServices_DataSource" DataTextField="ProductService" DataValueField="ID"></asp:CheckBoxList> <asp:SqlDataSource runat="server" ID="ProductsServices_DataSource" ConnectionString='<%$ ConnectionStrings:KaizenSvr01ConnectionString %>' SelectCommand="SELECT [ID], [ProductService] FROM [Repository_Products_Services]"></asp:SqlDataSource> </div> <br /> <br /> <div style="text-align:center;"> <asp:Button ID="Panel_ProductsServices_Select_btn" runat="server" class="btn btn-primary btn-md" Text="Select"/> <asp:Button ID="Panel_ProductsServices_Close_btn" runat="server" class="btn btn-primary btn-md" Text="Close"/> </div> </asp:Panel> <ajaxToolkit:ModalPopupExtender ID="ModalPopupExtender_ProductsServices" runat="server" BackgroundCssClass="modalbackground" PopupControlID="Panel_ProductsServices" TargetControlID="ClientRepDet_OpenProductsServices_btn" CancelControlID="Panel_ProductsServices_Close_btn"></ajaxToolkit:ModalPopupExtender> <div class="Center" > <asp:Label ID="ClientRepDet_ClientRepository_Lbl" Font-Size="30" Font-Bold="True" ForeColor="#3366FF" runat="server" Text="Client Repository"></asp:Label> </div> <br /> <div class="Center"> <br /> <%--LEFT ADDRESS BOX--%> <asp:Button ID="ClientRepDet_SearchContract_btn" OnClientClick="SearchContractPanel(); return false;" runat="server" Text="Search Contract" CssClass="btn btn-primary btn-md" /> <asp:Button ID="OpenSearchContractPanel" CssClass="HiddenButton" runat="server" Text="Button" OnClick="ShowSearchContractPanel_Click" /> <asp:Button ID="CancelContract_bnt" CssClass="HiddenButton" runat="server" Text="Button" OnClick="HideSearchContractPanel_Click" /> <asp:Button ID="Client_Rep_Details_ClearAll_btn" runat="server" Text="Clear All" CssClass="btn btn-primary btn-md" /> <br /> <br /> </div> <br /> <br /> <div /> <div> <table class="Center"> <tr> <td> <%--RIGHT ADDRESS BOX--%> <asp:Label ID="Label22" runat="server" Text="Legal Name" Width="200px" style="text-align:right;"></asp:Label> <asp:TextBox ID="ClientRepDet_LegalName_txtbox" runat="server" Width="200px"></asp:TextBox> <%--LEFT COLUMN--%> <asp:Label ID="Label25" runat="server" Text="Contract Found" Width="200px" style="text-align:right"></asp:Label> <asp:DropDownList ID="ClientRepDet_ContractFound_DropDnLst" runat="server" Width="200px" DataSourceID="ContractFound_DataSource" DataTextField="Contract_Found" DataValueField="ID"></asp:DropDownList> <asp:SqlDataSource ID="ContractFound_DataSource" runat="server" ConnectionString="<%$ ConnectionStrings:Risk_AssessmentConnectionString %>" SelectCommand="SELECT [ID], [Contract_Found] FROM [Repository_Contract_Found]"></asp:SqlDataSource> <%--MIDDLE COLUMN--%> <asp:Label ID="Label26" runat="server" Text="Contract Termination" Width="200px" style="text-align:right"></asp:Label> <asp:DropDownList ID="ClientRepDet_ContractTermination_DropDnLst" runat="server" Width="200px" style="margin-right: 50px;" DataSourceID="ContractTermination_DataSource" DataTextField="Contract_Termination" DataValueField="ID"></asp:DropDownList> <asp:SqlDataSource ID="ContractTermination_DataSource" runat="server" ConnectionString="<%$ ConnectionStrings:Risk_AssessmentConnectionString %>" SelectCommand="SELECT [ID], [Contract_Termination] FROM [Repository_Contract_Termination]"></asp:SqlDataSource> </td> </tr> <tr> <td> <%--onserverclick="Risk_Submit_Btn_Click"--%> <asp:Label ID="Label1" runat="server" Text="Company Type" Width="200px" style="text-align:right"></asp:Label> <asp:DropDownList ID="ClientRepDet_CompanyType_DropDnLst" runat="server" Width="200px" DataSourceID="CompanyType_DataSource" DataTextField="Company_Type" DataValueField="ID"></asp:DropDownList> <asp:SqlDataSource ID="CompanyType_DataSource" runat="server" ConnectionString="<%$ ConnectionStrings:Risk_AssessmentConnectionString %>" SelectCommand="SELECT [ID], [Company_Type] FROM [Repository_Company_Type]"></asp:SqlDataSource> <%--LEFT ADDRESS BOX--%> <asp:Label ID="Label2" runat="server" Text="CW Number" Width="200px" style="text-align:right"></asp:Label> <asp:TextBox ID="ClientRepDet_CwNumber_txtbox" runat="server" Width="200px">CW Num</asp:TextBox> <%--RIGHT ADDRESS BOX--%> <asp:Label ID="Label3" runat="server" Text="If For Convenience" Width="200px" style="text-align:right"></asp:Label> <asp:DropDownList ID="ClientRepDet_IfForConvenience_DropDnLst" runat="server" Width="200px" DataTextField="For_Convenience" DataValueField="ID" DataSourceID="IfForConvenience_DataSource" style="margin-right: 50px;"></asp:DropDownList> <asp:SqlDataSource runat="server" ID="IfForConvenience_DataSource" ConnectionString='<%$ ConnectionStrings:Risk_AssessmentConnectionString %>' SelectCommand="SELECT [For_Convenience], [ID] FROM [Repository_For_Convenience]"></asp:SqlDataSource> </td> </tr> <tr> <td> <%--MIDDLE COLUMN--%> <asp:Label ID="Label4" runat="server" Text="Company Suffix" Width="200px" style="text-align:right"></asp:Label> <asp:DropDownList ID="ClientRepDet_CompanySuffix_DropDnLst" runat="server" Width="200px" DataSourceID="CompanySuffix_DataSource" DataTextField="Suffix" DataValueField="ID"></asp:DropDownList> <asp:SqlDataSource ID="CompanySuffix_DataSource" runat="server" ConnectionString="<%$ ConnectionStrings:Risk_AssessmentConnectionString %>" SelectCommand="SELECT [ID], [Suffix] FROM [Repository_Company_Suffix]"></asp:SqlDataSource> <%--LEFT ADDRESS BOX--%> <asp:Label ID="Label5" runat="server" Text="Start Date" Width="200px" style="text-align:right"></asp:Label> <asp:TextBox ID="ClientRepDet_StartDate_txtbox" runat="server" Width="200px">StartDate</asp:TextBox> <%--RIGHT ADDRESS BOX--%> <asp:Label ID="Label6" runat="server" Text="Expiry Date" Width="200px" style="text-align:right"></asp:Label> <asp:TextBox ID="ClientRepDet_ExpiryDate_txtbox" runat="server" Width="200px" style="margin-right: 50px;">Expiry Date</asp:TextBox> </td> </tr> <tr> <td> <%--LEFT COLUMN--%> <asp:Label ID="Label7" runat="server" Text="Trading Name" Width="200px" style="text-align:right"></asp:Label> <asp:TextBox ID="ClientRepDet_TradingName_txtbox" runat="server" Width="200px">trading name</asp:TextBox> <%--MIDDLE COLUMN--%> <asp:Label ID="Label8" runat="server" Text="Contract Type" Width="200px" style="text-align:right"></asp:Label> <asp:DropDownList ID="ClientRepDet_ContractType_DropDnLst" runat="server" Width="200px" DataSourceID="ContractType_DataSource" DataTextField="Contract_Type" DataValueField="ID"></asp:DropDownList> <%--onserverclick="Risk_Submit_Btn_Click"--%> <asp:SqlDataSource runat="server" ID="ContractType_DataSource" ConnectionString='<%$ ConnectionStrings:Risk_AssessmentConnectionString %>' SelectCommand="SELECT [ID], [Contract_Type] FROM [Repository_Contract_Type]"></asp:SqlDataSource> <asp:Label ID="Label9" runat="server" Text="Renewal Term" Width="200px" style="text-align:right"></asp:Label> <asp:DropDownList ID="ClientRepDet_RenewalTerm_DropDnLst" runat="server" Width="200px" Style="margin-right: 50px;" DataSourceID="RenewalTerm_DataSource" DataTextField="Renewal_Term" DataValueField="ID"></asp:DropDownList> <asp:SqlDataSource runat="server" ID="RenewalTerm_DataSource" ConnectionString='<%$ ConnectionStrings:Risk_AssessmentConnectionString %>' SelectCommand="SELECT [ID], [Renewal_Term] FROM [Repository_Renewal_Term]"></asp:SqlDataSource> </td> </tr> <tr> <td> <%--LEFT ADDRESS BOX--%> <asp:Label ID="Label10" runat="server" Text="Incorporation Number" Width="200px" style="text-align:right"></asp:Label> <asp:TextBox ID="ClientRepDet_IncorporationNumber_txtbox" runat="server" Width="200px">Incorporation NUmber</asp:TextBox> <%--RIGHT ADDRESS BOX--%> <asp:Label ID="Label11" runat="server" Text="Renewal Clause" Width="200px" style="text-align:right"></asp:Label> <asp:DropDownList ID="ClientRepDet_RenewClause_DropDnLst" runat="server" Width="200px" DataSourceID="RenewalClause_DataSource" DataTextField="Renewal_Clause" DataValueField="ID"></asp:DropDownList> <asp:SqlDataSource ID="RenewalClause_DataSource" runat="server" ConnectionString="<%$ ConnectionStrings:Risk_AssessmentConnectionString %>" SelectCommand="SELECT [ID], [Renewal_Clause] FROM [Repository_Renewal_Clause]"></asp:SqlDataSource> <%--MIDDLE COLUMN--%> <asp:Label ID="Label12" runat="server" Text="Initial Term End Date" Width="200px" style="text-align:right"></asp:Label> <asp:TextBox ID="ClientRepDet_InitialTerEndDate_txtbox" runat="server" Width="200px" style="margin-right: 50px;">Initial Term End Date</asp:TextBox> </td> </tr> <tr> <td> <%--LEFT ADDRESS BOX--%> <asp:Label ID="Label13" runat="server" Text="Date of Incorporation" Width="200px" style="text-align:right"></asp:Label> <asp:TextBox ID="ClientRepDet_DateOfIncorporation_txtbox" runat="server" Width="200px">Date of Incorporation</asp:TextBox> <%--RIGHT ADDRESS BOX--%> <asp:Label ID="Label14" runat="server" Text="Expiration Time Frame" Width="200px" style="text-align:right"></asp:Label> <asp:DropDownList ID="ClientRepDet_ExpiryFrameTime_DropDnLst" runat="server" Width="200px" DataSourceID="ExpirationTimeFrame_DataSource" DataTextField="Expiration_TimeFrame" DataValueField="ID"></asp:DropDownList> <asp:SqlDataSource ID="ExpirationTimeFrame_DataSource" runat="server" ConnectionString="<%$ ConnectionStrings:Risk_AssessmentConnectionString %>" SelectCommand="SELECT [ID], [Expiration_TimeFrame] FROM [Repository_Expiration_TimeFrame]"></asp:SqlDataSource> <%--LEFT COLUMN--%> <asp:Label ID="Label15" runat="server" Text="Contract Amendments" Width="200px" style="text-align:right"></asp:Label> <asp:DropDownList ID="ClientRepDet_ContractAmendments_DropDnLst" runat="server" Width="200px" style="margin-right: 50px;" DataSourceID="ContractAmendments_DataSource" DataTextField="Contract_Amendments" DataValueField="ID"></asp:DropDownList> <asp:SqlDataSource ID="ContractAmendments_DataSource" runat="server" ConnectionString="<%$ ConnectionStrings:Risk_AssessmentConnectionString %>" SelectCommand="SELECT [ID], [Contract_Amendments] FROM [Repository_Contract_Amendments]"></asp:SqlDataSource> <%--<asp:TextBox ID="ClientRepDet_ContractAmendments_txtbox" runat="server" Width="200px" style="margin-right: 50px;">Contract Amendments</asp:TextBox>--%> </td> </tr> <tr> <td> <%--MIDDLE COLUMN--%> <asp:Label runat="server" Text="VAT Number" Width="200px" style="text-align:right"></asp:Label> <asp:TextBox ID="ClientRepDet_VatNumber_txtbox" runat="server" Width="200px">VAT Number</asp:TextBox> <%--onserverclick="Risk_Submit_Btn_Click"--%> <asp:Label ID="Label17" runat="server" Text="ICA Number" Width="200px" style="text-align:right"></asp:Label> <asp:TextBox ID="ClientRepDet_ICANumber_txtbox" runat="server" Width="200px">ICA Number</asp:TextBox> <%--LEFT ADDRESS BOX--%> <asp:Label ID="Label18" runat="server" Text="Data Processing Agreement" Width="200px" style="text-align:right"></asp:Label> <asp:DropDownList ID="ClientRepDet_DataProcessomgAgreement_DropDnLst" runat="server" Width="200px" Style="margin-right: 50px;" DataSourceID="DataProcessingAggreement_DataSource" DataTextField="Data_Processing_Agreement" DataValueField="ID"></asp:DropDownList> <asp:SqlDataSource runat="server" ID="DataProcessingAggreement_DataSource" ConnectionString='<%$ ConnectionStrings:Risk_AssessmentConnectionString %>' SelectCommand="SELECT [ID], [Data_Processing_Agreement] FROM [Repository_Data_Processing_Agreement]"></asp:SqlDataSource> </td> </tr> <tr> <td> <%--RIGHT ADDRESS BOX--%> <asp:Label ID="Label19" runat="server" Text="BVD Number" Width="200px" style="text-align:right"></asp:Label> <asp:TextBox ID="ClientRepDet_BvDNumber_txtbox" runat="server" Width="200px">BvD Number</asp:TextBox> <%--MIDDLE COLUMN--%> <asp:Label ID="Label20" runat="server" Text="Billing Cycle" Width="200px" style="text-align:right"></asp:Label> <asp:TextBox ID="ClientRepDet_BillingCycle_txtbox" runat="server" Width="200px">Billing Cycle</asp:TextBox> <%--LEFT ADDRESS BOX--%> <asp:Label ID="Label21" runat="server" Text="Country of Incorporation" Width="200px" style="text-align:right"></asp:Label> <asp:DropDownList ID="ClientRepDet_CountryOfIncorporation" runat="server" Width="200px" Style="margin-right: 50px;" DataSourceID="CountryOfIncorporation_DataSource" DataTextField="cOUNTRY" DataValueField="ID"></asp:DropDownList> <asp:SqlDataSource runat="server" ID="CountryOfIncorporation_DataSource" ConnectionString='<%$ ConnectionStrings:Risk_AssessmentConnectionString %>' SelectCommand="SELECT [ID], [cOUNTRY] FROM [Repository_CountryOfIncorporation]"></asp:SqlDataSource> </td> </tr> <tr> <td> <%--RIGHT ADDRESS BOX--%> <asp:Label ID="Label23" runat="server" Text="Company Status" Width="200px" style="text-align:right"></asp:Label> <asp:DropDownList ID="ClientRepDet_CompanyStatus_DropDnLst" runat="server" Width="200px" DataSourceID="CompanyStatus_DataSource" DataTextField="Status" DataValueField="ID"></asp:DropDownList> <asp:SqlDataSource ID="CompanyStatus_DataSource" runat="server" ConnectionString="<%$ ConnectionStrings:Risk_AssessmentConnectionString %>" SelectCommand="SELECT [ID], [Status] FROM [Repository_Company_Status]"></asp:SqlDataSource> <%--LEFT COLUMN--%> <asp:Label ID="Label24" runat="server" Text="Nature of Business" Width="200px" style="text-align:right"></asp:Label> <asp:TextBox ID="ClientRepDet_NatureOfBusiness_txtbox" runat="server" Width="200px">Natureof Business</asp:TextBox> <%--MIDDLE COLUMN--%> <asp:Label ID="Label27" runat="server" Text="Industry Code" Width="200px" style="text-align:right"></asp:Label> <asp:TextBox ID="ClientRepDet_IndustryCode_txtbox" runat="server" Width="200px" style="margin-right: 50px;">Industry Code</asp:TextBox> </td> </tr> </table> </div> <br /><br /> <div class="Center"> <asp:Label ID="Label34" runat="server" Text="Ariba URL" Width="200px" style="text-align:right"></asp:Label> <asp:TextBox ID="ClientRepDet_AribaURL_txtbox" runat="server" Width="600px">AribaURL</asp:TextBox> <asp:Label ID="ClientRepDet_ClientID_Lbl" runat="server" Text="" CssClass="HiddenButton"></asp:Label> </div> <br /><br /> <div> <table class="Center"> <tr> <td> <asp:Label ID="Label30" runat="server" Text="Registered Address" Width="400px" style="text-align:left"></asp:Label> <asp:Label ID="Label31" runat="server" Text="Trading Address (If applicable)" Width="400px" style="text-align:left; margin-left:70px;"></asp:Label> </td> </tr> <tr> <td> <%--onserverclick="Risk_Submit_Btn_Click"--%> <asp:TextBox ID="ClientRepDet_RegisteredAddress_txtbox" runat="server" Width="400px" Height="200px" TextMode="MultiLine">Registered Addresss</asp:TextBox> <%--LEFT ADDRESS BOX--%> <asp:TextBox ID="ClientRepDet_TradingAddress_txtbox" runat="server" Width="400px" Height="200px" TextMode="MultiLine" Style="margin-left:70px;">Trading Address</asp:TextBox> </td> </tr> </table> </div> <br /><br /> <div> <table class="Center"> <tr> <td> <%--RIGHT ADDRESS BOX--%> <asp:Label ID="Label28" runat="server" Text="Previous Names / Company Names" Width="400px" style="text-align:left"></asp:Label> <%--MIDDLE COLUMN--%> <asp:Label ID="Label29" runat="server" Text="Contract Notes" Width="400px" style="text-align:left; margin-left:70px;"></asp:Label> </td> </tr> <tr> <td> <%--LEFT ADDRESS BOX--%> <asp:TextBox ID="ClientRepDet_PreviousNames_txtbox" runat="server" Width="400px" Height="200px" TextMode="MultiLine">Previous Names / Company Names</asp:TextBox> <%--RIGHT ADDRESS BOX--%> <asp:TextBox ID="ClientRepDet_ContractNotes_txtbox" runat="server" Width="400px" Height="200px" TextMode="MultiLine" Style="margin-left:70px;">Contract Notes</asp:TextBox> </td> </tr> </table> </div> <br /><br /> <div> <table class="Center" draggable="true"> <tr> <td> <%--LEFT COLUMN--%> <asp:Label ID="Label32" runat="server" Text="Audit Trail" Width="400px" style="text-align:left"></asp:Label> <%--MIDDLE COLUMN--%> <asp:Label ID="Label33" runat="server" Text="Products & Services" Width="220px" style="text-align:left; margin-left:70px;"></asp:Label> <button type="button" id="ClientRepDet_OpenProductsServices_btn" runat="server" class="btn btn-primary btn-md">Open List</button> <button type="button" id="ClientRepDet_RestsetProducts_btn" runat="server" class="btn btn-primary btn-md">Reset List</button> <%--onserverclick="Risk_Submit_Btn_Click"--%> </td> </tr> <tr> <td> <%--LEFT ADDRESS BOX--%> <asp:TextBox ID="ClientRepDet_AuditTrail_txtbox" runat="server" Width="400px" Height="200px" TextMode="MultiLine">Audit Trail</asp:TextBox> <%--RIGHT ADDRESS BOX--%> <asp:TextBox ID="ClientRepDet_ProductsServices_txtbox" runat="server" Width="400px" Height="200px" TextMode="MultiLine" Style="margin-left:70px;">Products & Services</asp:TextBox> </td> </tr> </table> </div> <div class="Center"> <br /> <asp:Button id="ClientRepDet_Update_btn" runat="server" Text="Update" onclick="ClientRepDet_Update_btn_Click" CssClass="btn btn-primary btn-md"/> <asp:Button id="ClientRepDet_OnHold_btn" runat="server" Text="On Hold" onclick="ClientRepDet_OnHold_btn_Click" CssClass="btn btn-primary btn-md"/> <asp:Button id="ClientRepDet_QA_btn" runat="server" Text="Quality Assurance" CssClass="btn btn-primary btn-md"/> <br /> <br /> </div> </asp:Content>now see the update C# code that I am referring to.
using System; using System.Windows; using System.Windows.Controls; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Data; using System.Windows.Forms; using System.Web.UI.WebControls; using System.Data.SqlClient; using System.Globalization; using System.Drawing; using System.Activities.Expressions; using System.Web.Services; namespace TestDropdowns { public partial class Client_Rep_Details : System.Web.UI.Page { // Database connections string from web.Config Risk_AssessmentConnectionString SqlConnection DBconnection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["Risk_AssessmentConnectionString"].ToString()); public static int Client_ID = 0; public static string LegalName; public static string CompanyType; public static string CompanySuffix; public static string TradingName; public static string IncorporationNumber; public static DateTime DateofCorporation; public static string VatNumber; public static string BvDNumber; public static string CompanyStatus; public static string ContractFound; public static string CWNumber; public static DateTime StartDate; public static string ContractType; public static string RenewalClause; public static string ExpirationTimeFrame; public static string ICANumber; public static string BillingCycle; public static string NatureOfBusiness; public static string ContractTermination; public static string IfForConvenience; public static DateTime ExpiryDate; public static string RenewalTerm; public static DateTime InitialTermEndDate; public static string ContractAmendments_ID; public static string DataProcessingAgreement; public static string CountryOfIncorporation; public static string IndustryCode; public static string AriblaURL; //MULTILINE TEXTBOXES//////////////////////////////// public static string RegisteredAddress; public static string TradingAddress; public static string PreviousNames; public static string ContractNotes; public static string AuditTrail; public static string ProductsServices; ////////////////////////////////////////////// public static string ProductServicesSELECTED; // comma delimited ( 1,2,4,6,7,9 ) public static string[] Arr_Products_Services; // Array to store products and services selected public void Populate_SearchContract_GridView(string SqlStatment) { using (SqlConnection DBconnection2 = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["Risk_AssessmentConnectionString"].ToString())) { //string RA_Select = "SELECT [User_Name], [Legal_Name], [ICA_Number], [Incorporation_Number], [CW_Number], [Active_Company_Status], [Review_Status], [Assigned_To], [Reviewed_By], [Client_ID] FROM [vw_Repository_Clients] where [User_ID] = " + Index.UserID + " ORDER BY [Updated_Date] desc"; // User can only see there own Risk Assessments string RA_Select = SqlStatment; DataSet ds = new DataSet(); DataTable PStable = new DataTable(); String SqlQuery = RA_Select; SqlDataAdapter Adapter = new SqlDataAdapter(SqlQuery, DBconnection2); Adapter.Fill(ds, "Accounts"); PStable = ds.Tables[0]; DataView view = new DataView(PStable.DefaultView.ToTable()); SearchContract_GridView.DataSource = null; SearchContract_GridView.DataSource = view; SearchContract_GridView.DataBind(); ClientRepDet_SearchContractPanel_TestSQL.Text = PStable.Rows.Count.ToString() + " Contracts Found"; Adapter.Dispose(); } } public string ContractSearchSQLstring(string LegalName, string CWnumber, string ICAnumber, string Analyst, string Status, string ReviewStatus, string ReviewedBy) { string SQL_Select = "SELECT [User_Name], [Legal_Name], [ICA_Number], [Incorporation_Number], [CW_Number], [Active_Company_Status], [Review_Status], [Assigned_To], [Reviewed_By], [Client_ID] FROM [vw_Repository_Clients] "; string SQL_Where = ""; string SQL_And = ""; bool Others = false; if (LegalName == null) { LegalName = ""; } if (CWnumber == null) { CWnumber = ""; } if (ICAnumber == null) { ICAnumber = ""; } if (Analyst == null) { Analyst = ""; } if (Status == "Select" || Status == null) { Status = ""; } if (ReviewStatus == "Select" || ReviewStatus == null) { ReviewStatus = ""; } if (ReviewedBy == "Select" || ReviewedBy == null) { ReviewedBy = ""; } int LegalNameLen = LegalName.Length; int CWnumberLen = CWnumber.Length; int ICAnumberLen = ICAnumber.Length; int AnalystLen = Analyst.Length; int StatusLen = Status.Length; int ReviewStatusLen = ReviewStatus.Length; int ReviewedByLen = ReviewedBy.Length; // LEGAL NAME IF if (LegalNameLen > 0) { SQL_Where = "WHERE [Legal_Name] LIKE '%" + LegalName + "%' "; Others = true; } // CW NUMBER IF if ((CWnumberLen > 0) && (Others == true)) { SQL_And = SQL_And + "AND [CW_Number] LIKE '%" + CWnumber + "%' "; } else if ((CWnumberLen > 0) && (Others == false)) { SQL_Where = "WHERE [CW_Number] LIKE '%" + CWnumber + "%' "; Others = true; } // ICA Number IF if ((ICAnumberLen > 0) && (Others == true)) { SQL_And = SQL_And + "AND [ICA_Number] LIKE '%" + ICAnumber + "%' "; } else if ((ICAnumberLen > 0) && (Others == false)) { SQL_Where = "WHERE [ICA_Number] LIKE '%" + ICAnumber + "%' "; Others = true; } // Analyst IF if ((AnalystLen > 0) && (Others == true)) { SQL_And = SQL_And + "AND [Analyst] = " + Analyst; } else if ((AnalystLen > 0) && (Others == false)) { SQL_Where = "WHERE [Analyst] = " + Analyst ; Others = true; } // Status IF if ((StatusLen > 0) && (Others == true)) { SQL_And = SQL_And + "AND [Active_Company_Status_ID] = " + Status ; } else if ((StatusLen > 0) && (Others == false)) { SQL_Where = "WHERE [Active_Company_Status_ID] = " + Status; Others = true; } // Review Status IF if ((ReviewStatusLen > 0) && (Others == true)) { SQL_And = SQL_And + "AND [Review_Status] '" + ReviewStatus + "' "; } else if ((ReviewStatusLen > 0) && (Others == false)) { SQL_Where = "WHERE [Review_Status] = '" + ReviewStatus + "' "; Others = true; } // Reviewed By IF if ((ReviewedByLen > 0) && (Others == true)) { SQL_And = SQL_And + "AND [Reviewed_By] = '" + ReviewedBy + "' "; } else if ((ReviewedByLen > 0) && (Others == false)) { SQL_Where = "WHERE [Reviewed_By] = '" + ReviewedBy + "'' "; Others = true; } if(Others == true) { SQL_Select = SQL_Select + SQL_Where + SQL_And; } else { SQL_Select = SQL_Select + SQL_Where; } int UserID = 1; if ((LegalNameLen == 0) && (CWnumberLen == 0) && (ICAnumberLen == 0) && (AnalystLen == 0) && (StatusLen == 0) && (ReviewStatusLen == 0) && (ReviewedByLen == 0)) { SQL_Select = "SELECT [User_Name], [Legal_Name], [ICA_Number], [Incorporation_Number], [CW_Number], [Active_Company_Status], [Review_Status], [Assigned_To], [Reviewed_By], [Client_ID] FROM [vw_Repository_Clients] WHERE [User_ID] = " + UserID + " ORDER BY [Updated_Date] desc"; return SQL_Select; } else { //return SQL_Select + " AND [User_ID] = " + Index.UserID + " ORDER BY [Updated_Date] desc"; return SQL_Select + " AND [User_ID] = " + UserID + " ORDER BY [Updated_Date] desc"; } } protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["SearchContract_ClientId"] != null) { Client_ID = Convert.ToInt16(Request.QueryString["SearchContract_ClientId"]); string SQL_Clients = "SELECT * FROM [dbo].[Repository_Clients] WHERE [Client_ID] = " + Client_ID; using(DBconnection) { string CheckIsNull(string IsStringNull) { if (IsStringNull == null) { IsStringNull = ""; } return IsStringNull; } DBconnection.Open(); SqlCommand SqlCommand_Sql_Clients = new SqlCommand(SQL_Clients, DBconnection); SqlDataReader DataReader_Sql_Clients = SqlCommand_Sql_Clients.ExecuteReader(); DataReader_Sql_Clients.Read(); int Client_ID = Convert.ToInt16(DataReader_Sql_Clients["Company_Type_ID"]); string CompanyType_ID = DataReader_Sql_Clients["Company_Type_ID"].ToString(); // done string CompanySuffix_ID = DataReader_Sql_Clients["Company_Suffix_ID"].ToString(); // done string ActiveCompanyStatus_ID = DataReader_Sql_Clients["Active_Company_Status_ID"].ToString(); // done string ContractFound_ID = DataReader_Sql_Clients["Contract_Found_ID"].ToString(); // done string ContractType_ID = DataReader_Sql_Clients["Contract_Type_ID"].ToString(); // done string RenewalClause_ID = DataReader_Sql_Clients["Renewal_Clause_ID"].ToString(); //Done string ExpirationTimeFrame_ID = DataReader_Sql_Clients["Expiration_Time_Frame_ID"].ToString(); string ContractTermination_ID = DataReader_Sql_Clients["Termination_ID"].ToString(); //done string IfForConvenience_ID = DataReader_Sql_Clients["If_For_Convenience_ID"].ToString(); //done string ContractAmendments_ID = DataReader_Sql_Clients["Contract_Amendments_ID"].ToString(); // done string CountryOFIncorporation_ID = DataReader_Sql_Clients["Country_Of_Incorporation_ID"].ToString(); // done string DataProcessingAgreement_ID = DataReader_Sql_Clients["Data_Processing_Aggreement_ID"].ToString(); // done // DROP DOWNS ClientRepDet_ClientID_Lbl.Text = Client_ID.ToString(); ClientRepDet_CompanyType_DropDnLst.SelectedValue = CompanyType_ID; ClientRepDet_CompanySuffix_DropDnLst.SelectedValue = CompanySuffix_ID; ClientRepDet_CountryOfIncorporation.SelectedValue = CountryOFIncorporation_ID; ClientRepDet_CompanyStatus_DropDnLst.SelectedValue = ActiveCompanyStatus_ID; ClientRepDet_ContractFound_DropDnLst.SelectedValue = ContractFound_ID; ClientRepDet_ContractType_DropDnLst.SelectedValue = ContractType_ID; ClientRepDet_RenewClause_DropDnLst.SelectedValue = RenewalClause_ID; ClientRepDet_ContractTermination_DropDnLst.SelectedValue = ContractTermination_ID; ClientRepDet_IfForConvenience_DropDnLst.SelectedValue = IfForConvenience_ID; ClientRepDet_ContractAmendments_DropDnLst.SelectedValue = ContractAmendments_ID; ClientRepDet_ExpiryFrameTime_DropDnLst.SelectedValue = ExpirationTimeFrame_ID; ClientRepDet_DataProcessomgAgreement_DropDnLst.SelectedValue = DataProcessingAgreement_ID; // TEXT BOXES ClientRepDet_LegalName_txtbox.Text = CheckIsNull(DataReader_Sql_Clients["Legal_Name"].ToString()); ClientRepDet_TradingName_txtbox.Text = CheckIsNull(DataReader_Sql_Clients["Trading_Name"].ToString()); ClientRepDet_IncorporationNumber_txtbox.Text = CheckIsNull(DataReader_Sql_Clients["Incorporation_Number"].ToString()); ClientRepDet_ICANumber_txtbox.Text = CheckIsNull(DataReader_Sql_Clients["ICA_Number"].ToString()); ClientRepDet_BvDNumber_txtbox.Text = CheckIsNull(DataReader_Sql_Clients["BVD_ID"].ToString()); ClientRepDet_DateOfIncorporation_txtbox.Text = CheckIsNull(DataReader_Sql_Clients["Commencement_Date"].ToString()); ClientRepDet_CompanyStatus_DropDnLst.SelectedValue = DataReader_Sql_Clients["Active_Company_Status_ID"].ToString(); ClientRepDet_VatNumber_txtbox.Text = CheckIsNull(DataReader_Sql_Clients["VAT_Number"].ToString()); ClientRepDet_CwNumber_txtbox.Text = CheckIsNull(DataReader_Sql_Clients["CW_Number"].ToString()); ClientRepDet_NatureOfBusiness_txtbox.Text = CheckIsNull(DataReader_Sql_Clients["Nature_of_Business"].ToString()); ClientRepDet_ExpiryDate_txtbox.Text = CheckIsNull(DataReader_Sql_Clients["Expiration_Date"].ToString()); ClientRepDet_RenewalTerm_DropDnLst.SelectedValue = CheckIsNull(DataReader_Sql_Clients["Renewal_Term_ID"].ToString()); ClientRepDet_InitialTerEndDate_txtbox.Text = CheckIsNull(DataReader_Sql_Clients["Initial_Term_End_Date"].ToString()); ClientRepDet_IndustryCode_txtbox.Text = CheckIsNull(DataReader_Sql_Clients["Industry_Code"].ToString()); ClientRepDet_AribaURL_txtbox.Text = CheckIsNull(DataReader_Sql_Clients["Ariba_URL"].ToString()); ClientRepDet_RegisteredAddress_txtbox.Text = CheckIsNull(DataReader_Sql_Clients["Registered_Office_Address"].ToString()); ClientRepDet_TradingAddress_txtbox.Text = CheckIsNull(DataReader_Sql_Clients["Trading_Office_Address"].ToString()); ClientRepDet_PreviousNames_txtbox.Text = CheckIsNull(DataReader_Sql_Clients["Previous_Legal_Name"].ToString()); ClientRepDet_ContractNotes_txtbox.Text = CheckIsNull(DataReader_Sql_Clients["Contract_Notes"].ToString()); /* */ } } } protected void ShowSearchContractPanel_Click(object sender, EventArgs e) { ModalPopupExtender_SearchContract.Show(); //Populate_SearchContract_GridView(ContractSearchSQLstring(ClientRepDet_SearchContract_LegalName_TxtBox.Text, ClientRepDet_SearchContract_CwNumber_TxtBox.Text, ClientRepDet_SearchContract_ICANumber_TxtBox.Text, ClientRepDet_SearchContract_Analyst_DropDwnLst.Text, ClientRepDet_SearchContract_ContractStatus_DropDwnLst.Text, ClientRepDet_SearchContract_ReviewStatad_DropDwnLst.SelectedValue, ClientRepDet_SearchContract_ReviewedBy_DropDwnLst.SelectedValue)); Populate_SearchContract_GridView(ContractSearchSQLstring("","","","","","","")); // All contracts will LOAD } protected void HideSearchContractPanel_Click(object sender, EventArgs e) { ModalPopupExtender_SearchContract.Hide(); } protected void ClientRepDet_SearchContractPanel_btn_Click(object sender, EventArgs e) { //ContractSearchSQLstring(string LegalName, string CWnumber, string ICAnumber //, string Analyst, string Status, string ReviewStatus, string ReviewedBy) using(DBconnection) { Populate_SearchContract_GridView(ContractSearchSQLstring(ClientRepDet_SearchContract_LegalName_TxtBox.Text.ToString(), ClientRepDet_SearchContract_CwNumber_TxtBox.Text.ToString(), ClientRepDet_SearchContract_ICANumber_TxtBox.Text.ToString(), "", ClientRepDet_SearchContract_ContractStatus_DropDwnLst.SelectedItem.ToString(), ClientRepDet_SearchContract_ReviewStatad_DropDwnLst.SelectedItem.ToString(),"")); //Populate_SearchContract_GridView(ContractSearchSQLstring(ClientRepDet_SearchContract_LegalName_TxtBox.Text, ClientRepDet_SearchContract_CwNumber_TxtBox.Text, ClientRepDet_SearchContract_ICANumber_TxtBox.Text, ClientRepDet_SearchContract_Analyst_DropDwnLst.SelectedItem.ToString(), ClientRepDet_SearchContract_ContractStatus_DropDwnLst.SelectedItem.ToString(), ClientRepDet_SearchContract_ReviewStatad_DropDwnLst.SelectedItem.ToString(),"")); //Populate_SearchContract_GridView(ContractSearchSQLstring(ClientRepDet_SearchContract_LegalName_TxtBox.Text, ClientRepDet_SearchContract_CwNumber_TxtBox.Text, ClientRepDet_SearchContract_ICANumber_TxtBox.Text, ClientRepDet_SearchContract_Analyst_DropDwnLst.SelectedItem.ToString(), ClientRepDet_SearchContract_ContractStatus_DropDwnLst.SelectedItem.ToString(), ClientRepDet_SearchContract_ReviewStatad_DropDwnLst.SelectedItem.ToString(), ClientRepDet_SearchContract_ReviewedBy_DropDwnLst.SelectedItem.ToString())); // TEST SQL STATEMENT OUTPUT TO LABEL // ClientRepDet_SearchContractPanel_TestSQL.Text = ContractSearchSQLstring(ClientRepDet_SearchContract_LegalName_TxtBox.Text.ToString(), ClientRepDet_SearchContract_CwNumber_TxtBox.Text.ToString(), ClientRepDet_SearchContract_ICANumber_TxtBox.Text.ToString(), "", ClientRepDet_SearchContract_ContractStatus_DropDwnLst.SelectedItem.ToString(), ClientRepDet_SearchContract_ReviewStatad_DropDwnLst.SelectedItem.ToString(), ""); } } protected void ClientRepDet_Update_btn_Click(object sender, EventArgs e) { using (SqlConnection DBconnection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["Risk_AssessmentConnectionString"].ToString())) { SqlCommand UpdateClient = new SqlCommand("[dbo].[usp_UpdateClient]", DBconnection); DBconnection.Open(); UpdateClient.CommandType = System.Data.CommandType.StoredProcedure; //UpdateClient.Parameters.Add("@Client_ID", System.Data.SqlDbType.Int); //UpdateClient.Parameters["@Client_ID"].Value = Convert.ToInt32(ClientRepDet_ClientID_Lbl.ToString()); //UpdateClient.Parameters.Add("@UserID", System.Data.SqlDbType.Int); //UpdateClient.Parameters["@UserID"].Value = 1; //Index.UserID; /* UpdateClient.Parameters.Add("@Company_Type_ID", System.Data.SqlDbType.Int); UpdateClient.Parameters["@Company_Type_ID"].Value = Convert.ToUInt16(ClientRepDet_CompanyType_DropDnLst.SelectedValue); UpdateClient.Parameters.Add("@Company_Suffix_ID", System.Data.SqlDbType.Int); UpdateClient.Parameters["@Company_Suffix_ID"].Value = Convert.ToUInt16(ClientRepDet_CompanySuffix_DropDnLst.SelectedValue); UpdateClient.Parameters.Add("@Country_Of_Incorporation_ID", System.Data.SqlDbType.NVarChar); UpdateClient.Parameters["@Country_Of_Incorporation_ID"].Value = Convert.ToUInt16(ClientRepDet_CountryOfIncorporation.SelectedValue); UpdateClient.Parameters.Add("@Active_Company_Status_ID", System.Data.SqlDbType.Int); UpdateClient.Parameters["@Active_Company_Status_ID"].Value = Convert.ToUInt16(ClientRepDet_CompanyStatus_DropDnLst.SelectedValue); UpdateClient.Parameters.Add("@Contract_Found_ID", System.Data.SqlDbType.Int); UpdateClient.Parameters["@Contract_Found_ID"].Value = Convert.ToUInt16(ClientRepDet_ContractFound_DropDnLst.SelectedValue); UpdateClient.Parameters.Add("@Expiration_Time_Frame_ID", System.Data.SqlDbType.Int); UpdateClient.Parameters["@Expiration_Time_Frame_ID"].Value = Convert.ToUInt16(ClientRepDet_ExpiryFrameTime_DropDnLst.SelectedValue); UpdateClient.Parameters.Add("@Renewal_Clause_ID", System.Data.SqlDbType.Int); UpdateClient.Parameters["@Renewal_Clause_ID"].Value = Convert.ToUInt16(ClientRepDet_RenewClause_DropDnLst.SelectedValue); UpdateClient.Parameters.Add("@Renewal_Term_ID", System.Data.SqlDbType.Int); UpdateClient.Parameters["@Renewal_Term_ID"].Value = Convert.ToUInt16(ClientRepDet_RenewalTerm_DropDnLst.SelectedValue); UpdateClient.Parameters.Add("@Termination_ID", System.Data.SqlDbType.Int); UpdateClient.Parameters["@Termination_ID"].Value = Convert.ToUInt16(ClientRepDet_ContractTermination_DropDnLst.SelectedValue); UpdateClient.Parameters.Add("@If_For_Convenience_ID", System.Data.SqlDbType.Int); UpdateClient.Parameters["@If_For_Convenience_ID"].Value = Convert.ToUInt16(ClientRepDet_IfForConvenience_DropDnLst.SelectedValue); UpdateClient.Parameters.Add("@Contract_Type_ID", System.Data.SqlDbType.Int); UpdateClient.Parameters["@Contract_Type_ID"].Value = Convert.ToUInt16(ClientRepDet_ContractType_DropDnLst.SelectedValue); UpdateClient.Parameters.Add("@Data_Processing_Aggreement_ID", System.Data.SqlDbType.Int); // Needs looking at UpdateClient.Parameters["@Data_Processing_Aggreement_ID"].Value = Convert.ToUInt16(ClientRepDet_DataProcessomgAgreement_DropDnLst.SelectedValue); UpdateClient.Parameters.Add("@Contract_Amendments_ID", System.Data.SqlDbType.Int); UpdateClient.Parameters["@Contract_Amendments_ID"].Value = Convert.ToUInt16(ClientRepDet_ContractAmendments_DropDnLst.SelectedValue); */ UpdateClient.Parameters.Add("@Legal_Name", System.Data.SqlDbType.NVarChar); UpdateClient.Parameters["@Legal_Name"].Value = ClientRepDet_LegalName_txtbox.Text.ToString(); UpdateClient.Parameters.Add("@Trading_Name", System.Data.SqlDbType.NVarChar); UpdateClient.Parameters["@Trading_Name"].Value = ClientRepDet_TradingName_txtbox.Text.ToString(); UpdateClient.Parameters.Add("@Incorporation_Number", System.Data.SqlDbType.NVarChar); UpdateClient.Parameters["@Incorporation_Number"].Value = ClientRepDet_IncorporationNumber_txtbox.Text.ToString(); UpdateClient.Parameters.Add("@ICA_Number", System.Data.SqlDbType.NVarChar); UpdateClient.Parameters["@ICA_Number"].Value = ClientRepDet_SearchContract_ICANumber_TxtBox.Text.ToString(); UpdateClient.Parameters.Add("@Previous_Legal_Name", System.Data.SqlDbType.NVarChar); UpdateClient.Parameters["@Previous_Legal_Name"].Value = ClientRepDet_PreviousNames_txtbox.Text.ToString(); UpdateClient.Parameters.Add("@BVD_Number", System.Data.SqlDbType.NVarChar); UpdateClient.Parameters["@BVD_Number"].Value = ClientRepDet_BvDNumber_txtbox.Text.ToString(); UpdateClient.Parameters.Add("@Registered_Office_Address", System.Data.SqlDbType.NVarChar); UpdateClient.Parameters["@Registered_Office_Address"].Value = ClientRepDet_RegisteredAddress_txtbox.Text.ToString(); UpdateClient.Parameters.Add("@Trading_Office_Address", System.Data.SqlDbType.NVarChar); UpdateClient.Parameters["@Trading_Office_Address"].Value = ClientRepDet_TradingAddress_txtbox.Text.ToString(); UpdateClient.Parameters.Add("@Nature_Of_Business", System.Data.SqlDbType.NVarChar); UpdateClient.Parameters["@Nature_Of_Business"].Value = ClientRepDet_NatureOfBusiness_txtbox.Text.ToString(); UpdateClient.Parameters.Add("@Industry_Code", System.Data.SqlDbType.NVarChar); UpdateClient.Parameters["@Industry_Code"].Value = ClientRepDet_IndustryCode_txtbox.Text.ToString(); UpdateClient.Parameters.Add("@Expiration_Date", System.Data.SqlDbType.NVarChar); UpdateClient.Parameters["@Expiration_Date"].Value = ClientRepDet_ExpiryDate_txtbox.Text.ToString(); UpdateClient.Parameters.Add("@Expiration_Date_Required_Time_Frame", System.Data.SqlDbType.NVarChar); UpdateClient.Parameters["@Expiration_Date_Required_Time_Frame"].Value = ClientRepDet_ExpiryFrameTime_DropDnLst.SelectedItem.ToString(); //////UpdateClient.Parameters.Add("@Duration_of_Contract", System.Data.SqlDbType.NVarChar); //////UpdateClient.Parameters["@Duration_of_Contract"].Value = ClientRepDet_ ////UpdateClient.Parameters.Add("@Ariba_Error", System.Data.SqlDbType.NVarChar); ////UpdateClient.Parameters["@Ariba_Error"].Value = ClientRepDet_AribaURL_txtbox.ToString(); UpdateClient.Parameters.Add("@Initial_Term_End_Date", System.Data.SqlDbType.NVarChar); UpdateClient.Parameters["@Initial_Term_End_Date"].Value = ClientRepDet_InitialTerEndDate_txtbox.Text.ToString(); //UpdateClient.Parameters.Add("@Product_Services_Offered", System.Data.SqlDbType.Int); //UpdateClient.Parameters["@Product_Services_Offered"].Value = Index.UserID; UpdateClient.Parameters.Add("@Billing_Cycle", System.Data.SqlDbType.NVarChar); UpdateClient.Parameters["@Billing_Cycle"].Value = ClientRepDet_BillingCycle_txtbox.Text.ToString(); UpdateClient.Parameters.Add("@VAT_Number", System.Data.SqlDbType.NVarChar); UpdateClient.Parameters["@VAT_Number"].Value = ClientRepDet_VatNumber_txtbox.Text.ToString(); UpdateClient.Parameters.Add("@CW_Number", System.Data.SqlDbType.NVarChar); UpdateClient.Parameters["@CW_Number"].Value = ClientRepDet_CwNumber_txtbox.Text.ToString(); UpdateClient.Parameters.Add("@Ariba_URL", System.Data.SqlDbType.NVarChar); UpdateClient.Parameters["@Ariba_URL"].Value = ClientRepDet_AribaURL_txtbox.Text.ToString(); //UpdateClient.Parameters.Add("@Notes", System.Data.SqlDbType.Int); //UpdateClient.Parameters["@Notes"].Value = ClientRepDet_ContractNotes_txtbox.Text.ToString(); UpdateClient.Parameters.Add("@Contract_Notes", System.Data.SqlDbType.NVarChar); UpdateClient.Parameters["@Contract_Notes"].Value = ClientRepDet_ContractNotes_txtbox.Text.ToString(); //UpdateClient.Parameters.Add("@Review_Status", System.Data.SqlDbType.Int); //UpdateClient.Parameters["@Review_Status"].Value = ClientRepDet_SearchContract_ReviewStatad_DropDwnLst.SelectedValue; UpdateClient.ExecuteReader(); } } protected void ClientRepDet_OnHold_btn_Click(object sender,EventArgs e) { using (SqlConnection DBconnection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["Risk_AssessmentConnectionString"].ToString())) { SqlCommand OnHoldClient = new SqlCommand("[dbo].[usp_UpdateClient]", DBconnection); OnHoldClient.CommandType = System.Data.CommandType.StoredProcedure; OnHoldClient.Parameters.Add("@UserID", System.Data.SqlDbType.Int); OnHoldClient.Parameters["@UserID"].Value = Index.UserID; OnHoldClient.Parameters.Add("@Legal_Name", System.Data.SqlDbType.Int); OnHoldClient.Parameters["@Legal_Name"].Value = ClientRepDet_LegalName_txtbox.Text.ToString(); OnHoldClient.Parameters.Add("@Company_Type_ID", System.Data.SqlDbType.Int); OnHoldClient.Parameters["@Company_Type_ID"].Value = Convert.ToUInt16(ClientRepDet_CompanyType_DropDnLst.SelectedItem); OnHoldClient.Parameters.Add("@Company_Suffix_ID", System.Data.SqlDbType.Int); OnHoldClient.Parameters["@Company_Suffix_ID"].Value = Convert.ToUInt16(ClientRepDet_CompanySuffix_DropDnLst.SelectedItem); OnHoldClient.Parameters.Add("@Trading_Name", System.Data.SqlDbType.Int); OnHoldClient.Parameters["@Trading_Name"].Value = ClientRepDet_TradingName_txtbox.Text.ToString(); OnHoldClient.Parameters.Add("@Incorporation_Number", System.Data.SqlDbType.Int); OnHoldClient.Parameters["@Incorporation_Number"].Value = ClientRepDet_IncorporationNumber_txtbox.Text.ToString(); OnHoldClient.Parameters.Add("@ICA_Number", System.Data.SqlDbType.Int); OnHoldClient.Parameters["@ICA_Number"].Value = Index.UserID; /// OnHoldClient.Parameters.Add("@Country_Of_Incorporation_ID", System.Data.SqlDbType.Int); /// OnHoldClient.Parameters["@Country_Of_Incorporation_ID"].Value = ClientRepDet_IncorporationNumber_txtbox.Text.ToString(); OnHoldClient.Parameters.Add("@Previous_Legal_Name", System.Data.SqlDbType.Int); OnHoldClient.Parameters["@Previous_Legal_Name"].Value = ClientRepDet_PreviousNames_txtbox.Text.ToString(); OnHoldClient.Parameters.Add("@BVD_Number", System.Data.SqlDbType.Int); OnHoldClient.Parameters["@BVD_Number"].Value = ClientRepDet_BvDNumber_txtbox.Text.ToString(); OnHoldClient.Parameters.Add("@Registered_Office_Address", System.Data.SqlDbType.Int); OnHoldClient.Parameters["@Registered_Office_Address"].Value = ClientRepDet_RegisteredAddress_txtbox.Text.ToString(); OnHoldClient.Parameters.Add("@Trading_Office_Address", System.Data.SqlDbType.Int); OnHoldClient.Parameters["@Trading_Office_Address"].Value = ClientRepDet_TradingAddress_txtbox.Text.ToString(); OnHoldClient.Parameters.Add("@Nature_Of_Business", System.Data.SqlDbType.Int); OnHoldClient.Parameters["@Nature_Of_Business"].Value = ClientRepDet_NatureOfBusiness_txtbox.Text.ToString(); OnHoldClient.Parameters.Add("@Active_Company_Status_ID", System.Data.SqlDbType.Int); OnHoldClient.Parameters["@Active_Company_Status_ID"].Value = Convert.ToUInt16(ClientRepDet_CompanyStatus_DropDnLst.SelectedItem); OnHoldClient.Parameters.Add("@Industry_Code", System.Data.SqlDbType.Int); OnHoldClient.Parameters["@Industry_Code"].Value = Index.UserID; OnHoldClient.Parameters.Add("@Contract_Found_ID", System.Data.SqlDbType.Int); OnHoldClient.Parameters["@Industry_Code"].Value = ClientRepDet_IndustryCode_txtbox.Text.ToString(); OnHoldClient.Parameters.Add("@Expiration_Time_Frame_ID", System.Data.SqlDbType.Int); OnHoldClient.Parameters["@Expiration_Time_Frame_ID"].Value = Convert.ToUInt16(ClientRepDet_ExpiryFrameTime_DropDnLst.SelectedItem); OnHoldClient.Parameters.Add("@Expiration_Date", System.Data.SqlDbType.Int); OnHoldClient.Parameters["@Expiration_Date"].Value = ClientRepDet_ExpiryDate_txtbox.Text.ToString(); OnHoldClient.Parameters.Add("@Expiration_Date_Required_Time_Frame", System.Data.SqlDbType.Int); OnHoldClient.Parameters["@Expiration_Date_Required_Time_Frame"].Value = Convert.ToUInt16(ClientRepDet_ExpiryFrameTime_DropDnLst.SelectedItem); OnHoldClient.Parameters.Add("@Duration_of_Contract", System.Data.SqlDbType.Int); OnHoldClient.Parameters["@Duration_of_Contract"].Value = Index.UserID; OnHoldClient.Parameters.Add("@Renewal_Clause_ID", System.Data.SqlDbType.Int); OnHoldClient.Parameters["@Renewal_Clause_ID"].Value = Convert.ToUInt16(ClientRepDet_RenewClause_DropDnLst.SelectedItem); // OnHoldClient.Parameters.Add("@Renewal_Term_ID", System.Data.SqlDbType.Int); // OnHoldClient.Parameters["@Renewal_Term_ID"].Value = Index.UserID; //OnHoldClient.Parameters.Add("@Ariba_Error", System.Data.SqlDbType.Int); //OnHoldClient.Parameters["@Ariba_Error"].Value = Index.UserID; OnHoldClient.Parameters.Add("@Initial_Term_End_Date", System.Data.SqlDbType.Int); OnHoldClient.Parameters["@Initial_Term_End_Date"].Value = ClientRepDet_InitialTerEndDate_txtbox.Text.ToString(); // OnHoldClient.Parameters.Add("@Termination_ID", System.Data.SqlDbType.Int); // OnHoldClient.Parameters["@Termination_ID"].Value = Index.UserID; // OnHoldClient.Parameters.Add("@If_For_Convenience_ID", System.Data.SqlDbType.Int); // OnHoldClient.Parameters["@If_For_Convenience_ID"].Value = Index.UserID; // OnHoldClient.Parameters.Add("@Product_Services_Offered", System.Data.SqlDbType.Int); // OnHoldClient.Parameters["@Product_Services_Offered"].Value = Index.UserID; OnHoldClient.Parameters.Add("@Billing_Cycle", System.Data.SqlDbType.Int); OnHoldClient.Parameters["@Billing_Cycle"].Value = ClientRepDet_BillingCycle_txtbox.ToString(); OnHoldClient.Parameters.Add("@VAT_Number", System.Data.SqlDbType.Int); OnHoldClient.Parameters["@VAT_Number"].Value = ClientRepDet_VatNumber_txtbox.Text.ToString(); OnHoldClient.Parameters.Add("@CW_Number", System.Data.SqlDbType.Int); OnHoldClient.Parameters["@CW_Number"].Value = ClientRepDet_CwNumber_txtbox.Text.ToString(); OnHoldClient.Parameters.Add("@Contract_Type_ID", System.Data.SqlDbType.Int); OnHoldClient.Parameters["@Contract_Type_ID"].Value = Convert.ToUInt16(ClientRepDet_ContractType_DropDnLst.SelectedItem); // OnHoldClient.Parameters.Add("@Data_Processing_Aggreement_ID", System.Data.SqlDbType.Int); // OnHoldClient.Parameters["@Data_Processing_Aggreement_ID"].Value = Index.UserID; OnHoldClient.Parameters.Add("@Contract_Amendments_ID", System.Data.SqlDbType.Int); OnHoldClient.Parameters["@Contract_Amendments_ID"].Value = Convert.ToUInt16(ClientRepDet_ContractAmendments_DropDnLst.SelectedItem); OnHoldClient.Parameters.Add("@Ariba_URL", System.Data.SqlDbType.Int); OnHoldClient.Parameters[""].Value = ClientRepDet_AribaURL_txtbox.Text.ToString(); // OnHoldClient.Parameters.Add("@Notes", System.Data.SqlDbType.Int); // OnHoldClient.Parameters["@Notes"].Value = Index.UserID; OnHoldClient.Parameters.Add("@Contract_Notes", System.Data.SqlDbType.Int); OnHoldClient.Parameters["@Contract_Notes"].Value = ClientRepDet_AribaURL_txtbox.Text.ToString(); // OnHoldClient.Parameters.Add("@Review_Status", System.Data.SqlDbType.Int); // OnHoldClient.Parameters["@Review_Status"].Value = Index.UserID; OnHoldClient .ExecuteReader(); } } } }all I am testing here is the below code that is behind the update button.
protected void ClientRepDet_Update_btn_Click(object sender, EventArgs e)
I have never had this problem before, again, when I try to update the text boxes, then step through the code I can see none of my new values.
Saturday, September 14, 2019 9:57 PM
Answers
-
User2037455357 posted
I have realised what the issue is,
All my C# code relating to textboxes and updating to my database was inside the page_load method.
School boy mistake, sorry for the long post.
Regards
Rob
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Tuesday, September 17, 2019 8:50 AM
All replies
-
User-2054057000 posted
Your code is very big, you should post only the relevant code so that people can understand your problem and give you quick replay.
Sunday, September 15, 2019 5:47 AM -
User288213138 posted
Hi masterdineen,
masterdineen
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["SearchContract_ClientId"] != null) {According to the code you posted, I found some problems.
When you click the update button, the page will post back, so you should bind the data source in postback.
masterdineen
UpdateClient.ExecuteReader();
After you update the value in the Textbox, you need to rebind the Textbox.
I made deom for you as reference, and i suggest you use UpdateClient.Parameters.AddWithValue to update the data, its more concise.
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox> <asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" /> public string str = ConfigurationManager.ConnectionStrings["constr"].ConnectionString; string query = "select * from Test52"; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { using (SqlConnection con = new SqlConnection(str)) { using (SqlCommand cmd = new SqlCommand(query, con)) { con.Open(); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { TextBox1.Text = sdr[0].ToString(); } } } } } protected void Button1_Click(object sender, EventArgs e) { using (SqlConnection DBconnection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["constr"].ToString())) { SqlCommand UpdateClient = new SqlCommand("UPDATE Test52 SET Name = @Name", DBconnection); DBconnection.Open(); // UpdateClient.CommandType = System.Data.CommandType.StoredProcedure; //UpdateClient.Parameters.Add("@UserID", System.Data.SqlDbType.Int); //UpdateClient.Parameters["@Name"].Value = TextBox1.Text.ToString(); UpdateClient.Parameters.AddWithValue("@Name", TextBox1.Text); UpdateClient.ExecuteReader(); } TextBox1.DataBind(); }The result:
Best regards,
Sam
Monday, September 16, 2019 10:08 AM -
User2037455357 posted
I have realised what the issue is,
All my C# code relating to textboxes and updating to my database was inside the page_load method.
School boy mistake, sorry for the long post.
Regards
Rob
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Tuesday, September 17, 2019 8:50 AM
