Telerik Forums
UI for ASP.NET AJAX Forum
1 answer
66 views
Hi guys,

I wonder if this following is possible.
Currently, I have
(picture 1).
and code:
<telerik:RadGrid ID="rgQueryResult" runat="server" AutoGenerateColumns="true" AllowFilteringByColumn="true"
    OnNeedDataSource="QueryResult_NeedDataSource"
    AllowSorting="true"
    AllowPaging="true"
    EnableLinqExpressions="true"
    OnItemCommand="QueryResult_ItemCommand"
    OnItemCreated="QueryResult_ItemCreated"
    >
    <ExportSettings ExportOnlyData="true">
    </ExportSettings>
    <MasterTableView CommandItemDisplay="Top">
        <CommandItemSettings ShowAddNewRecordButton="false" ShowExportToCsvButton="false"
            ShowRefreshButton="false" ShowExportToExcelButton="false"  />
    </MasterTableView>
    <ClientSettings AllowColumnsReorder="true">
        <Scrolling AllowScroll="true"></Scrolling>
         
    </ClientSettings>
</telerik:RadGrid>

Is it possible to add another row of filters (dropdown)?
The datasource is user created sql query so I don't know in advance.

Thank you!
Kostadin
Telerik team
 answered on 20 Nov 2014
2 answers
73 views
When I try to select a row, the row is not highlighted and I am not sure why.

Markup:

<telerik:RadGrid ID="dgRates" runat="server" AllowSorting="false" AutoGenerateColumns="False" Skin="Web20" PageSize="200" GridLines="None" Width="390px" AllowPaging="True" TabIndex="-1" EnableEmbeddedSkins="true" OnBiffExporting="RadGrid_BiffExporting">
              <PagerStyle Position="Bottom" Mode="NumericPages" PageButtonCount="10" AlwaysVisible="true" />
              <ClientSettings>
                <Scrolling UseStaticHeaders="True" AllowScroll="True" ScrollHeight="300px"></Scrolling>
                <Resizing ResizeGridOnColumnResize="True" ClipCellContentOnResize="False" />
                <Selecting AllowRowSelect="True" />
              </ClientSettings>
              <MasterTableView AllowMultiColumnSorting="False" EnableNoRecordsTemplate="False" GridLines="None" DataKeyNames="ID" TableLayout="Fixed" ShowHeader="false">
                <Columns>
                  <telerik:GridBoundColumn DataField="ID" HeaderText="" UniqueName="ID" Display="false">
                    <HeaderStyle Width="0px" />
                  </telerik:GridBoundColumn>
                  <telerik:GridBoundColumn DataField="CarType" HeaderText="" UniqueName="CarType" Display="false">
                    <HeaderStyle Width="0px" />
                  </telerik:GridBoundColumn>
                  <telerik:GridBoundColumn DataField="Rate" HeaderText="" UniqueName="Rate" Display="false">
                    <HeaderStyle Width="0px" />
                  </telerik:GridBoundColumn>
                  <telerik:GridBoundColumn DataField="CurrencyCode" HeaderText="" UniqueName="CurrencyCode" Display="false">
                    <HeaderStyle Width="0px" />
                  </telerik:GridBoundColumn>
                  <telerik:GridBoundColumn DataField="Period" HeaderText="" UniqueName="Period" Display="false">
                    <HeaderStyle Width="0px" />
                  </telerik:GridBoundColumn>
                  <telerik:GridBoundColumn DataField="Total" HeaderText="" UniqueName="Total" Display="false">
                    <HeaderStyle Width="0px" />
                  </telerik:GridBoundColumn>
                  <telerik:GridCheckboxColumn DataField="HasInclusions" HeaderText="" UniqueName="HasInclusions" Display="false">
                    <HeaderStyle Width="0px" />
                  </telerik:GridCheckboxColumn>
                </Columns>
                <DetailItemTemplate>
                    <asp:Table ID="RateTable" runat="server" BorderWidth="0" Width="100%">
                        <asp:TableRow>
                            <asp:TableCell HorizontalAlign="Center" Width="70%" BorderColor="Transparent">
                               <asp:Label ID="lblCarType" runat="server"></asp:Label></asp:TableCell>
                           <asp:TableCell RowSpan="4" ID="tcbtnBook" HorizontalAlign="Center" VerticalAlign="Top" BorderColor="Transparent">
                               <asp:Button ID="btnBook" runat="server" CssClass="BtnStyle" Width="75px" Text="" CommandName="Book"></asp:Button>
                           </asp:TableCell>
                        </asp:TableRow>
                        <asp:TableRow>
                            <asp:TableCell CssClass="LabelHeading" HorizontalAlign="Center" Width="70%" BorderColor="Transparent">
                               $ <asp:Label ID="lblRate" runat="server"></asp:Label> <asp:Label ID="lblCurrencyCode" runat="server"></asp:Label> / <asp:Label ID="lblPeriod" runat="server"></asp:Label></asp:TableCell>
                        </asp:TableRow>
                        <asp:TableRow>
                            <asp:TableCell HorizontalAlign="Center" Width="70%" BorderColor="Transparent">
                               $ <asp:Label ID="lblTotal" runat="server"></asp:Label> <asp:Label ID="lblCurrencyCode2" runat="server"></asp:Label> <asp:Label ID="lblTotalText" runat="server"></asp:Label></asp:TableCell>
                        </asp:TableRow>
                        <asp:TableRow>
                            <asp:TableCell HorizontalAlign="Center" Width="70%" BorderColor="Transparent">
                               <asp:LinkButton ID="btnDetails" runat="server" Text="" Visible="false" CommandName="Details" /></asp:TableCell>
                        </asp:TableRow>
                    </asp:Table>
                </DetailItemTemplate>
              </MasterTableView>
            </telerik:RadGrid>


