Hi,

we are currently using Version 2011.2 915 of the ASP.NET AJAX Controls and have the following problem.

We want to populate RadScheduler via WCF Service which provides us with our own appointment objects (not inherited from AppointmentData; not implementing IAppointmentData) because other (non-telerik) applications have to use this service too.
Additionally we would like to use client-side binding to provide good responsiveness.
Currently we receive an error that the get_Time function within _toClientDate cannot be called on an object that is null.
In the arguments of RadScheduler.OnClientRequestSuccess we correctly receive our list of custom objects.

Is it possible to populate RadScheduler with our own objects? Do we need to use a custom DataProvider? Do we need a newer version of the RadControls?

Thanks in advance

Thomas 

Hello Sir /Madam,

Currently i am using rad grid in my project now i am using asp text box control inside the item template of rad grid now i Have to check all Textboxes text at client side and apply Validation on it if all text boxes text is empty then validation message should be shown. here is my screen shot that i have attached named (TextBox_inside_grid) in this screen shot if i dont write any text in any text box than at button click message Should be display and if i click on cancel button than all validation messages show be hide and if any text is inside the textboxes it should also be clear. Currently i am writing this code:

 function Materialreceived_ClientClick1() {
                var count = 0;
                var grid = $find("<%=RadGrid_POPUP_MaterialReceived.ClientID %>");
                var MasterTable = grid.get_masterTableView();
                for (var i = 0; i < MasterTable.get_dataItems().length; i++) {
                    var gridItemElement = MasterTable.get_dataItems()[i].findElement("txt_receivedqty");
                     var lenght = ((gridItemElement).val());
                    if (lenght>0) {

                     
                        count++;
                        break;
                    }
                }
               if (count == 0) {
                    alert("Please check atleast one !");
                    document.getElementById("<%=lblgrid.ClientID %>").innerHTML = 'User must enter a number on at least one row.';
                    return false;
                }
            }


But its not working. so please tell me asap.

thanks in advance

Hi,

I have a page which has a master grid and then in a NestedViewTemplate I have two PageViews which have grids as well.
From Javascript though, I cannot reference the grids in the PageViews using the $find command. 
Any idea on how to resolve this?

Code is below:

Here is the code for the Master Grid and PageViews:

