or
1 answer
149 views
Dears ,
kindly I need your help , I tried to make update but I always receive this error could you help
Incorrect syntax near 'nvarchar'.
I tried all the solutions but I didn't find anything
kindly I need your help , I tried to make update but I always receive this error could you help
Incorrect syntax near 'nvarchar'.
I tried all the solutions but I didn't find anything
<telerik:RadListView ID="RadListView1" runat="server" DataKeyNames="U_Serial_Number" DataSourceID="SqlDataSource1"> <LayoutTemplate> <div class="RadListView RadListView_Default"> <table cellspacing="0" style="width:100%;"> <thead> <tr class="rlvHeader"> <th> </th> <th> U_Serial_Number</th> <th> U_File_Number</th> <th> Odeon_ID_Number</th> <th> U_FullName</th> <th> Sex</th> <th> Remarks</th> <th> U_Name</th> <th> U_Dep</th> <th> U_Password</th> <th> U_Internal_Mail</th> <th> U_Region</th> <th> U_Week_End</th> <th> U_Balance</th> <th> U_Incednt</th> <th> U_Manger_Mail</th> <th> U_Manger_Name</th> <th> U_Status</th> <th> Unit</th> <th> U_Position</th> <th> U_Nationality</th> <th> U_Title</th> <th> Work_Mobile_Number</th> <th> Private_Mobile_Number</th> <th> Address</th> <th> U_Start_Date</th> <th> Contract_Start_Date</th> <th> Contract_End_Date</th> <th> U_Bday</th> <th> Personal_ID</th> <th> ID_Issue_Date</th> <th> ID_Expire_Date</th> <th> Marital_Status</th> <th> Military_Status</th> <th> Qualifications</th> <th> U_Universty</th> <th> U_Faculty</th> <th> U_Section</th> <th> U_GPA</th> <th> U_Graduation_Year</th> <th> Insurance_Number</th> <th> Basic_Salary</th> <th> Variable_Salary</th> <th> Pri_Medical_insurance_status</th> <th> Pri_Medical_Card_ Number</th> <th> Pri_Medical_Card_issue_date</th> <th> Pub_Medical_insurance_status</th> <th> Pub_Medical_insurance_Form</th> <th> Pub_Medical_card_issue_date</th> <th> Social_Insurance_status</th> <th> Insurance_Date</th> <th> Military_Expire_Date</th> </tr> </thead> <tbody> <tr ID="itemPlaceholder" runat="server"> </tr> </tbody> </table> <div style="display:none"> <telerik:RadCalendar ID="rlvSharedCalendar" runat="server" RangeMinDate="<%#new DateTime(1900, 1, 1) %>" Skin="<%#Container.Skin %>" /> </div> <div style="display:none"> <telerik:RadTimeView ID="rlvSharedTimeView" runat="server" Skin="<%# Container.Skin %>" /> </div> </div> </LayoutTemplate> <ItemTemplate> <tr class="rlvI"> <td> <asp:Button ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit" CssClass="rlvBEdit" Text=" " ToolTip="Edit" /> </td> <td> <asp:Label ID="U_Serial_NumberLabel" runat="server" Text='<%# Eval("U_Serial_Number") %>' /> </td> <td> <asp:Label ID="U_File_NumberLabel" runat="server" Text='<%# Eval("U_File_Number") %>' /> </td> <td> <asp:Label ID="Odeon_ID_NumberLabel" runat="server" Text='<%# Eval("Odeon_ID_Number") %>' /> </td> <td> <asp:Label ID="U_FullNameLabel" runat="server" Text='<%# Eval("U_FullName") %>' /> </td> <td> <asp:Label ID="SexLabel" runat="server" Text='<%# Eval("Sex") %>' /> </td> <td> <asp:Label ID="RemarksLabel" runat="server" Text='<%# Eval("Remarks") %>' /> </td> <td> <asp:Label ID="U_NameLabel" runat="server" Text='<%# Eval("U_Name") %>' /> </td> <td> <asp:Label ID="U_DepLabel" runat="server" Text='<%# Eval("U_Dep") %>' /> </td> <td> <asp:Label ID="U_PasswordLabel" runat="server" Text='<%# Eval("U_Password") %>' /> </td> <td> <asp:Label ID="U_Internal_MailLabel" runat="server" Text='<%# Eval("U_Internal_Mail") %>' /> </td> <td> <asp:Label ID="U_RegionLabel" runat="server" Text='<%# Eval("U_Region") %>' /> </td> <td> <asp:Label ID="U_Week_EndLabel" runat="server" Text='<%# Eval("U_Week_End") %>' /> </td> <td> <asp:Label ID="U_BalanceLabel" runat="server" Text='<%# Eval("U_Balance") %>' /> </td> <td> <asp:Label ID="U_IncedntLabel" runat="server" Text='<%# Eval("U_Incednt") %>' /> </td> <td> <asp:Label ID="U_Manger_MailLabel" runat="server" Text='<%# Eval("U_Manger_Mail") %>' /> </td> <td> <asp:Label ID="U_Manger_NameLabel" runat="server" Text='<%# Eval("U_Manger_Name") %>' /> </td> <td> <asp:Label ID="U_StatusLabel" runat="server" Text='<%# Eval("U_Status") %>' /> </td> <td> <asp:Label ID="UnitLabel" runat="server" Text='<%# Eval("Unit") %>' /> </td> <td> <asp:Label ID="U_PositionLabel" runat="server" Text='<%# Eval("U_Position") %>' /> </td> <td> <asp:Label ID="U_NationalityLabel" runat="server" Text='<%# Eval("U_Nationality") %>' /> </td> <td> <asp:Label ID="U_TitleLabel" runat="server" Text='<%# Eval("U_Title") %>' /> </td> <td> <asp:Label ID="Work_Mobile_NumberLabel" runat="server" Text='<%# Eval("Work_Mobile_Number") %>' /> </td> <td> <asp:Label ID="Private_Mobile_NumberLabel" runat="server" Text='<%# Eval("Private_Mobile_Number") %>' /> </td> <td> <asp:Label ID="AddressLabel" runat="server" Text='<%# Eval("Address") %>' /> </td> <td> <asp:Label ID="U_Start_DateLabel" runat="server" Text='<%# Eval("U_Start_Date") %>' /> </td> <td> <asp:Label ID="Contract_Start_DateLabel" runat="server" Text='<%# Eval("Contract_Start_Date") %>' /> </td> <td> <asp:Label ID="Contract_End_DateLabel" runat="server" Text='<%# Eval("Contract_End_Date") %>' /> </td> <td> <asp:Label ID="U_BdayLabel" runat="server" Text='<%# Eval("U_Bday") %>' /> </td> <td> <asp:Label ID="Personal_IDLabel" runat="server" Text='<%# Eval("Personal_ID") %>' /> </td> <td> <asp:Label ID="ID_Issue_DateLabel" runat="server" Text='<%# Eval("ID_Issue_Date") %>' /> </td> <td> <asp:Label ID="ID_Expire_DateLabel" runat="server" Text='<%# Eval("ID_Expire_Date") %>' /> </td> <td> <asp:Label ID="Marital_StatusLabel" runat="server" Text='<%# Eval("Marital_Status") %>' /> </td> <td> <asp:Label ID="Military_StatusLabel" runat="server" Text='<%# Eval("Military_Status") %>' /> </td> <td> <asp:Label ID="QualificationsLabel" runat="server" Text='<%# Eval("Qualifications") %>' /> </td> <td> <asp:Label ID="U_UniverstyLabel" runat="server" Text='<%# Eval("U_Universty") %>' /> </td> <td> <asp:Label ID="U_FacultyLabel" runat="server" Text='<%# Eval("U_Faculty") %>' /> </td> <td> <asp:Label ID="U_SectionLabel" runat="server" Text='<%# Eval("U_Section") %>' /> </td> <td> <asp:Label ID="U_GPALabel" runat="server" Text='<%# Eval("U_GPA") %>' /> </td> <td> <asp:Label ID="U_Graduation_YearLabel" runat="server" Text='<%# Eval("U_Graduation_Year") %>' /> </td> <td> <asp:Label ID="Insurance_NumberLabel" runat="server" Text='<%# Eval("Insurance_Number") %>' /> </td> <td> <asp:Label ID="Basic_SalaryLabel" runat="server" Text='<%# Eval("Basic_Salary") %>' /> </td> <td> <asp:Label ID="Variable_SalaryLabel" runat="server" Text='<%# Eval("Variable_Salary") %>' /> </td> <td> <asp:Label ID="Pri_Medical_insurance_statusLabel" runat="server" Text='<%# Eval("Pri_Medical_insurance_status") %>' /> </td> <td> <asp:Label ID="Pri_Medical_Card__NumberLabel" runat="server" Text='<%# Eval("[Pri_Medical_Card_ Number]") %>' /> </td> <td> <asp:Label ID="Pri_Medical_Card_issue_dateLabel" runat="server" Text='<%# Eval("Pri_Medical_Card_issue_date") %>' /> </td> <td> <asp:Label ID="Pub_Medical_insurance_statusLabel" runat="server" Text='<%# Eval("Pub_Medical_insurance_status") %>' /> </td> <td> <asp:Label ID="Pub_Medical_insurance_FormLabel" runat="server" Text='<%# Eval("Pub_Medical_insurance_Form") %>' /> </td> <td> <asp:Label ID="Pub_Medical_card_issue_dateLabel" runat="server" Text='<%# Eval("Pub_Medical_card_issue_date") %>' /> </td> <td> <asp:Label ID="Social_Insurance_statusLabel" runat="server" Text='<%# Eval("Social_Insurance_status") %>' /> </td> <td> <asp:Label ID="Insurance_DateLabel" runat="server" Text='<%# Eval("Insurance_Date") %>' /> </td> <td> <asp:Label ID="Military_Expire_DateLabel" runat="server" Text='<%# Eval("Military_Expire_Date") %>' /> </td> </tr> </ItemTemplate> <AlternatingItemTemplate> <tr class="rlvA"> <td> <asp:Button ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit" CssClass="rlvBEdit" Text=" " ToolTip="Edit" /> </td> <td> <asp:Label ID="U_Serial_NumberLabel" runat="server" Text='<%# Eval("U_Serial_Number") %>' /> </td> <td> <asp:Label ID="U_File_NumberLabel" runat="server" Text='<%# Eval("U_File_Number") %>' /> </td> <td> <asp:Label ID="Odeon_ID_NumberLabel" runat="server" Text='<%# Eval("Odeon_ID_Number") %>' /> </td> <td> <asp:Label ID="U_FullNameLabel" runat="server" Text='<%# Eval("U_FullName") %>' /> </td> <td> <asp:Label ID="SexLabel" runat="server" Text='<%# Eval("Sex") %>' /> </td> <td> <asp:Label ID="RemarksLabel" runat="server" Text='<%# Eval("Remarks") %>' /> </td> <td> <asp:Label ID="U_NameLabel" runat="server" Text='<%# Eval("U_Name") %>' /> </td> <td> <asp:Label ID="U_DepLabel" runat="server" Text='<%# Eval("U_Dep") %>' /> </td> <td> <asp:Label ID="U_PasswordLabel" runat="server" Text='<%# Eval("U_Password") %>' /> </td> <td> <asp:Label ID="U_Internal_MailLabel" runat="server" Text='<%# Eval("U_Internal_Mail") %>' /> </td> <td> <asp:Label ID="U_RegionLabel" runat="server" Text='<%# Eval("U_Region") %>' /> </td> <td> <asp:Label ID="U_Week_EndLabel" runat="server" Text='<%# Eval("U_Week_End") %>' /> </td> <td> <asp:Label ID="U_BalanceLabel" runat="server" Text='<%# Eval("U_Balance") %>' /> </td> <td> <asp:Label ID="U_IncedntLabel" runat="server" Text='<%# Eval("U_Incednt") %>' /> </td> <td> <asp:Label ID="U_Manger_MailLabel" runat="server" Text='<%# Eval("U_Manger_Mail") %>' /> </td> <td> <asp:Label ID="U_Manger_NameLabel" runat="server" Text='<%# Eval("U_Manger_Name") %>' /> </td> <td> <asp:Label ID="U_StatusLabel" runat="server" Text='<%# Eval("U_Status") %>' /> </td> <td> <asp:Label ID="UnitLabel" runat="server" Text='<%# Eval("Unit") %>' /> </td> <td> <asp:Label ID="U_PositionLabel" runat="server" Text='<%# Eval("U_Position") %>' /> </td> <td> <asp:Label ID="U_NationalityLabel" runat="server" Text='<%# Eval("U_Nationality") %>' /> </td> <td> <asp:Label ID="U_TitleLabel" runat="server" Text='<%# Eval("U_Title") %>' /> </td> <td> <asp:Label ID="Work_Mobile_NumberLabel" runat="server" Text='<%# Eval("Work_Mobile_Number") %>' /> </td> <td> <asp:Label ID="Private_Mobile_NumberLabel" runat="server" Text='<%# Eval("Private_Mobile_Number") %>' /> </td> <td> <asp:Label ID="AddressLabel" runat="server" Text='<%# Eval("Address") %>' /> </td> <td> <asp:Label ID="U_Start_DateLabel" runat="server" Text='<%# Eval("U_Start_Date") %>' /> </td> <td> <asp:Label ID="Contract_Start_DateLabel" runat="server" Text='<%# Eval("Contract_Start_Date") %>' /> </td> <td> <asp:Label ID="Contract_End_DateLabel" runat="server" Text='<%# Eval("Contract_End_Date") %>' /> </td> <td> <asp:Label ID="U_BdayLabel" runat="server" Text='<%# Eval("U_Bday") %>' /> </td> <td> <asp:Label ID="Personal_IDLabel" runat="server" Text='<%# Eval("Personal_ID") %>' /> </td> <td> <asp:Label ID="ID_Issue_DateLabel" runat="server" Text='<%# Eval("ID_Issue_Date") %>' /> </td> <td> <asp:Label ID="ID_Expire_DateLabel" runat="server" Text='<%# Eval("ID_Expire_Date") %>' /> </td> <td> <asp:Label ID="Marital_StatusLabel" runat="server" Text='<%# Eval("Marital_Status") %>' /> </td> <td> <asp:Label ID="Military_StatusLabel" runat="server" Text='<%# Eval("Military_Status") %>' /> </td> <td> <asp:Label ID="QualificationsLabel" runat="server" Text='<%# Eval("Qualifications") %>' /> </td> <td> <asp:Label ID="U_UniverstyLabel" runat="server" Text='<%# Eval("U_Universty") %>' /> </td> <td> <asp:Label ID="U_FacultyLabel" runat="server" Text='<%# Eval("U_Faculty") %>' /> </td> <td> <asp:Label ID="U_SectionLabel" runat="server" Text='<%# Eval("U_Section") %>' /> </td> <td> <asp:Label ID="U_GPALabel" runat="server" Text='<%# Eval("U_GPA") %>' /> </td> <td> <asp:Label ID="U_Graduation_YearLabel" runat="server" Text='<%# Eval("U_Graduation_Year") %>' /> </td> <td> <asp:Label ID="Insurance_NumberLabel" runat="server" Text='<%# Eval("Insurance_Number") %>' /> </td> <td> <asp:Label ID="Basic_SalaryLabel" runat="server" Text='<%# Eval("Basic_Salary") %>' /> </td> <td> <asp:Label ID="Variable_SalaryLabel" runat="server" Text='<%# Eval("Variable_Salary") %>' /> </td> <td> <asp:Label ID="Pri_Medical_insurance_statusLabel" runat="server" Text='<%# Eval("Pri_Medical_insurance_status") %>' /> </td> <td> <asp:Label ID="Pri_Medical_Card__NumberLabel" runat="server" Text='<%# Eval("[Pri_Medical_Card_ Number]") %>' /> </td> <td> <asp:Label ID="Pri_Medical_Card_issue_dateLabel" runat="server" Text='<%# Eval("Pri_Medical_Card_issue_date") %>' /> </td> <td> <asp:Label ID="Pub_Medical_insurance_statusLabel" runat="server" Text='<%# Eval("Pub_Medical_insurance_status") %>' /> </td> <td> <asp:Label ID="Pub_Medical_insurance_FormLabel" runat="server" Text='<%# Eval("Pub_Medical_insurance_Form") %>' /> </td> <td> <asp:Label ID="Pub_Medical_card_issue_dateLabel" runat="server" Text='<%# Eval("Pub_Medical_card_issue_date") %>' /> </td> <td> <asp:Label ID="Social_Insurance_statusLabel" runat="server" Text='<%# Eval("Social_Insurance_status") %>' /> </td> <td> <asp:Label ID="Insurance_DateLabel" runat="server" Text='<%# Eval("Insurance_Date") %>' /> </td> <td> <asp:Label ID="Military_Expire_DateLabel" runat="server" Text='<%# Eval("Military_Expire_Date") %>' /> </td> </tr> </AlternatingItemTemplate> <EditItemTemplate> <tr class="rlvIEdit"> <td colspan="52"> <table cellspacing="0" class="rlvEditTable"> <tr> <td> <asp:Label ID="U_Serial_NumberLabel2" runat="server" Text="U_Serial_Number"></asp:Label> </td> <td> <asp:Label ID="U_Serial_NumberLabel1" runat="server" Text='<%# Eval("U_Serial_Number") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_File_NumberLabel2" runat="server" AssociatedControlID="U_File_NumberTextBox" Text="U_File_Number"></asp:Label> </td> <td> <asp:TextBox ID="U_File_NumberTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_File_Number") %>' /> </td> </tr> <tr> <td> <asp:Label ID="Odeon_ID_NumberLabel2" runat="server" AssociatedControlID="Odeon_ID_NumberTextBox" Text="Odeon_ID_Number"></asp:Label> </td> <td> <asp:TextBox ID="Odeon_ID_NumberTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("Odeon_ID_Number") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_FullNameLabel2" runat="server" AssociatedControlID="U_FullNameTextBox" Text="U_FullName"></asp:Label> </td> <td> <asp:TextBox ID="U_FullNameTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_FullName") %>' /> </td> </tr> <tr> <td> <asp:Label ID="SexLabel2" runat="server" AssociatedControlID="SexTextBox" Text="Sex"></asp:Label> </td> <td> <asp:TextBox ID="SexTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("Sex") %>' /> </td> </tr> <tr> <td> <asp:Label ID="RemarksLabel2" runat="server" AssociatedControlID="RemarksTextBox" Text="Remarks"></asp:Label> </td> <td> <asp:TextBox ID="RemarksTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("Remarks") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_NameLabel2" runat="server" AssociatedControlID="U_NameTextBox" Text="U_Name"></asp:Label> </td> <td> <asp:TextBox ID="U_NameTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Name") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_DepLabel2" runat="server" AssociatedControlID="U_DepTextBox" Text="U_Dep"></asp:Label> </td> <td> <asp:TextBox ID="U_DepTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Dep") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_PasswordLabel2" runat="server" AssociatedControlID="U_PasswordTextBox" Text="U_Password"></asp:Label> </td> <td> <asp:TextBox ID="U_PasswordTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Password") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_Internal_MailLabel2" runat="server" AssociatedControlID="U_Internal_MailTextBox" Text="U_Internal_Mail"></asp:Label> </td> <td> <asp:TextBox ID="U_Internal_MailTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Internal_Mail") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_RegionLabel2" runat="server" AssociatedControlID="U_RegionTextBox" Text="U_Region"></asp:Label> </td> <td> <asp:TextBox ID="U_RegionTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Region") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_Week_EndLabel2" runat="server" AssociatedControlID="U_Week_EndTextBox" Text="U_Week_End"></asp:Label> </td> <td> <asp:TextBox ID="U_Week_EndTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Week_End") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_BalanceLabel2" runat="server" AssociatedControlID="U_BalanceTextBox" Text="U_Balance"></asp:Label> </td> <td> <asp:TextBox ID="U_BalanceTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Balance") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_IncedntLabel2" runat="server" AssociatedControlID="U_IncedntTextBox" Text="U_Incednt"></asp:Label> </td> <td> <asp:TextBox ID="U_IncedntTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Incednt") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_Manger_MailLabel2" runat="server" AssociatedControlID="U_Manger_MailTextBox" Text="U_Manger_Mail"></asp:Label> </td> <td> <asp:TextBox ID="U_Manger_MailTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Manger_Mail") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_Manger_NameLabel2" runat="server" AssociatedControlID="U_Manger_NameTextBox" Text="U_Manger_Name"></asp:Label> </td> <td> <asp:TextBox ID="U_Manger_NameTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Manger_Name") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_StatusLabel2" runat="server" AssociatedControlID="U_StatusTextBox" Text="U_Status"></asp:Label> </td> <td> <asp:TextBox ID="U_StatusTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Status") %>' /> </td> </tr> <tr> <td> <asp:Label ID="UnitLabel2" runat="server" AssociatedControlID="UnitTextBox" Text="Unit"></asp:Label> </td> <td> <asp:TextBox ID="UnitTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("Unit") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_PositionLabel2" runat="server" AssociatedControlID="U_PositionTextBox" Text="U_Position"></asp:Label> </td> <td> <asp:TextBox ID="U_PositionTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Position") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_NationalityLabel2" runat="server" AssociatedControlID="U_NationalityTextBox" Text="U_Nationality"></asp:Label> </td> <td> <asp:TextBox ID="U_NationalityTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Nationality") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_TitleLabel2" runat="server" AssociatedControlID="U_TitleTextBox" Text="U_Title"></asp:Label> </td> <td> <asp:TextBox ID="U_TitleTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Title") %>' /> </td> </tr> <tr> <td> <asp:Label ID="Work_Mobile_NumberLabel2" runat="server" AssociatedControlID="Work_Mobile_NumberTextBox" Text="Work_Mobile_Number"></asp:Label> </td> <td> <asp:TextBox ID="Work_Mobile_NumberTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("Work_Mobile_Number") %>' /> </td> </tr> <tr> <td> <asp:Label ID="Private_Mobile_NumberLabel2" runat="server" AssociatedControlID="Private_Mobile_NumberTextBox" Text="Private_Mobile_Number"></asp:Label> </td> <td> <asp:TextBox ID="Private_Mobile_NumberTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("Private_Mobile_Number") %>' /> </td> </tr> <tr> <td> <asp:Label ID="AddressLabel2" runat="server" AssociatedControlID="AddressTextBox" Text="Address"></asp:Label> </td> <td> <asp:TextBox ID="AddressTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("Address") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_Start_DateLabel2" runat="server" AssociatedControlID="U_Start_DateTextBox" Text="U_Start_Date"></asp:Label> </td> <td> <telerik:RadDateTimePicker ID="U_Start_DateTextBox" runat="server" DbSelectedDate='<%# Bind("U_Start_Date") %>' MinDate="<%#new DateTime(1900, 1, 1) %>" SharedCalendarID='<%# Container.OwnerListView.FindControl("rlvSharedCalendar").UniqueID %>' SharedTimeViewID='<%# Container.OwnerListView.FindControl("rlvSharedTimeView").UniqueID %>' Skin="<%#Container.OwnerListView.Skin %>" /> </td> </tr> <tr> <td> <asp:Label ID="Contract_Start_DateLabel2" runat="server" AssociatedControlID="Contract_Start_DateTextBox" Text="Contract_Start_Date"></asp:Label> </td> <td> <telerik:RadDateTimePicker ID="Contract_Start_DateTextBox" runat="server" DbSelectedDate='<%# Bind("Contract_Start_Date") %>' MinDate="<%#new DateTime(1900, 1, 1) %>" SharedCalendarID='<%# Container.OwnerListView.FindControl("rlvSharedCalendar").UniqueID %>' SharedTimeViewID='<%# Container.OwnerListView.FindControl("rlvSharedTimeView").UniqueID %>' Skin="<%#Container.OwnerListView.Skin %>" /> </td> </tr> <tr> <td> <asp:Label ID="Contract_End_DateLabel2" runat="server" AssociatedControlID="Contract_End_DateTextBox" Text="Contract_End_Date"></asp:Label> </td> <td> <telerik:RadDateTimePicker ID="Contract_End_DateTextBox" runat="server" DbSelectedDate='<%# Bind("Contract_End_Date") %>' MinDate="<%#new DateTime(1900, 1, 1) %>" SharedCalendarID='<%# Container.OwnerListView.FindControl("rlvSharedCalendar").UniqueID %>' SharedTimeViewID='<%# Container.OwnerListView.FindControl("rlvSharedTimeView").UniqueID %>' Skin="<%#Container.OwnerListView.Skin %>" /> </td> </tr> <tr> <td> <asp:Label ID="U_BdayLabel2" runat="server" AssociatedControlID="U_BdayTextBox" Text="U_Bday"></asp:Label> </td> <td> <telerik:RadDateTimePicker ID="U_BdayTextBox" runat="server" DbSelectedDate='<%# Bind("U_Bday") %>' MinDate="<%#new DateTime(1900, 1, 1) %>" SharedCalendarID='<%# Container.OwnerListView.FindControl("rlvSharedCalendar").UniqueID %>' SharedTimeViewID='<%# Container.OwnerListView.FindControl("rlvSharedTimeView").UniqueID %>' Skin="<%#Container.OwnerListView.Skin %>" /> </td> </tr> <tr> <td> <asp:Label ID="Personal_IDLabel2" runat="server" AssociatedControlID="Personal_IDTextBox" Text="Personal_ID"></asp:Label> </td> <td> <asp:TextBox ID="Personal_IDTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("Personal_ID") %>' /> </td> </tr> <tr> <td> <asp:Label ID="ID_Issue_DateLabel2" runat="server" AssociatedControlID="ID_Issue_DateTextBox" Text="ID_Issue_Date"></asp:Label> </td> <td> <telerik:RadDateTimePicker ID="ID_Issue_DateTextBox" runat="server" DbSelectedDate='<%# Bind("ID_Issue_Date") %>' MinDate="<%#new DateTime(1900, 1, 1) %>" SharedCalendarID='<%# Container.OwnerListView.FindControl("rlvSharedCalendar").UniqueID %>' SharedTimeViewID='<%# Container.OwnerListView.FindControl("rlvSharedTimeView").UniqueID %>' Skin="<%#Container.OwnerListView.Skin %>" /> </td> </tr> <tr> <td> <asp:Label ID="ID_Expire_DateLabel2" runat="server" AssociatedControlID="ID_Expire_DateTextBox" Text="ID_Expire_Date"></asp:Label> </td> <td> <telerik:RadDateTimePicker ID="ID_Expire_DateTextBox" runat="server" DbSelectedDate='<%# Bind("ID_Expire_Date") %>' MinDate="<%#new DateTime(1900, 1, 1) %>" SharedCalendarID='<%# Container.OwnerListView.FindControl("rlvSharedCalendar").UniqueID %>' SharedTimeViewID='<%# Container.OwnerListView.FindControl("rlvSharedTimeView").UniqueID %>' Skin="<%#Container.OwnerListView.Skin %>" /> </td> </tr> <tr> <td> <asp:Label ID="Marital_StatusLabel2" runat="server" AssociatedControlID="Marital_StatusTextBox" Text="Marital_Status"></asp:Label> </td> <td> <asp:TextBox ID="Marital_StatusTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("Marital_Status") %>' /> </td> </tr> <tr> <td> <asp:Label ID="Military_StatusLabel2" runat="server" AssociatedControlID="Military_StatusTextBox" Text="Military_Status"></asp:Label> </td> <td> <asp:TextBox ID="Military_StatusTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("Military_Status") %>' /> </td> </tr> <tr> <td> <asp:Label ID="QualificationsLabel2" runat="server" AssociatedControlID="QualificationsTextBox" Text="Qualifications"></asp:Label> </td> <td> <asp:TextBox ID="QualificationsTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("Qualifications") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_UniverstyLabel2" runat="server" AssociatedControlID="U_UniverstyTextBox" Text="U_Universty"></asp:Label> </td> <td> <asp:TextBox ID="U_UniverstyTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Universty") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_FacultyLabel2" runat="server" AssociatedControlID="U_FacultyTextBox" Text="U_Faculty"></asp:Label> </td> <td> <asp:TextBox ID="U_FacultyTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Faculty") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_SectionLabel2" runat="server" AssociatedControlID="U_SectionTextBox" Text="U_Section"></asp:Label> </td> <td> <asp:TextBox ID="U_SectionTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Section") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_GPALabel2" runat="server" AssociatedControlID="U_GPATextBox" Text="U_GPA"></asp:Label> </td> <td> <asp:TextBox ID="U_GPATextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_GPA") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_Graduation_YearLabel2" runat="server" AssociatedControlID="U_Graduation_YearTextBox" Text="U_Graduation_Year"></asp:Label> </td> <td> <asp:TextBox ID="U_Graduation_YearTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Graduation_Year") %>' /> </td> </tr> <tr> <td> <asp:Label ID="Insurance_NumberLabel2" runat="server" AssociatedControlID="Insurance_NumberTextBox" Text="Insurance_Number"></asp:Label> </td> <td> <asp:TextBox ID="Insurance_NumberTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("Insurance_Number") %>' /> </td> </tr> <tr> <td> <asp:Label ID="Basic_SalaryLabel2" runat="server" AssociatedControlID="Basic_SalaryTextBox" Text="Basic_Salary"></asp:Label> </td> <td> <telerik:RadNumericTextBox ID="Basic_SalaryTextBox" runat="server" DataType="Decimal" DbValue='<%# Bind("Basic_Salary") %>' Skin="<%#Container.OwnerListView.Skin %>" /> </td> </tr> <tr> <td> <asp:Label ID="Variable_SalaryLabel2" runat="server" AssociatedControlID="Variable_SalaryTextBox" Text="Variable_Salary"></asp:Label> </td> <td> <telerik:RadNumericTextBox ID="Variable_SalaryTextBox" runat="server" DataType="Decimal" DbValue='<%# Bind("Variable_Salary") %>' Skin="<%#Container.OwnerListView.Skin %>" /> </td> </tr> <tr> <td> <asp:Label ID="Pri_Medical_insurance_statusLabel2" runat="server" AssociatedControlID="Pri_Medical_insurance_statusTextBox" Text="Pri_Medical_insurance_status"></asp:Label> </td> <td> <asp:TextBox ID="Pri_Medical_insurance_statusTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("Pri_Medical_insurance_status") %>' /> </td> </tr> <tr> <td> <asp:Label ID="Pri_Medical_Card__NumberLabel2" runat="server" AssociatedControlID="Pri_Medical_Card__NumberTextBox" Text="Pri_Medical_Card_ Number"></asp:Label> </td> <td> <asp:TextBox ID="Pri_Medical_Card__NumberTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("[Pri_Medical_Card_ Number]") %>' /> </td> </tr> <tr> <td> <asp:Label ID="Pri_Medical_Card_issue_dateLabel2" runat="server" AssociatedControlID="Pri_Medical_Card_issue_dateTextBox" Text="Pri_Medical_Card_issue_date"></asp:Label> </td> <td> <telerik:RadDateTimePicker ID="Pri_Medical_Card_issue_dateTextBox" runat="server" DbSelectedDate='<%# Bind("Pri_Medical_Card_issue_date") %>' MinDate="<%#new DateTime(1900, 1, 1) %>" SharedCalendarID='<%# Container.OwnerListView.FindControl("rlvSharedCalendar").UniqueID %>' SharedTimeViewID='<%# Container.OwnerListView.FindControl("rlvSharedTimeView").UniqueID %>' Skin="<%#Container.OwnerListView.Skin %>" /> </td> </tr> <tr> <td> <asp:Label ID="Pub_Medical_insurance_statusLabel2" runat="server" AssociatedControlID="Pub_Medical_insurance_statusTextBox" Text="Pub_Medical_insurance_status"></asp:Label> </td> <td> <asp:TextBox ID="Pub_Medical_insurance_statusTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("Pub_Medical_insurance_status") %>' /> </td> </tr> <tr> <td> <asp:Label ID="Pub_Medical_insurance_FormLabel2" runat="server" AssociatedControlID="Pub_Medical_insurance_FormTextBox" Text="Pub_Medical_insurance_Form"></asp:Label> </td> <td> <asp:TextBox ID="Pub_Medical_insurance_FormTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("Pub_Medical_insurance_Form") %>' /> </td> </tr> <tr> <td> <asp:Label ID="Pub_Medical_card_issue_dateLabel2" runat="server" AssociatedControlID="Pub_Medical_card_issue_dateTextBox" Text="Pub_Medical_card_issue_date"></asp:Label> </td> <td> <telerik:RadDateTimePicker ID="Pub_Medical_card_issue_dateTextBox" runat="server" DbSelectedDate='<%# Bind("Pub_Medical_card_issue_date") %>' MinDate="<%#new DateTime(1900, 1, 1) %>" SharedCalendarID='<%# Container.OwnerListView.FindControl("rlvSharedCalendar").UniqueID %>' SharedTimeViewID='<%# Container.OwnerListView.FindControl("rlvSharedTimeView").UniqueID %>' Skin="<%#Container.OwnerListView.Skin %>" /> </td> </tr> <tr> <td> <asp:Label ID="Social_Insurance_statusLabel2" runat="server" AssociatedControlID="Social_Insurance_statusTextBox" Text="Social_Insurance_status"></asp:Label> </td> <td> <asp:TextBox ID="Social_Insurance_statusTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("Social_Insurance_status") %>' /> </td> </tr> <tr> <td> <asp:Label ID="Insurance_DateLabel2" runat="server" AssociatedControlID="Insurance_DateTextBox" Text="Insurance_Date"></asp:Label> </td> <td> <telerik:RadDateTimePicker ID="Insurance_DateTextBox" runat="server" DbSelectedDate='<%# Bind("Insurance_Date") %>' MinDate="<%#new DateTime(1900, 1, 1) %>" SharedCalendarID='<%# Container.OwnerListView.FindControl("rlvSharedCalendar").UniqueID %>' SharedTimeViewID='<%# Container.OwnerListView.FindControl("rlvSharedTimeView").UniqueID %>' Skin="<%#Container.OwnerListView.Skin %>" /> </td> </tr> <tr> <td> <asp:Label ID="Military_Expire_DateLabel2" runat="server" AssociatedControlID="Military_Expire_DateTextBox" Text="Military_Expire_Date"></asp:Label> </td> <td> <telerik:RadDateTimePicker ID="Military_Expire_DateTextBox" runat="server" DbSelectedDate='<%# Bind("Military_Expire_Date") %>' MinDate="<%#new DateTime(1900, 1, 1) %>" SharedCalendarID='<%# Container.OwnerListView.FindControl("rlvSharedCalendar").UniqueID %>' SharedTimeViewID='<%# Container.OwnerListView.FindControl("rlvSharedTimeView").UniqueID %>' Skin="<%#Container.OwnerListView.Skin %>" /> </td> </tr> <tr> <td colspan="2"> <asp:Button ID="UpdateButton" runat="server" CommandName="Update" CssClass="rlvBUpdate" Text=" " ToolTip="Update" /> <asp:Button ID="CancelButton" runat="server" CausesValidation="False" CommandName="Cancel" CssClass="rlvBCancel" Text=" " ToolTip="Cancel" /> </td> </tr> </table> </td> </tr> </EditItemTemplate> <InsertItemTemplate> <tr class="rlvIEdit"> <td colspan="52"> <table cellspacing="0" class="rlvEditTable"> <tr> <td> <asp:Label ID="U_Serial_NumberLabel2" runat="server" Text="U_Serial_Number"></asp:Label> </td> <td> <telerik:RadNumericTextBox ID="U_Serial_NumberTextBox" runat="server" DataType="Int32" DbValue='<%# Bind("U_Serial_Number") %>' NumberFormat-DecimalDigits="0" Skin="<%#Container.OwnerListView.Skin %>" /> </td> </tr> <tr> <td> <asp:Label ID="U_File_NumberLabel2" runat="server" AssociatedControlID="U_File_NumberTextBox" Text="U_File_Number"></asp:Label> </td> <td> <asp:TextBox ID="U_File_NumberTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_File_Number") %>' /> </td> </tr> <tr> <td> <asp:Label ID="Odeon_ID_NumberLabel2" runat="server" AssociatedControlID="Odeon_ID_NumberTextBox" Text="Odeon_ID_Number"></asp:Label> </td> <td> <asp:TextBox ID="Odeon_ID_NumberTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("Odeon_ID_Number") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_FullNameLabel2" runat="server" AssociatedControlID="U_FullNameTextBox" Text="U_FullName"></asp:Label> </td> <td> <asp:TextBox ID="U_FullNameTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_FullName") %>' /> </td> </tr> <tr> <td> <asp:Label ID="SexLabel2" runat="server" AssociatedControlID="SexTextBox" Text="Sex"></asp:Label> </td> <td> <asp:TextBox ID="SexTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("Sex") %>' /> </td> </tr> <tr> <td> <asp:Label ID="RemarksLabel2" runat="server" AssociatedControlID="RemarksTextBox" Text="Remarks"></asp:Label> </td> <td> <asp:TextBox ID="RemarksTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("Remarks") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_NameLabel2" runat="server" AssociatedControlID="U_NameTextBox" Text="U_Name"></asp:Label> </td> <td> <asp:TextBox ID="U_NameTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Name") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_DepLabel2" runat="server" AssociatedControlID="U_DepTextBox" Text="U_Dep"></asp:Label> </td> <td> <asp:TextBox ID="U_DepTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Dep") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_PasswordLabel2" runat="server" AssociatedControlID="U_PasswordTextBox" Text="U_Password"></asp:Label> </td> <td> <asp:TextBox ID="U_PasswordTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Password") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_Internal_MailLabel2" runat="server" AssociatedControlID="U_Internal_MailTextBox" Text="U_Internal_Mail"></asp:Label> </td> <td> <asp:TextBox ID="U_Internal_MailTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Internal_Mail") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_RegionLabel2" runat="server" AssociatedControlID="U_RegionTextBox" Text="U_Region"></asp:Label> </td> <td> <asp:TextBox ID="U_RegionTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Region") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_Week_EndLabel2" runat="server" AssociatedControlID="U_Week_EndTextBox" Text="U_Week_End"></asp:Label> </td> <td> <asp:TextBox ID="U_Week_EndTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Week_End") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_BalanceLabel2" runat="server" AssociatedControlID="U_BalanceTextBox" Text="U_Balance"></asp:Label> </td> <td> <asp:TextBox ID="U_BalanceTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Balance") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_IncedntLabel2" runat="server" AssociatedControlID="U_IncedntTextBox" Text="U_Incednt"></asp:Label> </td> <td> <asp:TextBox ID="U_IncedntTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Incednt") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_Manger_MailLabel2" runat="server" AssociatedControlID="U_Manger_MailTextBox" Text="U_Manger_Mail"></asp:Label> </td> <td> <asp:TextBox ID="U_Manger_MailTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Manger_Mail") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_Manger_NameLabel2" runat="server" AssociatedControlID="U_Manger_NameTextBox" Text="U_Manger_Name"></asp:Label> </td> <td> <asp:TextBox ID="U_Manger_NameTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Manger_Name") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_StatusLabel2" runat="server" AssociatedControlID="U_StatusTextBox" Text="U_Status"></asp:Label> </td> <td> <asp:TextBox ID="U_StatusTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Status") %>' /> </td> </tr> <tr> <td> <asp:Label ID="UnitLabel2" runat="server" AssociatedControlID="UnitTextBox" Text="Unit"></asp:Label> </td> <td> <asp:TextBox ID="UnitTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("Unit") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_PositionLabel2" runat="server" AssociatedControlID="U_PositionTextBox" Text="U_Position"></asp:Label> </td> <td> <asp:TextBox ID="U_PositionTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Position") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_NationalityLabel2" runat="server" AssociatedControlID="U_NationalityTextBox" Text="U_Nationality"></asp:Label> </td> <td> <asp:TextBox ID="U_NationalityTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Nationality") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_TitleLabel2" runat="server" AssociatedControlID="U_TitleTextBox" Text="U_Title"></asp:Label> </td> <td> <asp:TextBox ID="U_TitleTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Title") %>' /> </td> </tr> <tr> <td> <asp:Label ID="Work_Mobile_NumberLabel2" runat="server" AssociatedControlID="Work_Mobile_NumberTextBox" Text="Work_Mobile_Number"></asp:Label> </td> <td> <asp:TextBox ID="Work_Mobile_NumberTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("Work_Mobile_Number") %>' /> </td> </tr> <tr> <td> <asp:Label ID="Private_Mobile_NumberLabel2" runat="server" AssociatedControlID="Private_Mobile_NumberTextBox" Text="Private_Mobile_Number"></asp:Label> </td> <td> <asp:TextBox ID="Private_Mobile_NumberTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("Private_Mobile_Number") %>' /> </td> </tr> <tr> <td> <asp:Label ID="AddressLabel2" runat="server" AssociatedControlID="AddressTextBox" Text="Address"></asp:Label> </td> <td> <asp:TextBox ID="AddressTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("Address") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_Start_DateLabel2" runat="server" AssociatedControlID="U_Start_DateTextBox" Text="U_Start_Date"></asp:Label> </td> <td> <telerik:RadDateTimePicker ID="U_Start_DateTextBox" runat="server" DbSelectedDate='<%# Bind("U_Start_Date") %>' MinDate="<%#new DateTime(1900, 1, 1) %>" SharedCalendarID='<%# Container.OwnerListView.FindControl("rlvSharedCalendar").UniqueID %>' SharedTimeViewID='<%# Container.OwnerListView.FindControl("rlvSharedTimeView").UniqueID %>' Skin="<%#Container.OwnerListView.Skin %>" /> </td> </tr> <tr> <td> <asp:Label ID="Contract_Start_DateLabel2" runat="server" AssociatedControlID="Contract_Start_DateTextBox" Text="Contract_Start_Date"></asp:Label> </td> <td> <telerik:RadDateTimePicker ID="Contract_Start_DateTextBox" runat="server" DbSelectedDate='<%# Bind("Contract_Start_Date") %>' MinDate="<%#new DateTime(1900, 1, 1) %>" SharedCalendarID='<%# Container.OwnerListView.FindControl("rlvSharedCalendar").UniqueID %>' SharedTimeViewID='<%# Container.OwnerListView.FindControl("rlvSharedTimeView").UniqueID %>' Skin="<%#Container.OwnerListView.Skin %>" /> </td> </tr> <tr> <td> <asp:Label ID="Contract_End_DateLabel2" runat="server" AssociatedControlID="Contract_End_DateTextBox" Text="Contract_End_Date"></asp:Label> </td> <td> <telerik:RadDateTimePicker ID="Contract_End_DateTextBox" runat="server" DbSelectedDate='<%# Bind("Contract_End_Date") %>' MinDate="<%#new DateTime(1900, 1, 1) %>" SharedCalendarID='<%# Container.OwnerListView.FindControl("rlvSharedCalendar").UniqueID %>' SharedTimeViewID='<%# Container.OwnerListView.FindControl("rlvSharedTimeView").UniqueID %>' Skin="<%#Container.OwnerListView.Skin %>" /> </td> </tr> <tr> <td> <asp:Label ID="U_BdayLabel2" runat="server" AssociatedControlID="U_BdayTextBox" Text="U_Bday"></asp:Label> </td> <td> <telerik:RadDateTimePicker ID="U_BdayTextBox" runat="server" DbSelectedDate='<%# Bind("U_Bday") %>' MinDate="<%#new DateTime(1900, 1, 1) %>" SharedCalendarID='<%# Container.OwnerListView.FindControl("rlvSharedCalendar").UniqueID %>' SharedTimeViewID='<%# Container.OwnerListView.FindControl("rlvSharedTimeView").UniqueID %>' Skin="<%#Container.OwnerListView.Skin %>" /> </td> </tr> <tr> <td> <asp:Label ID="Personal_IDLabel2" runat="server" AssociatedControlID="Personal_IDTextBox" Text="Personal_ID"></asp:Label> </td> <td> <asp:TextBox ID="Personal_IDTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("Personal_ID") %>' /> </td> </tr> <tr> <td> <asp:Label ID="ID_Issue_DateLabel2" runat="server" AssociatedControlID="ID_Issue_DateTextBox" Text="ID_Issue_Date"></asp:Label> </td> <td> <telerik:RadDateTimePicker ID="ID_Issue_DateTextBox" runat="server" DbSelectedDate='<%# Bind("ID_Issue_Date") %>' MinDate="<%#new DateTime(1900, 1, 1) %>" SharedCalendarID='<%# Container.OwnerListView.FindControl("rlvSharedCalendar").UniqueID %>' SharedTimeViewID='<%# Container.OwnerListView.FindControl("rlvSharedTimeView").UniqueID %>' Skin="<%#Container.OwnerListView.Skin %>" /> </td> </tr> <tr> <td> <asp:Label ID="ID_Expire_DateLabel2" runat="server" AssociatedControlID="ID_Expire_DateTextBox" Text="ID_Expire_Date"></asp:Label> </td> <td> <telerik:RadDateTimePicker ID="ID_Expire_DateTextBox" runat="server" DbSelectedDate='<%# Bind("ID_Expire_Date") %>' MinDate="<%#new DateTime(1900, 1, 1) %>" SharedCalendarID='<%# Container.OwnerListView.FindControl("rlvSharedCalendar").UniqueID %>' SharedTimeViewID='<%# Container.OwnerListView.FindControl("rlvSharedTimeView").UniqueID %>' Skin="<%#Container.OwnerListView.Skin %>" /> </td> </tr> <tr> <td> <asp:Label ID="Marital_StatusLabel2" runat="server" AssociatedControlID="Marital_StatusTextBox" Text="Marital_Status"></asp:Label> </td> <td> <asp:TextBox ID="Marital_StatusTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("Marital_Status") %>' /> </td> </tr> <tr> <td> <asp:Label ID="Military_StatusLabel2" runat="server" AssociatedControlID="Military_StatusTextBox" Text="Military_Status"></asp:Label> </td> <td> <asp:TextBox ID="Military_StatusTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("Military_Status") %>' /> </td> </tr> <tr> <td> <asp:Label ID="QualificationsLabel2" runat="server" AssociatedControlID="QualificationsTextBox" Text="Qualifications"></asp:Label> </td> <td> <asp:TextBox ID="QualificationsTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("Qualifications") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_UniverstyLabel2" runat="server" AssociatedControlID="U_UniverstyTextBox" Text="U_Universty"></asp:Label> </td> <td> <asp:TextBox ID="U_UniverstyTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Universty") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_FacultyLabel2" runat="server" AssociatedControlID="U_FacultyTextBox" Text="U_Faculty"></asp:Label> </td> <td> <asp:TextBox ID="U_FacultyTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Faculty") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_SectionLabel2" runat="server" AssociatedControlID="U_SectionTextBox" Text="U_Section"></asp:Label> </td> <td> <asp:TextBox ID="U_SectionTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Section") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_GPALabel2" runat="server" AssociatedControlID="U_GPATextBox" Text="U_GPA"></asp:Label> </td> <td> <asp:TextBox ID="U_GPATextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_GPA") %>' /> </td> </tr> <tr> <td> <asp:Label ID="U_Graduation_YearLabel2" runat="server" AssociatedControlID="U_Graduation_YearTextBox" Text="U_Graduation_Year"></asp:Label> </td> <td> <asp:TextBox ID="U_Graduation_YearTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("U_Graduation_Year") %>' /> </td> </tr> <tr> <td> <asp:Label ID="Insurance_NumberLabel2" runat="server" AssociatedControlID="Insurance_NumberTextBox" Text="Insurance_Number"></asp:Label> </td> <td> <asp:TextBox ID="Insurance_NumberTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("Insurance_Number") %>' /> </td> </tr> <tr> <td> <asp:Label ID="Basic_SalaryLabel2" runat="server" AssociatedControlID="Basic_SalaryTextBox" Text="Basic_Salary"></asp:Label> </td> <td> <telerik:RadNumericTextBox ID="Basic_SalaryTextBox" runat="server" DataType="Decimal" DbValue='<%# Bind("Basic_Salary") %>' Skin="<%#Container.OwnerListView.Skin %>" /> </td> </tr> <tr> <td> <asp:Label ID="Variable_SalaryLabel2" runat="server" AssociatedControlID="Variable_SalaryTextBox" Text="Variable_Salary"></asp:Label> </td> <td> <telerik:RadNumericTextBox ID="Variable_SalaryTextBox" runat="server" DataType="Decimal" DbValue='<%# Bind("Variable_Salary") %>' Skin="<%#Container.OwnerListView.Skin %>" /> </td> </tr> <tr> <td> <asp:Label ID="Pri_Medical_insurance_statusLabel2" runat="server" AssociatedControlID="Pri_Medical_insurance_statusTextBox" Text="Pri_Medical_insurance_status"></asp:Label> </td> <td> <asp:TextBox ID="Pri_Medical_insurance_statusTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("Pri_Medical_insurance_status") %>' /> </td> </tr> <tr> <td> <asp:Label ID="Pri_Medical_Card__NumberLabel2" runat="server" AssociatedControlID="Pri_Medical_Card__NumberTextBox" Text="Pri_Medical_Card_ Number"></asp:Label> </td> <td> <asp:TextBox ID="Pri_Medical_Card__NumberTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("[Pri_Medical_Card_ Number]") %>' /> </td> </tr> <tr> <td> <asp:Label ID="Pri_Medical_Card_issue_dateLabel2" runat="server" AssociatedControlID="Pri_Medical_Card_issue_dateTextBox" Text="Pri_Medical_Card_issue_date"></asp:Label> </td> <td> <telerik:RadDateTimePicker ID="Pri_Medical_Card_issue_dateTextBox" runat="server" DbSelectedDate='<%# Bind("Pri_Medical_Card_issue_date") %>' MinDate="<%#new DateTime(1900, 1, 1) %>" SharedCalendarID='<%# Container.OwnerListView.FindControl("rlvSharedCalendar").UniqueID %>' SharedTimeViewID='<%# Container.OwnerListView.FindControl("rlvSharedTimeView").UniqueID %>' Skin="<%#Container.OwnerListView.Skin %>" /> </td> </tr> <tr> <td> <asp:Label ID="Pub_Medical_insurance_statusLabel2" runat="server" AssociatedControlID="Pub_Medical_insurance_statusTextBox" Text="Pub_Medical_insurance_status"></asp:Label> </td> <td> <asp:TextBox ID="Pub_Medical_insurance_statusTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("Pub_Medical_insurance_status") %>' /> </td> </tr> <tr> <td> <asp:Label ID="Pub_Medical_insurance_FormLabel2" runat="server" AssociatedControlID="Pub_Medical_insurance_FormTextBox" Text="Pub_Medical_insurance_Form"></asp:Label> </td> <td> <asp:TextBox ID="Pub_Medical_insurance_FormTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("Pub_Medical_insurance_Form") %>' /> </td> </tr> <tr> <td> <asp:Label ID="Pub_Medical_card_issue_dateLabel2" runat="server" AssociatedControlID="Pub_Medical_card_issue_dateTextBox" Text="Pub_Medical_card_issue_date"></asp:Label> </td> <td> <telerik:RadDateTimePicker ID="Pub_Medical_card_issue_dateTextBox" runat="server" DbSelectedDate='<%# Bind("Pub_Medical_card_issue_date") %>' MinDate="<%#new DateTime(1900, 1, 1) %>" SharedCalendarID='<%# Container.OwnerListView.FindControl("rlvSharedCalendar").UniqueID %>' SharedTimeViewID='<%# Container.OwnerListView.FindControl("rlvSharedTimeView").UniqueID %>' Skin="<%#Container.OwnerListView.Skin %>" /> </td> </tr> <tr> <td> <asp:Label ID="Social_Insurance_statusLabel2" runat="server" AssociatedControlID="Social_Insurance_statusTextBox" Text="Social_Insurance_status"></asp:Label> </td> <td> <asp:TextBox ID="Social_Insurance_statusTextBox" runat="server" CssClass="rlvInput" Text='<%# Bind("Social_Insurance_status") %>' /> </td> </tr> <tr> <td> <asp:Label ID="Insurance_DateLabel2" runat="server" AssociatedControlID="Insurance_DateTextBox" Text="Insurance_Date"></asp:Label> </td> <td> <telerik:RadDateTimePicker ID="Insurance_DateTextBox" runat="server" DbSelectedDate='<%# Bind("Insurance_Date") %>' MinDate="<%#new DateTime(1900, 1, 1) %>" SharedCalendarID='<%# Container.OwnerListView.FindControl("rlvSharedCalendar").UniqueID %>' SharedTimeViewID='<%# Container.OwnerListView.FindControl("rlvSharedTimeView").UniqueID %>' Skin="<%#Container.OwnerListView.Skin %>" /> </td> </tr> <tr> <td> <asp:Label ID="Military_Expire_DateLabel2" runat="server" AssociatedControlID="Military_Expire_DateTextBox" Text="Military_Expire_Date"></asp:Label> </td> <td> <telerik:RadDateTimePicker ID="Military_Expire_DateTextBox" runat="server" DbSelectedDate='<%# Bind("Military_Expire_Date") %>' MinDate="<%#new DateTime(1900, 1, 1) %>" SharedCalendarID='<%# Container.OwnerListView.FindControl("rlvSharedCalendar").UniqueID %>' SharedTimeViewID='<%# Container.OwnerListView.FindControl("rlvSharedTimeView").UniqueID %>' Skin="<%#Container.OwnerListView.Skin %>" /> </td> </tr> <tr> <td colspan="2"> <asp:Button ID="PerformInsertButton" runat="server" CommandName="PerformInsert" CssClass="rlvBAdd" Text=" " ToolTip="Insert" /> <asp:Button ID="CancelButton" runat="server" CausesValidation="False" CommandName="Cancel" CssClass="rlvBCancel" Text=" " ToolTip="Cancel" /> </td> </tr> </table> </td> </tr> </InsertItemTemplate> <EmptyDataTemplate> <div class="RadListView RadListView_Default"> <div class="rlvEmpty"> There are no items to be displayed.</div> </div> </EmptyDataTemplate> <SelectedItemTemplate> <tr class="rlvISel"> <td> <asp:Button ID="DeselectButton" runat="server" CausesValidation="False" CommandName="Deselect" CssClass="rlvBSel" Text=" " ToolTip="Deselect" /> <asp:Button ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit" CssClass="rlvBEdit" Text=" " ToolTip="Edit" /> </td> <td> <asp:Label ID="U_Serial_NumberLabel" runat="server" Text='<%# Eval("U_Serial_Number") %>' /> </td> <td> <asp:Label ID="U_File_NumberLabel" runat="server" Text='<%# Eval("U_File_Number") %>' /> </td> <td> <asp:Label ID="Odeon_ID_NumberLabel" runat="server" Text='<%# Eval("Odeon_ID_Number") %>' /> </td> <td> <asp:Label ID="U_FullNameLabel" runat="server" Text='<%# Eval("U_FullName") %>' /> </td> <td> <asp:Label ID="SexLabel" runat="server" Text='<%# Eval("Sex") %>' /> </td> <td> <asp:Label ID="RemarksLabel" runat="server" Text='<%# Eval("Remarks") %>' /> </td> <td> <asp:Label ID="U_NameLabel" runat="server" Text='<%# Eval("U_Name") %>' /> </td> <td> <asp:Label ID="U_DepLabel" runat="server" Text='<%# Eval("U_Dep") %>' /> </td> <td> <asp:Label ID="U_PasswordLabel" runat="server" Text='<%# Eval("U_Password") %>' /> </td> <td> <asp:Label ID="U_Internal_MailLabel" runat="server" Text='<%# Eval("U_Internal_Mail") %>' /> </td> <td> <asp:Label ID="U_RegionLabel" runat="server" Text='<%# Eval("U_Region") %>' /> </td> <td> <asp:Label ID="U_Week_EndLabel" runat="server" Text='<%# Eval("U_Week_End") %>' /> </td> <td> <asp:Label ID="U_BalanceLabel" runat="server" Text='<%# Eval("U_Balance") %>' /> </td> <td> <asp:Label ID="U_IncedntLabel" runat="server" Text='<%# Eval("U_Incednt") %>' /> </td> <td> <asp:Label ID="U_Manger_MailLabel" runat="server" Text='<%# Eval("U_Manger_Mail") %>' /> </td> <td> <asp:Label ID="U_Manger_NameLabel" runat="server" Text='<%# Eval("U_Manger_Name") %>' /> </td> <td> <asp:Label ID="U_StatusLabel" runat="server" Text='<%# Eval("U_Status") %>' /> </td> <td> <asp:Label ID="UnitLabel" runat="server" Text='<%# Eval("Unit") %>' /> </td> <td> <asp:Label ID="U_PositionLabel" runat="server" Text='<%# Eval("U_Position") %>' /> </td> <td> <asp:Label ID="U_NationalityLabel" runat="server" Text='<%# Eval("U_Nationality") %>' /> </td> <td> <asp:Label ID="U_TitleLabel" runat="server" Text='<%# Eval("U_Title") %>' /> </td> <td> <asp:Label ID="Work_Mobile_NumberLabel" runat="server" Text='<%# Eval("Work_Mobile_Number") %>' /> </td> <td> <asp:Label ID="Private_Mobile_NumberLabel" runat="server" Text='<%# Eval("Private_Mobile_Number") %>' /> </td> <td> <asp:Label ID="AddressLabel" runat="server" Text='<%# Eval("Address") %>' /> </td> <td> <asp:Label ID="U_Start_DateLabel" runat="server" Text='<%# Eval("U_Start_Date") %>' /> </td> <td> <asp:Label ID="Contract_Start_DateLabel" runat="server" Text='<%# Eval("Contract_Start_Date") %>' /> </td> <td> <asp:Label ID="Contract_End_DateLabel" runat="server" Text='<%# Eval("Contract_End_Date") %>' /> </td> <td> <asp:Label ID="U_BdayLabel" runat="server" Text='<%# Eval("U_Bday") %>' /> </td> <td> <asp:Label ID="Personal_IDLabel" runat="server" Text='<%# Eval("Personal_ID") %>' /> </td> <td> <asp:Label ID="ID_Issue_DateLabel" runat="server" Text='<%# Eval("ID_Issue_Date") %>' /> </td> <td> <asp:Label ID="ID_Expire_DateLabel" runat="server" Text='<%# Eval("ID_Expire_Date") %>' /> </td> <td> <asp:Label ID="Marital_StatusLabel" runat="server" Text='<%# Eval("Marital_Status") %>' /> </td> <td> <asp:Label ID="Military_StatusLabel" runat="server" Text='<%# Eval("Military_Status") %>' /> </td> <td> <asp:Label ID="QualificationsLabel" runat="server" Text='<%# Eval("Qualifications") %>' /> </td> <td> <asp:Label ID="U_UniverstyLabel" runat="server" Text='<%# Eval("U_Universty") %>' /> </td> <td> <asp:Label ID="U_FacultyLabel" runat="server" Text='<%# Eval("U_Faculty") %>' /> </td> <td> <asp:Label ID="U_SectionLabel" runat="server" Text='<%# Eval("U_Section") %>' /> </td> <td> <asp:Label ID="U_GPALabel" runat="server" Text='<%# Eval("U_GPA") %>' /> </td> <td> <asp:Label ID="U_Graduation_YearLabel" runat="server" Text='<%# Eval("U_Graduation_Year") %>' /> </td> <td> <asp:Label ID="Insurance_NumberLabel" runat="server" Text='<%# Eval("Insurance_Number") %>' /> </td> <td> <asp:Label ID="Basic_SalaryLabel" runat="server" Text='<%# Eval("Basic_Salary") %>' /> </td> <td> <asp:Label ID="Variable_SalaryLabel" runat="server" Text='<%# Eval("Variable_Salary") %>' /> </td> <td> <asp:Label ID="Pri_Medical_insurance_statusLabel" runat="server" Text='<%# Eval("Pri_Medical_insurance_status") %>' /> </td> <td> <asp:Label ID="Pri_Medical_Card__NumberLabel" runat="server" Text='<%# Eval("[Pri_Medical_Card_ Number]") %>' /> </td> <td> <asp:Label ID="Pri_Medical_Card_issue_dateLabel" runat="server" Text='<%# Eval("Pri_Medical_Card_issue_date") %>' /> </td> <td> <asp:Label ID="Pub_Medical_insurance_statusLabel" runat="server" Text='<%# Eval("Pub_Medical_insurance_status") %>' /> </td> <td> <asp:Label ID="Pub_Medical_insurance_FormLabel" runat="server" Text='<%# Eval("Pub_Medical_insurance_Form") %>' /> </td> <td> <asp:Label ID="Pub_Medical_card_issue_dateLabel" runat="server" Text='<%# Eval("Pub_Medical_card_issue_date") %>' /> </td> <td> <asp:Label ID="Social_Insurance_statusLabel" runat="server" Text='<%# Eval("Social_Insurance_status") %>' /> </td> <td> <asp:Label ID="Insurance_DateLabel" runat="server" Text='<%# Eval("Insurance_Date") %>' /> </td> <td> <asp:Label ID="Military_Expire_DateLabel" runat="server" Text='<%# Eval("Military_Expire_Date") %>' /> </td> </tr> </SelectedItemTemplate> </telerik:RadListView> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" DeleteCommand="DELETE FROM [Users] WHERE [U_Serial_Number] = @original_U_Serial_Number AND (([U_File_Number] = @original_U_File_Number) OR ([U_File_Number] IS NULL AND @original_U_File_Number IS NULL)) AND (([Odeon_ID_Number] = @original_Odeon_ID_Number) OR ([Odeon_ID_Number] IS NULL AND @original_Odeon_ID_Number IS NULL)) AND (([U_FullName] = @original_U_FullName) OR ([U_FullName] IS NULL AND @original_U_FullName IS NULL)) AND (([Sex] = @original_Sex) OR ([Sex] IS NULL AND @original_Sex IS NULL)) AND (([Remarks] = @original_Remarks) OR ([Remarks] IS NULL AND @original_Remarks IS NULL)) AND (([U_Name] = @original_U_Name) OR ([U_Name] IS NULL AND @original_U_Name IS NULL)) AND (([U_Dep] = @original_U_Dep) OR ([U_Dep] IS NULL AND @original_U_Dep IS NULL)) AND (([U_Password] = @original_U_Password) OR ([U_Password] IS NULL AND @original_U_Password IS NULL)) AND (([U_Internal_Mail] = @original_U_Internal_Mail) OR ([U_Internal_Mail] IS NULL AND @original_U_Internal_Mail IS NULL)) AND (([U_Region] = @original_U_Region) OR ([U_Region] IS NULL AND @original_U_Region IS NULL)) AND (([U_Week_End] = @original_U_Week_End) OR ([U_Week_End] IS NULL AND @original_U_Week_End IS NULL)) AND (([U_Balance] = @original_U_Balance) OR ([U_Balance] IS NULL AND @original_U_Balance IS NULL)) AND (([U_Incednt] = @original_U_Incednt) OR ([U_Incednt] IS NULL AND @original_U_Incednt IS NULL)) AND (([U_Manger_Mail] = @original_U_Manger_Mail) OR ([U_Manger_Mail] IS NULL AND @original_U_Manger_Mail IS NULL)) AND (([U_Manger_Name] = @original_U_Manger_Name) OR ([U_Manger_Name] IS NULL AND @original_U_Manger_Name IS NULL)) AND (([U_Status] = @original_U_Status) OR ([U_Status] IS NULL AND @original_U_Status IS NULL)) AND (([Unit] = @original_Unit) OR ([Unit] IS NULL AND @original_Unit IS NULL)) AND (([U_Position] = @original_U_Position) OR ([U_Position] IS NULL AND @original_U_Position IS NULL)) AND (([U_Nationality] = @original_U_Nationality) OR ([U_Nationality] IS NULL AND @original_U_Nationality IS NULL)) AND (([U_Title] = @original_U_Title) OR ([U_Title] IS NULL AND @original_U_Title IS NULL)) AND (([Work_Mobile_Number] = @original_Work_Mobile_Number) OR ([Work_Mobile_Number] IS NULL AND @original_Work_Mobile_Number IS NULL)) AND (([Private_Mobile_Number] = @original_Private_Mobile_Number) OR ([Private_Mobile_Number] IS NULL AND @original_Private_Mobile_Number IS NULL)) AND (([Address] = @original_Address) OR ([Address] IS NULL AND @original_Address IS NULL)) AND (([U_Start_Date] = @original_U_Start_Date) OR ([U_Start_Date] IS NULL AND @original_U_Start_Date IS NULL)) AND (([Contract_Start_Date] = @original_Contract_Start_Date) OR ([Contract_Start_Date] IS NULL AND @original_Contract_Start_Date IS NULL)) AND (([Contract_End_Date] = @original_Contract_End_Date) OR ([Contract_End_Date] IS NULL AND @original_Contract_End_Date IS NULL)) AND (([U_Bday] = @original_U_Bday) OR ([U_Bday] IS NULL AND @original_U_Bday IS NULL)) AND (([Personal_ID] = @original_Personal_ID) OR ([Personal_ID] IS NULL AND @original_Personal_ID IS NULL)) AND (([ID_Issue_Date] = @original_ID_Issue_Date) OR ([ID_Issue_Date] IS NULL AND @original_ID_Issue_Date IS NULL)) AND (([ID_Expire_Date] = @original_ID_Expire_Date) OR ([ID_Expire_Date] IS NULL AND @original_ID_Expire_Date IS NULL)) AND (([Marital_Status] = @original_Marital_Status) OR ([Marital_Status] IS NULL AND @original_Marital_Status IS NULL)) AND (([Military_Status] = @original_Military_Status) OR ([Military_Status] IS NULL AND @original_Military_Status IS NULL)) AND (([Qualifications] = @original_Qualifications) OR ([Qualifications] IS NULL AND @original_Qualifications IS NULL)) AND (([U_Universty] = @original_U_Universty) OR ([U_Universty] IS NULL AND @original_U_Universty IS NULL)) AND (([U_Faculty] = @original_U_Faculty) OR ([U_Faculty] IS NULL AND @original_U_Faculty IS NULL)) AND (([U_Section] = @original_U_Section) OR ([U_Section] IS NULL AND @original_U_Section IS NULL)) AND (([U_GPA] = @original_U_GPA) OR ([U_GPA] IS NULL AND @original_U_GPA IS NULL)) AND (([U_Graduation_Year] = @original_U_Graduation_Year) OR ([U_Graduation_Year] IS NULL AND @original_U_Graduation_Year IS NULL)) AND (([Insurance_Number] = @original_Insurance_Number) OR ([Insurance_Number] IS NULL AND @original_Insurance_Number IS NULL)) AND (([Basic_Salary] = @original_Basic_Salary) OR ([Basic_Salary] IS NULL AND @original_Basic_Salary IS NULL)) AND (([Variable_Salary] = @original_Variable_Salary) OR ([Variable_Salary] IS NULL AND @original_Variable_Salary IS NULL)) AND (([Pri_Medical_insurance_status] = @original_Pri_Medical_insurance_status) OR ([Pri_Medical_insurance_status] IS NULL AND @original_Pri_Medical_insurance_status IS NULL)) AND (([Pri_Medical_Card_ Number] = @original_Pri_Medical_Card_Number) OR ([Pri_Medical_Card_ Number] IS NULL AND @original_Pri_Medical_Card_Number IS NULL)) AND (([Pri_Medical_Card_issue_date] = @original_Pri_Medical_Card_issue_date) OR ([Pri_Medical_Card_issue_date] IS NULL AND @original_Pri_Medical_Card_issue_date IS NULL)) AND (([Pub_Medical_insurance_status] = @original_Pub_Medical_insurance_status) OR ([Pub_Medical_insurance_status] IS NULL AND @original_Pub_Medical_insurance_status IS NULL)) AND (([Pub_Medical_insurance_Form] = @original_Pub_Medical_insurance_Form) OR ([Pub_Medical_insurance_Form] IS NULL AND @original_Pub_Medical_insurance_Form IS NULL)) AND (([Pub_Medical_card_issue_date] = @original_Pub_Medical_card_issue_date) OR ([Pub_Medical_card_issue_date] IS NULL AND @original_Pub_Medical_card_issue_date IS NULL)) AND (([Social_Insurance_status] = @original_Social_Insurance_status) OR ([Social_Insurance_status] IS NULL AND @original_Social_Insurance_status IS NULL)) AND (([Insurance_Date] = @original_Insurance_Date) OR ([Insurance_Date] IS NULL AND @original_Insurance_Date IS NULL)) AND (([Military_Expire_Date] = @original_Military_Expire_Date) OR ([Military_Expire_Date] IS NULL AND @original_Military_Expire_Date IS NULL))" InsertCommand="INSERT INTO [Users] ([U_Serial_Number], [U_File_Number], [Odeon_ID_Number], [U_FullName], [Sex], [Remarks], [U_Name], [U_Dep], [U_Password], [U_Internal_Mail], [U_Region], [U_Week_End], [U_Balance], [U_Incednt], [U_Manger_Mail], [U_Manger_Name], [U_Status], [Unit], [U_Position], [U_Nationality], [U_Title], [Work_Mobile_Number], [Private_Mobile_Number], [Address], [U_Start_Date], [Contract_Start_Date], [Contract_End_Date], [U_Bday], [Personal_ID], [ID_Issue_Date], [ID_Expire_Date], [Marital_Status], [Military_Status], [Qualifications], [U_Universty], [U_Faculty], [U_Section], [U_GPA], [U_Graduation_Year], [Insurance_Number], [Basic_Salary], [Variable_Salary], [Pri_Medical_insurance_status], [Pri_Medical_Card_ Number], [Pri_Medical_Card_issue_date], [Pub_Medical_insurance_status], [Pub_Medical_insurance_Form], [Pub_Medical_card_issue_date], [Social_Insurance_status], [Insurance_Date], [Military_Expire_Date]) VALUES (@U_Serial_Number, @U_File_Number, @Odeon_ID_Number, @U_FullName, @Sex, @Remarks, @U_Name, @U_Dep, @U_Password, @U_Internal_Mail, @U_Region, @U_Week_End, @U_Balance, @U_Incednt, @U_Manger_Mail, @U_Manger_Name, @U_Status, @Unit, @U_Position, @U_Nationality, @U_Title, @Work_Mobile_Number, @Private_Mobile_Number, @Address, @U_Start_Date, @Contract_Start_Date, @Contract_End_Date, @U_Bday, @Personal_ID, @ID_Issue_Date, @ID_Expire_Date, @Marital_Status, @Military_Status, @Qualifications, @U_Universty, @U_Faculty, @U_Section, @U_GPA, @U_Graduation_Year, @Insurance_Number, @Basic_Salary, @Variable_Salary, @Pri_Medical_insurance_status, @Pri_Medical_Card_Number, @Pri_Medical_Card_issue_date, @Pub_Medical_insurance_status, @Pub_Medical_insurance_Form, @Pub_Medical_card_issue_date, @Social_Insurance_status, @Insurance_Date, @Military_Expire_Date)" OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT * FROM [Users] WHERE ([U_Name] = @U_Name)" UpdateCommand="UPDATE [Users] SET [U_File_Number] = @U_File_Number, [Odeon_ID_Number] = @Odeon_ID_Number, [U_FullName] = @U_FullName, [Sex] = @Sex, [Remarks] = @Remarks, [U_Name] = @U_Name, [U_Dep] = @U_Dep, [U_Password] = @U_Password, [U_Internal_Mail] = @U_Internal_Mail, [U_Region] = @U_Region, [U_Week_End] = @U_Week_End, [U_Balance] = @U_Balance, [U_Incednt] = @U_Incednt, [U_Manger_Mail] = @U_Manger_Mail, [U_Manger_Name] = @U_Manger_Name, [U_Status] = @U_Status, [Unit] = @Unit, [U_Position] = @U_Position, [U_Nationality] = @U_Nationality, [U_Title] = @U_Title, [Work_Mobile_Number] = @Work_Mobile_Number, [Private_Mobile_Number] = @Private_Mobile_Number, [Address] = @Address, [U_Start_Date] = @U_Start_Date, [Contract_Start_Date] = @Contract_Start_Date, [Contract_End_Date] = @Contract_End_Date, [U_Bday] = @U_Bday, [Personal_ID] = @Personal_ID, [ID_Issue_Date] = @ID_Issue_Date, [ID_Expire_Date] = @ID_Expire_Date, [Marital_Status] = @Marital_Status, [Military_Status] = @Military_Status, [Qualifications] = @Qualifications, [U_Universty] = @U_Universty, [U_Faculty] = @U_Faculty, [U_Section] = @U_Section, [U_GPA] = @U_GPA, [U_Graduation_Year] = @U_Graduation_Year, [Insurance_Number] = @Insurance_Number, [Basic_Salary] = @Basic_Salary, [Variable_Salary] = @Variable_Salary, [Pri_Medical_insurance_status] = @Pri_Medical_insurance_status, [Pri_Medical_Card_ Number] = @Pri_Medical_Card_Number, [Pri_Medical_Card_issue_date] = @Pri_Medical_Card_issue_date, [Pub_Medical_insurance_status] = @Pub_Medical_insurance_status, [Pub_Medical_insurance_Form] = @Pub_Medical_insurance_Form, [Pub_Medical_card_issue_date] = @Pub_Medical_card_issue_date, [Social_Insurance_status] = @Social_Insurance_status, [Insurance_Date] = @Insurance_Date, [Military_Expire_Date] = @Military_Expire_Date WHERE [U_Serial_Number] = @original_U_Serial_Number AND (([U_File_Number] LIKE @original_U_File_Number) OR ([U_File_Number] IS NULL AND @original_U_File_Number IS NULL)) AND (([Odeon_ID_Number] LIKE @original_Odeon_ID_Number) OR ([Odeon_ID_Number] IS NULL AND @original_Odeon_ID_Number IS NULL)) AND (([U_FullName] LIKE @original_U_FullName) OR ([U_FullName] IS NULL AND @original_U_FullName IS NULL)) AND (([Sex] LIKE @original_Sex) OR ([Sex] IS NULL AND @original_Sex IS NULL)) AND (([Remarks] LIKE @original_Remarks) OR ([Remarks] IS NULL AND @original_Remarks IS NULL)) AND (([U_Name] LIKE @original_U_Name) OR ([U_Name] IS NULL AND @original_U_Name IS NULL)) AND (([U_Dep] LIKE @original_U_Dep) OR ([U_Dep] IS NULL AND @original_U_Dep IS NULL)) AND (([U_Password] LIKE @original_U_Password) OR ([U_Password] IS NULL AND @original_U_Password IS NULL)) AND (([U_Internal_Mail] LIKE @original_U_Internal_Mail) OR ([U_Internal_Mail] IS NULL AND @original_U_Internal_Mail IS NULL)) AND (([U_Region] LIKE @original_U_Region) OR ([U_Region] IS NULL AND @original_U_Region IS NULL)) AND (([U_Week_End] LIKE @original_U_Week_End) OR ([U_Week_End] IS NULL AND @original_U_Week_End IS NULL)) AND (([U_Balance] LIKE @original_U_Balance) OR ([U_Balance] IS NULL AND @original_U_Balance IS NULL)) AND (([U_Incednt] LIKE @original_U_Incednt) OR ([U_Incednt] IS NULL AND @original_U_Incednt IS NULL)) AND (([U_Manger_Mail] LIKE @original_U_Manger_Mail) OR ([U_Manger_Mail] IS NULL AND @original_U_Manger_Mail IS NULL)) AND (([U_Manger_Name] LIKE @original_U_Manger_Name) OR ([U_Manger_Name] IS NULL AND @original_U_Manger_Name IS NULL)) AND (([U_Status] LIKE @original_U_Status) OR ([U_Status] IS NULL AND @original_U_Status IS NULL)) AND (([Unit] LIKE @original_Unit) OR ([Unit] IS NULL AND @original_Unit IS NULL)) AND (([U_Position] LIKE @original_U_Position) OR ([U_Position] IS NULL AND @original_U_Position IS NULL)) AND (([U_Nationality] LIKE @original_U_Nationality) OR ([U_Nationality] IS NULL AND @original_U_Nationality IS NULL)) AND (([U_Title] LIKE @original_U_Title) OR ([U_Title] IS NULL AND @original_U_Title IS NULL)) AND (([Work_Mobile_Number] LIKE @original_Work_Mobile_Number) OR ([Work_Mobile_Number] IS NULL AND @original_Work_Mobile_Number IS NULL)) AND (([Private_Mobile_Number] LIKE @original_Private_Mobile_Number) OR ([Private_Mobile_Number] IS NULL AND @original_Private_Mobile_Number IS NULL)) AND (([Address] LIKE @original_Address) OR ([Address] IS NULL AND @original_Address IS NULL)) AND (([U_Start_Date] LIKE @original_U_Start_Date) OR ([U_Start_Date] IS NULL AND @original_U_Start_Date IS NULL)) AND (([Contract_Start_Date] LIKE @original_Contract_Start_Date) OR ([Contract_Start_Date] IS NULL AND @original_Contract_Start_Date IS NULL)) AND (([Contract_End_Date] LIKE @original_Contract_End_Date) OR ([Contract_End_Date] IS NULL AND @original_Contract_End_Date IS NULL)) AND (([U_Bday] LIKE @original_U_Bday) OR ([U_Bday] IS NULL AND @original_U_Bday IS NULL)) AND (([Personal_ID] LIKE @original_Personal_ID) OR ([Personal_ID] IS NULL AND @original_Personal_ID IS NULL)) AND (([ID_Issue_Date] LIKE @original_ID_Issue_Date) OR ([ID_Issue_Date] IS NULL AND @original_ID_Issue_Date IS NULL)) AND (([ID_Expire_Date] LIKE @original_ID_Expire_Date) OR ([ID_Expire_Date] IS NULL AND @original_ID_Expire_Date IS NULL)) AND (([Marital_Status] LIKE @original_Marital_Status) OR ([Marital_Status] IS NULL AND @original_Marital_Status IS NULL)) AND (([Military_Status] LIKE @original_Military_Status) OR ([Military_Status] IS NULL AND @original_Military_Status IS NULL)) AND (([Qualifications] LIKE @original_Qualifications) OR ([Qualifications] IS NULL AND @original_Qualifications IS NULL)) AND (([U_Universty] LIKE @original_U_Universty) OR ([U_Universty] IS NULL AND @original_U_Universty IS NULL)) AND (([U_Faculty] LIKE @original_U_Faculty) OR ([U_Faculty] IS NULL AND @original_U_Faculty IS NULL)) AND (([U_Section] LIKE @original_U_Section) OR ([U_Section] IS NULL AND @original_U_Section IS NULL)) AND (([U_GPA] LIKE @original_U_GPA) OR ([U_GPA] IS NULL AND @original_U_GPA IS NULL)) AND (([U_Graduation_Year] LIKE @original_U_Graduation_Year) OR ([U_Graduation_Year] IS NULL AND @original_U_Graduation_Year IS NULL)) AND (([Insurance_Number] LIKE @original_Insurance_Number) OR ([Insurance_Number] IS NULL AND @original_Insurance_Number IS NULL)) AND (([Basic_Salary] LIKE @original_Basic_Salary) OR ([Basic_Salary] IS NULL AND @original_Basic_Salary IS NULL)) AND (([Variable_Salary] LIKE @original_Variable_Salary) OR ([Variable_Salary] IS NULL AND @original_Variable_Salary IS NULL)) AND (([Pri_Medical_insurance_status] LIKE @original_Pri_Medical_insurance_status) OR ([Pri_Medical_insurance_status] IS NULL AND @original_Pri_Medical_insurance_status IS NULL)) AND (([Pri_Medical_Card_ Number] LIKE @original_Pri_Medical_Card_Number) OR ([Pri_Medical_Card_ Number] IS NULL AND @original_Pri_Medical_Card_Number IS NULL)) AND (([Pri_Medical_Card_issue_date] LIKE @original_Pri_Medical_Card_issue_date) OR ([Pri_Medical_Card_issue_date] IS NULL AND @original_Pri_Medical_Card_issue_date IS NULL)) AND (([Pub_Medical_insurance_status] LIKE @original_Pub_Medical_insurance_status) OR ([Pub_Medical_insurance_status] IS NULL AND @original_Pub_Medical_insurance_status IS NULL)) AND (([Pub_Medical_insurance_Form] LIKE @original_Pub_Medical_insurance_Form) OR ([Pub_Medical_insurance_Form] IS NULL AND @original_Pub_Medical_insurance_Form IS NULL)) AND (([Pub_Medical_card_issue_date] LIKE @original_Pub_Medical_card_issue_date) OR ([Pub_Medical_card_issue_date] IS NULL AND @original_Pub_Medical_card_issue_date IS NULL)) AND (([Social_Insurance_status] LIKE @original_Social_Insurance_status) OR ([Social_Insurance_status] IS NULL AND @original_Social_Insurance_status IS NULL)) AND (([Insurance_Date] LIKE @original_Insurance_Date) OR ([Insurance_Date] IS NULL AND @original_Insurance_Date IS NULL)) AND (([Military_Expire_Date] LIKE @original_Military_Expire_Date) OR ([Military_Expire_Date] IS NULL AND @original_Military_Expire_Date IS NULL))"> <DeleteParameters> <asp:Parameter Name="original_U_Serial_Number" Type="Int32" /> <asp:Parameter Name="original_U_File_Number" Type="String" /> <asp:Parameter Name="original_Odeon_ID_Number" Type="String" /> <asp:Parameter Name="original_U_FullName" Type="String" /> <asp:Parameter Name="original_Sex" Type="String" /> <asp:Parameter Name="original_Remarks" Type="String" /> <asp:Parameter Name="original_U_Name" Type="String" /> <asp:Parameter Name="original_U_Dep" Type="String" /> <asp:Parameter Name="original_U_Password" Type="String" /> <asp:Parameter Name="original_U_Internal_Mail" Type="String" /> <asp:Parameter Name="original_U_Region" Type="String" /> <asp:Parameter Name="original_U_Week_End" Type="String" /> <asp:Parameter Name="original_U_Balance" Type="String" /> <asp:Parameter Name="original_U_Incednt" Type="String" /> <asp:Parameter Name="original_U_Manger_Mail" Type="String" /> <asp:Parameter Name="original_U_Manger_Name" Type="String" /> <asp:Parameter Name="original_U_Status" Type="String" /> <asp:Parameter Name="original_Unit" Type="String" /> <asp:Parameter Name="original_U_Position" Type="String" /> <asp:Parameter Name="original_U_Nationality" Type="String" /> <asp:Parameter Name="original_U_Title" Type="String" /> <asp:Parameter Name="original_Work_Mobile_Number" Type="String" /> <asp:Parameter Name="original_Private_Mobile_Number" Type="String" /> <asp:Parameter Name="original_Address" Type="String" /> <asp:Parameter Name="original_U_Start_Date" DbType="Date" /> <asp:Parameter Name="original_Contract_Start_Date" DbType="Date" /> <asp:Parameter Name="original_Contract_End_Date" DbType="Date" /> <asp:Parameter Name="original_U_Bday" DbType="Date" /> <asp:Parameter Name="original_Personal_ID" Type="String" /> <asp:Parameter Name="original_ID_Issue_Date" DbType="Date" /> <asp:Parameter Name="original_ID_Expire_Date" DbType="Date" /> <asp:Parameter Name="original_Marital_Status" Type="String" /> <asp:Parameter Name="original_Military_Status" Type="String" /> <asp:Parameter Name="original_Qualifications" Type="String" /> <asp:Parameter Name="original_U_Universty" Type="String" /> <asp:Parameter Name="original_U_Faculty" Type="String" /> <asp:Parameter Name="original_U_Section" Type="String" /> <asp:Parameter Name="original_U_GPA" Type="String" /> <asp:Parameter Name="original_U_Graduation_Year" Type="String" /> <asp:Parameter Name="original_Insurance_Number" Type="String" /> <asp:Parameter Name="original_Basic_Salary" Type="Decimal" /> <asp:Parameter Name="original_Variable_Salary" Type="Decimal" /> <asp:Parameter Name="original_Pri_Medical_insurance_status" Type="String" /> <asp:Parameter Name="original_Pri_Medical_Card_Number" Type="String" /> <asp:Parameter Name="original_Pri_Medical_Card_issue_date" DbType="Date" /> <asp:Parameter Name="original_Pub_Medical_insurance_status" Type="String" /> <asp:Parameter Name="original_Pub_Medical_insurance_Form" Type="String" /> <asp:Parameter Name="original_Pub_Medical_card_issue_date" DbType="Date" /> <asp:Parameter Name="original_Social_Insurance_status" Type="String" /> <asp:Parameter Name="original_Insurance_Date" DbType="Date" /> <asp:Parameter Name="original_Military_Expire_Date" DbType="Date" /> </DeleteParameters> <InsertParameters> <asp:Parameter Name="U_Serial_Number" Type="Int32" /> <asp:Parameter Name="U_File_Number" Type="String" /> <asp:Parameter Name="Odeon_ID_Number" Type="String" /> <asp:Parameter Name="U_FullName" Type="String" /> <asp:Parameter Name="Sex" Type="String" /> <asp:Parameter Name="Remarks" Type="String" /> <asp:Parameter Name="U_Name" Type="String" /> <asp:Parameter Name="U_Dep" Type="String" /> <asp:Parameter Name="U_Password" Type="String" /> <asp:Parameter Name="U_Internal_Mail" Type="String" /> <asp:Parameter Name="U_Region" Type="String" /> <asp:Parameter Name="U_Week_End" Type="String" /> <asp:Parameter Name="U_Balance" Type="String" /> <asp:Parameter Name="U_Incednt" Type="String" /> <asp:Parameter Name="U_Manger_Mail" Type="String" /> <asp:Parameter Name="U_Manger_Name" Type="String" /> <asp:Parameter Name="U_Status" Type="String" /> <asp:Parameter Name="Unit" Type="String" /> <asp:Parameter Name="U_Position" Type="String" /> <asp:Parameter Name="U_Nationality" Type="String" /> <asp:Parameter Name="U_Title" Type="String" /> <asp:Parameter Name="Work_Mobile_Number" Type="String" /> <asp:Parameter Name="Private_Mobile_Number" Type="String" /> <asp:Parameter Name="Address" Type="String" /> <asp:Parameter Name="U_Start_Date" DbType="Date" /> <asp:Parameter Name="Contract_Start_Date" DbType="Date" /> <asp:Parameter Name="Contract_End_Date" DbType="Date" /> <asp:Parameter Name="U_Bday" DbType="Date" /> <asp:Parameter Name="Personal_ID" Type="String" /> <asp:Parameter Name="ID_Issue_Date" DbType="Date" /> <asp:Parameter Name="ID_Expire_Date" DbType="Date" /> <asp:Parameter Name="Marital_Status" Type="String" /> <asp:Parameter Name="Military_Status" Type="String" /> <asp:Parameter Name="Qualifications" Type="String" /> <asp:Parameter Name="U_Universty" Type="String" /> <asp:Parameter Name="U_Faculty" Type="String" /> <asp:Parameter Name="U_Section" Type="String" /> <asp:Parameter Name="U_GPA" Type="String" /> <asp:Parameter Name="U_Graduation_Year" Type="String" /> <asp:Parameter Name="Insurance_Number" Type="String" /> <asp:Parameter Name="Basic_Salary" Type="Decimal" /> <asp:Parameter Name="Variable_Salary" Type="Decimal" /> <asp:Parameter Name="Pri_Medical_insurance_status" Type="String" /> <asp:Parameter Name="Pri_Medical_Card_Number" Type="String" /> <asp:Parameter Name="Pri_Medical_Card_issue_date" DbType="Date" /> <asp:Parameter Name="Pub_Medical_insurance_status" Type="String" /> <asp:Parameter Name="Pub_Medical_insurance_Form" Type="String" /> <asp:Parameter Name="Pub_Medical_card_issue_date" DbType="Date" /> <asp:Parameter Name="Social_Insurance_status" Type="String" /> <asp:Parameter Name="Insurance_Date" DbType="Date" /> <asp:Parameter Name="Military_Expire_Date" DbType="Date" /> </InsertParameters> <SelectParameters> <asp:ControlParameter ControlID="DropDownList2" Name="U_Name" PropertyName="SelectedValue" Type="String" /> </SelectParameters> <UpdateParameters> <asp:Parameter Name="U_File_Number" Type="String" /> <asp:Parameter Name="Odeon_ID_Number" Type="String" /> <asp:Parameter Name="U_FullName" Type="String" /> <asp:Parameter Name="Sex" Type="String" /> <asp:Parameter Name="Remarks" Type="String" /> <asp:Parameter Name="U_Name" Type="String" /> <asp:Parameter Name="U_Dep" Type="String" /> <asp:Parameter Name="U_Password" Type="String" /> <asp:Parameter Name="U_Internal_Mail" Type="String" /> <asp:Parameter Name="U_Region" Type="String" /> <asp:Parameter Name="U_Week_End" Type="String" /> <asp:Parameter Name="U_Balance" Type="String" /> <asp:Parameter Name="U_Incednt" Type="String" /> <asp:Parameter Name="U_Manger_Mail" Type="String" /> <asp:Parameter Name="U_Manger_Name" Type="String" /> <asp:Parameter Name="U_Status" Type="String" /> <asp:Parameter Name="Unit" Type="String" /> <asp:Parameter Name="U_Position" Type="String" /> <asp:Parameter Name="U_Nationality" Type="String" /> <asp:Parameter Name="U_Title" Type="String" /> <asp:Parameter Name="Work_Mobile_Number" Type="String" /> <asp:Parameter Name="Private_Mobile_Number" Type="String" /> <asp:Parameter Name="Address" Type="String" /> <asp:Parameter Name="U_Start_Date" DbType="Date" /> <asp:Parameter Name="Contract_Start_Date" DbType="Date" /> <asp:Parameter Name="Contract_End_Date" DbType="Date" /> <asp:Parameter Name="U_Bday" DbType="Date" /> <asp:Parameter Name="Personal_ID" Type="String" /> <asp:Parameter Name="ID_Issue_Date" DbType="Date" /> <asp:Parameter Name="ID_Expire_Date" DbType="Date" /> <asp:Parameter Name="Marital_Status" Type="String" /> <asp:Parameter Name="Military_Status" Type="String" /> <asp:Parameter Name="Qualifications" Type="String" /> <asp:Parameter Name="U_Universty" Type="String" /> <asp:Parameter Name="U_Faculty" Type="String" /> <asp:Parameter Name="U_Section" Type="String" /> <asp:Parameter Name="U_GPA" Type="String" /> <asp:Parameter Name="U_Graduation_Year" Type="String" /> <asp:Parameter Name="Insurance_Number" Type="String" /> <asp:Parameter Name="Basic_Salary" Type="Decimal" /> <asp:Parameter Name="Variable_Salary" Type="Decimal" /> <asp:Parameter Name="Pri_Medical_insurance_status" Type="String" /> <asp:Parameter Name="Pri_Medical_Card_Number" Type="String" /> <asp:Parameter Name="Pri_Medical_Card_issue_date" DbType="Date" /> <asp:Parameter Name="Pub_Medical_insurance_status" Type="String" /> <asp:Parameter Name="Pub_Medical_insurance_Form" Type="String" /> <asp:Parameter Name="Pub_Medical_card_issue_date" DbType="Date" /> <asp:Parameter Name="Social_Insurance_status" Type="String" /> <asp:Parameter Name="Insurance_Date" DbType="Date" /> <asp:Parameter Name="Military_Expire_Date" DbType="Date" /> <asp:Parameter Name="original_U_Serial_Number" Type="Int32" /> <asp:Parameter Name="original_U_File_Number" Type="String" /> <asp:Parameter Name="original_Odeon_ID_Number" Type="String" /> <asp:Parameter Name="original_U_FullName" Type="String" /> <asp:Parameter Name="original_Sex" Type="String" /> <asp:Parameter Name="original_Remarks" Type="String" /> <asp:Parameter Name="original_U_Name" Type="String" /> <asp:Parameter Name="original_U_Dep" Type="String" /> <asp:Parameter Name="original_U_Password" Type="String" /> <asp:Parameter Name="original_U_Internal_Mail" Type="String" /> <asp:Parameter Name="original_U_Region" Type="String" /> <asp:Parameter Name="original_U_Week_End" Type="String" /> <asp:Parameter Name="original_U_Balance" Type="String" /> <asp:Parameter Name="original_U_Incednt" Type="String" /> <asp:Parameter Name="original_U_Manger_Mail" Type="String" /> <asp:Parameter Name="original_U_Manger_Name" Type="String" /> <asp:Parameter Name="original_U_Status" Type="String" /> <asp:Parameter Name="original_Unit" Type="String" /> <asp:Parameter Name="original_U_Position" Type="String" /> <asp:Parameter Name="original_U_Nationality" Type="String" /> <asp:Parameter Name="original_U_Title" Type="String" /> <asp:Parameter Name="original_Work_Mobile_Number" Type="String" /> <asp:Parameter Name="original_Private_Mobile_Number" Type="String" /> <asp:Parameter Name="original_Address" Type="String" /> <asp:Parameter Name="original_U_Start_Date" DbType="Date" /> <asp:Parameter Name="original_Contract_Start_Date" DbType="Date" /> <asp:Parameter Name="original_Contract_End_Date" DbType="Date" /> <asp:Parameter Name="original_U_Bday" DbType="Date" /> <asp:Parameter Name="original_Personal_ID" Type="String" /> <asp:Parameter Name="original_ID_Issue_Date" DbType="Date" /> <asp:Parameter Name="original_ID_Expire_Date" DbType="Date" /> <asp:Parameter Name="original_Marital_Status" Type="String" /> <asp:Parameter Name="original_Military_Status" Type="String" /> <asp:Parameter Name="original_Qualifications" Type="String" /> <asp:Parameter Name="original_U_Universty" Type="String" /> <asp:Parameter Name="original_U_Faculty" Type="String" /> <asp:Parameter Name="original_U_Section" Type="String" /> <asp:Parameter Name="original_U_GPA" Type="String" /> <asp:Parameter Name="original_U_Graduation_Year" Type="String" /> <asp:Parameter Name="original_Insurance_Number" Type="String" /> <asp:Parameter Name="original_Basic_Salary" Type="Decimal" /> <asp:Parameter Name="original_Variable_Salary" Type="Decimal" /> <asp:Parameter Name="original_Pri_Medical_insurance_status" Type="String" /> <asp:Parameter Name="original_Pri_Medical_Card_Number" Type="String" /> <asp:Parameter Name="original_Pri_Medical_Card_issue_date" DbType="Date" /> <asp:Parameter Name="original_Pub_Medical_insurance_status" Type="String" /> <asp:Parameter Name="original_Pub_Medical_insurance_Form" Type="String" /> <asp:Parameter Name="original_Pub_Medical_card_issue_date" DbType="Date" /> <asp:Parameter Name="original_Social_Insurance_status" Type="String" /> <asp:Parameter Name="original_Insurance_Date" DbType="Date" /> <asp:Parameter Name="original_Military_Expire_Date" DbType="Date" /> </UpdateParameters> </asp:SqlDataSource>
Maria Ilieva
Telerik team
answered
on
26 Jun 2014
1 answer
541 views
I use SignalR, to logging items in RadGrid.
Message
TypeError: access to strict mode caller function is censored
The problem is in FireFox 29 and IE 10, not in Chrome 35.
I see the Problem is the call RefreshGrid()...
Message
TypeError: access to strict mode caller function is censored
The problem is in FireFox 29 and IE 10, not in Chrome 35.
<telerik:RadCodeBlock runat="server"> <script type="text/javascript"> function RefreshGrid() { var masterTable = $find("<%= GridPlayerMessages.ClientID %>").get_masterTableView(); masterTable.rebind(); } $(function () { var hub = $.connection.pilotServerHub; hub.client.logMessage = function () { RefreshGrid(); }; $.connection.hub.start(); }); </script></telerik:RadCodeBlock>I see the Problem is the call RefreshGrid()...
Kostadin
Telerik team
answered
on
26 Jun 2014
2 answers
94 views
Hi,
Is there any control in telerik that supports the following features for asp.net visualstudio 2010
Is there any control in telerik that supports the following features for asp.net visualstudio 2010
- Gantt view display of dynamic data
- Drag and drop support
- Plot nodes in the Gantt view in different colors.
- Connecting nodes in the Gantt view
also req to know whether any demo version and user manual available for that ?
Rumen
Telerik team
answered
on
26 Jun 2014
7 answers
87 views
Hello
Can you think to create a RadGanttView controle for asp.net Ajax ?
thanks
OLivier,
Can you think to create a RadGanttView controle for asp.net Ajax ?
thanks
OLivier,
Rumen
Telerik team
answered
on
26 Jun 2014
3 answers
128 views
The HD button / function not work!
​Even if I link to another hd movie the "dansskola.mp4" still playing.
"showskola_1080p.mp4" should play in HD mode....
And how do I choose which social media i want to use in the ShareButton function?
I might just want to take advantage of Facebook and Twitter....
​Even if I link to another hd movie the "dansskola.mp4" still playing.
"showskola_1080p.mp4" should play in HD mode....
RadMediaPlayer1.Source = "~/video/dansskola.mp4"RadMediaPlayer1.HDSource = "~/video/showskola_1080p.mp4"RadMediaPlayer1.Poster = "~/posters/dansskola.jpg"And how do I choose which social media i want to use in the ShareButton function?
I might just want to take advantage of Facebook and Twitter....
Eyup
Telerik team
answered
on
26 Jun 2014
3 answers
502 views
Hi all ,
I am using Telerik grid to insert, update and delete records but my problem is i want to show the rad window alert message on successfull update,insert , or delete but i am unable to figure out how to trigger this.
Below is my rad grid code
This is my insert command code
The rad windows inside this is also not called
Below is the code written on item inserted
Neither this is called and works though there is successfull insert in the database.
Help is highly appreciated.
Thanks,
I am using Telerik grid to insert, update and delete records but my problem is i want to show the rad window alert message on successfull update,insert , or delete but i am unable to figure out how to trigger this.
Below is my rad grid code
<telerik:RadGrid ID="RadGrid1" runat="server" GridLines="None" AllowPaging="True" PageSize="10" CssClass="RadGrid" AllowSorting="True" AutoGenerateColumns="False" ShowStatusBar="true" AllowAutomaticDeletes="true" AllowAutomaticUpdates="true" AllowAutomaticInserts="true" OnNeedDataSource="RadGrid1_NeedDataSource" OnUpdateCommand="RadGrid1_UpdateCommand" OnInsertCommand="RadGrid1_InsertCommand" OnDeleteCommand="RadGrid1_DeleteCommand" OnItemDeleted="RadGrid1_ItemDeleted" OnItemUpdated="RadGrid1_ItemUpdated"> <MasterTableView Width="100%" CommandItemDisplay="Top" DataKeyNames="UserId"> <Columns> <telerik:GridBoundColumn Visible="false" UniqueName="UserId" DataField="UserId" HeaderText="User Id" /> <telerik:GridBoundColumn DataField="FirstName" HeaderText="First Name" Visible="true" UniqueName="FirstName" /> <telerik:GridBoundColumn DataField="MiddleName" HeaderText="Middle Name" /> <telerik:GridBoundColumn DataField="LastName" HeaderText="Last Name" /> <%-- <telerik:GridCalculatedColumn DataFields="FirstName, MiddleName, LastName" Expression="{0} +{1} +{2}" HeaderText="Name" />--%> <telerik:GridBoundColumn DataField="UserType.UserTypeName" HeaderText="Role" /> <telerik:GridBoundColumn DataField="State.Name" HeaderText="State" /> <telerik:GridEditCommandColumn UniqueName="EditCommandColumn" HeaderText="Edit" ButtonType="ImageButton"> </telerik:GridEditCommandColumn> <%-- <telerik:GridEditCommandColumn UniqueName="EditCommandColumn"> </telerik:GridEditCommandColumn>--%> <telerik:GridButtonColumn UniqueName="DeleteColumn" CommandName="Delete" HeaderText="Delete" ButtonType="ImageButton" ConfirmDialogType="RadWindow" ConfirmText="Are you sure, you want to delete?" ConfirmDialogHeight="100px" ConfirmTitle="Delete TIMS User"> </telerik:GridButtonColumn> </Columns> <EditFormSettings UserControlName="~/UserControls/ManageUserControls/ManageUsers.ascx" EditFormType="WebUserControl"> <EditColumn UniqueName="EditCommandColumn1"> </EditColumn> </EditFormSettings> </MasterTableView> <ClientSettings EnableAlternatingItems="true" EnableRowHoverStyle="true" Selecting-AllowRowSelect="true"> <ClientEvents OnRowDblClick="RowDblClick" /> </ClientSettings> </telerik:RadGrid>protected void RadGrid1_InsertCommand(object source, GridCommandEventArgs e) { var editedItem = e.Item as GridEditableItem; var userControl = (UserControl)e.Item.FindControl(GridEditFormItem.EditFormUserControlID); var user = new User(); //const string radalertscript = "<script language='javascript'>function f(){radalert('Welcome to RadWindow <b>Prometheus</b>!', 330, 210); Sys.Application.remove_load(f);}; Sys.Application.add_load(f);</script>"; //Page.ClientScript.RegisterStartupScript(this.GetType(), "radalert", radalertscript); user.UserName = ((RadTextBox)userControl.FindControl("tbUserName")).Text; user.Password = Utility.EncryptTDC(((RadTextBox)userControl.FindControl("tbPassword")).Text); user.FirstName = ((RadTextBox)userControl.FindControl("tbFirstName")).Text; user.MiddleName = ((RadTextBox)userControl.FindControl("tbMiddleName")).Text; user.LastName = ((RadTextBox)userControl.FindControl("tbLastName")).Text; user.ContactPhoneMobile = ((RadTextBox)userControl.FindControl("tbHomePhone")).Text; user.ContactPhoneOffice = ((RadTextBox)userControl.FindControl("tbOfficePhone")).Text; if (((RadComboBox)userControl.FindControl("ddlState")).SelectedValue != "-1") user.StateId = Convert.ToInt32(((RadComboBox)userControl.FindControl("ddlState")).SelectedValue); if (((RadComboBox)userControl.FindControl("ddlInstitute")).SelectedValue != "-1") user.InstituteId = Convert.ToInt32(((RadComboBox)userControl.FindControl("ddlInstitute")).SelectedValue); if (((RadComboBox)userControl.FindControl("ddlTrainer")).SelectedValue != "-1") user.TrainerId = Convert.ToInt32(((RadComboBox)userControl.FindControl("ddlTrainer")).SelectedValue); user.UserTypeId = Convert.ToInt32(((RadComboBox)userControl.FindControl("ddlUserType")).SelectedValue); user.DateCreated = DateTime.Now; //string radalertscript = // "<script language='javascript'>function f(){radalert('main text to display', 340, 110, 'new title');}</script>"; ClientScript.RegisterStartupScript(this.GetType(), "radalert", "callAlert();", true); var userServiceContext = new TimsService<User>(); var result = userServiceContext.Create(user); if (result) { ((RadTextBox)userControl.FindControl("tbUserName")).Text = ""; ((RadTextBox)userControl.FindControl("tbPassword")).Text = ""; ((RadTextBox)userControl.FindControl("tbReEnterPassword")).Text = ""; ((RadTextBox)userControl.FindControl("tbFirstName")).Text = ""; ((RadTextBox)userControl.FindControl("tbMiddleName")).Text = ""; ((RadTextBox)userControl.FindControl("tbLastName")).Text = ""; ((RadTextBox)userControl.FindControl("tbHomePhone")).Text = ""; ((RadTextBox)userControl.FindControl("tbOfficePhone")).Text = ""; ((RadComboBox)userControl.FindControl("ddlState")).SelectedValue = "-1"; ((RadComboBox)userControl.FindControl("ddlInstitute")).SelectedValue = "-1"; ((RadComboBox)userControl.FindControl("ddlTrainer")).SelectedValue = "-1"; ((RadComboBox)userControl.FindControl("ddlUserType")).SelectedValue = "-1"; const string radalertscript = "<script language='javascript'>function f(){radalert('Welcome to RadWindow <b>Prometheus</b>!', 330, 210); Sys.Application.remove_load(f);}; Sys.Application.add_load(f);</script>"; Page.ClientScript.RegisterStartupScript(this.GetType(), "radalert", radalertscript, true); //RadGrid1.ItemInserted += RadGrid1_ItemInserted; } }The rad windows inside this is also not called
Below is the code written on item inserted
protected void RadGrid1_ItemInserted(object source, GridInsertedEventArgs e) { const string radalertscript = "<script language='javascript'>function f(){radalert('Welcome to RadWindow <b>Prometheus</b>!', 330, 210); Sys.Application.remove_load(f);}; Sys.Application.add_load(f);</script>"; Page.ClientScript.RegisterStartupScript(this.GetType(), "radalert", radalertscript, true); }Help is highly appreciated.
Thanks,
Marin Bratanov
Telerik team
answered
on
26 Jun 2014
10 answers
633 views
I'm trying to get the spell check to work under Prometheus. With everything I try I get the following 500 error:
---------------------------
Windows Internet Explorer
---------------------------
Spell Check Handler Server Error:500
<html>
<head>
<title>No dictionary loaded. Set the DictionaryPath property before spellchecking.</title>
<style>
body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;}
p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px}
b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px}
H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }
H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }
pre {font-family:"Lucida Console";font-size: .9em}
.marker {font-weight: bold; color: black;text-decoration: none;}
.version {color: gray;}
.error {margin-bottom: 10px;}
.expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; }
</style>
</head>
<body bgcolor="white">
<span><H1>Server Error in '/CANCis' Application.<hr width=100% size=1 color=silver></H1>
<h2> <i>No dictionary loaded. Set the DictionaryPath property before spellchecking.</i> </h2></span>
<font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">
<b> Description: </b>An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
<br><br>
<b> Exception Details: </b>System.ArgumentException: No dictionary loaded. Set the DictionaryPath property before spellchecking.<br><br>
<b>Source Error:</b> <br><br>
<table width=100% bgcolor="#ffffcc">
<tr>
<td>
<code>
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be ide…
---------------------------
OK
---------------------------
I'm not sure what I'm doing wrong. I've loaded the skins for Prometheus under the themes folder, the dictionaries under the Data-App folder and the Global Resource files.
3 answers
279 views
I am using the spell in a page located in a sub folder on my site. It works fine on my local machine, but on our QA and production servers it fails with the following client side error.
Webpage error details
User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2; .NET CLR 1.1.4322; .NET4.0C; .NET4.0E)
Timestamp: Tue, 2 Nov 2010 16:22:45 UTC
Message: Sys.ArgumentException: Cannot deserialize. The data does not correspond to valid JSON.
Parameter name: data
Line: 5
Char: 84093
Code: 0
URI: http://cawebappsdev/SalesCRMQA/ScriptResource.axd?d=jKruckmJp8vDLb592u-Ri4JQ91O8nSdaBpoqumey8nfZ3YV4dMT_t9s3_TfYk24911J7iOJTrfZn-SHpKIhcco-cO0sEgm8QZyxP_GOGncAzLS6EkF8ge5HzbCCOjPfNFrr9o9imvnTrCdbgX0MV8BjBK_Q1&t=2610f696
I did a search and following previous posts I have not found a solution. Here is my control tag.
<telerik:RadSpell id="radspellEditCallReport_GeneralSpellCheckTop" runat="server" ControlsToCheck="txtEditCallReport_ExecutiveSummary,reEditCallReport_CallObjectives,reEditCallReport_CallDetails,reEditCallReport_ActionItems" ButtonType="None" /> Here are my web.config entries
<httpHandlers> <add path="ChartImage.axd" type="Telerik.Web.UI.ChartHttpHandler" verb="*" validate="false" /> <add path="Telerik.Web.UI.DialogHandler.aspx" type="Telerik.Web.UI.DialogHandler" verb="*" validate="false" /> <add path="Telerik.RadUploadProgressHandler.ashx" type="Telerik.Web.UI.RadUploadProgressHandler" verb="*" validate="false" /> <add path="Telerik.Web.UI.WebResource.axd" type="Telerik.Web.UI.WebResource" verb="*" validate="false" /> <add path="Telerik.Web.UI.SpellCheckHandler.axd" type="Telerik.Web.UI.SpellCheckHandler" verb="*" validate="false" /> </httpHandlers> <add name="Telerik_Web_UI_SpellCheckHandler_axd" verb="*" preCondition="integratedMode" path="Telerik.Web.UI.SpellCheckHandler.axd" type="Telerik.Web.UI.SpellCheckHandler" />
<location path="Telerik.Web.UI.SpellCheckHandler.axd"> <system.web> <authorization> <allow users="*"/> </authorization> </system.web> </location>7 answers
328 views
Hi
I am using Telerik2012 Radeditor in my page. I have given the following statement in the editor control.
<telerik:EditorTool Name="AjaxSpellCheck" ShowIcon="true" Enabled="true" />
I have added corresponding changes in web.config file also. But once I click the icon on RadEditor, it shows a drop down as
"Spell checking in progress..." and two buttons as "Finish Spellchecking" and "Cancel". This two buttons are always disabled. This state remains the same as long as the page exists. Also the spell checker is not indicating any errors in the editor.
Can anyone please tell me what would be the issue here?
Any help will be highly appreciated.
Regards
Rekha.
I am using Telerik2012 Radeditor in my page. I have given the following statement in the editor control.
<telerik:EditorTool Name="AjaxSpellCheck" ShowIcon="true" Enabled="true" />
I have added corresponding changes in web.config file also. But once I click the icon on RadEditor, it shows a drop down as
"Spell checking in progress..." and two buttons as "Finish Spellchecking" and "Cancel". This two buttons are always disabled. This state remains the same as long as the page exists. Also the spell checker is not indicating any errors in the editor.
Can anyone please tell me what would be the issue here?
Any help will be highly appreciated.
Regards
Rekha.
1 answer
180 views
Hi,
I have in my html RadTextBox:
<telerik:RadTextBox ID="ShrtgLicAreaTextBox" runat="server" TabIndex="2" Width="300px" CssClass="textbox" MaxLength="40" Height="15px" onKeyUp="Count(this,40)" onChange="Count(this,40)" FocusedStyle-BackColor="#D4DEEC" >
<ClientEvents OnBlur="OnBlur" />
Here is my js for OnBlur event:
<script type="text/javascript">
function OnBlur(sender) {
sender.get_styles().EnabledStyle[0] += "background-color:#FFCC99;";
}
</script>
Bur for some reason when I leave textbox background color is not changing looks like OnBlur event does not work.
Thank so much for yuor help.
I have in my html RadTextBox:
<telerik:RadTextBox ID="ShrtgLicAreaTextBox" runat="server" TabIndex="2" Width="300px" CssClass="textbox" MaxLength="40" Height="15px" onKeyUp="Count(this,40)" onChange="Count(this,40)" FocusedStyle-BackColor="#D4DEEC" >
<ClientEvents OnBlur="OnBlur" />
Here is my js for OnBlur event:
<script type="text/javascript">
function OnBlur(sender) {
sender.get_styles().EnabledStyle[0] += "background-color:#FFCC99;";
}
</script>
Bur for some reason when I leave textbox background color is not changing looks like OnBlur event does not work.
Thank so much for yuor help.
Shinu
Top achievements
Rank 2
Rank 2
answered
on
26 Jun 2014
