Questions on UI for ASP.NET AJAX Forum

4 answers

477 views

Programmatically add aggregate to a grid column

Hi

I guess the title says it all. Is it possible to programmatically add an aggregate to a grid column and programatically set the gridfooterformatstring?

thanks

Grid

answered on 18 Feb 2011

4 answers

154 views

Telerik RadGrid vs. Intersoft's WebGrid

Hi,

We are using Intersoft's WebGrid in our application and facing lots of problem related to performance. Specially grid rendering time is very high. I have been asked for testing radgrid and make presentation so that we can switch over RadGrid.

Can anyone explain me the logic behind RadGrid rendering and how it is faster than WebGrid, is there any unique feature available in radgrid that is not available in other grid.
Any diffrences between RadGrid and WebGrid would make my presentation impressive.

Plzzzzzzzz reply if you have anuy input related to this.

Regards
Devanand Jha

Grid

answered on 17 Feb 2011

0 answers

58 views

RadUpload Ajax callback error.

I am using the RadUpload and all is working fine from my machine. But when I copy the changes up to the web server I get the error in the attachment.

This is running on iis7

<httpHandlers>

<remove verb="*" path="*.asmx" />

<add path="Telerik.RadUploadProgressHandler.ashx" verb="*" type="Telerik.Web.UI.Upload.RadUploadProgressHandler, Telerik.Web.UI"/>

<add path="*.asmx" verb="*" type=

"System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"

validate="false"/>

<add path="*_AppService.axd" verb="*" type=

"System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"

validate="false"/>

<add verb="GET,HEAD" path="ScriptResource.axd" type=

"System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"

validate="false" />

<add path="Telerik.Web.UI.WebResource.axd" type="Telerik.Web.UI.WebResource" verb="*" validate="false" />

<add path="Telerik.RadUploadProgressHandler.ashx" verb="*" type="Telerik.Web.UI.Upload.RadUploadProgressHandler, Telerik.Web.UI"/>

</httpHandlers>

<httpModules>

<add name="ScriptModule" type=

"System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"

/>

<add name="RadUploadModule" type="Telerik.Web.UI.RadUploadHttpModule, Telerik.Web.UI"/>

<add name="ErrorLog" type="Elmah.ErrorLogModule, Elmah" />

<add name="ErrorMail" type="Elmah.ErrorMailModule, Elmah" />

<add name="ErrorFilter" type="Elmah.ErrorFilterModule, Elmah" /> >

</httpModules>

<system.webServer>

<validation validateIntegratedModeConfiguration="false" />

<modules>

<remove name="ScriptModule" />

<add name="ScriptModule" preCondition="managedHandler" type=

"System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"

/>

<add name="RadUploadModule" preCondition="integratedMode" type="Telerik.Web.UI.RadUploadHttpModule" />

</modules>

<handlers>

<remove name="WebServiceHandlerFactory-Integrated" />

<remove name="ScriptHandlerFactory" />

<remove name="ScriptHandlerFactoryAppServices" />

<remove name="ScriptResource" />

<add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" type=

"System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"

/>

<add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode" type=

"System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"

/>

<add name="ScriptResource" preCondition="integratedMode" verb="GET,HEAD" path="ScriptResource.axd" type=

"System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"

/>

<add name="Telerik_Web_UI_WebResource_axd" verb="*" preCondition="integratedMode" path="Telerik.Web.UI.WebResource.axd" type="Telerik.Web.UI.WebResource" />

</handlers>

I do have this working on another site on the webserver but it is using classic mode where this website is using Integrated mode.

Upload (Obsolete)

asked on 17 Feb 2011

4 answers

349 views

Grid Expand/Collapse not working

Hi,

I have created a grid based on the demo Grid Programmatic Binding but can not get the grid to expand or collapse. I added the following code to the pre-render event and the grid opens with the first item expanded and the data is displayed in the detail grid correctly. But, when I try to collapse the row it will not collapse and none of the other rows will expand.