<div style="margin-left:10px;width:100%">
        <telerik:RadComboBox ID="RadComboBox1" runat="server" DataSourceID="SqlDataSource8" DataTextField="coachname" DataValueField="coachid" AutoPostBack="true" Skin="Forest" OnSelectedIndexChanged="RadComboBox1_SelectedIndexChanged"></telerik:RadComboBox>
    <asp:SqlDataSource runat="server" ID="SqlDataSource8" ConnectionString='<%$ ConnectionStrings:BHDPortalsConnectionString %>' SelectCommand="Select Distinct(FirstName + ' ' + LastName) as CoachName, CoachID from aspnet_users where FirstName + LastName &lt;&gt; ''"></asp:SqlDataSource>
        
        <telerik:RadGrid ID="RadGrid1" OnPreRender="RadGrid1_PreRender" DataSourceID="SqlDataSource1"
            runat="server" AutoGenerateColumns="False" AllowSorting="True"
            AllowPaging="True" GridLines="None" OnItemCreated="RadGrid1_ItemCreated" Width="98%"
            OnItemCommand="RadGrid1_ItemCommand" CellSpacing="0" AutoGenerateEditColumn="True" OnUpdateCommand="RadGrid1_UpdateCommand" AllowFilteringByColumn="true" OnItemDataBound="RadGrid1_ItemDataBound">

       

        <PagerStyle Mode="NumericPages"></PagerStyle>
        <GroupingSettings CaseSensitive="false"></GroupingSettings>

        <MasterTableView DataSourceID="SqlDataSource1" AllowMultiColumnSorting="True" EditMode="InPlace" Name="ParentGrid"

            GroupLoadMode="Server">

            <NestedViewTemplate>

                <asp:Panel runat="server" ID="InnerContainer" CssClass="viewWrap" Visible="false">

                    <telerik:RadTabStrip runat="server" ID="TabStip1" MultiPageID="Multipage1" SelectedIndex="0">

                        <Tabs>

                            <telerik:RadTab runat="server" Text="Appointments" PageViewID="PageView1">

                            </telerik:RadTab>

                            <telerik:RadTab runat="server" Text="Reports" PageViewID="PageView2">

                            </telerik:RadTab>


                        </Tabs>

                    </telerik:RadTabStrip>

                    <telerik:RadMultiPage runat="server" ID="Multipage1" SelectedIndex="0" RenderSelectedPageOnly="false">

                        <telerik:RadPageView runat="server" ID="PageView1">

                            <asp:Label ID="Label1" Font-Bold="true" Font-Italic="true" Text='<%# Eval("PatientID") %>'

                                Visible="false" runat="server"></asp:Label>

                            <telerik:RadGrid runat="server" ID="AppointmentsGrid" DataSourceID="SqlDataSource2" ShowFooter="true" OnItemCommand="AppointmentsGrid_ItemCommand" OnDataBound="AppointmentsGrid_DataBound" OnItemDataBound="AppointmentsGrid_ItemDataBound"

                                AllowSorting="true" EnableLinqExpressions="false">

                                <MasterTableView ShowHeader="true" AutoGenerateColumns="False" AllowPaging="true" PageSize="7" HierarchyLoadMode="ServerOnDemand">

                                    <Columns>
                                        <telerik:GridButtonColumn FilterControlAltText="Filter column column"    UniqueName="CancelBtn" Text="Cancel" CommandName="cancelBtn"
                                            HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center">
                                        </telerik:GridButtonColumn>
                                        <telerik:GridBoundColumn SortExpression="ID" HeaderText="Id" DataField="ID" UniqueName="ID" DataType="System.Int32" 
                                            FilterControlAltText="Filter ID Column" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center">
                                        </telerik:GridBoundColumn> 
                                        <telerik:GridBoundColumn SortExpression="Start" HeaderText="Start"
                                            DataField="Start" UniqueName="Start" DataType="System.DateTime" FilterControlAltText="Filter Start column"
                                            HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center">
                                        </telerik:GridBoundColumn>
                                        <telerik:GridBoundColumn SortExpression="Duration" HeaderText="Duration"
                                            DataField="Duration" UniqueName="Duration" DataType="System.DateTime" FilterControlAltText="Filter Duration column"
                                            HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center">
                                        </telerik:GridBoundColumn>
                                        <telerik:GridBoundColumn SortExpression="Appointment_Type" HeaderText="Appointment Type"
                                            DataField="Appointment_Type" UniqueName="Appointment_Type" FilterControlAltText="Filter Appointment Type column"
                                            HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center">
                                        </telerik:GridBoundColumn>

                                        <telerik:GridBoundColumn UniqueName="AppointmentStatus" DataField="AppointmentStatus" HeaderText="AppointmentStatus"
                                            SortExpression="AppointmentStatus" DataType="System.Int32" FilterControlAltText="Filter AppointmentStatus column"
                                            HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center">

                                        </telerik:GridBoundColumn>

                                        <telerik:GridButtonColumn ButtonType="ImageButton" CommandName="CoachNotes"
                                            HeaderText='Notes' Text="Notes" UniqueName="CoachNotes" ImageUrl="~/Images/notes.png" HeaderStyle-Font-Bold="true" HeaderStyle-Font-Size="Small" HeaderStyle-HorizontalAlign="Center">
                                            <HeaderStyle Width="20px" />
                                            <ItemStyle CssClass="MyImageButton" HorizontalAlign="Center" />
                                        </telerik:GridButtonColumn>
                                    </Columns>
                                            
                                    
                                
                                    </MasterTableView>
                            </telerik:RadGrid>

                            <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString='<%$ ConnectionStrings:BHDPortalsConnectionString %>' SelectCommand="SELECT [Start], [End], DATEDIFF(minute,[Start],[End]) as Duration, [Subject] as Appointment_Type, [AppointmentStatus], ID, isnull(PatientCoachNoteID,0) as PatientCoachNoteID FROM [BHDAppointments] WHERE ([ClientUserID] = @ClientUserID)">
                                <SelectParameters>
                                    <asp:ControlParameter ControlID="Label1" PropertyName="Text" Name="ClientUserID" Type="Int32"></asp:ControlParameter>
                                </SelectParameters>
                            </asp:SqlDataSource>

                            

                        </telerik:RadPageView>

                        <telerik:RadPageView runat="server" ID="PageView2">
                            <asp:Label ID="Label2" Font-Bold="true" Font-Italic="true" Text='<%# Eval("PatientID") %>'
                            Visible="false" runat="server"></asp:Label>

                        <telerik:RadGrid runat="server" ID="ReportsGrid" DataSourceID="SqlDataSource3" ShowFooter="true" OnItemCommand="ReportsGrid_ItemCommand" OnItemDataBound="ReportsGrid_ItemDataBound"
                            AllowSorting="true" EnableLinqExpressions="false" MasterTableView-DataKeyNames="PatientID">
                            <MasterTableView ShowHeader="true" AutoGenerateColumns="False" AllowPaging="true" PageSize="7" HierarchyLoadMode="ServerOnDemand">
                            <Columns>
                                
                                <telerik:GridBoundColumn SortExpression="Accession" HeaderText="Accession"
                                    DataField="Accession" UniqueName="Accession" FilterControlAltText="Filter Accession column"
                                    HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn SortExpression="OriginalOrderDate" HeaderText="Original Order Date"
                                    DataField="OriginalOrderDate" UniqueName="OriginalOrderDate" DataType="System.DateTime" FilterControlAltText="Filter OriginalOrderDate column"
                                    HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center">
                                </telerik:GridBoundColumn>
                                <telerik:GridButtonColumn ButtonType="ImageButton" CommandName="LabReport"
                                    HeaderText='Lab Report' Text="Lab Report" UniqueName="LabReport" ImageUrl="~/Images/notes.png" HeaderStyle-Font-Bold="true" HeaderStyle-Font-Size="Small" HeaderStyle-HorizontalAlign="Center">
                                    <HeaderStyle Width="20px" />
                                    <ItemStyle CssClass="MyImageButton" HorizontalAlign="Center" />
                                </telerik:GridButtonColumn>
                                <telerik:GridButtonColumn ButtonType="ImageButton" CommandName="PLPFile"
                                    HeaderText='PLP' Text="PLP" UniqueName="PLPFile" ImageUrl="~/Images/notes.png" HeaderStyle-Font-Bold="true" HeaderStyle-Font-Size="Small" HeaderStyle-HorizontalAlign="Center">
                                    <HeaderStyle Width="20px" />
                                    <ItemStyle CssClass="MyImageButton" HorizontalAlign="Center" />
                                </telerik:GridButtonColumn>
                                <telerik:GridButtonColumn ButtonType="ImageButton" CommandName="Questionaire"
                                    HeaderText='Questionaire' Text="Questionaire" UniqueName="Questionaire" ImageUrl="~/Images/notes.png" HeaderStyle-Font-Bold="true" HeaderStyle-Font-Size="Small" HeaderStyle-HorizontalAlign="Center">
                                    <HeaderStyle Width="20px" />
                                    <ItemStyle CssClass="MyImageButton" HorizontalAlign="Center" />
                                </telerik:GridButtonColumn>
                                <telerik:GridButtonColumn ButtonType="PushButton" CommandName="Action"
                                    HeaderText="Action" Text="Unlock" UniqueName="Action" HeaderStyle-Font-Bold="true" HeaderStyle-Font-Size="Small" HeaderStyle-HorizontalAlign="Center">
                                    <HeaderStyle Width="20px" />
                                    <ItemStyle HorizontalAlign="Center" />
                                 </telerik:GridButtonColumn>
                                <telerik:GridBoundColumn SortExpression="PLPFileName" HeaderText="PLP File Name"
                                    DataField="PLPFileName" UniqueName="PLPFileName" FilterControlAltText="Filter PLPFileName column"
                                    HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" EmptyDataText="">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn SortExpression="PLPCreatedDate" HeaderText="PLP Created Date"
                                    DataField="PLPCreatedDate" UniqueName="PLPCreatedDate" DataType="System.DateTime" FilterControlAltText="Filter OriginalOrderDate column"
                                    HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn SortExpression="QuestionaireStatus" HeaderText="QuestionaireStatus"
                                    DataField="QuestionaireStatus" UniqueName="QuestionaireStatus" DataType="System.Int32" FilterControlAltText="Filter QuestionaireStatus column"
                                    HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center">
                                </telerik:GridBoundColumn>
                            </Columns>
                            </MasterTableView>
                            </telerik:RadGrid>
                        
                            <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString='<%$ ConnectionStrings:BHDPortalsConnectionString %>' SelectCommand="Select P.PatientID, P.Accession, P.OriginalOrderDate, isnull(PLPFileName,'') as PLPFileName, P.PLPCreatedDate, case when A.cnt > 0 then 1 else 0 end as QuestionaireStatus
