Telerik Forums
UI for ASP.NET AJAX Forum
1 answer
103 views
I'm using ajax and adding radbutton to page code behind:



            Dim RB As New RadButton
            RB.Skin = "Sunset"
            RB.Text = "New User"
            RB.AutoPostBack = False
            RB.OnClientClicked = "NewUser"
            RB.UseSubmitBehavior = False
            RB.RegisterWithScriptManager = False


            Wind.Controls.Add(RB)

Wind is a HTMLGENERICCONTROL - DIV

button added page but clientside events not work, I'm try expect to RB.RegisterWithScriptManager = False property then ScriptManager Error

Rumen
Telerik team
 answered on 24 Jan 2011
0 answers
59 views
I have face one problem ..

All process include curd operation are working properly in local system  but when host in server especially one page not working ...

we are facing some problem's,
 
  * While adding the data the success full  message, have to show. But it has't  show any msg, and also the added data is stored in the data grid, but the rad grid did't get update. Instead of it show the error msg, which is attached.
 * At the same time while adding data it has to send the mail to the client but this function also not working .

Note:  we are using ajax control. Weather we have to do some operation in it.


pls give solution .. 
Asiq Raja
Top achievements
Rank 1
 asked on 24 Jan 2011
2 answers
94 views
Hello,

The documentation mentions:

"...you will need to have ASP.NET AJAX installed on your development/production machine..."
"... targeting ASP.NET 2.0, you will need to have ASP.NET AJAX 1.0 installed on your development/production machine..."

Here is my question.

Our production server is running in Windows Server 2008RC2, which has .NET Framework 3.5.1 installed.

According to the Microsoft Download Center "Microsoft .NET Framework 3.5" website,
the dot net framework should contain the ASP.NET Ajax already. 

Does it mean, if we want to run a website that uses RadControls, we won't need to install anything extra to our production server because it already has .NET Framework 3.5.1?

Many thanks!
Nim
Top achievements
Rank 1
 answered on 24 Jan 2011
2 answers
137 views

Hi Guys,

I'm using the filter functionality in the RadGrid & i've enabled/disabled certain columns to only have certain fields on which the user can filter data.
However, when i use the filter on any column, i get the following error:

Microsoft JScript runtime error: Sys.WebForms.PageRequestManagerServerErrorException:  is neither a DataColumn nor a DataRelation for table DefaultView.

As you can see, there is a blank entry in the err msg where it should normall state a column.
Does anyone know why this is happening?

My code is as follows:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="TotalTargets.aspx.cs" Inherits="WorkStreamList"
StylesheetTheme="SkinFile" %>
  
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
  
<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>
  
  
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  
<head runat="server">
    <title>Totals for Annual Targets</title>
    <link href="General.css" rel="stylesheet" type="text/css" />
    <!-- custom head section -->
    <style type="text/css">
        .MyImageButton
        {
           cursor: hand;
        }
        .EditFormHeader td
        {
            font-size: 14px;
            padding: 4px !important;
            color: #0066cc;
        }
        </style>
    <!-- end of custom head section -->
  
</head>
  
