Hi,

I consider myself as newbie in Telerik. I am trying to bind RADHtmlChart to SQLDatasource and it works in other project except this specific one. Hope someone can point out the issue. If I load the same data in ASP Datagrid I can see it on my page. However both RadGrid and RadHTMLChart doesn't work. One more thing, the normal RadChart works fine with same data source.

ASPX Code
SQL DataSource

Hi All ,

I am using batch editing in radgrid. Its working fine for delete and insert but when I try to update it takes the previous values of the respective cells.
Can anyone please help me find out what exactly I am missing.

FYI : I am exactly replicating batch editing demo from below link
http://demos.telerik.com/aspnet-ajax/grid/examples/data-editing/batch-editing/defaultcs.aspx

Thanks & Regards ,
Anurag

Hi,
i am using radcombobox and applying css to  it. it will get font but on item hover it will go back to original font for that single item.i want all in same font.

<telerik:RadComboBox ID="ComboFY" runat="server"  EmptyMessage="Please "  CssClass="rcbItem"></telerik:RadComboBox>

 .rcbItem, . rcbItem . rcbFocused, . rcbItem . rcbHovered
    {
        font-family: Verdana !important;
        font-size:12px;
    }

Hi Masters

I use the radmenu  with property Flow equal vertical inside the follow structure

 <tr style="height:28%;width:100%;vertical-align:top"> 
                            <td >
                                 <uc:UCMenu ID="UCMenu1" runat="server" Orientation="Vertical" />   <%--  inside rad menu--%>
                            </td>
  </tr>

but when change of resolution the radmenu  it gets some size or when use witdh = 100% grows much....

I need your guidance and help.

thanks & regars

Hello Scheduler experts.   I have attached an image that shows what I am trying to achieve with the scheduler.   First off,  is this even possible?  Secondly,  if it is possible do you have any suggestions on how to go about implementing such a view?  I basically want one row of slots that are 100% height and be able to show the entire month, grouped by week.   I will have to use the multi-day view to pull this off as far as I can tell...but as far as the groupings and only having one row for the slots I'm not sure how to go about implementing this.    By the way,  the appointments need to line up with the grid on the left...but I should be able to do some sorting to make that happen. 

Open to any suggestions.

Thanks.

Is there a way to reverse the order from largest-to-smallest TreeMapItems to smallest-to-largest TreeMapItems? Right now it always sorts the TreeMapItems with the largest relative size (value) to the upper left regardless of sorting algorithm. I've been asked if that can be reversed...

Hi

I'm not able to use the built in forms on the scheduler, what I have instead is a modal pop up, that I use to add / edit appointments. This works well.

What is missing is the ability to select a date / time range from the scheduler and have these populate the form. Is it possible to capture these data and send to the JS routine that opens the modal pop up?

Andy

Hi,

I am using the RadGrid and am inserting an image into a GridBoundColumn using the ItemDataBound event, this all works fine. However when I click on a column to sort all the text columns are sorted correctly but the images do not move.

Am I missing something?

 

Hi,

I have a functionality of moving items up and down same hierarchical level.

Treelist is wrapped into ajaxPanal.

Items are sorted within level according to "OrderNo"
I've added two buttons "MoveUp" and "MoveDown", which are changing item 's "OrderNo".

  protected void MoveQuestionDown(object sender, EventArgs e)
        {
            var itemId = int.Parse(((ImageButton)sender).CommandArgument);
            Presenter.MoveDown(itemId);
            QuestionsTree.Rebind();      
        }

        protected void MoveQuestionUp(object sender, EventArgs e)
        {
            var itemId = int.Parse(((ImageButton)sender).CommandArgument);
            Presenter.MoveUp(itemId);            
            QuestionsTree.Rebind();    
        }

Loadondemand is enabled.

Everything works fine until one of items is expanded and moved.
If i try to move (for example "down") expanded item with child's. it moves down but, item it was switched with cannot be expanded anymore. Expand button disappears.

Will appreciate any help.

Thank You.

Hi,
I am trying to filter the RadGrid [Grd_Url] using a RadComboBox [Cmb_Lst_Sel] which is inside "CommandItemTemplate". The RadComboBox has CheckBoxes enable and user can select multiple checkboxes. The RadGrid needs to be selected based on the multiple selection [DataValueField="lst_id"]. How can I do that?