Javascript:
function btnBook_onclick(index, id) {
    var masterTable = $find("dgRates").get_masterTableView();
    masterTable.clearSelectedItems();
    masterTable.selectItem(index);
    return false;
}
Peter
Top achievements
Rank 1
 answered on 20 Nov 2014
1 answer
71 views
Hi

I am using Telerik UI for ASP.Net AJAX version 2014.3.1024.45, and specifically the SharePoint Editor Web Part and have come across a situation whereby I am not able to paste content from Visio when in IE, to RadEditor. It should be noted that I am able to paste other content, such as from Word, successfully.

I thought that this may be a general limitation, so I created a new web project in Visual Studio 2013, added the RadEditor control and when I ran the application, I was able to successfully paste the content from Visio to the RadEditor.

All of my previous tests were in IE 11, so I repeated the test in Chrome for the SharePoint site and it correctly pasted the content, suggesting that the problem is related to the SharePoint RadEditor web part in IE.  The results of my tests are as follows;

Paste to SharePoint RadEditor web part in IE doesn’t work
Paste to SharePoint RadEditor web part in Chrome does work
Paste to RadEditor in app I created in VS in IE does work
Paste to RadEditor in app I created in VS in Chrome does work

Has anyone else come across something similar and know how to fix it – if it is at all possible? The problem does appear to be directly related to the SharePoint web part version of the RadEditor, as it works fine in the app that I have created outside of SharePoint.

Any help or advice gratefully appreciated.

Thanks.

James.
Ianko
Telerik team
 answered on 20 Nov 2014
3 answers
220 views
Team,

we are using Telerik rich text editor, character count and word counts are displaying wrongly.

upon prefilling the data to the editor is adding few more character (Space/carriage return) at the end.

can we know how to address this?
Prakash
Top achievements
Rank 1
 answered on 20 Nov 2014
12 answers
168 views
is it possible to use the aggregates of grouped columns and other functionalities also in sharepoint 2010 environment.
The Columns definition as described in help is missing ?!

<telerik:GridBoundColumn Aggregate="Count" DataField="CustomerID" DataType="System.String"
  HeaderText="CustomerID" SortExpression="CustomerID" UniqueName="CustomerID">
</telerik:GridBoundColumn>


