Questions on UI for ASP.NET AJAX Forum

6 answers

79 views

keeping the format of rows in export to excel of hierachical Grid

Hi,
I'm exporting hierarchical grid to Excel.
The problem is that while exporting the grid it's loosing the formatting of the Cells like Background color which i have set in

ItemDataBound event depending upon some condition.But in export to excel its not get persited.
Is there any way to achive this?

.

Thanks.

Grid

answered on 21 Aug 2012

2 answers

135 views

GridNumericColumn error alert

Team,

I wanted to show alert message "Enter only numbers" on error event of GridNumericColumn.
I have implemented it in RadNumericTextBox by 'ClientEvents.OnError = "numericerror"' property.
I wanted to to show same error message on GridNumericColumn data entry.
Please let me know How I can implement it ASAP.

Thanks in advance

Regards,
Sampada

Grid

answered on 21 Aug 2012

3 answers

172 views

Grid Item Command detect wrong row after client side hits

Hi,
I have a radgrid with 3 gridButtonColumn , I added Client side ItemCommand for one command column but when i click on another commands inside of server side item command it detect FIRST row as data grid Item .
e.g
in server side itemcommand i have e.Item as GridDataItem and i get item.getDataKeyValue but it constantly returns first row key values. when I remove client side item command every thing will be OK.

is this for client side bug or there is some trick?

Regards,
Morteza

Grid

answered on 21 Aug 2012

11 answers

620 views

Telerik FormView?

Is there an equivalent asp:FormView control in the Telerik tool box?
I need a FormView type control to show detail data but also want to carry across the same skin as the rest of the Telerik controls.

Thanks
Andrew

General Discussions

answered on 21 Aug 2012

1 answer

37 views

View State Error In Grids Having Column style as Drop Down

We are facing problem of View state error in the grid with dropdown column type (Please refer the attached image).
Strangely this is happening only to those grids have dropdown columns other this is working perfectly alright.

Actions permitted in our grid:-
1. It is mutli row edit grid.
2. First colum is an check box type(Which indicates that the row in edit mode or not) and some of the other columns are combo box
3. While checking the check box the row should go to editable mode
4. While unchecking check box the row status should change to non edit mode
5. While Unchecking the check box in last editable row,Row should not change the status in to a nondeitable mode

While performing the 5th action we are face ViewState error.

Looking forwarded to solution for the this.

Grid

answered on 21 Aug 2012

2 answers

72 views

modify radScheduler appointment's layout appearance

Requirements
RadControls version 2012 q2
.NET version 4
Visual Studio version 2010
programming language c#
browsers	supported by RadControls

