Mohamed El-Sayed
Top achievements
Rank 1
Rank 1
Mohamed El-Sayed
asked on 24 Jun 2014, 06:29 PM
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>1 Answer, 1 is accepted
0
Hi,
I suppose that the error you are facing is a general SQL one and is not directly related to the RadGrid control. You can probably replace the RadGrid with a asp GridView and will get the same error.
Actually this is widely discussed on the web. See this thread for example.
I hope this helps!
Regards,
Maria Ilieva
Telerik
I suppose that the error you are facing is a general SQL one and is not directly related to the RadGrid control. You can probably replace the RadGrid with a asp GridView and will get the same error.
Actually this is widely discussed on the web. See this thread for example.
I hope this helps!
Regards,
Maria Ilieva
Telerik
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.