ASPX:
----------------------------------------------------------------------

<telerik:RadGrid ID="Grd_Url" runat="server" GridLines="None" AllowSorting="true" AllowPaging="true" PageSize="50"
    AllowFilteringByColumn="true" AutoGenerateColumns="False" AllowMultiRowSelection="true" AllowMultiRowEdit="true"
    AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AllowAutomaticDeletes="True" 
    DataSourceID="Sql_Url" Width="100%">
    <SortingSettings SortToolTip=""/>
    <FilterItemStyle Width="100%"></FilterItemStyle>
    <GroupingSettings CaseSensitive="false"></GroupingSettings>
    <PagerStyle AlwaysVisible="true" Mode="NextPrevAndNumeric"/>
    <MasterTableView DataKeyNames="url_id" CommandItemDisplay="Top" EditMode="InPlace" InsertItemPageIndexAction="ShowItemOnCurrentPage"
        GroupLoadMode="Client" GroupsDefaultExpanded="true" TableLayout="Fixed" Width="100%">
        <GroupByExpressions>
            <telerik:GridGroupByExpression>
                <SelectFields>
                    <telerik:GridGroupByField FieldName="lst_name"></telerik:GridGroupByField>
                    <telerik:GridGroupByField FieldName="lst_sort"></telerik:GridGroupByField>
                </SelectFields>
                <GroupByFields>
                    <telerik:GridGroupByField FieldName="lst_sort" SortOrder="Ascending"></telerik:GridGroupByField>
                    <telerik:GridGroupByField FieldName="lst_name" SortOrder="Ascending"></telerik:GridGroupByField>
                </GroupByFields>
            </telerik:GridGroupByExpression>
        </GroupByExpressions>
        <CommandItemTemplate>
        <div id="Div_Tlb_Fixed">
            <telerik:RadToolBar ID="Tlb_Url" runat="server" EnableImageSprites="true"
                OnButtonClick="CsTlbClick" OnClientButtonClicking="jsTlbUrl">
                <Items>
                    <telerik:RadToolBarButton CommandName="Toggle" PostBack="false" ToolTip="Expand/Collapse Folders"
                        CssClass="Btn_ToggleN" HoveredCssClass="Btn_ToggleH"
                        CheckOnClick="true" AllowSelfUnCheck="true" Group="T">
                    </telerik:RadToolBarButton>

                    <telerik:RadToolBarButton CommandName="Clear" PostBack="false" ToolTip="Clear Website Selection"
                        CssClass="Btn_ClearN" HoveredCssClass="Btn_ClearH">
                    </telerik:RadToolBarButton>
                </Items>
            </telerik:RadToolBar>
            <telerik:RadComboBox ID="Cmb_Lst_Sel" runat="server" DataTextField="lst_name" CheckBoxes="true"
                DataValueField="lst_id" AutoPostBack="True" EnableCheckAllItemsCheckBox="true" 
                DataSourceID="Sql_Lst" Width="20%">
                <Items>
                    <telerik:RadComboBoxItem Text="All" Value="" Selected="true"></telerik:RadComboBoxItem>
                </Items>
            </telerik:RadComboBox> 
        </div>
        </CommandItemTemplate>
        <Columns>
            <telerik:GridBoundColumn DataField="lst_id" HeaderText="Folder ID" SortExpression="lst_id" 
                UniqueName="lst_id" Display="false">
                <HeaderStyle HorizontalAlign="Left" Width="1%"/>
                <ItemStyle HorizontalAlign="Left" Width="1%"/>
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn DataField="lst_name" HeaderText="Folder Name" SortExpression="lst_name" 
                UniqueName="lst_name" Display="false">
                <HeaderStyle HorizontalAlign="Left" Width="1%"/>
                <ItemStyle HorizontalAlign="Left" Wrap="false" Width="1%"/>
            </telerik:GridBoundColumn>
            <telerik:GridTemplateColumn DataField="url_name" HeaderText="Website Name" SortExpression="url_name" 
                UniqueName="url_name" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" 
                ShowFilterIcon="false" FilterControlWidth="100%">
                <HeaderStyle HorizontalAlign="Left" Width="25%"/>
                <ItemStyle HorizontalAlign="Left" Width="25%"/>
                <ItemTemplate>
                    <asp:HyperLink ID="Hyp_url_name" runat="server" Target="_blank" Font-Underline="false"
                        NavigateUrl='<%# Eval("url_address") %>'><%# Eval("url_name") %>
                    </asp:HyperLink>
                </ItemTemplate>
                <EditItemTemplate>
                    <telerik:RadTextBox runat="server" ID="Gce_url_name" MaxLength="128" 
                        Text = '<%# Bind("url_name") %>' Width="100%">
                    </telerik:RadTextBox>
                </EditItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn DataField="url_address" HeaderText="Website Address" SortExpression="url_address" 
                UniqueName="url_address" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" 
                ShowFilterIcon="false" FilterControlWidth="100%">
                <HeaderStyle HorizontalAlign="Left" Width="47%"/>
                <ItemStyle HorizontalAlign="Left" Width="47%"/>
                <ItemTemplate>
                    <asp:HyperLink ID="Hyp_url_address" runat="server" Target="_blank" Font-Underline="false"
                        NavigateUrl='<%# Eval("url_address") %>'><%# Eval("url_address")%>
                    </asp:HyperLink>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridEditCommandColumn UniqueName="Btn_Edit" ButtonType="ImageButton" EditText="Edit" HeaderText="Edit">
                <HeaderStyle HorizontalAlign="Center" Width="7%"/>
                <ItemStyle HorizontalAlign="Center" Width="7%"/>
            </telerik:GridEditCommandColumn>
            <telerik:GridButtonColumn CommandName="Delete" UniqueName="Btn_Delete" ButtonType="ImageButton" Text="Delete"
                ConfirmDialogType="RadWindow" ConfirmTitle="Delete" ConfirmText="Delete the selected websites(s)? You cannot UNDO the operation.">
                <HeaderStyle HorizontalAlign="Center" Width="4%"/>
                <ItemStyle HorizontalAlign="Center" Width="4%"/>
            </telerik:GridButtonColumn>
        </Columns>
    </MasterTableView>
    <ClientSettings AllowRowsDragDrop="true" AllowColumnsReorder="false" AllowKeyboardNavigation="false"
            AllowGroupExpandCollapse="true" AllowDragToGroup="false">
        <Selecting AllowRowSelect="true" EnableDragToSelectRows="true"/>
        <Resizing AllowRowResize="true" AllowColumnResize="true" AllowResizeToFit="true" EnableRealTimeResize="true" 
            ResizeGridOnColumnResize="false" ShowRowIndicatorColumn="false" ClipCellContentOnResize="false"/>
        <Scrolling AllowScroll="false" SaveScrollPosition="true"/>
        <KeyboardNavigationSettings AllowSubmitOnEnter="true"/>
        <ClientEvents OnRowDblClick="jsRowDblClick" OnRowDropping="onRowDropping"/>
    </ClientSettings>