Private

Sub rgvSecurityGroups_PreRender(ByVal sender As Object, ByVal e As System.EventArgs) Handles rgvSecurityGroups.PreRender
If Not Page.IsPostBack Then
rgvSecurityGroups.MasterTableView.Items(0).Expanded = True
End If
End Sub

Below is the code for my page. Thank you for your assistance.

Tracy

<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/IPSMaster.Master" CodeBehind="WBC SEC Security Groups.aspx.vb" Inherits="IPS_Gateway.WBC_SEC_Security_Groups" %>

<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="act" %>

<asp:Content ID="cntMain" ContentPlaceHolderID="cphMainContent" runat="server" >

<asp:SqlDataSource ID="SQLDS_SecurityGroups" runat="server" ConnectionString="<%$ ConnectionStrings:IPSDataConnectionString %>"

SelectCommandType="StoredProcedure" SelectCommand="[Security].[DSP_SecurityGroups-SEL-INS-UPD-DEL]">

<SelectParameters>

<asp:Parameter Name="strCommandType" Type="String" DefaultValue="Select" />

</SelectParameters>

</asp:SqlDataSource>

<asp:SqlDataSource ID="SQLDS_SecurityGroupUsers" runat="server" ConnectionString="<%$ ConnectionStrings:IPSDataConnectionString %>"

SelectCommandType="StoredProcedure" SelectCommand="[Security].[DSP_SecurityGroupUsers-Select]" >

</asp:SqlDataSource>

<asp:panel ID="pnlPage" runat="server" SkinId="skn_GPC01_Panel_MainContent">

<telerik:RadAjaxManager ID="RadAjaxManager2" runat="server">

<AjaxSettings>

<telerik:AjaxSetting AjaxControlID="rgvSecurityGroups">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="rgvSecurityGroups" LoadingPanelID="RadAjaxLoadingPanel1" />

<telerik:AjaxUpdatedControl ControlID="rwmMessageBox" />

<telerik:AjaxUpdatedControl ControlID="rwmSecuritySettings" />

</UpdatedControls>

</telerik:AjaxSetting>

</AjaxSettings>

</telerik:RadAjaxManager>

<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" BackgroundPosition="Center" ZIndex="150" >

<asp:Image ID="imgLoading" runat="server" ImageUrl='<%$Resources:Images, LoadingBlack %>' AlternateText="Loading" />

</telerik:RadAjaxLoadingPanel>

<asp:HiddenField ID="hdfSecurityId" runat="server" />

<asp:panel ID="pnlPageHeader" runat="server" cssClass="css_GPC01_Panel_PageHeading" >

<asp:Label ID="txtPageTitle" runat="server" CssClass="css_GPC01_Label_PageTitle" Text="Security Groups" />

<asp:ImageButton ID="ibtPageInformation" runat="server" SkinID="skn_GPC01_ImageButton_PageInformation" />

</asp:panel>

<asp:Panel ID="pnlPageContent" runat="server" CssClass="css_GPC01_Panel_PageContent" >

<telerik:RadGrid ID="rgvSecurityGroups" runat="server" DataSourceID="SQLDS_SecurityGroups"

EnableEmbeddedSkins = "true" Skin="Black"

AllowMultiRowSelection="false"

AllowAutomaticDeletes="True"

AllowAutomaticInserts="True"

AllowAutomaticUpdates="True"

AllowPaging="True"

EnableViewState ="true"

AutoGenerateColumns="False"

height="560px">

<PagerStyle AlwaysVisible="true" Mode="NextPrevAndNumeric" />

<ClientSettings AllowColumnsReorder="false" EnablePostBackOnRowClick="true"

AllowExpandCollapse="true" >

<Selecting AllowRowSelect="true" />

<Scrolling AllowScroll="true" UseStaticHeaders="true" />

</ClientSettings>

