Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
140
connect to a table in db oracle xmladatasource
posted

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 !!!