Telerik Forums
UI for ASP.NET AJAX Forum
2 answers
470 views
Hi, I have a RadGrid that is basically copied from the Batch Editing demo (FYI, I'm a Telerik newbie). Functionally it all works great and I was pleased with how quickly I was able to convert the demo to suit me needs. However, I have one small issue with the GridTextBoxColumnEditor control width. No matter what I try to set in the aspx code, the text box width is resolutely fixed at what looks to be 100px-150px.
In the code sample I've included below, the textbox width is set to 200px. I can change this to 2px or 2000px or just delete the line altogether. It makes no difference. Could anyone help please?
<telerik:RadWindowManager ID="RadWindowManager1" runat="server" EnableShadow="true"></telerik:RadWindowManager>
 
<telerik:RadAjaxPanel runat="server" ID="RadAjaxPanel1">
    <telerik:RadGrid ID="RadGrid1" DataSourceID="ds_ActivityCodes" AutoGenerateColumns="False" AllowSorting="True"
        AllowAutomaticDeletes="False" AllowAutomaticInserts="True" AllowAutomaticUpdates="True"
        AllowPaging="True" GridLines="None" PageSize="10" Width="750px" runat="server">
 
        <MasterTableView CommandItemDisplay="TopAndBottom" DataKeyNames="activity_id"
            DataSourceID="ds_ActivityCodes" HorizontalAlign="NotSet" EditMode="Batch" AutoGenerateColumns="False">
 
            <CommandItemSettings ShowSaveChangesButton="false" />
 
            <BatchEditingSettings EditType="Cell" OpenEditingEvent="None" />
 
            <SortExpressions>
                <telerik:GridSortExpression FieldName="ActivityCode" SortOrder="Ascending" />
            </SortExpressions>
 
            <Columns>
                <telerik:GridBoundColumn DataField="ActivityCode" HeaderStyle-Width="60px" HeaderText="Activity Code" SortExpression="ActivityCode" UniqueName="ActivityCode">
                    <ColumnValidationSettings EnableRequiredFieldValidation="true">
                        <RequiredFieldValidator ForeColor="Red" Text="*This field is required">
                        </RequiredFieldValidator>
                    </ColumnValidationSettings>
                </telerik:GridBoundColumn>
 
                <telerik:GridBoundColumn DataField="ActivityDescription" HeaderStyle-Width="210px" HeaderText="Description" SortExpression="ActivityDescription" UniqueName="ActivityDescription">
                    <ColumnValidationSettings EnableRequiredFieldValidation="true">
                        <RequiredFieldValidator ForeColor="Red" Text="*This field is required">
                        </RequiredFieldValidator>
                    </ColumnValidationSettings>
                </telerik:GridBoundColumn>
 
                <telerik:GridCheckBoxColumn DataField="display" HeaderStyle-Width="60px" HeaderText="Display" SortExpression="display" UniqueName="display" >
                </telerik:GridCheckBoxColumn>
            </Columns>
 
        </MasterTableView>
    </telerik:RadGrid>
 
    <telerik:GridTextBoxColumnEditor runat="server" ID="TextEditor">
        <TextBoxStyle Width="200px" />
    </telerik:GridTextBoxColumnEditor>
 
    <telerik:GridCheckBoxColumnEditor runat="server" ID="CheckBoxEditor">
        <CheckBoxStyle Width="20px" />
    </telerik:GridCheckBoxColumnEditor>
</telerik:RadAjaxPanel>
Geoff
Top achievements
Rank 1
 answered on 05 Nov 2013
3 answers
198 views
Hi

I am able to bind resource combobox in radscheduler, i want to set default selected index, by default null value is coming in that 

I don't want null value, i want to put selected index 1 so that by default i can have some value in that.

Thank & Regards
--------------------------
Ashok k
Plamen
Telerik team
 answered on 05 Nov 2013
1 answer
134 views
Hi Support

I have a radtilelist control with content template tiles bound to an sql datasource. Everything works fine except being unable to add settings for peek template. I cant find the settings in intellisense. I want to display template for 2 seconds on mouse over after mouse out.  I need some help.

Thanks
Karl
Shinu
Top achievements
Rank 2
 answered on 05 Nov 2013
1 answer
109 views
I have this Radgrid:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="projects.aspx.cs" Inherits="projects" %>
 
<%@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
<head runat="server">
    <title>Projects</title>
</head>
<body>
    <table width="100%">
    <tr>
    <td><img src="images/logo.PNG"  /></td>
    </tr>
    </table>
 
 
    <form id="form1" runat="server">
    <div>
     
    </div>
     <telerik:RadScriptManager ID="RadScriptManager1" runat="server">
            </telerik:RadScriptManager>
       <telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">
        <script type="text/javascript">
            // <![CDATA[
            //On insert and update buttons click temporarily disables ajax to perform upload actions
            function conditionalPostback(sender, eventArgs) {
                var theRegexp = new RegExp("\.UpdateButton$|\.PerformInsertButton$", "ig");
                if (eventArgs.get_eventTarget().match(theRegexp)) {
                    var upload = $find(window['UploadId']);
                    //alert(upload);
                    if (upload == null) {
                        eventArgs.set_enableAjax(false);
                        return;
                    }
                    //AJAX is disabled only if file is selected for upload
                    if (upload.getFileInputs()[0].value != "") {
                        eventArgs.set_enableAjax(false);
                    }
                }
            }
 
            function validateRadUpload(source, e) {
                e.IsValid = false;
 
                var upload = $find(source.parentNode.getElementsByTagName('div')[0].id);
                if (upload == null) {
                    return;
                }
                var inputs = upload.getFileInputs();
                for (var i = 0; i < inputs.length; i++) {
                    //check for empty string or invalid extension
                    if (inputs[i].value != "" && upload.isExtensionValid(inputs[i].value)) {
                        e.IsValid = true;
                        break;
                    }
                }
            }
            // ]]>
        </script>
    </telerik:RadCodeBlock>
     
    <table width="100%">
    <tr>
    <td>
    <telerik:RadMenu ID="RadMenu1" runat="server" Skin="Default" Width="100%" Font-Size="Large">
   <Items>
   
   <telerik:RadMenuItem Text="Login" runat="server"></telerik:RadMenuItem>
    <telerik:RadMenuItem Text="Home" runat="server" NavigateUrl="home.aspx" ></telerik:RadMenuItem>
   <telerik:RadMenuItem Text="Data Administration" runat="server"  NavigateUrl="~/dataAdmin.aspx">
       <Items>
           <telerik:RadMenuItem runat="server" NavigateUrl="customers.aspx" Text="Customers">
           </telerik:RadMenuItem>
           <telerik:RadMenuItem runat="server" NavigateUrl="manufacturers.aspx" Text="Manufactures">
           </telerik:RadMenuItem>
           <telerik:RadMenuItem runat="server" NavigateUrl="product.aspx" Text="Products">
           </telerik:RadMenuItem>
           <telerik:RadMenuItem runat="server" NavigateUrl="events.aspx" Text="Events">
           </telerik:RadMenuItem>
           <telerik:RadMenuItem runat="server" Selected="True" Text="Projects">
           </telerik:RadMenuItem>
       </Items>
       </telerik:RadMenuItem>
   <telerik:RadMenuItem Text="Search" runat="server" NavigateUrl="search.aspx"></telerik:RadMenuItem>
    <telerik:RadMenuItem Text="Indust. Reports" runat="server"  NavigateUrl="industry_report.aspx"></telerik:RadMenuItem>
       <telerik:RadMenuItem runat="server" NavigateUrl="~/reports_Start_page.aspx" Text="Reports Section">
       </telerik:RadMenuItem>
   <telerik:RadMenuItem Text="Administration" runat="server" NavigateUrl="users.aspx"></telerik:RadMenuItem>
   <telerik:RadMenuItem Text="Help" runat="server" NavigateUrl="help.aspx" ></telerik:RadMenuItem>
   <telerik:RadMenuItem Text="Log Out" runat="server" NavigateUrl="logout.aspx"></telerik:RadMenuItem>
   </Items>
     
        
  </telerik:RadMenu>
  </td>
  </tr>
  </table>
 
            <table>
            <tr>
            <td><asp:Button ID="Button2" runat="server" Text="Export XL" OnClick="Button2_Click" /></td>
            </tr>
            </table>
              <table width="100%">
              <tr>
              <td>
     
            <telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server"  clientevents-onrequeststart="conditionalPostback" 
            RestoreOriginalRenderDelegate="false"  LoadingPanelID="RadAjaxLoadingPanel1">
             <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server" >
                <AjaxSettings>
                    <telerik:AjaxSetting AjaxControlID="RadGrid1">
                        <UpdatedControls>
                            <telerik:AjaxUpdatedControl ControlID="RadGrid1" ></telerik:AjaxUpdatedControl>
                            <telerik:AjaxUpdatedControl ControlID="RequiredFieldValidator1"></telerik:AjaxUpdatedControl>
                             
                        </UpdatedControls>
                    </telerik:AjaxSetting>
                    </AjaxSettings>
            </telerik:RadAjaxManager>
             <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server"  Skin="Telerik">
         </telerik:RadAjaxLoadingPanel>         
        
 
       <telerik:RadGrid runat="server" ID="RadGrid1" AllowPaging="True"
            AllowFilteringByColumn="True"
            AllowSorting="True"
            AllowMultiRowSelection="true"
            AutoGenerateColumns="False"
            AllowAutomaticInserts="True"
            AllowAutomaticUpdates="True"
            AllowAutomaticDeletes="True" ShowStatusBar="True"
             OnDetailTableDataBind="RadGrid1_DetailTableDataBind"
            GridLines="None"
            DataSourceID="SqlDataSource1"
            PageSize="10" CellSpacing="0"
            OnDeleteCommand="RadGrid1_DeleteCommand"
            OnItemCreated="RadGrid1_ItemCreated"
            OnItemCommand="RadGrid1_ItemCommand"
               OnItemInserted="RadGrid1_ItemInserted"
                OnItemUpdated="RadGrid1_ItemUpdated"
               OnItemDataBound="RadGrid1_ItemDataBound"
              OnUpdateCommand="RadGrid1_UpdateCommand"
             oninsertcommand="RadGrid1_InsertCommand" >
            <PagerStyle Mode="NextPrevAndNumeric"   AlwaysVisible="true"></PagerStyle>
            <MasterTableView Width="100%" CommandItemDisplay="Top" DataKeyNames="proj_id"  Name="Master" >
             
               
              <Columns>
                 
                <telerik:GridClientSelectColumn UniqueName="ChkSel" >
                </telerik:GridClientSelectColumn>
                 
                 
                    <telerik:GridEditCommandColumn ButtonType="ImageButton">
                        <HeaderStyle Width="36px"></HeaderStyle>
                    </telerik:GridEditCommandColumn>
                     
                     
                     
                     
                    <telerik:GridTemplateColumn HeaderText="ProjectID"  UniqueName="proj_id" DataField="proj_id" >
                        <ItemTemplate>
                            <asp:Label ID="lblid" runat="server" Text='<%# Bind("proj_id") %>'></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate >
                            <asp:TextBox ID="txtid" Width="300px" runat="server" Text='<%# Bind("proj_id") %>'  ReadOnly="true">
                            </asp:TextBox>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
                     
                    <telerik:GridTemplateColumn HeaderText="Project Name"  UniqueName="proj_name" DataField="proj_name"  SortExpression="proj_name">
                        <ItemTemplate>
                            <asp:Label ID="lblpn" runat="server" Text='<%# Bind("proj_name") %>'></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <asp:TextBox ID="txtpn" Width="300px" runat="server" Text='<%# Bind("proj_name") %>' >
                            </asp:TextBox>
                             <asp:RequiredFieldValidator ID="RequiredFieldValidator1" ControlToValidate="txtpn"
                            ErrorMessage="This field is required" runat="server" Display="Dynamic">
                        </asp:RequiredFieldValidator>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
                     
                     
                                      
                    <telerik:GridDropDownColumn DataSourceID="SqlDataSource2" ListTextField="custname"
                        ListValueField="custid" UniqueName="ddl" SortExpression="proj_cust_id"
                        EmptyListItemText="Select Customer" EnableEmptyListItem="true"
                        HeaderText="Customer" DropDownControlType="RadComboBox" DataField="proj_cust_id">
                         
                    </telerik:GridDropDownColumn>
                     
                    <telerik:GridDropDownColumn DataSourceID="SqlDataSource3" ListTextField="manname"
                        ListValueField="manid" UniqueName="ddl2" SortExpression="proj_man_id"
                        EmptyListItemText="Select Manufacturer" EnableEmptyListItem="true"
                        HeaderText="Manufacturer" DropDownControlType="RadComboBox" DataField="proj_man_id">
                    </telerik:GridDropDownColumn>
                     
                    <telerik:GridDropDownColumn DataSourceID="SqlDataSource4" ListTextField="prodname"
                        ListValueField="prodid" UniqueName="ddl3" SortExpression="proj_prod_id"
                        EmptyListItemText="Select Product" EnableEmptyListItem="true"
                        HeaderText="Product" DropDownControlType="RadComboBox" DataField="proj_prod_id">
                    </telerik:GridDropDownColumn>
 
 
                     
                    <telerik:GridDateTimeColumn UniqueName="proj_date" PickerType="DatePicker" HeaderText="Proj Date"
                    DataField="proj_date"  DataFormatString="{0:MM/dd/yyyy}">
                    <ItemStyle Width="120px"></ItemStyle>
                    </telerik:GridDateTimeColumn>
                     
                    <telerik:GridTemplateColumn HeaderText="Num Of Vehicle"  UniqueName="proj_num_of_vehicles" DataField="proj_num_of_vehicles" display="false">
                        <ItemTemplate>
                            <asp:Label ID="lblnov" runat="server" Text='<%# Eval("proj_num_of_vehicles")  %>' width="50px"></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <telerik:RadNumericTextBox ID="txtnov" Width="50px" runat="server" Text='<%# Bind("proj_num_of_vehicles") %>' >
                            <NumberFormat DecimalDigits="0" />
                            </telerik:RadNumericTextBox>
                             <asp:RequiredFieldValidator ID="RequiredFieldValidator2" ControlToValidate="txtnov"
                            ErrorMessage="This field is required" runat="server" Display="Dynamic">
                        </asp:RequiredFieldValidator>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
                     
                    <telerik:GridTemplateColumn HeaderText="Coach per Vehicle"  UniqueName="proj_coach_vehicle" DataField="proj_coach_vehicle" display="false">
                        <ItemTemplate>
                            <asp:Label ID="lblcv" runat="server" Text='<%# Eval("proj_coach_vehicle")  %>' width="50px"></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <telerik:RadNumericTextBox ID="txtcv" Width="50px" runat="server" Text='<%# Bind("proj_coach_vehicle") %>' >
                           <NumberFormat DecimalDigits="0" />
                            </telerik:RadNumericTextBox>
                             <asp:RequiredFieldValidator ID="RequiredFieldValidator3" ControlToValidate="txtcv"
                            ErrorMessage="This field is required" runat="server" Display="Dynamic">
                        </asp:RequiredFieldValidator>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
                     
                     <telerik:GridTemplateColumn HeaderText="Contract Value(€)"  UniqueName="proj_contract_value"
                     DataField="proj_contract_value" display="false"  >
                        <ItemTemplate>
                            <asp:Label ID="lblcval" runat="server" Text='<%# Eval("proj_contract_value")  %>' width="150px"></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <telerik:RadNumericTextBox  ID="txtcval" Width="150px" runat="server" Text='<%# Bind("proj_contract_value") %>' >
                           <NumberFormat DecimalDigits="0" />
                            </telerik:RadNumericTextBox>
                             <asp:RequiredFieldValidator ID="RequiredFieldValidator4" ControlToValidate="txtcval"
                            ErrorMessage="This field is required" runat="server" Display="Dynamic">
                        </asp:RequiredFieldValidator>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
                     
                     
                    <telerik:GridTemplateColumn HeaderText="Avg Price per Coach(€)"  UniqueName="proj_avg_price_per_coach" DataField="proj_avg_price_per_coach" display="false">
                        <ItemTemplate></ItemTemplate>
                        <EditItemTemplate>
                            <telerik:RadNumericTextBox ID="txtppc" Width="150px" runat="server"  ReadOnly="true" >
                            <NumberFormat DecimalDigits="0" />
                            </telerik:RadNumericTextBox>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
                     
                    <telerik:GridTemplateColumn HeaderText="Length(m)"  UniqueName="proj_length" DataField="proj_length" display="false">
                        <ItemTemplate>
                            <asp:Label ID="lblpl" runat="server" Text='<%# Eval("proj_length")  %>' width="50px"></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <telerik:RadNumericTextBox ID="txtpl" Width="50px" runat="server" Text='<%# Bind("proj_length") %>' >
                            <NumberFormat DecimalDigits="0" />
                            </telerik:RadNumericTextBox>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
                     
                    <telerik:GridTemplateColumn HeaderText="Width(mm)"  UniqueName="proj_width" DataField="proj_width" display="false">
                        <ItemTemplate>
                            <asp:Label ID="lblpw" runat="server" Text='<%# Eval("proj_width")  %>' width="50px"></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <telerik:RadNumericTextBox ID="txtpw" Width="50px" runat="server" Text='<%# Bind("proj_width") %>' >
                            <NumberFormat DecimalDigits="0" />
                            </telerik:RadNumericTextBox>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
                     
                    <telerik:GridTemplateColumn HeaderText="Height(mm)"  UniqueName="proj_height" DataField="proj_height" display="false">
                        <ItemTemplate>
                            <asp:Label ID="lblph" runat="server" Text='<%# Eval("proj_height")  %>' width="50px"></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <telerik:RadNumericTextBox ID="txtph" Width="50px" runat="server" Text='<%# Bind("proj_height") %>' >
                            <NumberFormat DecimalDigits="0" />
                            </telerik:RadNumericTextBox>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
                     
                    <telerik:GridTemplateColumn HeaderText="Passenger Seats"  UniqueName="proj_passenger_seats" DataField="proj_passenger_seats" display="false">
                        <ItemTemplate>
                            <asp:Label ID="lblps" runat="server" Text='<%# Eval("proj_passenger_seats")  %>' width="50px"></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <telerik:RadNumericTextBox ID="txtps" Width="50px" runat="server" Text='<%# Bind("proj_passenger_seats") %>' >
                            <NumberFormat DecimalDigits="0" />
                            </telerik:RadNumericTextBox>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
                     
                    <telerik:GridTemplateColumn HeaderText="Passengers Total"  UniqueName="proj_passenger_total" DataField="proj_passenger_seats" display="false">
                        <ItemTemplate>
                            <asp:Label ID="lblpat" runat="server" Text='<%# Eval("proj_passenger_total")  %>' width="50px"></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <telerik:RadNumericTextBox ID="txtpat" Width="50px" runat="server" Text='<%# Bind("proj_passenger_total") %>' >
                            <NumberFormat DecimalDigits="0" />
                            </telerik:RadNumericTextBox>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
 
 
                    <telerik:GridTemplateColumn HeaderText="Brand"  UniqueName="proj_brand" DataField="proj_brand" display="false">
                        <ItemTemplate>
                            <asp:Label ID="lblbr" runat="server" Text='<%# Eval("proj_brand")  %>' width="100px"></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <asp:textbox ID="txtbr" Width="100px" runat="server" Text='<%# Bind("proj_brand") %>' >
                            </asp:textbox>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
 
 
                     <telerik:GridTemplateColumn HeaderText="System Voltage"  UniqueName="proj_systemvoltage" DataField="proj_systemvoltage" display="false">
                        <ItemTemplate>
                            <asp:Label ID="lblsv" runat="server" Text='<%# Eval("proj_systemvoltage")  %>' width="100px"></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <asp:textbox ID="txtsv" Width="100px" runat="server" Text='<%# Bind("proj_systemvoltage") %>' >
                            </asp:textbox>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
 
 
                     <telerik:GridTemplateColumn HeaderText="Gauge"  UniqueName="proj_gauge" DataField="proj_gauge" display="false">
                        <ItemTemplate>
                            <asp:Label ID="lblga" runat="server" Text='<%# Eval("proj_gauge")  %>' width="100px"></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <asp:textbox ID="txtga" Width="100px" runat="server" Text='<%# Bind("proj_gauge") %>' >
                            </asp:textbox>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
 
 
                     <telerik:GridTemplateColumn HeaderText="Service Speed"  UniqueName="proj_service_speed" DataField="proj_service_speed" display="false">
                        <ItemTemplate>
                            <asp:Label ID="lblss" runat="server"  Text="Service Speed (Km/h)" width="100px"></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <asp:textbox ID="txtss" Width="100px" runat="server" Text='<%# Bind("proj_service_speed") %>' >
                            </asp:textbox>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
                     
                     
                     
                    <telerik:GridTemplateColumn HeaderText="Available Attachments"  UniqueName="proj_attach" DataField="proj_attach" display="false">
                           <ItemTemplate></ItemTemplate>
                           <EditItemTemplate>
                            <asp:TextBox ID="txtprojattach" Width="300px" runat="server" Text='<%# Bind("proj_attach") %>'  ReadOnly="true">
                            </asp:TextBox>
                            <asp:Button id="btn" OnClick="btn_Click" runat="server"  Text="View Attachments"/>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
                    <telerik:gridtemplatecolumn uniquename="Upload" HeaderText="Select attachments (jpg, jpeg, pdf, txt)" Display="false">
                        <ItemTemplate></ItemTemplate>
                        <edititemtemplate>
                          <telerik:radupload id="RadUpload1" runat="server"   MaxFileInputsCount="1"  AllowedFileExtensions=".jpg,.jpeg,.pdf,.txt"
                         TargetFolder="~/Proj_AttachFiles"  ControlObjectsVisibility="None"  />
                            
                        </edititemtemplate>
                    </telerik:gridtemplatecolumn>
                                         
                      
                     <telerik:GridTemplateColumn HeaderText="Notes"  UniqueName="proj_notes" DataField="proj_notes" display="false">
                        <ItemTemplate>
                            <asp:Label ID="lblnotes" runat="server" Text='<%# Eval("proj_notes")  %>' width="300px"></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <telerik:RadTextBox ID="txtnotes" Width="500px" runat="server" Text='<%# Bind("proj_notes") %>' Height="100px" TextMode="MultiLine" >
                            </telerik:RadTextBox>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
                     
                     
                    <telerik:GridTemplateColumn   UniqueName="uname" DataField="uname"  HeaderText="Modified By">
                          <ItemTemplate>
                            <asp:Label ID="lbluname" runat="server" Text='<%# Bind("uname") %>'></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <asp:TextBox ID="uname"  runat="server" Text='<%# Bind("uname") %>'  ReadOnly="true">
                            </asp:TextBox>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
                     
                     
                
                     <telerik:GridButtonColumn UniqueName="Delete_col" Text="Delete" CommandName="Delete"
                    ConfirmText="Delete this record ?" ConfirmDialogType="RadWindow" ButtonType="ImageButton">
                        <HeaderStyle Width="36px"></HeaderStyle>
                    </telerik:GridButtonColumn>
                </Columns>
 
 
 
 
 
               
               <DetailTables  >
               <telerik:GridTableView DataKeyNames="proj_id" ClientDataKeyNames="proj_id" HierarchyLoadMode="ServerBind"
                            Width="100%" runat="server" CommandItemDisplay="Top" Name="Details" >
                            <ParentTableRelation>
                                <telerik:GridRelationFields DetailKeyField="proj_id" MasterKeyField="proj_id"></telerik:GridRelationFields>
                            </ParentTableRelation>
                            <Columns>
                             
                             <telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="EditCommandColumn1">
                                <HeaderStyle Width="36px"></HeaderStyle>
                            </telerik:GridEditCommandColumn>
                             
                              
 
                             <telerik:GridTemplateColumn HeaderText="ID"  UniqueName="id" DataField="id" display="false">
                                <ItemTemplate>
                                    <asp:Label ID="lblid" runat="server" Text='<%# Bind("id") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="txtid" Width="70px" runat="server" Text='<%# Bind("id") %>'  ReadOnly="true">
                                    </asp:TextBox>
                                </EditItemTemplate>
                            </telerik:GridTemplateColumn>
 
                              
                              <telerik:GridDropDownColumn DataSourceID="SqlDataSource3" ListTextField="manname"
                                ListValueField="manname" UniqueName="ddl7" SortExpression="b_man_id"
                                EmptyListItemText="Select Manufacturer" EnableEmptyListItem="true"
                                HeaderText="Manufacturer" DropDownControlType="RadComboBox" DataField="b_man_id" >
                                
                            </telerik:GridDropDownColumn>
 
 
                             
 
                             <telerik:GridNumericColumn  DataField="b_contract_price" HeaderText="Contract Value(€)" 
                                UniqueName="b_contract_price"  >
                            </telerik:GridNumericColumn >
 
                              
 
                            <telerik:GridTemplateColumn   UniqueName="b_avg_price" DataField="b_avg_price"  HeaderText="Avg Price per Coach(€)">
                                  <ItemTemplate>
                                    <asp:Label ID="lblavgp" runat="server" Text='<%# Bind("b_avg_price") %>'></asp:Label>
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <telerik:RadNumericTextBox ID="txtavgp"  runat="server" Text='<%# Bind("b_avg_price") %>' 
                                    ReadOnly="true" Width="100px" >
                                    <NumberFormat DecimalDigits="0" />
                                    </telerik:RadNumericTextBox>
                                    
                                </EditItemTemplate>
                            </telerik:GridTemplateColumn>
 
                                
 
                                 <telerik:GridButtonColumn UniqueName="Delete_col2" Text="Delete" CommandName="Delete"
                                    ConfirmText="Delete this record ?" ConfirmDialogType="RadWindow" ButtonType="ImageButton">
                                        <HeaderStyle Width="36px"></HeaderStyle>
                                    </telerik:GridButtonColumn>
 
                            </Columns>
                            </telerik:GridTableView>
               </DetailTables>
 
 
 
                 
                <EditFormSettings>
                    <EditColumn ButtonType="ImageButton">
                    </EditColumn>
                </EditFormSettings>
                 
            </MasterTableView>
            <ClientSettings>
            <Selecting  AllowRowSelect="true"/>
            </ClientSettings>
        </telerik:RadGrid>
 
 
 
 
 
 
 
        </telerik:RadAjaxPanel>
 
</td>
</tr>
</table>
 
         
         
 
        <asp:SqlDataSource runat="server" ID="SqlDataSource2" ConnectionString="<%$ ConnectionStrings:stad_conn  %>"
        SelectCommand="SELECT  cust_id as custid,cust_name as custname FROM customers order by cust_name">
        </asp:SqlDataSource>
 
         <asp:SqlDataSource runat="server" ID="SqlDataSource22" ConnectionString="<%$ ConnectionStrings:stad_conn  %>"
                SelectCommand="SELECT cust_name,cust_id FROM customers order by cust_name">
                </asp:SqlDataSource>
         
        <asp:SqlDataSource runat="server" ID="SqlDataSource3" ConnectionString="<%$ ConnectionStrings:stad_conn  %>"
        SelectCommand="SELECT  man_id as manid,man_name as manname FROM manufacturers order by man_name">
        </asp:SqlDataSource>
         
        <asp:SqlDataSource runat="server" ID="SqlDataSource4" ConnectionString="<%$ ConnectionStrings:stad_conn  %>"
        SelectCommand="SELECT  prod_id as prodid,prod_type as prodname FROM products order by prod_type">
        </asp:SqlDataSource>
         
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:stad_conn %>"
        DeleteCommand="DELETE FROM [projects] WHERE [ID] = @ID"
         
        InsertCommand="INSERT INTO [projects] ([proj_id],[proj_cust_id], [proj_man_id], [proj_date],[proj_num_of_vehicles],
                      [proj_coach_vehicle],[proj_contract_value],[proj_length],[proj_width],
                      [proj_height],[proj_passenger_seats],[proj_passenger_total],[proj_notes],
                      [uname],[proj_name],[proj_prod_id],[proj_brand],[proj_systemvoltage],[proj_gauge],[proj_service_speed])
                      VALUES (@proj_id,@proj_cust_id,@proj_man_id, @proj_date,@proj_num_of_vehicles,@proj_coach_vehicle,
                      @proj_contract_value,@proj_length, @proj_width,@proj_height,@proj_passenger_seats,
                      @proj_passenger_total,@proj_notes,@uname,@proj_name,@proj_prod_id,@proj_brand,@proj_systemvoltage,@proj_gauge,@proj_service_speed)"
                       
        SelectCommand="SELECT  [id],[proj_id],[proj_cust_id], [proj_man_id], [proj_date],[proj_num_of_vehicles],[proj_coach_vehicle],
                       [proj_contract_value],[proj_length],[proj_width],[proj_height] ,[proj_attach],[proj_prod_id],[proj_service_speed],
                       [proj_passenger_seats],[proj_passenger_total],[proj_notes],[uname],[proj_name],[proj_brand],[proj_systemvoltage],[proj_gauge] 
                       from projects"
         
        UpdateCommand="UPDATE [projects] SET [proj_id] = @proj_id,[proj_cust_id] = @proj_cust_id,
                        [proj_man_id] = @proj_man_id, [proj_date] = @proj_date,[proj_prod_id] = @proj_prod_id,
                      [proj_num_of_vehicles] = @proj_num_of_vehicles, [proj_coach_vehicle] = @proj_coach_vehicle,
                      [proj_contract_value] = @proj_contract_value,  [proj_service_speed] = @proj_service_speed,
                      [proj_length] = @proj_length, [proj_width] = @proj_width,
                      [proj_height] = @proj_height, [proj_passenger_seats] = @proj_passenger_seats,
                      [proj_passenger_total] = @proj_passenger_total, [proj_notes] = @proj_notes,[proj_name]=@proj_name,
                      [proj_brand]=@proj_brand,[proj_systemvoltage]=@proj_systemvoltage,[proj_gauge]=@proj_gauge
                      WHERE [ID] = @ID">
        <DeleteParameters>
            <asp:Parameter Name="ID" Type="Int32"></asp:Parameter>
        </DeleteParameters>
        <InsertParameters>
            <asp:Parameter Name="proj_cust_id" Type="String"></asp:Parameter>
            <asp:Parameter Name="proj_prod_id" Type="String"></asp:Parameter>
            <asp:Parameter Name="proj_brand" Type="String"></asp:Parameter>
            <asp:Parameter Name="proj_systemvoltage" Type="String"></asp:Parameter>
            <asp:Parameter Name="proj_gauge" Type="String"></asp:Parameter>
            <asp:Parameter Name="proj_man_id" Type="String"></asp:Parameter>
            <asp:Parameter Name="proj_service_speed" Type="String"></asp:Parameter>
            <asp:Parameter Name="proj_date" Type="DateTime"></asp:Parameter>
            <asp:Parameter Name="proj_num_of_vehicles" Type="Int16"></asp:Parameter>
            <asp:Parameter Name="proj_coach_vehicle" Type="Int16"></asp:Parameter>
            <asp:Parameter Name="proj_contract_value" Type="Double"></asp:Parameter>
            <asp:Parameter Name="proj_length" Type="Double"></asp:Parameter>
            <asp:Parameter Name="proj_width" Type="Double"></asp:Parameter>
            <asp:Parameter Name="proj_system_voltage" Type="Double"></asp:Parameter>
            <asp:Parameter Name="proj_height" Type="Double"></asp:Parameter>
            <asp:Parameter Name="proj_passenger_seats" Type="Int16"></asp:Parameter>
            <asp:Parameter Name="proj_passenger_total" Type="Int16"></asp:Parameter>
            <asp:Parameter Name="proj_notes" Type="String"></asp:Parameter>
            <asp:Parameter Name="proj_name" Type="String"></asp:Parameter>
            <asp:Parameter Name="uname" Type="String"></asp:Parameter>
            <asp:Parameter Name="proj_id" Type="String"></asp:Parameter>
        </InsertParameters>
        <UpdateParameters>
           <asp:Parameter Name="proj_cust_id" Type="String"></asp:Parameter>
           <asp:Parameter Name="proj_prod_id" Type="String"></asp:Parameter>
            <asp:Parameter Name="proj_man_id" Type="String"></asp:Parameter>
             <asp:Parameter Name="proj_brand" Type="String"></asp:Parameter>
             <asp:Parameter Name="proj_service_speed" Type="String"></asp:Parameter>
            <asp:Parameter Name="proj_systemvoltage" Type="String"></asp:Parameter>
            <asp:Parameter Name="proj_gauge" Type="String"></asp:Parameter>
            <asp:Parameter Name="proj_date" Type="DateTime"></asp:Parameter>
            <asp:Parameter Name="proj_num_of_vehicles" Type="Int16"></asp:Parameter>
            <asp:Parameter Name="proj_coach_vehicle" Type="Int16"></asp:Parameter>
            <asp:Parameter Name="proj_contract_value" Type="Double"></asp:Parameter>
            <asp:Parameter Name="proj_length" Type="Double"></asp:Parameter>
            <asp:Parameter Name="proj_width" Type="Double"></asp:Parameter>
            <asp:Parameter Name="proj_system_voltage" Type="Double"></asp:Parameter>
            <asp:Parameter Name="proj_height" Type="Double"></asp:Parameter>
            <asp:Parameter Name="proj_passenger_seats" Type="Int16"></asp:Parameter>
            <asp:Parameter Name="proj_passenger_total" Type="Int16"></asp:Parameter>
            <asp:Parameter Name="proj_notes" Type="String"></asp:Parameter>
            <asp:Parameter Name="proj_name" Type="String"></asp:Parameter>
            <asp:Parameter Name="ID" Type="Int32"></asp:Parameter>
        </UpdateParameters>
    </asp:SqlDataSource>
     
 </form>