<MasterTableView DataSourceID="SQLDS_SecurityGroups" DataKeyNames="SecurityID"

EditMode="InPlace" CommandItemDisplay="Top" PageSize="30" >

<CommandItemTemplate >

<div style="padding: 5px 5px;">

<asp:LinkButton ID="lbtAdd" runat="server" CommandName="InitInsert" ToolTip ="Add New Group" Visible='<%# Not rgvSecurityGroups.MasterTableView.IsItemInserted %>'><asp:Image ID="imgAdd" runat="server" CssClass="css_GFS01_Image_Align" ImageURL="<%$ Resources:Images,AddRecord20%>" /> Add </asp:LinkButton>

<asp:LinkButton ID="IbtEdit" runat="server" CommandName="EditSelected" ToolTip ="Edit Group" Visible='<%# rgvSecurityGroups.EditIndexes.Count = 0 and Not rgvSecurityGroups.MasterTableView.IsItemInserted %>'> <asp:Image runat="server" CssClass="css_GFS01_Image_Align" ImageURL="<%$ Resources:Images, EditRecord20%>"/> Edit </asp:LinkButton>

<asp:LinkButton ID="IbtCancel" runat="server" CommandName="CancelAll" ToolTip ="Cancel Edit/Add" Visible='<%# rgvSecurityGroups.EditIndexes.Count > 0 Or rgvSecurityGroups.MasterTableView.IsItemInserted %>'><asp:Image ID="imgCancel" runat="server" CssClass="css_GFS01_Image_Align" ImageURL="<%$ Resources:Images,CancelRecord20%>" /> Cancel </asp:LinkButton>

<asp:LinkButton ID="lbtSaveNew" runat="server" CommandName="PerformInsert" ToolTip ="Save New Group" Visible='<%# rgvSecurityGroups.MasterTableView.IsItemInserted%>'><asp:Image ID="imgSaveNew" runat="server" CssClass="css_GFS01_Image_Align" ImageURL="<%$ Resources:Images,SaveRecord20%>" /> Save New</asp:LinkButton>

<asp:LinkButton ID="lbtDelete" runat="server" CommandName="DeleteSelected" ToolTip ="Delete Group" Visible='<%# rgvSecurityGroups.EditIndexes.Count = 0 and Not rgvSecurityGroups.MasterTableView.IsItemInserted %>'><asp:Image ID="imgDelete" runat="server" CssClass="css_GFS01_Image_Align" ImageURL="<%$ Resources:Images,DeleteRecord20%>" />Delete </asp:LinkButton>

<asp:LinkButton ID="lbtSave" runat="server" CommandName="UpdateEdited" ToolTip ="Save Changes" Visible='<%# rgvSecurityGroups.EditIndexes.Count > 0 or rgvSecurityGroups.MasterTableView.IsItemInserted%>'><asp:Image runat="server" CssClass="css_GFS01_Image_Align" ImageURL="<%$ Resources:Images,SaveRecord20%>" /> Update </asp:LinkButton>

<asp:LinkButton ID="ibtSettings" runat="server" CommandName="ShowSettings" ToolTip ="Edit/View Security Settings" Visible='<%# rgvSecurityGroups.EditIndexes.Count=0 AND Not rgvSecurityGroups.MasterTableView.IsItemInserted%>'><asp:Image ID="Image1" runat="server" CssClass="css_GFS01_Image_Align" ImageURL="<%$ Resources:Images,SecuritySettings20%>" /> Security Settings </asp:LinkButton>

<asp:LinkButton ID="lbtRefresh" runat="server" CommandName="RebindGrid" ><asp:Image id="imgRefresh" runat="server" CssClass="css_GFS01_Image_Align" ImageURL="<%$Resources:Images, ReloadBlue16 %>" AlternateText ="Refresh Grid" /></asp:LinkButton>

</div>

</CommandItemTemplate>

