This is a migrated thread and some comments may be shown as answers.

Not get data from SQLDatasource

1 Answer 57 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Cagdas
Top achievements
Rank 1
Cagdas asked on 04 Jun 2014, 01:30 PM
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>

1 Answer, 1 is accepted

Sort by
0
Eyup
Telerik team
answered on 09 Jun 2014, 10:47 AM
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.

 
Tags
PivotGrid
Asked by
Cagdas
Top achievements
Rank 1
Answers by
Eyup
Telerik team
Share this question
or