</telerik:RadGrid>

<asp:SqlDataSource ID="Sql_Url" runat="server" OnInserting="CsSqlInserting" OnSelecting="CsSqlSelecting"
ConnectionString="<%$ ConnectionStrings:Con_Str %>" 
    DeleteCommand="DELETE FROM [t_Urls] WHERE [url_id] = @url_id" 
    InsertCommand="INSERT INTO [t_Urls] ([url_id], [usr_id], [lst_id], [url_isOpen], [url_name], [url_address], [url_sort]) 
                   VALUES (NEWID(), @usr_id, @lst_id, @url_isOpen, @url_name, @url_address, @url_sort)" 
    SelectCommand="SELECT b.[lst_id], b.[lst_name], b.[lst_sort], a.[url_id], a.[url_isOpen], a.[url_name], a.[url_address], a.[url_sort] 
                   FROM (SELECT * FROM [t_Urls] WHERE [usr_id] = @usr_id) a 
                   INNER JOIN 
                   (SELECT * FROM [t_Lists] WHERE [usr_id] = @usr_id AND [lst_type] IN ('a', @lst_type_filter)) b 
                   ON a.[lst_id] = b.[lst_id] 
                   ORDER BY b.[lst_sort] ASC, a.[url_sort] ASC, a.[url_date] DESC"
    UpdateCommand="UPDATE [t_Urls] SET [lst_id] = @lst_id, [url_isOpen] = @url_isOpen, [url_name] = @url_name, 
                   [url_address] = @url_address, [url_sort] = @url_sort WHERE [url_id] = @url_id">
    <InsertParameters>
        <asp:Parameter Name="usr_id"/>
        <asp:Parameter Name="lst_id"/>
        <asp:Parameter Name="url_isOpen" Type="Boolean" DefaultValue="true"/>
        <asp:Parameter Name="url_name" Type="String"/>
        <asp:Parameter Name="url_address" Type="String"/>
        <asp:Parameter Name="url_sort" Type="Byte" DefaultValue="1"/>
    </InsertParameters>
    <SelectParameters>
        <asp:Parameter Name="usr_id"/>
        <asp:Parameter Name="lst_type_filter" Type="String" DefaultValue="z"/>
    </SelectParameters>
    <UpdateParameters>
        <asp:Parameter Name="lst_id"/>
        <asp:Parameter Name="url_isOpen" Type="Boolean"/>
        <asp:Parameter Name="url_name" Type="String"/>
        <asp:Parameter Name="url_address" Type="String"/>
        <asp:Parameter Name="url_sort" Type="Byte"/>
    </UpdateParameters>
    <DeleteParameters>
        <asp:Parameter Name="url_id"/>
    </DeleteParameters>
