C# (CSharp) TableQuery.AddTable Beispiele

Beispiel #1

Datei: Global.asax.cs Projekt: bechirzf/obsolete-aspxdashboarddesigner-how-to-save-dashboards-to-a-data-base-t373382

    protected void Application_Start(object sender, EventArgs e)
    {
        string dbFileName = Server.MapPath("~/App_Data/DashboardDataSet.xml");
        DataBaseDashboardStorage dataBaseDashboardStorage = new DataBaseDashboardStorage();

        ASPxDashboardDesigner.Storage.SetDashboardStorage(dataBaseDashboardStorage);

        Access97ConnectionParameters accessParams = new Access97ConnectionParameters();

        accessParams.FileName = Server.MapPath("~/App_Data/nwind.mdb");
        DashboardSqlDataSource sqlDataSource        = new DashboardSqlDataSource("SQL Data Source", accessParams);
        TableQuery             customerReportsQuery = new TableQuery("CustomerReports");

        customerReportsQuery.AddTable("CustomerReports").SelectColumns("CompanyName", "ProductName", "OrderDate", "ProductAmount");
        sqlDataSource.Queries.Add(customerReportsQuery);

        DataSourceInMemoryStorage dataSourceStorage = new DataSourceInMemoryStorage();

        dataSourceStorage.RegisterDataSource("sqlDataSource1", sqlDataSource);
        ASPxDashboardDesigner.Storage.SetDataSourceStorage(dataSourceStorage);
        ASPxDashboardDesigner.Storage.ConfigureDataConnection += Storage_ConfigureDataConnection;
    }