</body>
</html>
since a subgrid was added I am unable to make the filter working. Any help will be appreciated.
What should I do /change to make the filter working again?

Kostadin
Telerik team
 answered on 05 Nov 2013
4 answers
343 views
Hi,
I need to set the Pivot grid PivotGridRowField header as same like PivotGridColumnField.
the Pivot grid both Row header and column header should be uniform.
Each rowfield header should have border shame like Colum filed header.

2) I want to export the Pivot grid it works fine but i need the Pivot grid row header should be added in export as column header.

Syed
Top achievements
Rank 1
 answered on 05 Nov 2013
2 answers
107 views
Hi,

I'm trying to implement your "Creating Appointments with Drag-and-drop" example (see code below), but I'm having the following problems:

1. At the beginning the program crashes because 

DataKeyField, DataSubjectField, DataStartField and DataEndField are required for databinding

I've added the following properties to the RadScheduler:
DataKeyField="ID" DataSubjectField="Subject" DataStartField="Start" DataEndField="End"

2. I can add items from the tree view to the scheduler, but when moving these items to another time or dragging them to change the duration, items will return to the original position.

3. When using the advanced form to insert an appointment, program is crashing with the following JavaScript runtime error:
JavaScript runtime error: Unable to get property 'findItemByText' of undefined or null reference