FROM PatientAccessionReports P (nolock)
LEFT JOIN (Select PatientID, Accession, Count(*) as cnt from tblAnswers (nolock) group by PatientID, Accession) A 
on A.PatientID = P.PatientID and A.Accession = P.Accession
where P.PatientID = @PatientID">
                                <SelectParameters>
                                    <asp:ControlParameter ControlID="Label2" PropertyName="Text" Name="PatientID" Type="String"></asp:ControlParameter>
                                </SelectParameters>
                            </asp:SqlDataSource>
                        
                        </telerik:RadPageView>

                        

                    </telerik:RadMultiPage>

                </asp:Panel>

            </NestedViewTemplate>

<CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings>

<RowIndicatorColumn Visible="True" FilterControlAltText="Filter RowIndicator column"></RowIndicatorColumn>

<ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column"></ExpandCollapseColumn>

            <Columns>

                

                <telerik:GridBoundColumn SortExpression="FirstName" HeaderText="First Name"

                    DataField="FirstName" UniqueName="FirstName" ReadOnly="true" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains">

                </telerik:GridBoundColumn>

                <telerik:GridBoundColumn SortExpression="Lastname" HeaderText="Last Name"

                    DataField="Lastname" UniqueName="Lastname" FilterControlAltText="Filter Lastname column" ReadOnly="true" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains">

                </telerik:GridBoundColumn>

                <telerik:GridBoundColumn SortExpression="BestContactPhoneNumber" HeaderText="Contact Phone"

                    DataField="BestContactPhoneNumber" UniqueName="BestContactPhoneNumber" FilterControlAltText="Filter BestContactPhoneNumber column" ReadOnly="true" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains">

                </telerik:GridBoundColumn>

                <telerik:GridBoundColumn SortExpression="PatientID"

                    HeaderText="Patient ID" DataField="PatientID" UniqueName="PatientID" FilterControlAltText="Filter PatientID column" ReadOnly="true" ForceExtractValue="InEditMode" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains">

                </telerik:GridBoundColumn>

                <telerik:GridBoundColumn SortExpression="AppointmentCount"
                    HeaderText="# of Appointments" DataField="AppointmentCount" UniqueName="AppointmentCount" FilterControlAltText="Filter AppointmentCount column" HeaderStyle-Width="5px" HeaderStyle-HorizontalAlign="Center" ReadOnly="true" ItemStyle-HorizontalAlign="Center" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains">
                    
                </telerik:GridBoundColumn>

                
                <telerik:GridTemplateColumn HeaderText="Coach Id" UniqueName="CoachID" HeaderStyle-Font-Bold="true" HeaderStyle-Font-Size="Small" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains">
                    <ItemTemplate>
                        <%#DataBinder.Eval(Container.DataItem,"coachname")%>
                    </ItemTemplate>
                    <EditItemTemplate>
                        <telerik:RadComboBox runat="server" ID="RadComboBox2" DataTextField="Name" Skin="Forest" AutoPostBack="true" OnSelectedIndexChanged="RadComboBox2_SelectedIndexChanged"
                            DataValueField="CoachId" DataSourceID="CoachUsers" SelectedValue='<%#Bind("CoachId") %>'>
                        </telerik:RadComboBox>
                    </EditItemTemplate>
                </telerik:GridTemplateColumn>

                <telerik:GridButtonColumn ButtonType="ImageButton" CommandName="Book"
                    HeaderText='Book' Text="Book" UniqueName="Book" ImageUrl="~/Images/book-icon.png" HeaderStyle-Font-Bold="true" HeaderStyle-Font-Size="Small" HeaderStyle-HorizontalAlign="Center">
                    <HeaderStyle Width="20px" />
                    <ItemStyle CssClass="MyImageButton" HorizontalAlign="Center" />
                </telerik:GridButtonColumn>
            </Columns>

