Questions on UI for ASP.NET AJAX Forum

1 answer

100 views

Resource view not working with unorthodox database schema

Hello,

I am trying to set up the Scheduler so as to get a view of techs and their availability. The catch is, the database does not conform to the design that the Scheduler appears to want. The <telerik:ResourceType> tag needs a data source, a primary key (for the tech), and a foreign key (for the appointment). The problem in my case is that the primary key of the appointment is not in the same table as that of the tech. There is an Appointments table and a Users table, and the two are linked via a third table containing the PK of the user and the PK of the appointment.

I have tried to work around this by using a SqlDataSource with the following SQL query:

    
            SELECT A.ID AS apptID, U.userID, A.name, A.[dateTime], A.dateTimeEnd, U.userName<br> 
        
            FROM AppointmentUsers AXU<br> 
        
            JOIN Users U ON AXU.userID = U.userID<br> 
        
            JOIN Appointments A ON AXU.apptID = A.ID

Using this, I'm able to get a list of techs to assign the appointment to when I edit the appointment. However, I'm still unable to view the resources on a given day. Below is a full code sample:

    
                    <telerik:RadScheduler ID="Scheduler" 
        
                                          DataKeyField="apptID" 
        
                                          DataSubjectField="name" 
        
                                          DataStartField="dateTime" 
        
                                          DataEndField="dateTimeEnd" 
        
                                          DataSourceID="AppointmentsData" 
        
                                          runat="server"> 
        
                        <DayView ShowResourceHeaders="true" /> 
        
                        <WeekView ShowResourceHeaders="true" /> 
        
                        <MonthView ShowResourceHeaders="true" /> 
        
                        <TimelineView ShowResourceHeaders="true" /> 
        
                        <ResourceTypes> 
        
                            <telerik:ResourceType Name="Tech" KeyField="userID" ForeignKeyField="apptID" TextField="userName" DataSourceID="AppointmentsData" /> 
        
                        </ResourceTypes> 
        
                    </telerik:RadScheduler> 
        
                    <asp:SqlDataSource ID="AppointmentsData" 
        
                                       ProviderName="System.Data.SqlClient" 
        
                                       ConnectionString=xxx
        
                                       SelectCommand="SELECT A.ID AS apptID, U.userID, A.name, A.[dateTime], A.dateTimeEnd, U.userName 
        
                                                      FROM AppointmentUsers AXU 
        
                                                      JOIN Users U ON AXU.userID = U.userID 
        
                                                      JOIN Appointments A ON AAXU.apptID = A.ID 
        
                                                      WHERE A.companyID = 7673" 
        
                                       runat="server" />

Thanks,

Daniel

Scheduler

answered on 12 Mar 2010

1 answer

76 views

Pager control in the gridview

Hi,
I am having problem with viewing the pager control within the radgrid. The dropdownlist for the page size seems to be like a text box. Refer the attached screenshot for the same.

Also, given below are the code-snippets from our code:

    
            <telerik:RadGrid ID="grdBookings" runat="server" AutoGenerateColumns="false" Skin="Office2007" 
        
                                    OnNeedDataSource="grdBookings_NeedDataSource" OnItemDataBound="grdBookings_ItemDataBound" 
        
                                    AllowSorting="true" Width="99%" AllowPaging="true" PagerStyle-Mode="NextPrevAndNumeric" 
        
                                    EnableEmbeddedSkins="true"></telerik:RadGrid> 
        
            -------------- 
        
            <telerik:RadAjaxManagerProxy ID="RadAjaxManagerProxyViewBooking" runat="server"> 
        
                <AjaxSettings> 
        
                    <telerik:AjaxSetting AjaxControlID="ddlBookings"> 
        
                        <UpdatedControls> 
        
                            <telerik:AjaxUpdatedControl ControlID="grdBookings" LoadingPanelID="RadAjaxLoadingPanel2" /> 
        
                            <telerik:AjaxUpdatedControl ControlID="ddlBookings" /> 
        
                        </UpdatedControls> 
        
                    </telerik:AjaxSetting> 
        
                    <telerik:AjaxSetting AjaxControlID="grdBookings"> 
        
                        <UpdatedControls> 
        
                            <telerik:AjaxUpdatedControl ControlID="grdBookings" LoadingPanelID="RadAjaxLoadingPanel2" /> 
        
                        </UpdatedControls> 
        
                    </telerik:AjaxSetting> 
        
                </AjaxSettings> 
        
            </telerik:RadAjaxManagerProxy> 
        
            <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel2" runat="server" Skin="Default"> 
        
            </telerik:RadAjaxLoadingPanel>