Hopefully someone can help me with this.....

Thanks,
Egbert

<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true"
    CodeFile="Test.aspx.cs" Inherits="Test" %>
 
<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>
 
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server">
 <style type="text/css">
        .divRadios
        {
            margin-bottom: 15px;
        }
        .background
        {
            background: url("arrows.png") no-repeat scroll 0 0 transparent;
            padding: 115px 0 0 0px;
            margin-left: 45px;
        }
          
        #RadTreeView1
        {
            margin-bottom: 15px;
        }
        .divTree
        {
            float: left;
            width: 315px;
              
        }
        .schedulerPositioning
        {
            width: 960px;
            float: left;
            display: block;
        }
    </style></asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
    <telerik:RadAjaxManager runat="server" ID="RadAjaxManager1" EnableAJAX="true">
        <AjaxSettings>
            <telerik:AjaxSetting AjaxControlID="RadScheduler1">
                <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="RadScheduler1" LoadingPanelID="RadAjaxLoadingPanel1">
                    </telerik:AjaxUpdatedControl>
                </UpdatedControls>
            </telerik:AjaxSetting>
        </AjaxSettings>
    </telerik:RadAjaxManager>
    <telerik:RadAjaxLoadingPanel runat="server" ID="RadAjaxLoadingPanel1">
    </telerik:RadAjaxLoadingPanel>
    <telerik:RadScriptBlock ID="RadScriptBlock1" runat="server">
        <script type="text/javascript">
                //<![CDATA[
            //Shows whether an Appointment is inserted directly, or the
            //the Advanced Insert Form is opened when TreeView node is dropped on the Scheduler.
            var directlyInsertAppointment = true;
 
            function pageLoad() {
                $telerik.$('#<%=RadioButtonListChooseInsert.ClientID %>').click(radioButtonListChooseInsert_click);
            }
 
            function radioButtonListChooseInsert_click(radioButtonList) {
                //Gets the currently selected item of the RadioButtonList.
                var selectedItemValue = $telerik.$('#<%=RadioButtonListChooseInsert.ClientID %> input[type=radio]:checked').val();
 
                if (selectedItemValue == "DirectInsert") {
                    directlyInsertAppointment = true;
                } else {
                    directlyInsertAppointment = false;
                }
            }
 
            function nodeDropping(sender, eventArgs) {
                var htmlElement = eventArgs.get_htmlElement();
                var scheduler = $find('<%= RadScheduler1.ClientID %>');
 
                if (isPartOfSchedulerAppointmentArea(htmlElement)) {
                    //Gets the TimeSlot where an Appointment is dropped.
                    var timeSlot = scheduler.get_activeModel().getTimeSlotFromDomElement(htmlElement);
                    var startTime = timeSlot.get_startTime();
                    var endTime = new Date(startTime);
 
                    //Gets all the data needed for the an Appointment, from the TreeView node.
                    var node = eventArgs.get_sourceNode();
                    var text = node.get_text();
                    var attributes = node.get_attributes();
                    var duration = attributes.getAttribute("Duration");
                    endTime.setMinutes(endTime.getMinutes() + parseInt(duration));
                    var speaker = attributes.getAttribute("Speaker");
                    var parentValue = node.get_parent().get_value();
                    var category = scheduler.get_resources().getResourceByTypeAndKey("Category", parentValue);
 
                    //New appointment is created. The start/end time, subject and category are set.
                    var newAppointment = new Telerik.Web.UI.SchedulerAppointment();
                    newAppointment.set_start(startTime);
                    newAppointment.set_end(endTime);
                    newAppointment.set_subject(text + " (by " + speaker + ")");
                    if (category != null) {
                        newAppointment.get_resources().add(category);
                    }
 
                    //Checks for the user's choice of the method for inserting Appointments.
                    if (directlyInsertAppointment) {
                        scheduler.insertAppointment(newAppointment);
                    } else {
                        //If Advanced Form is opened, the information from the TreeVew node is stored in a hidden input.
                        var appointmentInfo = { subject: text, duration: duration, speaker: speaker, category: category };
                        var appointmentInfoSerialized = Sys.Serialization.JavaScriptSerializer.serialize(appointmentInfo);
                        $get("<%=HiddenInputAppointmentInfo.ClientID%>").value = appointmentInfoSerialized;
                        scheduler.showInsertFormAt(timeSlot);
                    }
                }
                else {
                    //The node was dropped elsewhere on the document.
                    eventArgs.set_cancel(true);
                }
            }
 
            function isPartOfSchedulerAppointmentArea(htmlElement) {
                // Determines if an HTML element is part of the scheduler appointment area.
                // This can be either the rsContent or the rsAllDay div (in day and week view).
                return $telerik.$(htmlElement).parents().is("div.rsAllDay") ||
                            $telerik.$(htmlElement).parents().is("div.rsContent")
            }
 
            function formCreated(scheduler, args) {
                var mode = args.get_mode();
                if (mode == Telerik.Web.UI.SchedulerFormMode.AdvancedInsert ||
                         mode == Telerik.Web.UI.SchedulerFormMode.AdvancedEdit) {
                    //Gets the value from the hidden input, and populates the Appointment's data from it.
                    if ($get("<%=HiddenInputAppointmentInfo.ClientID%>").value != "") {
                        var hiddenInputValue = Sys.Serialization.JavaScriptSerializer.deserialize($get("<%=HiddenInputAppointmentInfo.ClientID%>").value);
                        if (hiddenInputValue) {
                            var subjectObject = $find('<%= RadScheduler1.ClientID %>' + "_Form_Subject");
                            subjectObject.set_value(hiddenInputValue.subject + " (by " + hiddenInputValue.speaker + ")");
 
                            var startTime = $find('<%= RadScheduler1.ClientID %>' + "_Form_StartTime").get_selectedDate();
                            var endTime = new Date(startTime.setMinutes(startTime.getMinutes() + parseInt(hiddenInputValue.duration)));
                            $find('<%= RadScheduler1.ClientID %>' + "_Form_EndTime").set_selectedDate(endTime);
 
                            $find('<%= RadScheduler1.ClientID %>' + "_Form_ResCategory").findItemByText(hiddenInputValue.category._text).select();
                        }
                    }
                }
            }
 
            //ToolTip events.
            //The  ToolTip is activated on Appointment's click.
            function appointmentClick(sender, args) {
                var apt = args.get_appointment();
                showTooltip(apt);
            }
 
            //The ToolTip contains: start/end time, subject and category for the clicked Appointment.
            function showTooltip(apt) {
                var tooltip = $find('<%=RadToolTip1.ClientID %>');
                tooltip.set_targetControl(apt.get_element());
                $get("startTime").innerHTML = "<strong>Starts on: </strong>" + apt.get_start().format("MM/dd/yyyy HH:mm");
                $get("endTime").innerHTML = "<strong>Ends on: </strong>" + apt.get_end().format("MM/dd/yyyy HH:mm");
                $get("subject").innerHTML = "<strong>Subject: </strong>" + apt.get_subject();
                $get("category").innerHTML = "<strong>Category: </strong>" + apt.get_resources().getResourceByType("Category").get_text();
                tooltip.set_text($get("contentContainer").innerHTML);
                setTimeout(function () {
                    tooltip.show();
                }, 20);
            }
 
            function hideTooltip() {
                setTimeout(function () {
                    var activeTooltip = Telerik.Web.UI.RadToolTip.getCurrent();
                    if (activeTooltip)
                    { activeTooltip.hide(); }
                }, 50);
            }
 
            function appointmentMoving(sender, args) {
                hideTooltip();
            }
               //]]>
        </script>
    </telerik:RadScriptBlock>
    <div>
        <div class="divRadios">
            <span><strong>Choose a Method to Insert an Appointment</strong></span>
            <asp:RadioButtonList ID="RadioButtonListChooseInsert" runat="server" RepeatDirection="Vertical">
                <asp:ListItem Text="Directly insert an appointment" Value="DirectInsert" Selected="true"></asp:ListItem>
                <asp:ListItem Text="Use advanced form to insert an appointment" Value="AdvancedInsert"></asp:ListItem>
            </asp:RadioButtonList>
        </div>
        <div class="background">
        </div>
        <div class="divTree">
            <span><strong>Drag a Node to the Scheduler</strong></span>
            <telerik:RadTreeView ID="RadTreeView1" runat="server" EnableDragAndDrop="True" Width="340px"
                OnClientNodeDropping="nodeDropping">
                <Nodes>
                    <telerik:RadTreeNode Value="1" Text="Technology" AllowDrag="false" Expanded="true">
                        <Nodes>
                            <telerik:RadTreeNode Text="A prosthetic arm that 'feels'" Speaker="Todd Kuiken" Duration="90" />
                            <telerik:RadTreeNode Text="Wireless data from every light bulb" Speaker="Harald Haas"
                                Duration="50" />
                            <telerik:RadTreeNode Text="Beware conflicts of interest" Speaker="Dan Ariely" Duration="60" />
                            <telerik:RadTreeNode Text="Can we make things that make themselves?" Speaker="Skylar Tibbits"
                                Duration="40" />
                        </Nodes>
                    </telerik:RadTreeNode>
                    <telerik:RadTreeNode Value="2" Text="Science" AllowDrag="false">
                        <Nodes>
                            <telerik:RadTreeNode Text="Finding life we can't imagine" Speaker="Christoph Adami"
                                Duration="70">
                            </telerik:RadTreeNode>
                            <telerik:RadTreeNode Text="The real reason for brains" Speaker="Daniel Wolpert" Duration="80">
                            </telerik:RadTreeNode>
                            <telerik:RadTreeNode Text="Making matter come alive" Speaker="Lee Cronin" Duration="90">
                            </telerik:RadTreeNode>
                            <telerik:RadTreeNode Text="Finding planets around other stars" Speaker="Lucianne Walkowicz"
                                Duration="50">
                            </telerik:RadTreeNode>
                        </Nodes>
                    </telerik:RadTreeNode>
                    <telerik:RadTreeNode Value="3" Text="Business" AllowDrag="false">
                        <Nodes>
                            <telerik:RadTreeNode Text="3 things I learned while my plane crashed" Speaker="Ric Elias"
                                Duration="70">
                            </telerik:RadTreeNode>
                            <telerik:RadTreeNode Text="The surprising math of cities and corporations" Speaker="Geoffrey West"
                                Duration="60">
                            </telerik:RadTreeNode>
                            <telerik:RadTreeNode Text="How the market can keep streams flowing" Speaker="Rob Harmon"
                                Duration="50">
                            </telerik:RadTreeNode>
                            <telerik:RadTreeNode Text="How to use experts -- and when not to" Speaker="Noreena Hertz"
                                Duration="90">
                            </telerik:RadTreeNode>
                        </Nodes>
                    </telerik:RadTreeNode>
                    <telerik:RadTreeNode Value="4" Text="Entertainment" AllowDrag="false">
                        <Nodes>
                            <telerik:RadTreeNode Text="On being just crazy enough" Speaker="Joshua Walters" Duration="70">
                            </telerik:RadTreeNode>
                            <telerik:RadTreeNode Text="A flirtatious aria" Speaker="Danielle de Niese" Duration="60">
                            </telerik:RadTreeNode>
                            <telerik:RadTreeNode Text="A history of the universe in sound" Speaker="Honor Harger"
                                Duration="80">
                            </telerik:RadTreeNode>
                            <telerik:RadTreeNode Text="The magic of truth and lies (and iPods)" Speaker="Marko Tempest"
                                Duration="50">
                            </telerik:RadTreeNode>
                        </Nodes>
                    </telerik:RadTreeNode>
                    <telerik:RadTreeNode Value="5" Text="Global Issues" AllowDrag="false">
                        <Nodes>
                            <telerik:RadTreeNode Text="We can recycle plastic" Speaker="Mike Biddle" Duration="50">
                            </telerik:RadTreeNode>
                            <telerik:RadTreeNode Text="Learning from a barefoot movement" Speaker="Bunker Roy"
                                Duration="40">
                            </telerik:RadTreeNode>
                            <telerik:RadTreeNode Text="How the economic inequality harms societies" Speaker="Rickard Wilkinson"
                                Duration="70">
                            </telerik:RadTreeNode>
                            <telerik:RadTreeNode Text="Ending hunger now" Speaker="Josette Sheeran" Duration="30">
                            </telerik:RadTreeNode>
                        </Nodes>
                    </telerik:RadTreeNode>
                </Nodes>
                <CollapseAnimation Duration="100" Type="OutQuint" />
                <ExpandAnimation Duration="100" />
            </telerik:RadTreeView>
        </div>
        <div class="schedulerPositioning">
            <telerik:RadAjaxPanel ID="RadAjaxPanel" runat="server">
                <telerik:RadScheduler runat="server" ID="RadScheduler1" StartInsertingInAdvancedForm="true"
                            DataKeyField="ID" DataSubjectField="Subject" DataStartField="Start" DataEndField="End"
                    OnClientAppointmentClick="appointmentClick" OnClientAppointmentMoving="appointmentMoving"
                    OnClientFormCreated="formCreated" EnableDescriptionField="true" OverflowBehavior="Auto">
                    <AdvancedForm Modal="true"></AdvancedForm>
                </telerik:RadScheduler>
                <input id="HiddenInputAppointmentInfo" name="HiddenInputAppointmentInfo" type="hidden"
                    runat="server">
            </telerik:RadAjaxPanel>
            <telerik:RadToolTip ID="RadToolTip1" runat="server" RelativeTo="Element" Position="BottomCenter"
                AutoCloseDelay="0" ShowEvent="FromCode" Width="250px">
                <div id="contentContainer">
                    <div id="startTime">
                    </div>
                    <div id="endTime">
                    </div>
                    <div id="subject">
                    </div>
                    <div id="category">
                    </div>
                </div>
            </telerik:RadToolTip>
        </div>
    </div></asp:Content>

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Telerik.Web.UI;
 
