Questions on UI for ASP.NET AJAX Forum

1 answer

124 views

SqlDataSource Select Statement COUNT field incorrect

Hello
Here is my sqldatasource statement

    
             <asp:SqlDataSource id="SqlDSLegende" runat="server" 
        
                        connectionstring="<%$ ConnectionStrings:ConnectionString %>" 
        
                        providerName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
        
                        selectcommand="SELECT dbo_GPM_T_MAT_GRP.INTERV, Right([dbo_gpm_T_MAT_GRP.MAT],1) AS Expr3, dbo_GPM_T_MAT_GRP.GRP, dbo_GPM_T_MAT_GRP.ID_ECO, dbo_GPM_T_MSG_CODE.CAT_MSG_CODE, dbo_GPM_T_MSG_CODE.DESCR FROM (dbo_GPM_T_MAT_GRP INNER JOIN dbo_GPM_T_MAT ON (dbo_GPM_T_MAT_GRP.ID_ECO = dbo_GPM_T_MAT.ID_ECO) AND (dbo_GPM_T_MAT_GRP.MAT = dbo_GPM_T_MAT.MAT)) INNER JOIN dbo_GPM_T_MSG_CODE ON dbo_GPM_T_MAT_GRP.ID_ECO = dbo_GPM_T_MSG_CODE.ID_ECO GROUP BY Left([dbo_GPM_T_MAT_grp].[mat],3), dbo_GPM_T_MAT_GRP.INTERV, Right([dbo_gpm_T_MAT_GRP.MAT],1), dbo_GPM_T_MAT_GRP.GRP, dbo_GPM_T_MAT_GRP.ID_ECO, dbo_GPM_T_MSG_CODE.CAT_MSG_CODE, dbo_GPM_T_MSG_CODE.DESCR HAVING (((Left([dbo_GPM_T_MAT_grp].[mat],3))='tra') AND ((dbo_GPM_T_MAT_GRP.INTERV)=?) AND ((Right([dbo_gpm_T_MAT_GRP.MAT],1))='5') AND ((dbo_GPM_T_MAT_GRP.GRP)=?) AND ((dbo_GPM_T_MAT_GRP.ID_ECO)=?) AND ((dbo_GPM_T_MSG_CODE.CAT_MSG_CODE)='as5' Or (dbo_GPM_T_MSG_CODE.CAT_MSG_CODE)='fo5')) OR (((Left([dbo_GPM_T_MAT_grp].[mat],3))='tra') AND ((dbo_GPM_T_MAT_GRP.INTERV)=?) AND ((Right([dbo_gpm_T_MAT_GRP.MAT],1))='4') AND ((dbo_GPM_T_MAT_GRP.GRP)=?) AND ((dbo_GPM_T_MAT_GRP.ID_ECO)=?) AND ((dbo_GPM_T_MSG_CODE.CAT_MSG_CODE)='as4' Or (dbo_GPM_T_MSG_CODE.CAT_MSG_CODE)='fo4')) OR (((Left([dbo_GPM_T_MAT_grp].[mat],3))='tra') AND ((dbo_GPM_T_MAT_GRP.INTERV)=?) AND ((Right([dbo_gpm_T_MAT_GRP.MAT],1))='3') AND ((dbo_GPM_T_MAT_GRP.GRP)=?) AND ((dbo_GPM_T_MAT_GRP.ID_ECO)=?) AND ((dbo_GPM_T_MSG_CODE.CAT_MSG_CODE)='as3' Or (dbo_GPM_T_MSG_CODE.CAT_MSG_CODE)='fo3')) OR (((Left([dbo_GPM_T_MAT_grp].[mat],3))='tra') AND ((dbo_GPM_T_MAT_GRP.INTERV)=?) AND ((Right([dbo_gpm_T_MAT_GRP.MAT],1))='2') AND ((dbo_GPM_T_MAT_GRP.GRP)=?) AND ((dbo_GPM_T_MAT_GRP.ID_ECO)=?) AND ((dbo_GPM_T_MSG_CODE.CAT_MSG_CODE)='as2' Or (dbo_GPM_T_MSG_CODE.CAT_MSG_CODE)='fo2')) OR (((Left([dbo_GPM_T_MAT_grp].[mat],3))='tra') AND ((dbo_GPM_T_MAT_GRP.INTERV)=?) AND ((Right([dbo_gpm_T_MAT_GRP.MAT],1))='1') AND ((dbo_GPM_T_MAT_GRP.GRP)=?) AND ((dbo_GPM_T_MAT_GRP.ID_ECO)=?) AND ((dbo_GPM_T_MSG_CODE.CAT_MSG_CODE)='as1' Or (dbo_GPM_T_MSG_CODE.CAT_MSG_CODE)='fo1'))">  
        
                        <SelectParameters> 
        
                            <asp:Parameter Name="INTERV" Type="String" /> 
        
                            <asp:Parameter Name="GRP" Type="string" /> 
        
                            <asp:Parameter Name="ID_ECO" Type="int32" /> 
        
                        </SelectParameters> 
        
                    </asp:SqlDataSource>