<body>
    <form id="form1" runat="server">
  
        <asp:scriptmanager runat="server"></asp:scriptmanager>
  
        <telerik:RadFormDecorator ID="RadFormDecorator1" runat="server" DecoratedControls="All" />
  
        <table border="0" cellpadding="0" cellspacing="0" style="height:30px; width:800px;" >
        <tr><td  style="width:80%">
            <img id="Img1" alt="Savings Plans" src="Pics/SavingsPlansTitle2.gif" runat="server"  />
              <asp:Label ID="lblUserName" runat="server" Font-Bold="True" Font-Size="Small" ForeColor="Black"
                Style="font-size: Small"></asp:Label
        </td><td style="width:20%" align="right">
        <asp:UpdateProgress runat="server" ID="updateprogress1" >
            <ProgressTemplate >
            <div class="progress">
                <img alt="" src="Pics/load.gif"  
                    style="width: 30px; height: 30px; vertical-align:middle" /><b><span style="font-size: small; color: #FF0000">
                Please Wait...</span></b>
            </div
            </ProgressTemplate>
        </asp:UpdateProgress>
        </td></tr>
  
        </table>
          
        <div id="MainSection" runat="server" style="width: 800px;" >
  
        <div style="width: 800px; text-align: center;">
            <asp:UpdatePanel ID="UpdatePanel3" runat="server"  >
                <ContentTemplate>
                    <asp:Label ID="lblError" runat="server" Font-Bold="True" Font-Size="Medium" ForeColor="Red"
                        Style="font-size: small"></asp:Label>
                </ContentTemplate>
            </asp:UpdatePanel>
        </div>
          
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:SavingsPlanDBConnectionString %>"
                SelectCommand="SELECT [id], [BusinessCode], [BusinessUnit], [Directorate], [TotalTarget], [FinancialYear], [SortOrder] FROM [OverallTargets]" 
                DeleteCommand="DELETE FROM [OverallTargets] WHERE [id] = @id" 
                InsertCommand="INSERT INTO [OverallTargets] ([BusinessCode], [BusinessUnit], [Directorate], [TotalTarget], [FinancialYear], [SortOrder]) VALUES (@BusinessCode, @BusinessUnit, @Directorate, @TotalTarget, @FinancialYear, @SortOrder)" 
                UpdateCommand="UPDATE [OverallTargets] SET [BusinessCode] = @BusinessCode, [BusinessUnit] = @BusinessUnit, [Directorate] = @Directorate, [TotalTarget] = @TotalTarget, [FinancialYear] = @FinancialYear, [SortOrder]=@SortOrder WHERE [id] = @id" >
            <DeleteParameters>
                <asp:Parameter Name="id" Type="Int32" />
            </DeleteParameters>
            <UpdateParameters>
                <asp:Parameter Name="BusinessCode" Type="String" />
                <asp:Parameter Name="BusinessUnit" Type="String" />
                <asp:Parameter Name="Directorate" Type="String" />
                <asp:Parameter Name="FinancialYear" Type="String" />
                <asp:Parameter Name="TotalTarget" Type="Decimal" />
                <asp:Parameter Name="SortOrder" Type="Int16" />
                <asp:Parameter Name="id" Type="Int32" />
            </UpdateParameters>
            <InsertParameters>
                <asp:Parameter Name="BusinessCode" Type="String" />
                <asp:Parameter Name="BusinessUnit" Type="String" />
                <asp:Parameter Name="Directorate" Type="String" />
                <asp:Parameter Name="FinancialYear" Type="String" />
                <asp:Parameter Name="TotalTarget" Type="Decimal" />
                <asp:Parameter Name="SortOrder" Type="Int16"  />
            </InsertParameters>
        </asp:SqlDataSource>
          
        <asp:SqlDataSource ID="DS_Directorate" runat="server" 
            ConnectionString="<%$ ConnectionStrings:DataAcademy400ConnectionString %>" 
            SelectCommand="SELECT DISTINCT LOWER(DirectorateDescription) AS Directorate FROM ORACLE_DS_GL_Hierarchy WHERE (DirectorateCode <> 'BS') ORDER BY Directorate" >
        </asp:SqlDataSource>
          
        <br />
        <asp:Label ID="Label2" runat="server" Text="Total Targets:" ForeColor="Black" Font-Size="Medium"  Font-Bold="True" Font-Names="Monotype Corsiva,Verdana"></asp:Label>
        <br />
          
        <telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">
            <script type="text/javascript">
                function RowDblClick(sender, eventArgs) {
                    sender.get_masterTableView().editItem(eventArgs.get_itemIndexHierarchical());
                }
            </script>
        </telerik:RadCodeBlock>
          
        <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
            <AjaxSettings>
                <telerik:AjaxSetting AjaxControlID="RadGrid1">
                    <UpdatedControls>
                        <telerik:AjaxUpdatedControl ControlID="RadGrid1" LoadingPanelID="RadAjaxLoadingPanel1" />
                    </UpdatedControls>
                </telerik:AjaxSetting>
            </AjaxSettings>
        </telerik:RadAjaxManager>
  
        <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" HorizontalAlign="Center" Visible="true" Skin="Web20" 
            RegisterWithScriptManager="true" Width="800px" />
          
        <telerik:RadGrid ID="RadGrid1" GridLines="None" runat="server" AllowAutomaticDeletes="True"
            AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AllowPaging="True"
            AutoGenerateColumns="False" DataSourceID="SqlDataSource1" Skin="Web20" 
            Width="800px" AllowFilteringByColumn="True" OnItemUpdated="RadGrid1_ItemUpdated"
            OnItemDeleted="RadGrid1_ItemDeleted" OnItemInserted="RadGrid1_ItemInserted" 
            OnDataBound="RadGrid1_DataBound" OnItemDataBound="RadGrid1_ItemDataBound" 
            onitemcommand="RadGrid1_ItemCommand" AllowMultiRowEdit="false" AllowMultiRowSelection="false" >
            <PagerStyle Mode="NextPrevAndNumeric" />
            <AlternatingItemStyle BackColor="#E8F1FF" />
            <MasterTableView Width="800px" CommandItemDisplay="TopAndBottom" DataKeyNames="Id"  
                DataSourceID="SqlDataSource1" HorizontalAlign="NotSet" AutoGenerateColumns="False">
                <CommandItemSettings ExportToPdfText="Export to Pdf"></CommandItemSettings>
  
                <RowIndicatorColumn FilterControlAltText="Filter RowIndicator column"></RowIndicatorColumn>
  
                <ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column"></ExpandCollapseColumn>
                <Columns>
                    <telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="EditCommandColumn">
                        <ItemStyle CssClass="MyImageButton" />
                    </telerik:GridEditCommandColumn>
                    <telerik:GridTemplateColumn HeaderText="Id"  UniqueName="Id" AllowFiltering="false"
                        EditFormColumnIndex="1" >
                        <ItemTemplate>
                            <asp:Label runat="server" ID="lblId"  Text='<%# Eval("Id") %>'></asp:Label>
                        </ItemTemplate>
                        <InsertItemTemplate>
                            <asp:Label runat="server" ID="lblId"  Text='<%# Eval("Id") %>'></asp:Label>
                        </InsertItemTemplate>
                        <EditItemTemplate>
                            <asp:Label runat="server" ID="lblId"  Text='<%# Eval("Id") %>'></asp:Label>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
  
                    <telerik:GridTemplateColumn HeaderText="Directorate" SortExpression="Directorate" UniqueName="Directorate" AllowFiltering="true"
                        EditFormColumnIndex="0" FilterControlWidth="80%">
                        <ItemTemplate>
                            <asp:Label runat="server" ID="lblDirectorate" Text='<%# Eval("Directorate") %>'></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <span>
                            <telerik:RadComboBox runat="server" Width="250px" Height="150px"
                                EmptyMessage="Select a Directorate" DataSourceID="DS_Directorate" DataTextField="Directorate"
                                DataValueField="Directorate"  
                                HeaderText="Directorate" Skin="Web20" SelectedValue='<%# Bind("Directorate") %>'
                                UniqueName="Directorate" ID="cmbDirectorate" ColumnEditorID="GridDropDownColumnEditor2">
                            </telerik:RadComboBox
                            <asp:RequiredFieldValidator ID="RequiredFieldValidator5" ControlToValidate="cmbDirectorate"
                            ErrorMessage="*" runat="server">
                            </asp:RequiredFieldValidator>
                            </span>
                        </EditItemTemplate>
                          
                        <InsertItemTemplate>
                            <span>
                            <telerik:RadComboBox runat="server" Width="250px" Height="150px"
                                EmptyMessage="Select a Directorate" DataSourceID="DS_Directorate" DataTextField="Directorate"
                                DataValueField="Directorate" 
                                HeaderText="Directorate" Skin="Web20" SelectedValue='<%# Bind("Directorate") %>'
                                UniqueName="Directorate" ID="cmbDirectorate" ColumnEditorID="GridDropDownColumnEditor2">
                            </telerik:RadComboBox
                            <asp:RequiredFieldValidator ID="RequiredFieldValidator6" ControlToValidate="cmbDirectorate"
                            ErrorMessage="*" runat="server">
                            </asp:RequiredFieldValidator>
                            </span>
                        </InsertItemTemplate>
                      
                    </telerik:GridTemplateColumn>
  
                    <telerik:GridTemplateColumn HeaderText="Business Unit" SortExpression="BusinessUnit" UniqueName="BusinessUnit" AllowFiltering="true"
                        EditFormColumnIndex="0" FilterControlWidth="80%">
                        <ItemTemplate>
                            <asp:Label runat="server" ID="lblBusinessUnit" Text='<%# Eval("BusinessUnit") %>'></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <span>
                            <telerik:RadComboBox runat="server" Width="250px" Height="150px"
                                EmptyMessage="Select a Business Unit" DataSourceID="DS_BusinessUnit" DataTextField="BusinessUnit"
                                DataValueField="BusinessUnit" 
                                HeaderText="BusinessUnit" Skin="Web20" SelectedValue='<%# Bind("BusinessUnit") %>'
                                UniqueName="BusinessUnit" ID="cmbBusinessUnit" ColumnEditorID="GridDropDownColumnEditor2">
                            </telerik:RadComboBox
                            <asp:RequiredFieldValidator ID="RequiredFieldValidator3" ControlToValidate="cmbBusinessUnit"
                            ErrorMessage="*" runat="server">
                            </asp:RequiredFieldValidator>
                            </span>
                        </EditItemTemplate>
                          
                        <InsertItemTemplate>
                            <span>
                            <telerik:RadComboBox runat="server" Width="250px" Height="150px"
                                EmptyMessage="Select a Business Unit" DataSourceID="DS_BusinessUnit" DataTextField="BusinessUnit"
                                DataValueField="BusinessUnit"
                                HeaderText="BusinessUnit" Skin="Web20" SelectedValue='<%# Bind("BusinessUnit") %>'
                                UniqueName="BusinessUnit" ID="cmbBusinessUnit" ColumnEditorID="GridDropDownColumnEditor2">
                            </telerik:RadComboBox
                            <asp:RequiredFieldValidator ID="RequiredFieldValidator4" ControlToValidate="cmbBusinessUnit"
                            ErrorMessage="*" runat="server">
                            </asp:RequiredFieldValidator>
                            </span>
                        </InsertItemTemplate>
                      
                    </telerik:GridTemplateColumn>
  
  
                    <telerik:GridTemplateColumn HeaderText="Business Code" SortExpression="BusinessCode" UniqueName="BusinessCode" AllowFiltering="true"
                        EditFormColumnIndex="0" FilterControlWidth="70%" >
                        <ItemTemplate>
                            <asp:Label runat="server" ID="lblBusinessCode" Text='<%# Eval("BusinessCode") %>'></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <span>
                            <telerik:RadTextBox runat="server" Width="250px" Text='<%# Bind("BusinessCode") %>' ID="txtBusinessCode" Visible="false" >
                            </telerik:RadTextBox>
                            </span>
                        </EditItemTemplate>
                        <InsertItemTemplate>
                            <span>
                            <telerik:RadTextBox runat="server" Width="250px" Text='<%# Bind("BusinessCode") %>' ID="txtBusinessCode" Visible="false" >
                            </telerik:RadTextBox>
                            </span>
                        </InsertItemTemplate>
                    </telerik:GridTemplateColumn>
  
  
                    <telerik:GridTemplateColumn HeaderText="Year" SortExpression="FinancialYear" UniqueName="FinancialYear" AllowFiltering="true"
                        EditFormColumnIndex="1" FilterControlWidth="70%">
                        <ItemTemplate>
                            <asp:Label runat="server" ID="lblFinancialYear" Text='<%# Eval("FinancialYear") %>' Width="70px"></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <span>
                            <telerik:RadComboBox runat="server" Width="250px" Height="150px"
                                EmptyMessage="Select a Financial Year"
                                HeaderText="Year" Skin="Web20" SelectedValue='<%# Bind("FinancialYear") %>'
                                UniqueName="FinancialYear" ID="cmbFinancialYear" ColumnEditorID="GridDropDownColumnEditor2">
                                <Items>
                                <telerik:RadComboBoxItem Value=" " Text=" " />
                                <telerik:RadComboBoxItem Value="2009-10" Text="2009-10" />
                                <telerik:RadComboBoxItem Value="2010-11" Text="2010-11" />
                                <telerik:RadComboBoxItem Value="2011-12" Text="2011-12" />
                                <telerik:RadComboBoxItem Value="2012-13" Text="2012-13" />
                                <telerik:RadComboBoxItem Value="2013-14" Text="2013-14" />
                                <telerik:RadComboBoxItem Value="2014-15" Text="2014-15" />
                                <telerik:RadComboBoxItem Value="2015-16" Text="2015-16" />
                                <telerik:RadComboBoxItem Value="2016-17" Text="2016-17" />
                                </Items>
                            </telerik:RadComboBox
                            <asp:RequiredFieldValidator ID="RequiredFieldValidator8" ControlToValidate="cmbFinancialYear"
                            ErrorMessage="*" runat="server">
                            </asp:RequiredFieldValidator>
                            </span>
                        </EditItemTemplate>
                          
                        <InsertItemTemplate>
                            <span>
                            <telerik:RadComboBox runat="server" Width="250px" Height="150px"
                                EmptyMessage="Select a Financial Year"
                                HeaderText="Year" Skin="Web20" SelectedValue='<%# Bind("FinancialYear") %>'
                                UniqueName="FinancialYear" ID="cmbFinancialYear" ColumnEditorID="GridDropDownColumnEditor2">
                                <Items>
                                <telerik:RadComboBoxItem Value=" " Text=" " />
                                <telerik:RadComboBoxItem Value="2009-10" Text="2009-10" />
                                <telerik:RadComboBoxItem Value="2010-11" Text="2010-11" />
                                <telerik:RadComboBoxItem Value="2011-12" Text="2011-12" />
                                <telerik:RadComboBoxItem Value="2012-13" Text="2012-13" />
                                <telerik:RadComboBoxItem Value="2013-14" Text="2013-14" />
                                <telerik:RadComboBoxItem Value="2014-15" Text="2014-15" />
                                <telerik:RadComboBoxItem Value="2015-16" Text="2015-16" />
                                <telerik:RadComboBoxItem Value="2016-17" Text="2016-17" />
                                </Items>
                            </telerik:RadComboBox
                            <asp:RequiredFieldValidator ID="RequiredFieldValidator9" ControlToValidate="cmbFinancialYear"
                            ErrorMessage="*" runat="server">
                            </asp:RequiredFieldValidator>
                            </span>
                        </InsertItemTemplate>
                      
                    </telerik:GridTemplateColumn>
  
                    <telerik:GridTemplateColumn HeaderText="Total Target" SortExpression="TotalTarget" UniqueName="TotalTarget" AllowFiltering="false"
                        EditFormColumnIndex="1" >
                        <ItemTemplate>
                            <asp:Label runat="server" ID="lblTotalTarget" Text='<%# Eval("TotalTarget", "{0:C0}") %>'></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <span><telerik:RadNumericTextBox BackColor="#6B8DC2" 
                                EmptyMessage="Enter Overall Target Value" Font-Bold="True" ForeColor="White" Skin="Web20" runat="server" ID="tbTotalTarget" Width="245px" DbValue='<%# Bind("TotalTarget") %>'></telerik:RadNumericTextBox>
                            <asp:RequiredFieldValidator ID="RequiredFieldValidator1" ControlToValidate="tbTotalTarget"
                            ErrorMessage="*" runat="server">
                            </asp:RequiredFieldValidator>
                            </span>
                        </EditItemTemplate>
                        <InsertItemTemplate>
                            <span><telerik:RadNumericTextBox BackColor="#6B8DC2" 
                                EmptyMessage="Enter Overall Target Value" Font-Bold="True" ForeColor="White" Skin="Web20" runat="server" ID="tbTotalTarget" Width="245px" DbValue='<%# Bind("TotalTarget") %>'></telerik:RadNumericTextBox>
                            <asp:RequiredFieldValidator ID="RequiredFieldValidator1" ControlToValidate="tbTotalTarget"
                            ErrorMessage="*" runat="server">
                            </asp:RequiredFieldValidator>
                            </span>
                        </InsertItemTemplate>             
                    </telerik:GridTemplateColumn>
  
                    <telerik:GridTemplateColumn HeaderText="SortOrder"  UniqueName="SortOrder" AllowFiltering="false"  Visible="false" 
                        EditFormColumnIndex="1">
                        <ItemTemplate>
                            <asp:Label runat="server" ID="lblSortOrder" Text='<%# Eval("SortOrder") %>'></asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <span>
                            <telerik:RadTextBox runat="server" Width="250px" Text='<%# Bind("SortOrder") %>' ID="txtSortOrder" Visible="false" >
                            </telerik:RadTextBox>
                            </span>
                        </EditItemTemplate>
                        <InsertItemTemplate>
                            <span>
                            <telerik:RadTextBox runat="server" Width="250px" Text='<%# Bind("SortOrder") %>' ID="txtSortOrder" Visible="false" >
                            </telerik:RadTextBox>
                            </span>
                        </InsertItemTemplate>
                    </telerik:GridTemplateColumn>
  
                    <telerik:GridButtonColumn ConfirmText="Delete this product?" ConfirmDialogType="RadWindow"
                        ConfirmTitle="Delete" ButtonType="ImageButton" CommandName="Delete" Text="Delete"
                        UniqueName="DeleteColumn">
                        <ItemStyle HorizontalAlign="Center" CssClass="MyImageButton" />
                    </telerik:GridButtonColumn>
                </Columns>
                <EditFormSettings ColumnNumber="2" CaptionDataField="Id" CaptionFormatString="Edit properties of Record Id {0}" InsertCaption="New Record">
                   <FormTableItemStyle Wrap="False"></FormTableItemStyle>
                    <FormCaptionStyle CssClass="EditFormHeader"></FormCaptionStyle>
                    <FormMainTableStyle GridLines="None" CellSpacing="0" CellPadding="3" BackColor="#F2FFEC"
                        Width="100%" />
                    <FormTableStyle CellSpacing="0" CellPadding="2" Height="60px" BackColor="#F2FFEC" />
                    <FormTableAlternatingItemStyle Wrap="False"></FormTableAlternatingItemStyle>
                    <EditColumn ButtonType="ImageButton" InsertText="Insert Record" UpdateText="Update Record"
                        UniqueName="EditCommandColumn1" CancelText="Cancel edit">
                    </EditColumn>
                    <FormTableButtonRowStyle HorizontalAlign="Right" CssClass="EditFormButtonRow"></FormTableButtonRowStyle>
                </EditFormSettings>
            </MasterTableView>
            <ClientSettings>
                <Selecting AllowRowSelect="True" />
                <ClientEvents OnRowDblClick="RowDblClick" />
            </ClientSettings>
  
            <EditItemStyle BackColor="#F2FFEC" />
  
            <ActiveItemStyle BackColor="#FFF8D9" BorderColor="#FFF8D9" BorderStyle="Solid" 
                BorderWidth="1px" />
            <SelectedItemStyle BackColor="#FFF8D9" BorderColor="#FFF8D9" 
                BorderStyle="Solid" BorderWidth="1px" />
  
            <FilterMenu EnableImageSprites="False"></FilterMenu>
  
            <HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Web20"></HeaderContextMenu>
  
        </telerik:RadGrid>
        <telerik:GridTextBoxColumnEditor ID="GridTextBoxColumnEditor1" runat="server" TextBoxStyle-Width="200px" Visible="false" />
        <telerik:GridTextBoxColumnEditor ID="GridTextBoxColumnEditor2" runat="server" TextBoxStyle-Width="200px" />
        <telerik:GridTextBoxColumnEditor ID="GridTextBoxColumnEditor3" runat="server" TextBoxStyle-Width="200px" />
        <telerik:GridDropDownListColumnEditor ID="GridDropDownColumnEditor1" runat="server" 
                DropDownStyle-Width="300px" Visible="false"   >
                <DropDownStyle Width="300px"></DropDownStyle>
            </telerik:GridDropDownListColumnEditor>
        <telerik:GridDropDownListColumnEditor ID="GridDropDownColumnEditor2" runat="server" DropDownStyle-Width="300px" />
        <telerik:GridDropDownListColumnEditor ID="GridDropDownColumnEditor3" runat="server" DropDownStyle-Width="300px" />
        <telerik:GridNumericColumnEditor ID="GridNumericColumnEditor1" runat="server" NumericTextBox-Width="200px"  />
  
         
  
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
            ConnectionString="<%$ ConnectionStrings:SavingsPlanDBConnectionString %>" 
            SelectCommand="SELECT [id], [BusinessCode], [BusinessUnit], [Directorate], [TotalTarget], [SortOrder] FROM [OverallTargets]"
            FilterExpression="id='{0}'" 
                DeleteCommand="DELETE FROM [OverallTargets] WHERE [id] = @id" 
                InsertCommand="INSERT INTO [OverallTargets] ([BusinessCode], [BusinessUnit], [Directorate], [TotalTarget], [SortOrder]) VALUES (@BusinessCode, @BusinessUnit, @Directorate, @TotalTarget, @SortOrder)" 
                UpdateCommand="UPDATE [OverallTargets] SET [BusinessCode] = @BusinessCode, [BusinessUnit] = @BusinessUnit, [Directorate] = @Directorate, [TotalTarget] = @TotalTarget, [SortOrder] = @SortOrder WHERE [id] = @id">
            <DeleteParameters>
                <asp:Parameter Name="id" Type="Int32" />
            </DeleteParameters>
  
            <UpdateParameters>
                <asp:Parameter Name="BusinessCode" Type="String" />
                <asp:Parameter Name="BusinessUnit" Type="String" />
                <asp:Parameter Name="Directorate" Type="String" />
                <asp:Parameter Name="TotalTarget" Type="Decimal" />
                <asp:Parameter Name="SortOrder" Type="Int32" />
                <asp:Parameter Name="id" Type="Int32" />
            </UpdateParameters>
            <InsertParameters>
                <asp:Parameter Name="BusinessCode" Type="String" />
                <asp:Parameter Name="BusinessUnit" Type="String" />
                <asp:Parameter Name="Directorate" Type="String" />
                <asp:Parameter Name="TotalTarget" Type="Decimal" />
                <asp:Parameter Name="SortOrder" Type="Int32" />
            </InsertParameters>
        </asp:SqlDataSource>
  
        <asp:SqlDataSource ID="DS_BusinessUnit" runat="server" 
            ConnectionString="<%$ ConnectionStrings:DataAcademy400ConnectionString %>" 
              
                SelectCommand="SELECT DISTINCT BusinessUnitCode, CASE BusinessUnitCode WHEN 'C1' THEN 'Corporate' WHEN 'F1' THEN 'Facilities' WHEN 'G1' THEN 'Group 1 - Emergency Services' WHEN 'G2' THEN 'Group 2 - Planned Inpatient Care' WHEN 'G3' THEN 'Group 3 - Ambulatory Care' WHEN 'G4' THEN 'Group 4 - Clinical Support' WHEN 'G5' THEN 'Group 5 - Womens & Children' ELSE 'ERROR' END AS BusinessUnit FROM ORACLE_DS_GL_Hierarchy WHERE (BusinessUnitCode NOT IN ('BSBU', 'C2', '3A', '9A')) ORDER BY BusinessUnitCode, BusinessUnit">
        </asp:SqlDataSource>
                  
        <br /><br /> 
          
        <asp:LinkButton ID="btnHome" OnClick="btnHome_Click" 
        runat="server" CausesValidation="False" 
        Text="<img style='v-align:bottom; margin-top:3px;Border-style:none;' src='Pics/home2.gif' alt='Back To Home Page'>"></asp:LinkButton>
         Back To Home Page
          
        <br /><br />
        <asp:LinkButton ID="btnBack" OnClick="btnBack_Click" 
        runat="server" CausesValidation="False" 
        Text="<img style='v-align:bottom; margin-top:3px;Border-style:none;' src='Pics/back.png' alt='Back To Home Page'>"></asp:LinkButton>
         Back To Reference Tables Page        
          
    </div
    </form>