<Columns>

<telerik:GridBoundColumn DataField="SecurityId" UniqueName="SecurityID" HeaderText="Security Id" HeaderStyle-HorizontalAlign="Left" HeaderStyle-Width="80px" ItemStyle-HorizontalAlign="Center" DataType="System.Int32" ReadOnly="true" />

<telerik:GridBoundColumn DataField="SecurityGroup" UniqueName="SecurityGroup" HeaderText="Group" HeaderStyle-HorizontalAlign="Left" HeaderStyle-Width="200px" ColumnEditorID ="gtcEditor1"/>

<telerik:GridBoundColumn DataField="UserCount" UniqueName="UserCount" HeaderText="User Count" HeaderStyle-HorizontalAlign="Left" HeaderStyle-Width="80px" ItemStyle-HorizontalAlign="Center" DataType="System.Int32" ReadOnly="true" />

<telerik:GridBoundColumn DataField="CreatedBy" UniqueName="CreatedBy" HeaderText="Created By" HeaderStyle-HorizontalAlign="Left" HeaderStyle-Width="130px" ItemStyle-HorizontalAlign="Left" ReadOnly="true" />

<telerik:GridBoundColumn DataField="CreatedDate" UniqueName="CreatedDate" HeaderText="Created Date" HeaderStyle-HorizontalAlign="Center" HeaderStyle-Width="130px" ItemStyle-HorizontalAlign="Center" DataType="System.DateTime" DataFormatString="{0:MM/dd/yy h:mm:ss t}" ReadOnly="true" />

<telerik:GridBoundColumn DataField="UpdatedBy" UniqueName="UpdatedBy" HeaderText="Updated By" HeaderStyle-HorizontalAlign="Left" HeaderStyle-Width="130px" ItemStyle-HorizontalAlign="Left" ReadOnly="true" />

<telerik:GridBoundColumn DataField="UpdatedDate" UniqueName="UpdatedDate" HeaderText="Updated Date" HeaderStyle-HorizontalAlign="Center" HeaderStyle-Width="130px" ItemStyle-HorizontalAlign="Center" DataType="System.DateTime" DataFormatString="{0:MM/dd/yy h:mm:ss t}" ReadOnly="true" />

</Columns>

<DetailTables>

<telerik:GridTableView DataKeyNames="SecurityObject" >

<Columns>

<telerik:GridBoundColumn DataField="UserId" UniqueName="UserID" HeaderText="User Id" HeaderStyle-HorizontalAlign="Left" HeaderStyle-Width="50px" ItemStyle-HorizontalAlign="Center" ReadOnly="true" DataType="System.Int32" />

<telerik:GridBoundColumn DataField="UserName" UniqueName="UserName" HeaderText="User Name" HeaderStyle-HorizontalAlign="Left" HeaderStyle-Width="150px" />

<telerik:GridBoundColumn DataField="SecurityObject" UniqueName="SecurityObject" HeaderText="Security Object" HeaderStyle-HorizontalAlign="Left" HeaderStyle-Width="150px" DataType="System.Int32" />

<telerik:GridBoundColumn DataField="UserLoginId" UniqueName="UserLoginId" HeaderText="Login Id" HeaderStyle-HorizontalAlign="Left" HeaderStyle-Width="150px" />

<telerik:GridBoundColumn DataField="UserStatus" UniqueName="UserStatus" HeaderText="Status" />

<telerik:GridBoundColumn DataField="EmployeeStatus" UniqueName="EmployeeStatus" HeaderText="Employee Status" />

</Columns>

</telerik:GridTableView>

</DetailTables>

</MasterTableView>

</telerik:RadGrid>

<telerik:GridTextBoxColumnEditor ID="gtcEditor1" runat="server" TextBoxStyle-Width="200px" />