It says to me that COUNT field incorrect.
So I put

    
             <asp:SqlDataSource id="SqlDSLegende" runat="server" 
        
                        connectionstring="<%$ ConnectionStrings:ConnectionString %>" 
        
                        providerName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
        
                        selectcommand="SELECT dbo_GPM_T_MAT_GRP.INTERV, Right([dbo_gpm_T_MAT_GRP.MAT],1) AS Expr3, dbo_GPM_T_MAT_GRP.GRP, dbo_GPM_T_MAT_GRP.ID_ECO, dbo_GPM_T_MSG_CODE.CAT_MSG_CODE, dbo_GPM_T_MSG_CODE.DESCR FROM (dbo_GPM_T_MAT_GRP INNER JOIN dbo_GPM_T_MAT ON (dbo_GPM_T_MAT_GRP.ID_ECO = dbo_GPM_T_MAT.ID_ECO) AND (dbo_GPM_T_MAT_GRP.MAT = dbo_GPM_T_MAT.MAT)) INNER JOIN dbo_GPM_T_MSG_CODE ON dbo_GPM_T_MAT_GRP.ID_ECO = dbo_GPM_T_MSG_CODE.ID_ECO GROUP BY Left([dbo_GPM_T_MAT_grp].[mat],3), dbo_GPM_T_MAT_GRP.INTERV, Right([dbo_gpm_T_MAT_GRP.MAT],1), dbo_GPM_T_MAT_GRP.GRP, dbo_GPM_T_MAT_GRP.ID_ECO, dbo_GPM_T_MSG_CODE.CAT_MSG_CODE, dbo_GPM_T_MSG_CODE.DESCR HAVING (((Left([dbo_GPM_T_MAT_grp].[mat],3))='tra') AND ((dbo_GPM_T_MAT_GRP.INTERV)=?) AND ((Right([dbo_gpm_T_MAT_GRP.MAT],1))='5') AND ((dbo_GPM_T_MAT_GRP.GRP)=?) AND ((dbo_GPM_T_MAT_GRP.ID_ECO)=?) AND ((dbo_GPM_T_MSG_CODE.CAT_MSG_CODE)='as5' Or (dbo_GPM_T_MSG_CODE.CAT_MSG_CODE)='fo5')) OR (((Left([dbo_GPM_T_MAT_grp].[mat],3))='tra') AND ((dbo_GPM_T_MAT_GRP.INTERV)=?) AND ((Right([dbo_gpm_T_MAT_GRP.MAT],1))='4') AND ((dbo_GPM_T_MAT_GRP.GRP)=?) AND ((dbo_GPM_T_MAT_GRP.ID_ECO)=?) AND ((dbo_GPM_T_MSG_CODE.CAT_MSG_CODE)='as4' Or (dbo_GPM_T_MSG_CODE.CAT_MSG_CODE)='fo4')) OR (((Left([dbo_GPM_T_MAT_grp].[mat],3))='tra') AND ((dbo_GPM_T_MAT_GRP.INTERV)=?) AND ((Right([dbo_gpm_T_MAT_GRP.MAT],1))='3') AND ((dbo_GPM_T_MAT_GRP.GRP)=?) AND ((dbo_GPM_T_MAT_GRP.ID_ECO)=?) AND ((dbo_GPM_T_MSG_CODE.CAT_MSG_CODE)='as3' Or (dbo_GPM_T_MSG_CODE.CAT_MSG_CODE)='fo3')) OR (((Left([dbo_GPM_T_MAT_grp].[mat],3))='tra') AND ((dbo_GPM_T_MAT_GRP.INTERV)=?) AND ((Right([dbo_gpm_T_MAT_GRP.MAT],1))='2') AND ((dbo_GPM_T_MAT_GRP.GRP)=?) AND ((dbo_GPM_T_MAT_GRP.ID_ECO)=?) AND ((dbo_GPM_T_MSG_CODE.CAT_MSG_CODE)='as2' Or (dbo_GPM_T_MSG_CODE.CAT_MSG_CODE)='fo2')) OR (((Left([dbo_GPM_T_MAT_grp].[mat],3))='tra') AND ((dbo_GPM_T_MAT_GRP.INTERV)=?) AND ((Right([dbo_gpm_T_MAT_GRP.MAT],1))='1') AND ((dbo_GPM_T_MAT_GRP.GRP)=?) AND ((dbo_GPM_T_MAT_GRP.ID_ECO)=?) AND ((dbo_GPM_T_MSG_CODE.CAT_MSG_CODE)='as1' Or (dbo_GPM_T_MSG_CODE.CAT_MSG_CODE)='fo1'))">  
        
                        <SelectParameters> 
        
                            <asp:Parameter Name="INTERV" Type="String" /> 
        
                            <asp:Parameter Name="GRP" Type="string" /> 
        
                            <asp:Parameter Name="ID_ECO" Type="int32" /> 
        
                            <asp:Parameter Name="INTERV" Type="String" /> 
        
                            <asp:Parameter Name="GRP" Type="string" /> 
        
                            <asp:Parameter Name="ID_ECO" Type="int32" /> 
        
                            <asp:Parameter Name="INTERV" Type="String" /> 
        
                            <asp:Parameter Name="GRP" Type="string" /> 
        
                            <asp:Parameter Name="ID_ECO" Type="int32" /> 
        
                            <asp:Parameter Name="INTERV" Type="String" /> 
        
                            <asp:Parameter Name="GRP" Type="string" /> 
        
                            <asp:Parameter Name="ID_ECO" Type="int32" /> 
        
                            <asp:Parameter Name="INTERV" Type="String" /> 
        
                            <asp:Parameter Name="GRP" Type="string" /> 
        
                            <asp:Parameter Name="ID_ECO" Type="int32" /> 
        
                        </SelectParameters> 
        
                    </asp:SqlDataSource>