<EditFormSettings>
<EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn>
</EditFormSettings>

<PagerStyle PageSizeControlType="RadComboBox"></PagerStyle>

        </MasterTableView>

        <ClientSettings AllowDragToGroup="true">

        </ClientSettings>

<FilterMenu EnableImageSprites="False"></FilterMenu>

    </telerik:RadGrid>

        <asp:SqlDataSource ID="SqlDataSource1" ConnectionString="<%$ ConnectionStrings:BHDPortalsConnectionString %>" SelectCommand="SELECT   pi.FirstName, pi.Lastname,  pi.BestContactPhoneNumber, pi.PatientID, dbo.fnCountAppointments(pi.PatientID) as AppointmentCount,  pi.CoachId, aspnet_Users.FirstName + ' ' + aspnet_Users.LastName as [coachname], aspnet_Users.CurrentProviderBHDUserID,  aspnet_Users.BHDUserID
FROM      aspnet_Users INNER JOIN
                         tblPatientInfo AS pi ON aspnet_Users.CoachID = pi.CoachId
WHERE pi.CoachId = @coachid"
            runat="server">
            <SelectParameters>
                <asp:ControlParameter ControlID="hdcoachid" Name="coachid" PropertyName="Value" />
            </SelectParameters>
        </asp:SqlDataSource>
        <asp:SqlDataSource ID="CoachUsers" runat="server" ConnectionString='<%$ ConnectionStrings:BHDPortalsConnectionString %>' SelectCommand="Select distinct coachid, FirstName + ' ' + LastName as [Name] from [aspnet_Users] (nolock)"></asp:SqlDataSource>