<telerik:RadWindowManager ID="rwmMessageBox" runat="server" Behaviors="Close, Move" EnableViewState ="false" Animation="Slide" AnimationDuration="5" Height="400" Width = "400" VisibleOnPageLoad ="true" DestroyOnClose="true" Modal="true" EnableEmbeddedSkins="true" Skin="Black" />

<telerik:RadWindowManager ID="rwmSecuritySettings" runat="server" Behaviors="Close, Move" EnableViewState ="false" Animation="Slide" AnimationDuration="5" Height="700" Width = "835" VisibleOnPageLoad ="true" DestroyOnClose="true" Modal="true" Style="z-index:3000" />

<br />

</asp:Panel>

</asp:panel>

<asp:Panel ID="pnlFooter" runat="server" CssClass="css_GPC01_Panel_Footer">

<asp:Label ID="lblObjectId" runat="server" CssClass="css_GPC01_Label_Tiny" />

</asp:Panel>

</asp:Content>

Private Sub rgvSecurityGroups_DetailTableDataBind(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridDetailTableDataBindEventArgs) Handles rgvSecurityGroups.DetailTableDataBind

Dim SelectedRow As GridDataItem = CType(e.DetailTableView.ParentItem, GridDataItem)

Dim intSecurityObject As Int32 = SelectedRow.GetDataKeyValue("SecurityID")

SQLDS_SecurityGroupUsers.SelectParameters.Clear()

SQLDS_SecurityGroupUsers.SelectParameters.Add("intObjectId", Convert.ToInt32(intSecurityObject))

e.DetailTableView.DataSourceID = "SQLDS_SecurityGroupUsers"

End Sub

Grid

answered on 17 Feb 2011

7 answers

135 views

Excel Export puts data into 2 rows when it should be 1

Hi, we have a large dataset of nearly 200 columns by 250 rows. On screen, the grid presentation is normal with a row-per-record as it should be. However, when exported to Excel and opened in Excel 2008, each record shows in two rows with one row being blank. This results in a row count that is 2x what it should be.

When selecting an individual data item in the resulting excel file, two cells are selected.

The data does not appear to be grouped, at least as far as Excel is concerned.

We have attempted a variety of 'tricks' in Excel to remove the extra rows, but none are perfect and some result in lost data.

Is the issue (2 rows in excel) known and if so, how can we resolve this so that ideally, the excel file appears as it does on screen? We are using .net 2 framework and telerik 2010 Q1 (2010.1.309.20) for this application. Thanks.

Grid

answered on 17 Feb 2011

9 answers

140 views

Validate 2 checkboxes in hierarchical detail grid

I have a hierarchy grid with master and detail grid. I need to be able to insert and update the detail grid. There are 2 checkboxes that if one is checked then the other one should not be checked. How do I validate or make this happen? Please help.
Thanks!

Grid

answered on 17 Feb 2011

0 answers

62 views

RadGrid and Rebinding

EDITED: Nevermind. Programmer error.

Grid

asked on 17 Feb 2011

3 answers

115 views

Deployment error

I just deployed my web app and I am getting javascript errors, when I run it in VS .NET 2010 and on my local machine's IIS it's fine but when I deploy it to our test server I get this error.

"Webpage error details

Message: 'Sys' is undefined
Line: 79
Char: 1
Code: 0

Message: 'Sys' is undefined
Line: 201
Char: 1
Code: 0

"

the offending line is:

<script type="text/javascript">

//<![CDATA[

Sys.WebForms.PageRequestManager._initialize('RadScriptManager1', 'form1', ['trgSpeakersPanel','','trgSponsorsPanel','','tRadAjaxManager1SU',''], [], [], 90, '');

//]]>

</script>

I have searched this topic with no fixes working yet I do know there are legacy apps running on this that use an older version of Telerik controls. I am using VS.NET 2010 and .net framework 4.0.

Thanks

Grid

answered on 17 Feb 2011

3 answers

266 views

Grid - data binding to hierarchical data set

Hi all,