Even if for me, that doesn't make sense...But the error is gone.
Unfortunatly, there is no record in my datagrid linked to this sqldatasource

In code behind I put that code

    
              Me.SqlDsLegende.SelectParameters("ID_ECO").DefaultValue = dsLogin.Tables(0).Rows(0).Item("ID_ECO")  
        
              Me.SqlDSLegende.SelectParameters("INTERV").DefaultValue = dsLogin.Tables(0).Rows(0).Item("NO_INTERV")  
        
              Me.SqlDSLegende.SelectParameters("GRP").DefaultValue = "01"

So, does somebody know how to handle many time the same parameter in the same statement??
Thank you very much

Grid

answered on 22 May 2009

4 answers

126 views

RadCalender Ajax Issue

Hi,

I have a web page which includes a asp:textbox and RadCalender. when asp:textbox autopostback property is true and after autopostback of page, radcalender loading takes too much time and browser gives "Do u want to stop running script, other wise browser may crash" message. My telerik version is "2008.1.515.35"

This link may help to see problem easily,

http://dev5.pagos.com/SpreadSheetWEB/Output.aspx?ApplicationId=a89e1927-7f99-4300-8ed3-205399c67dbc

Thanks for any replay.

Calendar

answered on 22 May 2009

4 answers

219 views

Initialize a TimePicker in MVC

Im trying to use a TimePicker in my MVC view but am having some difficulty in initializing the control to the value in my passed in model. I have tried doing this in a JQuery document.Ready as seen in the code below, but have been unsucessful as of yet.

                    <telerik:RadTimePicker ID="RadTimePicker1" runat="server" Width="160px"          
                                    BorderWidth="0px" >         
                             <ClientEvents OnPopupOpening="Initsd" />         
                             <TimeView StartTime="08:00:00"         
                               Interval="00:15:00"         
                               EndTime="18:00:00"         
                               Columns="4">         
                               </TimeView>         
                             </telerik:RadTimePicker>         

                    <script type="text/javascript">         
                     $(function() {         
                     var StartTimePicker = $find("<%= RadTimePicker1.ClientID %>");         
                         if (StartTimePicker) {         
                             alert("hit");         
                             StartTimePicker.set_selectedDate('<%= Model.StartTime %>');         
                         }         
                     });         
                </script>         