Here is the code of my webpart:
<WpNs1:TelerikSPRadGridWebPart runat="server" __MarkupType="xmlmarkup" WebPart="true" __WebPartId="{A4DEC18D-8081-41BC-95C2-3891DA62D7D2}" ><WebPart xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://schemas.microsoft.com/WebPart/v2">
  <Title>Marketing Research</Title>
  <FrameType>None</FrameType>
  <Description>Telerik SPRadGrid Web Part</Description>
  <IsIncluded>true</IsIncluded>
  <ZoneID>g_35F88101A875412AA8912B7EAAF29F1A</ZoneID>
  <PartOrder>2</PartOrder><FrameState>Normal</FrameState><Height /><Width /><AllowRemove>false</AllowRemove><AllowZoneChange>false</AllowZoneChange><AllowMinimize>false</AllowMinimize><AllowConnect>true</AllowConnect><AllowEdit>false</AllowEdit><AllowHide>false</AllowHide><IsVisible>true</IsVisible><DetailLink /><HelpLink /><HelpMode>Modeless</HelpMode><Dir>Default</Dir><PartImageSmall /><MissingAssembly>Cannot import this Web Part.</MissingAssembly><PartImageLarge /><IsIncludedFilter /><ExportControlledProperties>true</ExportControlledProperties><ConnectionID>00000000-0000-0000-0000-000000000000</ConnectionID><ID>g_a4dec18d_8081_41bc_95c2_3891da62d7d2</ID><SqlDataStructure xmlns="Telerik.Ajax.SharePoint"><Connection><IntegratedSecurity>false</IntegratedSecurity></Connection><Columns /><DetailTables /><Relations /><PrimaryKeys /><EnableSorting>false</EnableSorting><EnablePaging>false</EnablePaging><EnableFiltering>false</EnableFiltering><EnableRowSelect>false</EnableRowSelect><EnableContextMenu>false</EnableContextMenu><EnableColumnReorder>false</EnableColumnReorder><AllowInsert>false</AllowInsert><AllowUpdate>false</AllowUpdate><AllowDelete>false</AllowDelete><AllowSelection>false</AllowSelection><AllowMultipleSelection>false</AllowMultipleSelection><PagerMode>NextPrev</PagerMode><Layout>Grid</Layout><InsertItemPosition>None</InsertItemPosition><Skin>Simple</Skin><UserInternalEditing>false</UserInternalEditing></SqlDataStructure><SPListDataStructure xmlns="Telerik.Ajax.SharePoint"><DetailTables /><Relations /><EnableSorting>false</EnableSorting><EnablePaging>false</EnablePaging><EnableFiltering>false</EnableFiltering><EnableRowSelect>false</EnableRowSelect><EnableContextMenu>false</EnableContextMenu><EnableColumnReorder>false</EnableColumnReorder><ShowGroupFooter>true</ShowGroupFooter><AllowInsert>false</AllowInsert><AllowUpdate>false</AllowUpdate><AllowDelete>false</AllowDelete><AllowSelection>false</AllowSelection><AllowMultipleSelection>false</AllowMultipleSelection><PagerMode>NextPrev</PagerMode><Layout>Grid</Layout><InsertItemPosition>None</InsertItemPosition><Skin>Simple</Skin><UserInternalEditing>false</UserInternalEditing></SPListDataStructure><ViewID xmlns="Telerik.Ajax.SharePoint">00000000-0000-0000-0000-000000000000</ViewID><ShowToolbar xmlns="Telerik.Ajax.SharePoint">false</ShowToolbar><EnableHeaderContextMenu xmlns="Telerik.Ajax.SharePoint">false</EnableHeaderContextMenu><EnableInserting xmlns="Telerik.Ajax.SharePoint">false</EnableInserting><EnableEditing xmlns="Telerik.Ajax.SharePoint">false</EnableEditing><EnableDeleting xmlns="Telerik.Ajax.SharePoint">false</EnableDeleting><Skin xmlns="Telerik.Ajax.SharePoint">Windows7</Skin><BindingMode xmlns="Telerik.Ajax.SharePoint">SPListSingle</BindingMode><ListID xmlns="Telerik.Ajax.SharePoint">94de5d0f-7f51-4c89-9e65-26c5074250bf</ListID></WebPart></WpNs1:TelerikSPRadGridWebPart>