I'd like to display a hierarchical grid - Master/Detail (or parent/child if you will). I've created a dataset that contains the parent and child records. My dataset only returns columns I want to display...in other words, I don't want to "hard-code" columns in the HTML markup or in the code behind. I also DON"T want to use any object datasource controls (ie: SQLDataSourceControl). Simply, I want to bind and display whatever data is in the dataset directly to the grid control.

Can you please provide me with the grid HTML and code that will allow me to bind this dataset to a grid?

        public static DataSet GetHierarchicalDataSet()
        {
                DataTable parentTable = GetParentData(); //retrieves parent data from database
                parentTable.TableName = "Parent";
                DataTable childTable = GetChildData(); //retrieves child data from database
                childTable.TableName = "Child"

                DataSet ds = new DataSet();
                ds.Tables.Add(parentTable.Copy());
                ds.Tables.Add(childTable.Copy());

                DataColumn parentColumn = ds.Tables["Parent"].Columns["ParentID"];
                DataColumn childColumn = ds.Tables["Child"].Columns["ParentID"];
                DataRelation relationship = new DataRelation("ParentChild", parentColumn, childColumn);
                ds.Relations.Add(relationship);

                return ds;
        }

Grid

answered on 17 Feb 2011

5 answers

140 views

Tab header not being selected

I have a tabstrip control with 5 tabs and one multiview.

When I execute the client side js to enable and select a specific tab, the view gets selected fine, but the tab header doesn't get selected. During debugging, I have verified that the text coming back is "Sec Ins". I have also verified by the attachment, that before the "tab.enable()" was hit the "enabled" property was "false". After passing that code to enable the tab, you can see it says it's "enabled". Another attachment is how the screen looks after the js funtion is completed as I have explained above. I have also tried the findTabByValue method getting the same results.

How can I enable & select the tab header to correspond to the selected view?

Here is my html: Notice the bolding...
<code>
<telerik:RadTabStrip ID="tsPatientDemographics" runat="server" AutoPostBack="false"
                                                                                    ScrollButtonsPosition="Right" MultiPageID="RadMultiPage1" BackColor="Gray" CausesValidation="False"
                                                                                    Align="Left" Width="100%">
                                                                                    <Tabs>
                                                                                        <telerik:RadTab Text="P<u>a</u>tient" AccessKey="A" Width="60px">
                                                                                        </telerik:RadTab>
                                                                                        <telerik:RadTab Text="G<u>u</u>arantor" AccessKey="U" Width="80px">
                                                                                        </telerik:RadTab>
                                                                                        <telerik:RadTab Text="<u>P</u>ri Ins" AccessKey="P" Width="60px">
                                                                                        </telerik:RadTab>
                                                                                        <telerik:RadTab Text="<u>S</u>ec Ins" AccessKey="S" Value="Sec Ins" Width="60px"
                                                                                            Enabled="false">
                                                                                        </telerik:RadTab>
                                                                                        <telerik:RadTab Text="<u>T</u>er Ins" AccessKey="T" Value="Ter Ins" Width="70px"
                                                                                            Enabled="false">
                                                                                        </telerik:RadTab>
                                                                                    </Tabs>
                                                                                </telerik:RadTabStrip>
                                                                                <telerik:RadMultiPage ID="RadMultiPage1" runat="server" SelectedIndex="0" ScrollBars="None">
                                                                                    <telerik:RadPageView ID="RadPatientInfoView" runat="server" Width="100%" BackColor="LightGray">
                                                                                        <table width="100%" bgcolor="#F6F6F6" cellpadding="0" cellspacing="0">

</code>

Here is my js:
<code>
function selectSecTab() {
                var tabStrip = $find("<%= tsPatientDemographics.ClientID %>");
                var tab = tabStrip.findTabByText("Sec Ins");
                tab.enable();
                tab.select();

            }

</code>

TabStrip

answered on 17 Feb 2011