</asp:SqlDataSource>

<asp:SqlDataSource ID="Sql_Lst" runat="server" OnSelecting="CsSqlSelectingCmb"
ConnectionString="<%$ ConnectionStrings:Con_Str %>"
    SelectCommand="SELECT [lst_id], [lst_name] 
                   FROM [t_Lists] 
                   WHERE [usr_id] = @usr_id 
                   ORDER BY [lst_sort]">
    <SelectParameters>
        <asp:Parameter Name="usr_id"/>
    </SelectParameters>
</asp:SqlDataSource> 


C#:
----------------------------------------------------------------------

        protected void Page_Load(object s, EventArgs e)
        {
            _isAuth = HttpContext.Current.User.Identity.IsAuthenticated;

            Sql_Url.SelectCommand = "SELECT b.[lst_id], b.[lst_name], b.[lst_sort], a.[url_id], a.[url_isOpen], a.[url_name], a.[url_address], a.[url_sort] " +
                                    "FROM (SELECT * FROM [t_Urls] WHERE [usr_id] = @usr_id) a " +
                                    "INNER JOIN " +
                                    "(SELECT * FROM [t_Lists] WHERE [usr_id] = @usr_id AND [lst_type] IN ('a', @lst_type_filter)) b " +
                                    "ON a.[lst_id] = b.[lst_id] " +
                                    "ORDER BY b.[lst_sort] ASC, a.[url_sort] ASC, a.[url_date] DESC ";
        }

        protected void CsTlbClick(object s, RadToolBarEventArgs e)
        {
        }

        protected void CsSqlInserting(object s, SqlDataSourceCommandEventArgs e)
        {
            if (_isAuth)
            {
                e.Command.Parameters["@usr_id"].Value = Membership.GetUser(HttpContext.Current.User.Identity.Name).ProviderUserKey;
            }
            else
            {
                e.Command.Parameters["@usr_id"].Value = Guid.Empty;
            }
        }

        protected void CsSqlSelecting(object s, SqlDataSourceCommandEventArgs e)
        {

             e.Command.Parameters["@usr_id"].Value = Membership.GetUser(HttpContext.Current.User.Identity.Name).ProviderUserKey;
             e.Command.Parameters["@lst_type_filter"].Value = (Session["lst_type"] != null && Session["lst_type"].ToString() != "") ? Session["lst_type"].ToString() : "z";
        }

        protected void CsSqlSelectingCmb(object s, SqlDataSourceCommandEventArgs e)
        {

            e.Command.Parameters["@usr_id"].Value = Membership.GetUser(HttpContext.Current.User.Identity.Name).ProviderUserKey;

        }

------------