Not get data from SQLDatasource

2 posts, 0 answers
  1. Cagdas
    Cagdas avatar
    1 posts
    Member since:
    Aug 2011

    Posted 04 Jun 2014 Link to this post

    Hello, i am testin to populate radpivotgrid from sql view but i dont see any data on it  do i have to add fields manualy? i checked get started its say ionly need to define datasourse and thats it but i couldnt manage it. do i missin something? or it cant populate from datasource i need to add fiels manualy?

    How its look:
            <telerik:RadScriptManager ID="RadScriptManager1" Runat="server">
            </telerik:RadScriptManager>
            <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                ConnectionString="<%$ ConnectionStrings:ASTAVUK2014ConnectionString %>" 
                SelectCommand="SELECT * FROM [TEKB_VET_SON]"></asp:SqlDataSource>
            <telerik:RadPivotGrid ID="RadPivotGrid1" runat="server" 
                DataSourceID="SqlDataSource1" EnableConfigurationPanel="True" Skin="MetroTouch">
            </telerik:RadPivotGrid>
  2. Eyup
    Admin
    Eyup avatar
    3013 posts

    Posted 09 Jun 2014 Link to this post

    Hello Cagdas,

    Yes, your assumption is correct. Unlike RadGrid, RadPivotGrid needs you to define the fields collection initially since the columns, rows and aggregate fields structure can vary greatly depending on your requirements. I suggest that you download and run the web site provided in the following blog for a basic sample:
    http://blogs.telerik.com/aspnet-ajax/posts/13-12-03/aspnet-pivot-table-made-easy

    Hope this helps.

    Regards,
    Eyup
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  3. UI for ASP.NET Ajax is Ready for VS 2017
Back to Top