or
Absence -> List<Available> Available------------------------------------------------------------| ABSENCE |------------------------------------------------------------| Field1 | Field2 || || ----------------------------------------------------- || | Available | || ----------------------------------------------------- || | Available Field1 | Available Field2 | || ----------------------------------------------------- || ||----------------------------------------------------------||----------------------------------------------------------|| Field1 | Field2 || || ----------------------------------------------------- || | Available | || ----------------------------------------------------- || | Available Field1 | Available Field2 | || ----------------------------------------------------- || |------------------------------------------------------------private void detailTable_NeedDataSource(object sender, EventArgs e) { (sender as Telerik.Reporting.Processing.Table).DataSource = OrderDetails; }private void chart1_NeedDataSource(object sender, EventArgs e){ Telerik.Reporting.Processing.Chart procChart = (Telerik.Reporting.Processing.Chart)sender; Telerik.Reporting.Chart chart = (Telerik.Reporting.Chart)procChart.ItemDefinition; chart.ChartTitle.TextBlock.Text = chart.Report.ReportParameters["Branch"].Value.ToString();}private void textBox3_ItemDataBinding(object sender, EventArgs e){ Telerik.Reporting.Processing.TextBox procTB = (Telerik.Reporting.Processing.TextBox)sender; Telerik.Reporting.TextBox tb = (Telerik.Reporting.TextBox)procTB.ItemDefinition; tb.Value = "= Parameters.Branch.Value";}Hi All,
I have a multi-tenant database based on Microsoft SQL Azure to store my client info and I am using Telerik Report to for my Report modules.
Since I have to pull info from different database for different client, how do i dynamically configure my connection at web.config in order to know which database am i pulling from?
Please advise
Thanks You.
Eg.
<connectionStrings>
<add name="ReportClassLib.Properties.Settings.ClientDB" connectionString="**;Initial Catalog=DB_1;User ID=**;Password=**"
providerName="System.Data.SqlClient" />
</connectionStrings>
Client 1 is DB_1, Client 2 is DB_2,……