Anyone done this yet?

Calendar

answered on 22 May 2009

3 answers

203 views

RadMenu inside of RadSplitter

I'm trying to use them a RadMenu inside of a RadSplitter/RadPane and am having issues trying to get the content to fill into the correct pane -- can someone please lend a quick hand? I've attempted to adapt a sample and am programmatically populating a radmenu (called RadMenu2) with items and have set their respective targets so that when they click on the menu items they open in their respective window panes.

    
                    <div id="ParentDivElement" style="height: 100%; background-color: #000000;"> 
        
                        <telerik:RadSplitter ID="MainSplitter" runat="server" Height="100%" Width="100%" 
        
                            Orientation="Horizontal" Skin="Black" FullScreenMode="True"> 
        
                            <telerik:RadPane ID="TopPane" runat="server" Height="5" MinHeight="0" MaxHeight="5" 
        
                                Scrolling="none"> 
        
                                <!-- Place the content of the pane here --> 
        
                            </telerik:RadPane> 
        
                            <telerik:RadSplitBar ID="RadsplitbarTop" runat="server" CollapseMode="Forward" /> 
        
                            <telerik:RadPane ID="MainPane" runat="server" Scrolling="none" MinWidth="500"> 
        
                                <telerik:RadSplitter ID="NestedSplitter" runat="server" Skin="Black" LiveResize="false"> 
        
                                    <telerik:RadPane ID="LeftPane" runat="server" Width="200" MinWidth="150" MaxWidth="400"> 
        
                                        <!-- Place the content of the pane here --> 
        
                                         <telerik:RadMenu CollapseAnimation-Type="None" ID="RadMenu2"  runat="server" Width="100%"  
        
                            Flow="Vertical" Height="100px" OnClientItemClicked="clickHandler" BackColor="White" BorderStyle="None" Skin="Black" ForeColor="Black"  
        
                                            style="background-color: #000000"> 
        
                    <Items> 
        
                        <telerik:RadMenuItem Width="100%" id="lblLoginStatus" NavigateUrl="signout.aspx" runat="server"> 
        
                            <GroupSettings ExpandDirection="Right"></GroupSettings> 
        
                        </telerik:RadMenuItem> 
        
                    </Items> 
        
                        <CollapseAnimation Type="None" /> 
        
                </telerik:RadMenu> 
        
                                    </telerik:RadPane> 
        
                                    <telerik:RadSplitBar ID="VerticalSplitBar" runat="server" CollapseMode="Forward" /> 
        
                                    <telerik:RadPane ID="ContentPane" ContentUrl="home.aspx" runat="server"> 
        
                                        <!-- Place the content of the pane here --> 
        
                                    </telerik:RadPane> 
        
                                </telerik:RadSplitter> 
        
                            </telerik:RadPane> 
        
                        </telerik:RadSplitter></div>

I was hoping that this link would spawn inside of my client pane, but it doesn't seem to be working - it either spawns in the same window or spawns in a new window -- I'm assuming that it cannot find the ContentPane for some reason

    
                            Dim MenuItem3 As New RadMenuItem 
        
                            MenuItem3.Text = "Sign up/Register" 
        
                            MenuItem3.Value = "Sign up/Register" 
        
                            MenuItem3.NavigateUrl = "/register.aspx" 
        
                            MenuItem3.Target = ContentPane.ClientID 
        
                            MenuItem3.Width = "104"

Any ideas where I'm going wrong?TIA!

Splitter

answered on 22 May 2009

7 answers

234 views

Tooltip from RadToolTipManager behind ModalPopupExtender Panel

I have a ASP.Net page with a RadToolTipManager

Then I use a normal ASP.Net ModalPopupExtender that open a panel, but the tooltips for textboxes inside that panel, appear behind the modal window.

I do have a custom skin, so i can modify CSS - I played with the z-index, but no luck...

Thanks, Gert

ToolTip

answered on 22 May 2009

1 answer

110 views

[Solved] No postback when 2 items have same Text, even with different Value

Hi,

With the RadComboBox below:

<telerik:radcombobox id="TestCombobox" runat="server" AutoPostBack="true" >

<Items>

<telerik:RadComboBoxItem Text="One" Value="1" />

<telerik:RadComboBoxItem Text="two" Value="2" />

<telerik:RadComboBoxItem Text="Three" Value="3" />

<telerik:RadComboBoxItem Text="One" Value="4" />

</Items>

</telerik:radcombobox>

Click on the last item "One", a postback happen.

Then, click on the first item with Text also set to "One". No postback.

Is this a known issue?

Thanks

Frederic

ComboBox

answered on 22 May 2009

1 answer

132 views

encoding email addresses in encoded ASCII form

Hi is it possible to encode email address in an encoded ASCII form automatically within the editor (to help disguise from spam bots)?

Has anyone done this?

Cheers

Editor

answered on 22 May 2009

0 answers

121 views

Multiple Drag and Drop not working

Hi folks,
if i select two items in two rad tree view controls and drag and drop it to the Grid am getting only one item inserted in the grid view.
As it is clearly shown below.
http://demos.telerik.com/aspnet-ajax/treeview/examples/functionality/draganddropnodes/defaultcs.aspx
How we knw that that items dropped in that particular grid
Thanks
Regards
N.Balaji

TreeView

asked on 22 May 2009

1 answer

242 views

Adding Multiple Items Client Side

I'm trying to populate a RadComboBox on the client side with values from an array. Here's the markup I'm using for the control:

    
            <telerik:RadComboBox ID="cboSerialNumber" runat="server" />

The rest of the page doesn't matter. It's just in a simple HTML page. Here's the javascript code I'm using to add items:

    
                function InitDetails() 
        
                { 
        
                    var combo = $find("<%= cboSerialNumber.ClientID %>"); 
        
                    combo.get_items().clear(); 
        
                    for (i = 0; i < arrSerials.length; i++) 
        
                    { 
        
                        AddSerial(arrSerials[i]); 
        
                    } 
        
                } 
        
                function AddSerial(num) 
        
                { 
        
                    var combo = $find("<%= cboSerialNumber.ClientID %>"); 
        
                    var comboItem = new Telerik.Web.UI.RadComboBoxItem(); 
        
                    comboItem.set_text(num); 
        
                    combo.trackChanges(); 
        
                    combo.get_items().add(comboItem); 
        
                    comboItem.select(); 
        
                    combo.commitChanges();       
        
                }

arrSerials contains a list of serials that the user has input through a text box. Each are string values for the serial number.

And here's the issue. The second time through this loop, the AddSerial function throws an exception on the combo.get_items().add(comboItem); line

The error I'm seeing is: Object doesn't support this property or method.
Debugging halts on the bolded line in this function from Telerik:

_removeEmTags:function(text){
var _1b2=text.indexOf("<em>");
var _1b3=text.indexOf("</em>");
if(_1b2>=0&&_1b3>_1b2){
text=String.format("{0}{1}{2}",text.substr(0,_1b2),text.substr(_1b2+4,_1b3-_1b2-4),text.substr(_1b3+5));
}
return text;
}

Is there some other way I'm supposed to be adding a list of items to the combo box on the client side? Can anyone else reproduce this issue?

Thanks for your time,
Bren

ComboBox

answered on 22 May 2009

8 answers

180 views

IE6 select problems

Hi,
I'm trying to use this ComboBox in a public page that has to work on IE6, and having lots of problems.

It doesn't properly cover the SELECT element, even tough it is advertised that it does!
I'm using LoadOnDemand with Webservice and if the user types very quickly the SELECT elements under the drop down are still visible. Pressing backspace or pausing in typing corrects the problem. My observation is that the code (Javascript) that is trying to detect the height of the drop down div and placing iframe behind it is not working correctly, the iframe hight ends up been 15px - is there a method that I can call to correct this? I tryed calling showDropDown in OnClientItemsRequested, but it flickers...

Next, I have set ShowWhileLoading="False" and/or OpenDropDownOnLoad="false", but the drop down still shows.
I added this OnClientDropDownOpening="OnClientDropDownOpening" but the method never gets called.

Most important is that the documentation for Client-Side is at best basic. "The following table lists the most important methods of the client-side RadComboBox object:" - where is the rest?

ComboBox

answered on 22 May 2009