</body>
</html>

.cs file:
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 WorkStreamList : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        this.lblError.ForeColor = System.Drawing.Color.White;
        this.lblError.Text = "-";
        this.lblUserName.ForeColor = System.Drawing.Color.Black;
  
        String conn;
        String SQL;
        System.Data.SqlClient.SqlConnection Con = new System.Data.SqlClient.SqlConnection();
        System.Data.SqlClient.SqlCommand com = new System.Data.SqlClient.SqlCommand();
        System.Data.SqlClient.SqlDataReader RDR;
  
        String @strUserName = this.User.Identity.Name.ToString();
        String strWindowsUserName;
        int CountPos = strUserName.IndexOf(@"\");
  
        //hide edit options as default & enable for only Admin users
        this.MainSection.Visible = false;
  
  
        if (CountPos > 0)
        {
            strUserName = strUserName.Substring(CountPos, strUserName.Length - (CountPos));
            strWindowsUserName = strUserName.Substring(1, strUserName.Length - 1);
        }
        else
        {
            strWindowsUserName = "Error";
        }
  
        conn = System.Configuration.ConfigurationManager.ConnectionStrings["SavingsPlanDBConnectionString"].ConnectionString;
        Con.ConnectionString = conn;
        com.Connection = Con;
  
        SQL = "SELECT Permission From Users where username='" + strWindowsUserName + "'";
  
        com.CommandText = SQL;
        com.CommandType = System.Data.CommandType.Text;
        Con.Open();
  
        RDR = com.ExecuteReader();
  
        if (RDR.HasRows)
        {
            // Call Read before accessing data.
            while (RDR.Read())
            {
                if (RDR["permission"].ToString() == "Admin")
                {
                    this.MainSection.Visible = true;
                }
                else
                {
                    this.lblUserName.ForeColor = System.Drawing.Color.Red;
                    this.lblUserName.Text = "Error: You do not have the required permissions to access this page! Please contact the systems team for further info.";
                }
            }
        }
        else
        {
            this.lblUserName.ForeColor = System.Drawing.Color.Red;
            this.lblUserName.Text = "Error: You do not have the required permissions to access this page! Please contact the systems team for further info.";
        }
  
        RDR.Close();
        RDR = null;
        Con.Close();
        Con = null;    
  
    }
  
  
    protected void btnHome_Click(object sender, EventArgs e)
    {
        try
        {
            Response.Redirect("Default.aspx");
        }
        catch (Exception ex)
        {
            this.lblError.ForeColor = System.Drawing.Color.Red;
            this.lblError.Text = "Error: " + ex.Message.ToString() + " \n Error Source: " + ex.Source.ToString();
        }
    }
  
    protected void btnBack_Click(object sender, EventArgs e)
    {
        try
        {
            Response.Redirect("RefTable.aspx");
        }
        catch (Exception ex)
        {
            this.lblError.ForeColor = System.Drawing.Color.Red;
            this.lblError.Text = "Error: " + ex.Message.ToString() + " \n Error Source: " + ex.Source.ToString();
        }
    }
  
  
    protected void ValidateCurrency(object sender, ServerValidateEventArgs args)
    {
        try
        {
            string strCurrencyValue;
            strCurrencyValue = args.Value.ToString();
            //check to see if value entered is empty or null - if so then set to null to allow non-mandatory fields to update
            if (strCurrencyValue == "" || strCurrencyValue == null)
            {
                args.IsValid = true;
            }
            else
            {
                strCurrencyValue = strCurrencyValue.Replace("£", "").Replace(",", "").Replace("$", "");
                args.IsValid = Functions.IsNumeric(strCurrencyValue);
            }
  
        }
        catch (Exception ex)
        {
            this.lblError.ForeColor = System.Drawing.Color.Red;
            this.lblError.Text = "Error: " + ex.Message.ToString() + " \n Error Source: " + ex.Source.ToString();
        }
  
  
    }
  
  
  
    protected void RadGrid1_ItemUpdated(object source, Telerik.Web.UI.GridUpdatedEventArgs e)
    {
        try
        {       
         
            GridEditableItem item = (GridEditableItem)e.Item;
            String id = item.GetDataKeyValue("Id").ToString();
  
            if (e.Exception != null)
            {
                e.KeepInEditMode = true;
                e.ExceptionHandled = true;
                SetMessage("Record with Id " + id + " cannot be updated. Reason: " + e.Exception.Message);
            }
            else
            {
                SetMessage("Record with Id " + id + " is updated!");
            }
        }
        catch (Exception ex)
        {
            this.lblError.ForeColor = System.Drawing.Color.Red;
            this.lblError.Text = "Error: " + ex.Message.ToString() + " \n Error Source: " + ex.Source.ToString();
        }
    }
  
    protected void RadGrid1_ItemInserted(object source, GridInsertedEventArgs e)
    {
  
        try
        {
            if (e.Exception != null)
            {
                e.ExceptionHandled = true;
                SetMessage("Record cannot be inserted. Reason: " + e.Exception.Message);
            }
            else
            {
                SetMessage("New Record is inserted!");
            }
        }
        catch (Exception ex)
        {
            this.lblError.ForeColor = System.Drawing.Color.Red;
            this.lblError.Text = "Error: " + ex.Message.ToString() + " \n Error Source: " + ex.Source.ToString();
        }
    }
  
    protected void RadGrid1_ItemDeleted(object source, GridDeletedEventArgs e)
    {
        GridDataItem dataItem = (GridDataItem)e.Item;
        String id = dataItem.GetDataKeyValue("Id").ToString();
  
        try 
        {
  
            if (e.Exception != null)
            {
                e.ExceptionHandled = true;
                SetMessage("Record with Id " + id + " cannot be deleted. Reason: " + e.Exception.Message);
            }
            else
            {
                SetMessage("Record with Id " + id + " is deleted!");
            }
        }
        catch (Exception ex)
        {
            this.lblError.ForeColor = System.Drawing.Color.Red;
            this.lblError.Text = "Error: " + ex.Message.ToString() + " \n Error Source: " + ex.Source.ToString();
        }
    }
  
    private void DisplayMessage(string text)
    {
        RadGrid1.Controls.Add(new LiteralControl(string.Format("<span style='color:red'>{0}</span>", text)));
    }
  
    private void SetMessage(string message)
    {
        gridMessage = message;
    }
  
    private string gridMessage = null;
  
    protected void RadGrid1_DataBound(object sender, EventArgs e)
    {
        if (RadGrid1.MasterTableView.IsItemInserted)
        {
              
        }
  
        if (!string.IsNullOrEmpty(gridMessage))
        {
            DisplayMessage(gridMessage);
        }
    }
  
  
    protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
    {
        try 
        {
            if ((e.Item is GridEditFormItem) && (e.Item.IsInEditMode))
            {
                GridEditFormItem editform = (GridEditFormItem)e.Item;
                editform["BusinessCode"].Parent.Visible = false;
                editform["SortOrder"].Parent.Visible = false;
            }  
  
  
            if ((e.Item is GridEditFormInsertItem))
            {
                GridEditFormInsertItem item = (GridEditFormInsertItem)e.Item;
                RadNumericTextBox txt = (RadNumericTextBox)item.FindControl("tbTotalTarget");
                RadComboBox cmbBusinessUnit = (RadComboBox)item.FindControl("cmbBusinessUnit");
                cmbBusinessUnit.Items.Insert(0, new RadComboBoxItem(""));
                RadComboBox cmbDirectorate = (RadComboBox)item.FindControl("cmbDirectorate");
                cmbDirectorate.Items.Insert(0, new RadComboBoxItem(""));
  
                  
            }
            if ((e.Item.IsInEditMode) && (e.Item is GridEditFormItem) && (!(e.Item is GridEditFormInsertItem)))
            {
                GridEditFormItem item = (GridEditFormItem)e.Item;
                RadNumericTextBox txt = (RadNumericTextBox)item.FindControl("tbTotalTarget");
                RadComboBox ddl = (RadComboBox)item.FindControl("cmbBusinessUnit");
                //ddl.Items.Insert(0, new RadComboBoxItem(""));
            }
        }
        catch (Exception ex)
        {
            this.lblError.ForeColor = System.Drawing.Color.Red;
            this.lblError.Text = "Error: " + ex.Message.ToString() + " \n Error Source: " + ex.Source.ToString();
        }
  
  
    }
  
  
    protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e) 
    {
        if (e.CommandName == "InitInsert")
        {
  
        }
  
  
  
  
        if (e.CommandName == "PerformInsert" && e.Item is GridEditFormInsertItem)
        {
            GridEditFormInsertItem item = (GridEditFormInsertItem)e.Item;
            RadComboBox cmb = (RadComboBox)item.FindControl("cmbBusinessUnit");
            RadTextBox txtCode = (RadTextBox)item.FindControl("txtBusinessCode");
            RadTextBox txtSortOrder = (RadTextBox)item.FindControl("txtSortOrder");
                          
            switch (cmb.SelectedValue.ToLower().Substring(0, 7))
            {
                case "corpora":
                    txtCode.Text = "C";
                    txtSortOrder.Text = "7";
                    break;
                case "facilit":
                    txtCode.Text = "F";
                    txtSortOrder.Text = "6";
                    break;
                case "group 1":
                    txtCode.Text = "G1";
                    txtSortOrder.Text = "1";
                    break;
                case "group 2":
                    txtCode.Text = "G2";
                    txtSortOrder.Text = "2";
                    break;
                case "group 3":
                    txtCode.Text = "G3";
                    txtSortOrder.Text = "3";
                    break;
                case "group 4":
                    txtCode.Text = "G4";
                    txtSortOrder.Text = "4";
                    break;
                case "group 5":
                    txtCode.Text = "G5";
                    txtSortOrder.Text = "5";
                    break;
                default:
                    txtCode.Text = "EE";
                    txtSortOrder.Text = "0";
                    break;
            
  
        }
  
        if (e.CommandName == "Update" && e.Item is GridEditFormItem)
        {
  
            GridEditFormItem item = (GridEditFormItem)e.Item;
            RadComboBox cmb = (RadComboBox)item.FindControl("cmbBusinessUnit");
            RadTextBox txtCode = (RadTextBox)item.FindControl("txtBusinessCode");
            RadTextBox txtSortOrder = (RadTextBox)item.FindControl("txtSortOrder");
  
  
            switch (cmb.SelectedValue.ToLower().Substring(0, 7))
            {
                case "corpora":
                    txtCode.Text = "C";
                    txtSortOrder.Text = "7";
                    break;
                case "facilit":
                    txtCode.Text = "F";
                    txtSortOrder.Text = "6";
                    break;
                case "group 1":
                    txtCode.Text = "G1";
                    txtSortOrder.Text = "1";
                    break;
                case "group 2":
                    txtCode.Text = "G2";
                    txtSortOrder.Text = "2";
                    break;
                case "group 3":
                    txtCode.Text = "G3";
                    txtSortOrder.Text = "3";
                    break;
                case "group 4":
                    txtCode.Text = "G4";
                    txtSortOrder.Text = "4";
                    break;
                case "group 5":
                    txtCode.Text = "G5";
                    txtSortOrder.Text = "5";
                    break;
                default:
                    txtCode.Text = "EE";
                    txtSortOrder.Text = "0";
                    break;
            
        }
    }
}
Shuja
Top achievements
Rank 1
 answered on 24 Jan 2011
4 answers
117 views
We just purchased the asp.net ajax controls and I have a basic question, is there any examples of saving and loading rad dock state from a database?
Clark
Top achievements
Rank 1
 answered on 24 Jan 2011
3 answers
175 views
Can AnyOne Help me with the Skins. My application is garded by single Sign-On. If I apply SSo to my application the skins for the radcontrols ant applying. Please guid me in this.

Thanks
Pradeep
Top achievements
Rank 1
 answered on 24 Jan 2011
1 answer
86 views

Hi

When I create a webform and try to drag and drop on it RADWindow for instance then I don't find the RAD Controls in the toolbox. What am I missing?

Thanks

Regards

PS: Sorry for typos in title.

Svetlina Anati
Telerik team
 answered on 24 Jan 2011
1 answer
70 views
I have created a page that has a header area and beneath that is my Rad Splitter with 2 panes. I have tried the suggested way of having a div with a height of 100% and setting the splitter area to 100%. The problem is that the page is bigger than it should be. So, I messed with the splitter's offset, but sometimes it works and other times it expandes past the page horizontally and vertically. How do you suggest I setup my page so that I can have a header section then my splitter section? Thanks

Daniel
Svetlina Anati
Telerik team
 answered on 24 Jan 2011
2 answers
121 views
We are using RadCombobox,I need combo box in the ModalPopupExtender. But when I expand that combo which is in ModalPopupExtender,items are not visible on popup window. They appear in the backround as the main page is. On the pop up only dropdown is appearing,expanded items are at back of pop up window.
   Can you please tell me the solution to see the expand items of combo on the same pop up.
naveen NAVEEN
Top achievements
Rank 1
 answered on 24 Jan 2011
6 answers
155 views
Hi,

It seems that the checkboxes in a RadTreeView are not being styled, here is my markup from the page where I isolated the issue:

 

 <telerik:RadScriptManager ID="RadScriptManager1" runat="server">
</telerik:RadScriptManager>

<telerik:RadFormDecorator ID="RadFormDecorator1" runat="server"
DecoratedControls="All" Skin="Windows7" />

<telerik:RadTreeView ID="RadTreeView1" runat="server" CheckBoxes="True" Height="280px">
<Nodes>
<telerik:RadTreeNode Text="Software" Expanded="true">
<Nodes>
<telerik:RadTreeNode Text="Business &amp;amp; Office"/>
<telerik:RadTreeNode Text="Database" />
<telerik:RadTreeNode Text="Networking" />
<telerik:RadTreeNode Text="Presentation" />
<telerik:RadTreeNode Text="Project Management" />
<telerik:RadTreeNode Text="Reports" />
<telerik:RadTreeNode Text="Spreadsheet" />
<telerik:RadTreeNode Text="Word Processing" />
</Nodes>
</telerik:RadTreeNode>
<telerik:RadTreeNode Text="Books">
<Nodes>
<telerik:RadTreeNode Text="Arts" />
<telerik:RadTreeNode Text="Biographies" />
<telerik:RadTreeNode Text="Children's Books" />
<telerik:RadTreeNode Text="Computers &amp;amp; Internet" />
<telerik:RadTreeNode Text="Cooking" />
<telerik:RadTreeNode Text="History" />
<telerik:RadTreeNode Text="Fiction" />
<telerik:RadTreeNode Text="Mystery" />
<telerik:RadTreeNode Text="Nonfiction" />
<telerik:RadTreeNode Text="Romance" />
<telerik:RadTreeNode Text="Science Fiction " />
<telerik:RadTreeNode Text="Travel" />
</Nodes>
</telerik:RadTreeNode>
<telerik:RadTreeNode Text="Music">
<Nodes>
<telerik:RadTreeNode Text="Alternative" />
<telerik:RadTreeNode Text="Blues" />
<telerik:RadTreeNode Text="Children's Music" />
<telerik:RadTreeNode Text="Classical" />
<telerik:RadTreeNode Text="Country" />
<telerik:RadTreeNode Text="Dance" />
<telerik:RadTreeNode Text="Folk " />
<telerik:RadTreeNode Text="Hard Rock" />
<telerik:RadTreeNode Text="Jazz" />
<telerik:RadTreeNode Text="Soundtracks" />
</Nodes>
</telerik:RadTreeNode>
<telerik:RadTreeNode Text="Movies">
<Nodes>
<telerik:RadTreeNode Text="Action" />
<telerik:RadTreeNode Text="Animation" />
<telerik:RadTreeNode Text="Classics" />
<telerik:RadTreeNode Text="Comedy" />
<telerik:RadTreeNode Text="Documentary" />
<telerik:RadTreeNode Text="Drama" />
<telerik:RadTreeNode Text="Horror" />
<telerik:RadTreeNode Text="Musicals" />
<telerik:RadTreeNode Text="Mystery" />
<telerik:RadTreeNode Text="Westerns" />
</Nodes>
</telerik:RadTreeNode>
</Nodes>
</telerik:RadTreeView> 

 

Have I missed something or is it a known bug ?

Many Thanks,
Aash.

Igor
Top achievements
Rank 1
 answered on 24 Jan 2011
Narrow your results
Selected tags
Tags
+? more
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?