Regards and help for support

Chris
Marin
Telerik team
 answered on 20 Nov 2014
1 answer
120 views
Hi, I want to apply filter on item template contains ternary how can do this.

 <telerik:GridTemplateColumn UniqueName="IsAverage"  HeaderText="Average/Sum" ItemStyle-HorizontalAlign="Left" HeaderStyle-HorizontalAlign="Left"  AllowFiltering="false" >                                                                                                                               
       <ItemTemplate>  
      <asp:Label Id="active" runat="server" Text='<%# Convert.ToBoolean(Eval("IsAverage")) == true ? "Average" : "Sum" %>'></asp:Label>                                                     </ItemTemplate>                                                                  
            <HeaderStyle HorizontalAlign="Left"></HeaderStyle>
       <ItemStyle HorizontalAlign="Left"></ItemStyle>
  </telerik:GridTemplateColumn>

please provide example or solution with source code.
Radoslav
Telerik team
 answered on 20 Nov 2014
3 answers
117 views
Hi, noob here so apologies in advance for any misconceptions but I downloaded the telerik demo and samples materials to a Win 8 with Visual Studio 2013 Professional installed in November 2014.  I've read/worked through the first half of the "UI for ASP.Net Ajax" pdf step by step tutorial as well as referenced/tried my hand at opening the CS solutions provided.  However, I'm not getting the sense this is the most productive strategy.  Yes, the pdf provides orientation but much of the specifics are -- I presume -- out of date for my setup.  Similarly the example solutions could imho use a "readme" page in the main directory detailing how to use them (including their age, the updates VS will require, how their file structure relates to the pdf etc).

My first question then is whether a better learning strategy or materials can be suggested.  (Fwiw I'd be willing to pay someone a moderate fee to be an answer resource that can speed my learning curve.) 

Secondly I have some database experience and wasted too much time researching MVC with its requisite EF/ORM "kludge" -- instead I want to normalize and tune a database then write stored procedures to connect with webform components (please advise of security or performance issues possibly resulting as appropriate).

Thanks in advance   
Marin Bratanov
Telerik team
 answered on 20 Nov 2014
1 answer
85 views
Hi All,

i am using Chart in one of my page. what i am trying to bind grid data in chart. Below is the example of data i am trying to bind. 

Carrier_Name               ActualBalance              30Days                  31-60Days                 61-90Days           90+ Days
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Career1                              18644.00                  5370.00                   1263.00                      444.00                 11567.00                                                             Career2                              18185.00                  14019.00                 1331.00                      278.00                  2557.00                                                                     Career3                              5956.00                    5813.00                    0.000.00                    143.00                                                                                                   Career4                              4567.00                    0.00                          176.00                       0.00                     4391.00                                                                 Career5                              2418.00                    602.00                      0.00                           0.00                      1816.00


Now in my chart i want to bind all Actual Balance row in first Series, all 30Days row in second series , all 31-60Days row in third series and so on.

I have attached .jpg file for the output i am looking for. Please if anyone can help Thanks. 

 
Danail Vasilev
Telerik team
 answered on 20 Nov 2014
1 answer
88 views
Hi,

I have four static databound columns in radgrid like  Column1,column2, Column3 and Column4 with binding datatable its working fine  like sorting,paging. etc.
if i'm going to add additional one databound or numberic bound  column thats "Column5" through programatically  in pageinit event means its not working . same column adding more than once on each postback. Column5 ,Column6 without header..

Can you give sample project with this scenario?
Viktor Tachev
Telerik team
 answered on 20 Nov 2014
9 answers
629 views
Hi Experts

Is there any way to set/override the RadGrid Header Color while using the default skin.
I tried all possible ways and couldnt make it happen.

Thank you,
Deva
Fawad
Top achievements
Rank 1
 answered on 20 Nov 2014
Narrow your results
Selected tags
Tags
+? more
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?