Please let us know what might be causing the problem.

Thanks in advance.

Grid

answered on 12 Mar 2010

1 answer

108 views

DLL FOR RADLISTBOX

RADLISTBOX with cascading example not working properly.............
e.g. im selecting multiple educations and based on that i will select specialization.........but cascading not hapning........
any clue????

ListBox

answered on 12 Mar 2010

2 answers

148 views

DatePicker SelectedDate property returns 2 digit year

Hi,

The DatePicker SelectedDate property is returning 2 digit year on a particular deployment. All other installation of the same page returns 4 digit year. It seems something enviromental causing this 2 digit year behavior. Any ideas on what could cause this?

    
            <%@ Page Language="C#" %> 
        
            <%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %> 
        
            <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 
        
            <script runat="server"> 
        
                protected void RadDatePicker1_SelectedDateChanged(object sender, Telerik.Web.UI.Calendar.SelectedDateChangedEventArgs e) { 
        
                    Label1.Text = RadDatePicker1.SelectedDate.ToString(); 
        
                } 
        
            </script> 
        
            <html xmlns="http://www.w3.org/1999/xhtml"> 
        
            <head runat="server"> 
        
                <title></title> 
        
            </head> 
        
            <body> 
        
                <form id="form1" runat="server"> 
        
                <asp:ScriptManager ID="ScriptManager1" runat="server"> 
        
                </asp:ScriptManager> 
        
                <div> 
        
                    <p> 
        
                        <telerik:RadDatePicker ID="RadDatePicker1" runat="server" AutoPostBack="True" OnSelectedDateChanged="RadDatePicker1_SelectedDateChanged"> 
        
                            <DateInput AutoPostBack="True"> 
        
                            </DateInput> 
        
                            <Calendar UseRowHeadersAsSelectors="False" UseColumnHeadersAsSelectors="False" ViewSelectorText="x"> 
        
                            </Calendar> 
        
                            <DatePopupButton ImageUrl="" HoverImageUrl=""></DatePopupButton> 
        
                        </telerik:RadDatePicker> 
        
                        &nbsp;<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label></p> 
        
                    <p> 
        
                </div> 
        
                </form> 
        
            </body> 
        
            </html>

Thanks,
Dev.

Calendar

answered on 12 Mar 2010

1 answer

89 views

RadEditor not loading ConfigFile.xml properties in DNN

Hi,

I've installed RadEditor in DotNetNuke 5.1.4 using the downloaded Module installation pack.
However, it seems that the RadEditor does not understand the properties inside the xml...below are my ConfigFile.xml from \DesktopModules\TelerikWebUI\RadEditorProvider\

    
            <?xml version="1.0" encoding="utf-8" ?> 
        
            <configuration> 
        
              <property name="Skin">Default</property> 
        
              <property name="NewLineBr">false</property> 
        
              <property name="Width">600</property> 
        
            </configuration>

Did I missing anything? Thank you.

George Lew

Editor

answered on 12 Mar 2010

1 answer

76 views

Combox entrys not visible

All Combobox entrys are not visible in my Project (See Attach). But in Code there are entrys.

<div style="width: 500px; float: left;">
       <div id="ctl00_C_Inhalt_CB_Testobjekt" class="RadComboBox RadComboBox_Default" style="width:350px;display:-moz-inline-stack;display:inline-block;zoom:1;*display:inline;">