PROJECT DESCRIPTION
How would you change the first code of the example (http://demos.telerik.com/aspnet-ajax/scheduler/examples/outlook2007/defaultcs.aspx) to behave in such a way that when appointments have same time they are stacked and somewhat hidden behind each other instead of beside each other, with a small portion of the other same time appointments on the same block showing an edge to indicate there are multiple appointments on the same block and you could click the appointment to rotate to view the next hidden one? So they would appear stacked in some way and only one would be fully visible at a time, yet you could do a single click to move that one to the back and rotate the visible one to the back and bring another forward?

Scheduler

answered on 21 Aug 2012

1 answer

77 views

Problem loading the Hierarchical Grid

Hi,

We are using the hierarchical functionality of the Telerik grid and we have hierarchy upto four level and the total records for all this levels comes upto around 1300 records and we are not applying any paging and when we try to run the page, it takes around 55 seconds to load the page and the html page size comes to around 4.5 MB.

we applied the compression technique as well but still the page was taking around 45 seconds to load with the viewstate which is required for the Hierarchical grid and also the loading time of the page is unacceptable to the Client.

We are attaching the source code. Please look into it and let us know if there is any optimization possible to speed up the execution time of the page.

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="RelationGrid.aspx.cs" Inherits="RelationGrid"

Debug="true" %>

<%@ 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></title>

</head>

<body>

<form id="form1" runat="server">

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

<div>

<% Response.Write(DateTime.Now.ToString()); %>

<telerik:RadGrid ID="RadGrid1" OnPreRender="RadGrid1_PreRender" runat="server" ShowStatusBar="true"

DataSourceID="SqlDataSource1" AutoGenerateColumns="False" AllowSorting="True"

AllowMultiRowSelection="False" GridLines="None" EnableViewState="true" >

<PagerStyle Mode="NumericPages"></PagerStyle>

<MasterTableView DataSourceID="SqlDataSource1" DataKeyNames="nGroupID" AllowMultiColumnSorting="True"

HierarchyDefaultExpanded="true" >

<DetailTables>

<telerik:GridTableView DataKeyNames="nSubGroupID" DataSourceID="SqlDataSource2" Width="100%"

runat="server" HierarchyDefaultExpanded="true" EnableViewState="true" >

<ParentTableRelation>

<telerik:GridRelationFields DetailKeyField="nGroupID" MasterKeyField="nGroupID" />

</ParentTableRelation>

<DetailTables>

<telerik:GridTableView DataKeyNames="QuoteSubID" DataSourceID="SqlDataSource3"

Width="100%"

runat="server" HierarchyDefaultExpanded="true" EnableViewState="true">

<ParentTableRelation>

<telerik:GridRelationFields DetailKeyField="nSubGroupID"

MasterKeyField="nSubGroupID" />

</ParentTableRelation>

<DetailTables>

<telerik:GridTableView DataKeyNames="CatId" DataSourceID="SqlDataSource4"

Width="100%"

runat="server" HierarchyDefaultExpanded="true" EnableViewState="true" >

<ParentTableRelation>

<telerik:GridRelationFields DetailKeyField="QuoteSubID"

MasterKeyField="QuoteSubID" />

</ParentTableRelation>

<Columns>

<telerik:GridBoundColumn HeaderText="KIT ITEM" DataField="CDescription"

UniqueName="CDescription">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn HeaderText="Quantity" DataField="quotekitqty"

UniqueName="quotekitqty">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn HeaderText="Type" DataField="cattype"

UniqueName="cattype">

</telerik:GridBoundColumn>

</Columns>

</telerik:GridTableView>

</DetailTables>

<Columns>

<telerik:GridBoundColumn HeaderText="QuoteSubID" DataField="QuoteSubID"

UniqueName="QuoteSubID">

</telerik:GridBoundColumn>

<telerik:GridCheckBoxColumn HeaderText="K" DataField="CatPrint"

UniqueName="CatPrint">

<HeaderStyle Font-Bold="true" />

</telerik:GridCheckBoxColumn>

<telerik:GridCheckBoxColumn HeaderText="B" DataField="QuoteHeading"

UniqueName="QuoteHeading">

<HeaderStyle Font-Bold="true" />

</telerik:GridCheckBoxColumn>

<telerik:GridCheckBoxColumn HeaderText="I" DataField="nItalic"

UniqueName="nItalic">

<HeaderStyle Font-Bold="true" Font-Italic="true" />

</telerik:GridCheckBoxColumn>

<telerik:GridBoundColumn HeaderText="Use Quantity" DataField="Quantity"

UniqueName="Quantity">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn HeaderText="Bill Quantity" DataField="BillQuantity"

UniqueName="Quantity">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn HeaderText="Period" DataField="Period"

UniqueName="Period">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn HeaderText="CDescription" DataField="CDescription"

UniqueName="CDescription">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn HeaderText="Note" DataField="QuoteDescription"

UniqueName="QuoteDescription">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn HeaderText="Reg Rate" DataField="SuggestedRate"

UniqueName="SuggestedRate">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn HeaderText="Disc%" DataField="DiscountPercent"

UniqueName="DiscountPercent">

<HeaderStyle ForeColor="AliceBlue" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn HeaderText="Disc Rate" DataField="DiscountRate"

UniqueName="DiscountRate">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn HeaderText="Line Total" DataField="Sum"

UniqueName="Sum">

</telerik:GridBoundColumn>

</Columns>

</telerik:GridTableView>

</DetailTables>

<Columns>

<%--<telerik:GridBoundColumn HeaderText="SubGroupID" DataField="nSubGroupID"

UniqueName="nSubGroupID">

<HeaderStyle BackColor="Gray" ForeColor="Red" />

</telerik:GridBoundColumn>--%>

<telerik:GridBoundColumn HeaderText="SubGroup Name" DataField="tSubGroupName"

UniqueName="tSubGroupName">

<ItemStyle BackColor="Gray" ForeColor="Red" />

</telerik:GridBoundColumn>

</Columns>

</telerik:GridTableView>

</DetailTables>

<Columns>

<%--<telerik:GridBoundColumn HeaderText="GroupID" DataField="nGroupID" UniqueName="nGroupID">

<HeaderStyle BackColor="Gray" ForeColor="Red" />

</telerik:GridBoundColumn>--%>

<telerik:GridBoundColumn HeaderText="GroupName" DataField="tGroupName" UniqueName="tGroupName">

<ItemStyle BackColor="Gray" ForeColor="Red" />

</telerik:GridBoundColumn>

</Columns>

</MasterTableView>

</telerik:RadGrid>

<asp:SqlDataSource ID="SqlDataSource1" runat="server" SelectCommand="select * from GroupMaster with(noLock)

where tQuoteID =43617 ORDER BY (CASE WHEN tgroupname = '[EXTRAS]' THEN 99991 ELSE (case when

tgroupname='[ADJUSTMENTS]' then 99992 ELSE (case WHEN tgroupname='[INTERNAL USE ONLY]' THEN 99993 ELSE

tGroupLineNumber END) END) END ) "

ConnectionString="<%$ ConnectionStrings:DatasetConnString %>"></asp:SqlDataSource>

<asp:SqlDataSource ID="SqlDataSource2" ConnectionString="<%$ ConnectionStrings:DatasetConnString %>"

ProviderName="System.Data.SqlClient" SelectCommand="select * from subgroupmaster with(noLock) where

ngroupid=@nGroupID order by tsubgrouplinenumber"

runat="server">

<SelectParameters>

<asp:SessionParameter Name="nGroupID" SessionField="nGroupID" Type="string" />

</SelectParameters>

</asp:SqlDataSource>

<asp:SqlDataSource ID="SqlDataSource3" ConnectionString="<%$ ConnectionStrings:DatasetConnString %>"

ProviderName="System.Data.SqlClient" SelectCommand="SELECT

dbo.tblQuoteSub.QuoteSubSync,

dbo.tblQuoteSub.QuoteSubID,

dbo.tblQuoteSub.QuoteId,

dbo.tblQuoteSub.nSubGroupID,

dbo.tblQuoteSub.nGroupID,

dbo.tblQuoteSub.CatPrint,

dbo.tblCat.CatType,

dbo.tblQuoteSub.LineNumber,

dbo.tblQuoteSub.QuoteHeading,

dbo.tblQuoteSub.nItalic,

dbo.tblQuoteSub.Quantity,

dbo.tblQuoteSub.BillQuantity,

dbo.tblQuoteSub.Period,

dbo.tblQuoteSub.CategoryID,

dbo.tblCat.CDescription,

dbo.tblQuoteSub.QuoteDescription,

dbo.tblQuoteSub.SuggestedRate,

dbo.tblQuoteSub.DiscountPercent,

dbo.tblQuoteSub.DiscountRate,

(dbo.tblQuoteSub.SuggestedRate * dbo.tblQuoteSub.Period * dbo.tblQuoteSub.BillQuantity)

* (1 - CAST(dbo.tblQuoteSub.DiscountPercent AS float) / 100) AS [Sum],

dbo.tblQuoteSub.QuoteKitParentId,

dbo.tblQuoteSub.EquipTotal,

dbo.tblQuoteSub.EquipAvailable,

dbo.tblQuoteSub.Equip_NonConfirmed,

dbo.tblQuoteSub.CompanyWideEquipAvailable,

dbo.tblQuoteSub.QuoteSubParentId,

dbo.tblQuoteSub.QuoteCancelParentId,

dbo.tblQuoteSub.QuoteCancelChildId,

dbo.tblQuoteSub.QuoteSubstituteParentId,

dbo.tblQuoteSub.QuoteFloatParentId,

dbo.tblQuoteSub.QuoteSFRParentId,

dbo.tblQuoteSub.QuoteSFRChildId, dbo.tblQuoteSub.QuoteSubEnteredBy, dbo.tblQuoteSub.QuoteSubEnteredDate,

dbo.tblQuoteSub.QuoteSubLastModifiedBy, dbo.tblQuoteSub.QuoteSubLastModifiedDate,

dbo.tblQuoteSub.QuoteHeaderFooterId

FROM

dbo.tblQuoteSub with(noLock) INNER JOIN

dbo.tblCat with(noLock) ON dbo.tblQuoteSub.CategoryID = dbo.tblCat.CatId INNER JOIN

dbo.SubGroupMaster with(noLock) ON dbo.tblQuoteSub.nSubGroupID =

dbo.SubGroupMaster.nSubGroupID INNER JOIN

dbo.GroupMaster with(noLock) ON dbo.SubGroupMaster.nGroupID = dbo.GroupMaster.nGroupID

where tblquotesub.quoteid=43617 and tblquotesub.nsubgroupid=@nSubGroupID and (quotekitparentid = 0 OR

QuoteKitParentID IS NULL)

ORDER BY dbo.tblQuoteSub.LineNumber" runat="server">

<SelectParameters>

<asp:SessionParameter Name="nSubGroupID" SessionField="nSubGroupID" Type="Int32" />

</SelectParameters>

</asp:SqlDataSource>

<asp:SqlDataSource ID="SqlDataSource4" ConnectionString="<%$ ConnectionStrings:DatasetConnString %>"

ProviderName="System.Data.SqlClient" SelectCommand="SELECT tblcat.cattype,tblCat.CDescription,

tblCat.CatId, quotekitqty, tblquotesub.quotecatkitautoid, QuoteSubID,Quantity,BillQuantity ,

QuoteKitQty,QuoteKitParentId FROM tblQuoteSub with(noLock) INNER JOIN tblCat with(noLock) ON

tblQuoteSub.CategoryID = tblCat.CatId where QuoteKitParentId=@QuoteSubID ORDER BY linenumber" runat="server">

<SelectParameters>

<asp:SessionParameter Name="QuoteSubID" SessionField="QuoteSubID" Type="Int32" />

</SelectParameters>

</asp:SqlDataSource>

<% Response.Write(DateTime.Now.ToString()); %>

</div>

</form>

</body>

</html>

Regards,
Hitesh

Grid

answered on 21 Aug 2012

3 answers

135 views

Two combo boxes and SelectedIndexChanged

Hello,
How to implement two combo boxes one with Customer ID and second with Visible Customer name (as value as well ID) with following functionality:

1. If one is chosen information about customer are displayed
2. If after choosing one someone clicked second one, first one should return do starting state (nothing chosen) and customer should be displayed based on clicked combo box etc.

ComboBox

answered on 21 Aug 2012

1 answer

136 views

Captcha Image Fails to Render on a load balanced

Hi,

I read that in a load balancing network, the session needs to be out of process
http://www.telerik.com/help/aspnet-ajax/captcha-webfarm-and-webgarden.html

I have a project converting objects to serialize will be a big job.

Is there any other alternative to make this work.
I mean any solution that uses "Inproc" session to work with load balancing

regards
Aslam

Captcha

answered on 21 Aug 2012

2 answers

81 views

Disabled multi-line RadTextBox problem

Hi,

I'm using a multi-line disabled RadTextBox and I've found out that when you click on it, it fires the client-event "OnValueChanged".
It happens only with that scenario:

txtBox.TextMode = TextBoxMode.MultiLine

txtBox.Enabled = False

Is that a known issue? If yes, is there any workaround available?

Christian.

Input

answered on 21 Aug 2012