hi how can i get the data of a table in a db oracle ? i tried with the xmladatasource but it doesn't work.
this is the code :
XmlaDataSource DataSource = new XmlaDataSource(); DataSource.ServerUri = new Uri("ip of the db"); XmlaOracleConnectionSettings OSettings = new XmlaOracleConnectionSettings(); OSettings.ServerUri = new Uri("ip of the db:port"); OSettings.Credentials = new XmlaNetworkCredential("username", "password"); XmlaConnection OConnection = new XmlaConnection(OSettings); XmlaDataProvider ODataProvider = new XmlaDataProvider(OConnection); DataSource = new XmlaDataSource(ODataProvider); DataSource.LoadSchemaAsync(); XamPivotGrid PivotGrid = new XamPivotGrid(); PivotGrid.DataSource = DataSource; this.LayoutRoot.Children.Add(PivotGrid);
if possible i would like to obtain all the data of a single table in the db. thanks !!!
Hello,
Thank you for contacting Infragistics!
Based on your code it looks like you now have to setup hierarchies and measures. You are assigning the data to the grid and data provider but you are not telling it how to interpret it:
Assigning Hierarchies and Measures