public partial class Test : System.Web.UI.Page
{
    private const string ProviderSessionKey = "Telerik.Web.Examples.Scheduler.XmlSchedulerProvider.DefaultCS";
     
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session.Count == 0 || Session["Login"] == null || Session["Login"].ToString() == "No")
        {
            Response.Redirect("Login.aspx");
        }
    }
}

Egbert
Top achievements
Rank 1
 answered on 05 Nov 2013
1 answer
255 views
how to Hide the Row Field Column,

In Rad grid we use Display=false ,is there any function for hiding the Pivot grid Row Field Column.

In my project i want to display the row fields in some order for that i use a Row Number column  but this rownumer column of Row field shold be hidden.
Shinu
Top achievements
Rank 2
 answered on 05 Nov 2013
1 answer
110 views
Hi, 

I think I found a bug with my q2 2013 controls, where if I programmatically remove some items from the list by setting its property to visible = false, the navigation breaks also. It navigates to the index of the items it thinks should be there. 

<telerik:RadTileList ID="tllReporting" runat="server" Skin="FriskaMetro" EnableEmbeddedSkins="False"
        Height="500px">
        <Groups>
            <%--Sales--%>
            <telerik:TileGroup>
                <Tiles>
                    <telerik:RadContentTemplateTile NavigateUrl="Sales/CombinedSales.aspx" Shape="Square" Name="tileSalesCombined">
                        <ContentTemplate>
                            <div class="SlidePanel" style="width100%height80px">
                                <h1>
                                    Combined Sales</h1>
                            </div>
                            <div class="SlidePanelTitle" style="width100%height50px">
                                <h3>
                                    Sales</h3>
                            </div>
                        </ContentTemplate>
                        <PeekTemplate>
                            <div class="SlidePanel" style="width88%height120px">
                                Report to show the combined retail and catering sales for period
                            </div>
                        </PeekTemplate>
                        <PeekTemplateSettings Animation="Slide" AnimationDuration="800" Easing="easeInOutBack"
                            ShowInterval="0" CloseDelay="5000" ShowPeekTemplateOnMouseOver="true" HidePeekTemplateOnMouseOut="true" />
                    </telerik:RadContentTemplateTile>
                    <telerik:RadContentTemplateTile NavigateUrl="Sales/ProductsSoldReport.aspx" Shape="Square" Name="tileSalesProductsSold">
                        <ContentTemplate>
                            <div class="SlidePanel" style="width100%height80px">
                                <h1>
                                    Product <br />Sales</h1>
                            </div>
                            <div class="SlidePanelTitle" style="width100%height50px">
                                <h3>
                                    Sales</h3>
                            </div>
                        </ContentTemplate>
                        <PeekTemplate>
                            <div class="SlidePanel" style="width88%height120px">
                                Report to show the total number of products sold in a period
                            </div>
                        </PeekTemplate>
                        <PeekTemplateSettings Animation="Slide" AnimationDuration="800" Easing="easeInOutBack"
                            ShowInterval="0" CloseDelay="5000" ShowPeekTemplateOnMouseOver="true" HidePeekTemplateOnMouseOut="true" />
                    </telerik:RadContentTemplateTile>
                    <telerik:RadContentTemplateTile NavigateUrl="Sales/SalesPOReceiptsReport.aspx" Shape="Wide" Name="tileSalesPOReceipts">
                        <ContentTemplate>
                            <div class="SlidePanel" style="width100%height80px">
                                <h1>
                                    Paid Out Receipts</h1>
                            </div>
                            <div class="SlidePanelTitle" style="width100%height50px">
                                <h3>
                                    Sales</h3>
                            </div>
                        </ContentTemplate>
                        <PeekTemplate>
                            <div class="SlidePanel" style="width88%height120px">
                                Report to show the paid out cash receipts per store
                            </div>
                        </PeekTemplate>
                        <PeekTemplateSettings Animation="Slide" AnimationDuration="800" Easing="easeInOutBack"
                            ShowInterval="0" CloseDelay="5000" ShowPeekTemplateOnMouseOver="true" HidePeekTemplateOnMouseOut="true" />
                    </telerik:RadContentTemplateTile>
                    <telerik:RadContentTemplateTile NavigateUrl="Sales/SalesSummaryReport.aspx" Shape="Square"
                        Name="tileSalesSalesSummary">
                        <ContentTemplate>
                            <div class="SlidePanel" style="width100%height80px">
                                <h1>
                                    Sales Summary</h1>
                            </div>
                            <div class="SlidePanelTitle" style="width100%height50px">
                                <h3>
                                    Sales</h3>
                            </div>
                        </ContentTemplate>
                        <PeekTemplate>
                            <div class="SlidePanel" style="width88%height120px">
                                Report to show the value of the sales in a period per store
                            </div>
                        </PeekTemplate>
                        <PeekTemplateSettings Animation="Slide" AnimationDuration="800" Easing="easeInOutBack"
                            ShowInterval="0" CloseDelay="5000" ShowPeekTemplateOnMouseOver="true" HidePeekTemplateOnMouseOut="true" />
                    </telerik:RadContentTemplateTile>
   </Tiles>
            </telerik:TileGroup>
        </Groups>
    </telerik:RadTileList>