<table cellpadding="0" cellspacing="0" summary="combobox" border="0" style="border-width:0;table-layout:fixed;border-collapse:collapse;width:100%">
  <tr>
   <td class="rcbInputCell rcbInputCellLeft" style="margin-top:-1px;margin-bottom:-1px;width:100%;"><input name="ctl00$C_Inhalt$CB_Testobjekt" type="text" class="rcbInput rcbEmptyMessage" id="ctl00_C_Inhalt_CB_Testobjekt_Input" value="Testobjekt wählen..." style="display: block;" /></td><td class="rcbArrowCell rcbArrowCellRight" style="margin-top:-1px;margin-bottom:-1px;"><a id="ctl00_C_Inhalt_CB_Testobjekt_Arrow" style="overflow: hidden;display: block;position: relative;outline: none;">select</a></td>
  </tr>
</table><div class="rcbSlide" style="z-index:6000;"><div id="ctl00_C_Inhalt_CB_Testobjekt_DropDown" class="RadComboBoxDropDown RadComboBoxDropDown_Default " style="float:left;display:none;"><div class="rcbScroll rcbWidth" style="width:100%;"><ul class="rcbList" style="list-style:none;margin:0;padding:0;zoom:1;"><li class="rcbItem "></li><li class="rcbItem ">Proband männlich</li><li class="rcbItem ">Proband weiblich</li><li class="rcbItem ">Teil eines postmortalen Testobjekt männlich</li><li class="rcbItem ">Teil eines postmortalen Testobjekt weiblich</li><li class="rcbItem ">Postmortales Testobjekt männlich</li><li class="rcbItem ">Postmortales Testobjekt weiblich</li><li class="rcbItem ">Teil eines Dummy (z.B. Kopf mit Hals, festgesetzt)</li><li class="rcbItem ">Dummy (z.B. Hybrid III)</li><li class="rcbItem ">Teil eines Tier männlich</li><li class="rcbItem ">Teil eines Tier weiblich</li><li class="rcbItem ">Tier männlich</li><li class="rcbItem ">Tier weiblich</li></ul></div></div></div><input id="ctl00_C_Inhalt_CB_Testobjekt_ClientState" name="ctl00_C_Inhalt_CB_Testobjekt_ClientState" type="hidden" />

ComboBox

answered on 12 Mar 2010

2 answers

126 views

[Solved] Set pagerStyle in c#

Hi i have problem with set property pagerStyle in C#. I try set in Pge_Load adn Page_Init but not working. Pleas can you help my.

    
            grid.PagerStyle.PagerTextFormat = "{4} &nbsp;<strong>{5}</strong> řádků ve <strong>{1}</strong> str."; 
        
            grid.PagerStyle.PageSizeLabelText = "Počet řádků:";

Grid

answered on 12 Mar 2010

2 answers

212 views

Pager Template - Dropdown List

Does anyone have a sample of a Pager Template that only has a dropdown listbox with something like "Pg 1 of 10", "Pg 2 of 10", etc. as items in the dropdown. And then, when one of the items is selected, the grid pages to that page?

Or, if no samples, can someone point me in the right direction. Meaning, should this be server-side custom paging code or declarative code within the template?

Thanks.

Grid

answered on 12 Mar 2010

2 answers

91 views

Problem with update Command

I am trying to update my RadGid in Code behind as

Protected

Sub RadGrid1_UpdateCommand(ByVal source As Object, ByVal e As GridCommandEventArgs)

Dim editedItem As GridEditableItem = TryCast(e.Item, GridEditableItem)

Dim Length As String = TryCast(editedItem("numExternalLength").Controls(0), TextBox).Text

End Sub

Here "numExternalLength" is the unique name for GridBoundColumn.
Now the problem is it retrieves only the previous value and not the newly entered value by the user.
Please help me to get the new values that the user enters so that it can be updated in the db.

General Discussions