or
1 answer
160 views
Hello,
I have upgraded my application to latest telerik dll for Asp.net ajax (Q3 2010).
Since then there are issue in RadEditors Dialogs.
Css/Skin is not setting for the dialogs. It just sets to RadEditor.
I have copied new skins and images related to radeditor in my application.
Please help me if I am missing anything.
I am attaching few screenshots of the dialogs.
Thanks in advance.
I have upgraded my application to latest telerik dll for Asp.net ajax (Q3 2010).
Since then there are issue in RadEditors Dialogs.
Css/Skin is not setting for the dialogs. It just sets to RadEditor.
I have copied new skins and images related to radeditor in my application.
Please help me if I am missing anything.
I am attaching few screenshots of the dialogs.
Thanks in advance.
Rumen
Telerik team
answered
on
24 Jan 2011
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
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 ..
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 ..
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!
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
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"> <html xmlns="http://www.w3.org/1999/xhtml"> <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; } } } }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?
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
Thanks
Pradeep
Top achievements
Rank 1
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
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
Rank 1
answered
on
24 Jan 2011