Thenn I set the visible property as such: 

foreach (RadBaseTile tile in tllReporting.GetAllTiles())
            {
                tile.Visible = Authentication.HasUserPageAccess("~/Reporting/"+tile.NavigateUrl);
            }
Is this a bug?

Many thanks!
Gabor
Stanimir
Telerik team
 answered on 05 Nov 2013
1 answer
83 views
ComboBox - Grid Filtered by Combo with Checkboxes
===============================================================

Does anyone know how to modify the demo below to enable checkboxes [CheckBoxes="true" EnableCheckAllItemsCheckBox="true"]
and be able to filter the RadGrid for the multiple selected/checked items in the RadComboBox? In the demo below, it only filters the grid for the ONE selected item.

Demo - ComboBox - Grid Filtered by Combo:
http://demos.telerik.com/aspnet-ajax/controls/examples/integration/gridcomboajax/defaultcs.aspx?product=combobox

Shinu
Top achievements
Rank 2
 answered on 05 Nov 2013
4 answers
216 views
Hello all

I have the following RadGrid, where i have an EditForm template for editing and inserting, well, the Update command is working fine, however, when using SelectedValue in the DropDownList the insert form will not show when i click add new record, and when i remove the SelectedValue property, the insert form shows but wont work when i insert data, i double checked my sql statement for inserting and it works fine.