</div>

This is the code for the Javascript call that doesn't see the AppointmentsGrid. 

This works fine and sees the RadGrid1
var grid = $find("<%=RadGrid1.ClientID %>").get_masterTableView().NestedTable().get_dataItems()[index]; 

This code won't work. Can't see the Appointments Grid.
var grid = $find("<%=AppointmentsGrid.ClientID %>").get_masterTableView().NestedTable().get_dataItems()[index];

Thanks,

Kevin

I have a hierarchy RadGrid implementation which uses the AutoGenerateColumns pattern. In the RadGrid1_ColumnCreated event I'm setting the properties to align specific columns based on a list of column names which require right alignment.


The issue is when the grid is rendered the right aligned columns are overflowing the column width - see the MV Base column and the text only displays correctly when I click on the row. Attached is a screenshot of the issue showing 2 rows in the Details section. This behaviour is in IE8 - our company standard browser.

Hi
     How can I give heading for an expand-collapse column??

thanks in advance
Allen

Hi All

I have a gridTemplateColumn with a Checkbox, I'm having problems accessing the selected rows (multiple)

How would I do this in my senareo without a GridClientSelectColumn

Andy

Hi,

Im using a RadGrid for editing participants in an event.

I Would like to validate the email adress before comitting the data.

The problem is now that if i have more than one row in EditState and trys to commit one of the rows is validates all rows in editState?

Why is that? and how to avoid it?

Here is the code to my grid:

Sorry for the cryptic title, not sure how  best to describe it.

I have a page used to search records in a table with about 4000 records.  The query for the search uses 10 optional parameters provided via textboxes, dropdowns and datepickers.  When the page loads, the grid should start empty.  The user selects as many paramas suit their search needs and clck a button. i.e. dept='finance' and role='csr' and startdate > 'somedate'.  all parameters are optional and ANDed together using something like

Example SQL

ALTER PROC test (
    @Dept varchar(50)=null,
    @Role varchar(50)=null,
    @Startdate datetime=null ) AS

SELECT some, bunch, of, fields
FROM sometable
WHERE
    (Dept = @Dept or isNull(@Dept,'')='')
    AND (Role = @Role or isNull(@Role,'')='')
    AND (startdate > @somedate or isNull(@somedate,0)=0)

* Grid must start with zero records on page load
* If the user select no parameters then ALL records will be returned.

As it stands now when the page loads ALL 4000 records are returned because I have CancelSelectonNullParameter=false in the SQL DataSource. This can usually causes a timeout.

I know I can do some of this via custom paging but thats not really what I want. I want the page to load with zero records in the grid but if the user clicks search with no parameters set then yes all recods can be returned.  at which point normal paging will occur.

Thanks
Kelly

I want change Font-Family of tabstript item in javascript (clinet side) in asp.net ajax rad controls.

I have a radgrid on page and i bind data on serverside. Bydefault sorting is set to false on grid. But on click of a checkbox on a container page, I want to sort grid data on specific column.  for example below, on click of a checkbox I want to sort my data as Active customer on top or Inactive customers on top.  How would I do that on clientside.? Can I enable sorting on individual column only?

ID	Name	Total Orders	Active
1	Customer 1	9	TRUE
2	Customer 2	11	FALSE
3	Customer 3	2	FALSE
4	Customer 4	20	TRUE
5	Customer 5	31	TRUE