Any suggestions?

    <telerik:RadGrid ID="GridStaff"  runat="server" ShowStatusBar="True" 
        OnItemCommand="GridStaff_ItemCommand" OnItemUpdated="GridStaff_ItemUpdated"
        OnItemCreated="GridStaff_ItemCreated"
        OnUpdateCommand="GridStaff_UpdateCommand" OnItemInserted="GridStaff_ItemInserted"
        OnInsertCommand="GridStaff_InsertCommand" OnPreRender="GridStaff_PreRender"
    AutoGenerateColumns="False" PageSize="20" AllowSorting="True" AllowAutomaticInserts="True"
    AllowPaging="True" DataSourceID="SqlDataSourceStaff" AllowAutomaticDeletes="true"
        OnItemDataBound="GridStaff_ItemDataBound"
    AllowAutomaticUpdates="True" Width="835px" FilterType="CheckedList" AllowFilteringByColumn="True"
                GridLines="None" CellSpacing="0">
                <ExportSettings>
                    <Pdf>
                        <PageHeader>
                            <LeftCell Text="" />
                            <MiddleCell Text="" />
                            <RightCell Text="" />
                        </PageHeader>
                        <PageFooter>
                            <LeftCell Text="" />
                            <MiddleCell Text="" />
                            <RightCell Text="" />
                        </PageFooter>
                    </Pdf>
                </ExportSettings>
                 
                <MasterTableView DataSourceID="SqlDataSourceStaff" InsertItemDisplay="Top" InsertItemPageIndexAction="ShowItemOnFirstPage" DataKeyNames="UserID" EditMode="EditForms" AutoGenerateColumns="false" AllowMultiColumnSorting="False" Width="100%" CommandItemDisplay="Top" Name="admStaff">
                <CommandItemSettings ShowAddNewRecordButton="true" AddNewRecordText="Add New Staff Member" ShowExportToPdfButton="true" />
                    <RowIndicatorColumn FilterControlAltText="Filter RowIndicator column"
                        Visible="True">
                    </RowIndicatorColumn>
                    <ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column"
                        Visible="True">
                    </ExpandCollapseColumn>
                <Columns>
                <telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="EditCommandColumn">
                <HeaderStyle Width="20px">
                </HeaderStyle>
                </telerik:GridEditCommandColumn>
                <telerik:GridBoundColumn SortExpression="UserID" ShowFilterIcon="false" AllowFiltering="false" HeaderText="#" HeaderButtonType="TextButton" DataField="UserID" UniqueName="UserID" MaxLength="7">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn SortExpression="EnglishName" HeaderText="Name" HeaderButtonType="TextButton" DataField="EnglishName" UniqueName="EnglishName" MaxLength="40">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn SortExpression="Subject" HeaderText="Subject" HeaderButtonType="TextButton" DataField="SubEn" UniqueName="Subject">
                </telerik:GridBoundColumn>
                 
                <telerik:GridBoundColumn SortExpression="DepEn" HeaderText="Department" HeaderButtonType="TextButton" DataField="DepartID" UniqueName="DepEn">
                </telerik:GridBoundColumn>
                 
                <telerik:GridTemplateColumn HeaderText="Load/Week" UniqueName="TLoad" AllowFiltering="false" >
                <ItemStyle Width="20px" />
                    <ItemTemplate>
                        <asp:Label ID="lblTeacherLoad" runat="server"></asp:Label>
                    </ItemTemplate>
                </telerik:GridTemplateColumn>
                 
                <telerik:GridBoundColumn SortExpression="PhoneNumber" HeaderText="PhoneNumber" HeaderButtonType="TextButton" AllowFiltering="false" DataField="PhoneNumber" UniqueName="PhoneNumber">
                </telerik:GridBoundColumn>
                 
                <telerik:GridTemplateColumn HeaderText="MSG" UniqueName="SendMSG" AllowFiltering="false" >
                <ItemStyle Width="20px" />
                    <ItemTemplate>
                        <asp:ImageButton ID="img_SendMSG" runat="server" CommandName="SendMsgToStaff" ImageUrl="~/images/sendmsgicon.png" CommandArgument='<%# Bind("UserID") %>' Width="20px" Height="20px" />
                    </ItemTemplate>
                </telerik:GridTemplateColumn>
                <telerik:GridTemplateColumn HeaderText="SMS" UniqueName="SendSMS" AllowFiltering="false" >
                <ItemStyle Width="20px" />
                    <ItemTemplate>
                        <asp:ImageButton ID="img_SendSMS" runat="server" CommandName="SendSmsToStaff" ImageUrl="~/images/sendsmsicon.png" CommandArgument='<%# Bind("UserID") %>' Width="20px" Height="20px" />
                    </ItemTemplate>
                </telerik:GridTemplateColumn>
                </Columns>
                 
                <EditFormSettings EditFormType="Template" PopUpSettings-Modal="true">
                         
                         
                        <FormTemplate>
                        <div class="register">
                         
                            
                        
                           <div class="divClass">
         
         
        <fieldset class="rowPersonalEn">
            <legend>Personal Details
            </legend>
            <p>
                <label>User ID
                </label>
                 
                <asp:TextBox ID="txtUserID" CssClass="long" Text='<%# Bind("UserID") %>' Enabled="false" runat="server"></asp:TextBox>
            </p>
            <p>
                <label>First Name
                </label>
                 
                <asp:TextBox ID="txtFirstNameEn" CssClass="long" Text='<%# Bind("FirstNameEn") %>' runat="server"></asp:TextBox>
            </p>
            <p>
                <label>Second Name
                </label>
                 
                <asp:TextBox ID="txtSecondNameEn" CssClass="long" Text='<%# Bind("SecondNameEn") %>' runat="server"></asp:TextBox>
            </p>
            <p>
                <label>Family Name
                </label>
                 
                <asp:TextBox ID="txtFamilyNameEn" CssClass="long" Text='<%# Bind("FamilyNameEn") %>' runat="server"></asp:TextBox>
            </p>
            <p>
                <label>Date of Birth
                </label>
                 
                <asp:TextBox ID="txtDOB" CssClass="long" Text='<%# Bind("DOB") %>' runat="server"></asp:TextBox>
            </p>
            <p>
                <label>Nationality
                </label>
                 
                <asp:DropDownList ID="ddlNationality" runat="server">
                </asp:DropDownList>
            </p>
            <p>
                <label>ID No.
                </label>
                 
                <asp:TextBox ID="txtIDNo" CssClass="long" Text='<%# Bind("IDNo") %>' runat="server"></asp:TextBox>
                 
            </p>
            <p>
                <label>Mobile
                </label>
                 
                <asp:TextBox ID="txtMobile" CssClass="long" Text='<%# Bind("PhoneNumber") %>' runat="server"></asp:TextBox>
                 
            </p>
            <p>
                <label>Email
                </label>
                 
                <asp:TextBox ID="txtEmail" CssClass="long" Text='<%# Bind("Email") %>' runat="server"></asp:TextBox>
                 
            </p>
            <p>
                <label>Notes
                </label>
                 
                <asp:TextBox ID="txtNotes" TextMode="MultiLine" Text='<%# Bind("Notes") %>' CssClass="multi" runat="server"></asp:TextBox>
                 
            </p>
        </fieldset>
        <fieldset class="rowPersonalAr">
            <legend>المعلومات الشخصية</legend>
            <p style="text-align:left">
                 
                <asp:TextBox ID="txtFirstNameAr" CssClass="long" Text='<%# Bind("FirstNameAr") %>' runat="server"></asp:TextBox>
                <label>الاسم الأول
                </label>
            </p>
           <p>
                 
                <asp:TextBox ID="txtSecondNameAr" CssClass="long" Text='<%# Bind("SecondNameAr") %>' runat="server"></asp:TextBox>
                <label>الاسم الثاني
                </label>
            </p>
            <p>
                 
                <asp:TextBox ID="txtFamilyNameAr" CssClass="long" Text='<%# Bind("FamilyNameAr") %>' runat="server"></asp:TextBox>
                <label>العائلة
                </label>
            </p>
        </fieldset>
         
        <fieldset class="rowAcademical">
            <legend>Academical Information
            </legend>
            <p>
                <label>Degree</label>
                <asp:DropDownList ID="ddlAcademicDegree" runat="server" DataSourceID="DataSourceAD" DataTextField="ADEn" DataValueField="ADID" AppendDataBoundItems="true" >
                    <asp:ListItem Selected="True" Text="Select" Value="0"></asp:ListItem>
                     
                </asp:DropDownList>
            </p>
            <p>
                <label>Experience
                </label>
                 
                <asp:TextBox ID="txtExp" CssClass="long" Text='<%# Bind("YearsOfExp") %>' runat="server"></asp:TextBox>
            </p>
            <p>
                <label>College/Uni.
                </label>
                 
                <asp:TextBox ID="txtUniv" CssClass="long" Text='<%# Bind("CollegeName") %>' runat="server"></asp:TextBox>
            </p>
            <p>
                 <label>Department</label>
                <asp:DropDownList ID="ddlDept" runat="server" DataSourceID="DataSourceDepartments"  DataTextField="DepartmentEn" DataValueField="DepartmentID" AppendDataBoundItems="true" >
                                       
                                            <asp:ListItem Selected="True" Text="Select" Value="0" >
                                            </asp:ListItem>
                     
                </asp:DropDownList>
            </p>
            <p>
                 <label>Stage</label>
                <asp:DropDownList ID="ddlStage" runat="server" DataSourceID="DataSourceStages" DataTextField="StageEn" DataValueField="StageID"  AppendDataBoundItems="true">
                      <asp:ListItem Selected="True" Text="Select" Value="0"></asp:ListItem>
                     
                </asp:DropDownList>
            </p>
            <p>
                 <label>Subject</label>
                <asp:DropDownList ID="ddlSubject" runat="server" DataSourceID="DataSourceSubjects"  DataTextField="SubEn" DataValueField="SubID" AppendDataBoundItems="true">
                    <asp:ListItem Selected="True" Text="Select" Value="0"></asp:ListItem>
                     
                </asp:DropDownList>
            </p>
            <p>
                 <label>Hired Date</label>
                <asp:TextBox ID="txtHireDate" CssClass="long" Text='<%# Bind("HiredDate") %>' runat="server"></asp:TextBox>
            </p>
        </fieldset>
        <div>
         <asp:Button ID="btnUpdate" Text='<%# (Container is GridEditFormInsertItem) ? "Insert" : "Update" %>'
                                runat="server" CommandName="Update">
                            </asp:Button
                                 <asp:Button ID="btnCancel" Text="Close" runat="server" CausesValidation="False"
                                CommandName="Cancel"></asp:Button>
        </div>
 
        </div>
         
         </div>
                        </FormTemplate>
                    </EditFormSettings>
                    <BatchEditingSettings EditType="Cell" />
                    <PagerStyle AlwaysVisible="True" PageSizeControlType="RadComboBox" />
                </MasterTableView>
                <PagerStyle AlwaysVisible="True" PageSizeControlType="RadComboBox" />
                <FilterMenu EnableImageSprites="False">
                </FilterMenu>
                </telerik:RadGrid>
 
<asp:SqlDataSource ID="SqlDataSourceStaff" runat="server"
      ConnectionString="<%$ ConnectionStrings:EschoolTestV2ConnectionString %>"
      SelectCommand="SELECT usr.*, usr.FirstNameEn+' '+usr.FamilyNameEn AS EnglishName, dept.DepEn AS DepartID,dept.DepID AS DeparID,sub.SubEn,sub.SubID, ad.ADEn,st.StageEn FROM AttUsers usr,AttStages st, AttAcademicalDegrees ad, AttDepartments dept, AttSubjects sub WHERE st.StageID=usr.Stage AND ad.ADID=usr.AcademicalDegree AND sub.SubID=usr.Subject AND usr.Department=dept.DepID"
      UpdateCommand="UPDATE AttUsers SET [FirstNameEn]=@FirstNameEn, [FirstNameAr]=@FirstNameAr, [SecondNameEn]=@SecondNameEn,[SecondNameAr]=@SecondNameAr,[FamilyNameEn]=@FamilyNameEn,[FamilyNameAr]=@FamilyNameAr,[DOB]=@DOB,[IDNo]=IDNo,[PhoneNumber]=@PhoneNumber,[Email]=@Email,[Notes]=@Notes,[YearsOfExp]=@YearsOfExp,[CollegeName]=@CollegeName,[Department]=@DeparID,[Subject]=@Subject,[AcademicalDegree]=@AcademicalDegree,[Stage]=@Stage,[HiredDate]=@HiredDate WHERE UserID=@UserID"
      InsertCommand="INSERT INTO AttUsers (FirstNameAr,SecondNameAr,FamilyNameAr,FirstNameEn,SecondNameEn,FamilyNameEn,DOB,IDNo,PhoneNumber,Email,Notes,YearsOfExp,CollegeName,Department,Subject,AcademicalDegree,Stage,HiredDate) VALUES (@FirstNameAr,@SecondNameAr,@FamilyNameAr,@FirstNameEn,@SecondNameEn,@FamilyNameEn,@DOB,@IDNo,@PhoneNumber,@Email,@Notes,@YearsOfExp,@CollegeName,@DeparID,@Subject,@AcademicalDegree,@Stage,@HiredDate)">
        <UpdateParameters>
            <asp:Parameter Name="UserID" Type="String"></asp:Parameter>
            <asp:Parameter Name="FirstNameAr" Type="String"></asp:Parameter>
            <asp:Parameter Name="FirstNameEn" Type="String"></asp:Parameter>
            <asp:Parameter Name="SecondNameAr" Type="String"></asp:Parameter>
            <asp:Parameter Name="SecondNameEn" Type="String"></asp:Parameter>
            <asp:Parameter Name="FamilyNameAr" Type="String"></asp:Parameter>
            <asp:Parameter Name="FamilyNameEn" Type="String"></asp:Parameter>
            <asp:Parameter Name="DOB" Type="DateTime"></asp:Parameter>
            <asp:Parameter Name="IDNo" Type="String"></asp:Parameter>
            <asp:Parameter Name="PhoneNumber" Type="String"></asp:Parameter>
            <asp:Parameter Name="Email" Type="String"></asp:Parameter>
            <asp:Parameter Name="Notes" Type="String"></asp:Parameter>
            <asp:Parameter Name="YearsOfExp" Type="String"></asp:Parameter>
            <asp:Parameter Name="CollegeName" Type="String"></asp:Parameter>
            <asp:Parameter Name="DeparID" Type="String"></asp:Parameter>
            <asp:Parameter Name="Subject" Type="String"></asp:Parameter>
             
            <asp:Parameter Name="AcademicalDegree" Type="String"></asp:Parameter>
            <asp:Parameter Name="HiredDate" Type="DateTime"></asp:Parameter>
            <asp:Parameter Name="Stage" Type="String" />
        </UpdateParameters>
        <InsertParameters>
             
            <asp:Parameter Name="FirstNameAr" Type="String"></asp:Parameter>
            <asp:Parameter Name="FirstNameEn" Type="String"></asp:Parameter>
            <asp:Parameter Name="SecondNameAr" Type="String"></asp:Parameter>
            <asp:Parameter Name="SecondNameEn" Type="String"></asp:Parameter>
            <asp:Parameter Name="FamilyNameAr" Type="String"></asp:Parameter>
            <asp:Parameter Name="FamilyNameEn" Type="String"></asp:Parameter>
            <asp:Parameter Name="DOB" Type="DateTime"></asp:Parameter>
            <asp:Parameter Name="IDNo" Type="String"></asp:Parameter>
            <asp:Parameter Name="PhoneNumber" Type="String"></asp:Parameter>
            <asp:Parameter Name="Email" Type="String"></asp:Parameter>
            <asp:Parameter Name="Notes" Type="String"></asp:Parameter>
            <asp:Parameter Name="YearsOfExp" Type="String"></asp:Parameter>
            <asp:Parameter Name="CollegeName" Type="String"></asp:Parameter>
            <asp:Parameter Name="DeparID" Type="String"></asp:Parameter>
            <asp:Parameter Name="Subject" Type="String"></asp:Parameter>
            <asp:Parameter Name="Stage" Type="String"></asp:Parameter>
            <asp:Parameter Name="AcademicalDegree" Type="String"></asp:Parameter>
            <asp:Parameter Name="HiredDate" Type="DateTime"></asp:Parameter>
        </InsertParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="DataSourceDepartments" runat="server"
      ConnectionString="<%$ ConnectionStrings:EschoolTestV2ConnectionString %>"
      SelectCommand="SELECT DepEn AS DepartmentEn, DepID AS DepartmentID FROM AttDepartments ORDER BY DepID ASC">
    
</asp:SqlDataSource>
<asp:SqlDataSource ID="DataSourceSubjects" runat="server"
      ConnectionString="<%$ ConnectionStrings:EschoolTestV2ConnectionString %>"
      SelectCommand="SELECT SubEn, SubID FROM AttSubjects ORDER BY SubID ASC">
    
</asp:SqlDataSource>
<asp:SqlDataSource ID="DataSourceAD" runat="server"
      ConnectionString="<%$ ConnectionStrings:EschoolTestV2ConnectionString %>"
      SelectCommand="SELECT ADID, ADEn FROM AttAcademicalDegrees ORDER BY ADID ASC">
    
</asp:SqlDataSource>
<asp:SqlDataSource ID="DataSourceStages" runat="server"
      ConnectionString="<%$ ConnectionStrings:EschoolTestV2ConnectionString %>"
      SelectCommand="SELECT StageID, StageEn FROM AttStages ORDER BY StageID ASC">
    
</asp:SqlDataSource>
Princy
Top achievements
Rank 2
 answered on 05 Nov 2013
Narrow your results
Selected tags
Tags
+? more
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?