Load the Web Designer with default Connection and few Data Sources

[saifur.rahman@solentive.com]

Hi Team,
I tried to load the web designer with default connection and few data sources loaded. But it is not working.

private void LoadTheDesigner()
{
StiReport report = new StiReport();
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["DB"].ConnectionString);
sqlConn.Open();
report.RegData("EntireSystem", sqlConn);
report.Dictionary.Synchronize();
report.Dictionary.Connect();
StiWebDesigner1.Design(report);
}

after loading up into the browser I cant see any connection in dictionary. Please help me. I did the same thing in win designer, and that works perfectly.

[Jan]

Hello,

Sorry this code can't work with Web Designer. You can't use SqlConnection in this case. Please create StiSqlDatabase instead. For example:

Code: Select all

StiReport report = new StiReport();
StiSqlDatabase database = new StiSqlDatabase("Name", ConfigurationManager.ConnectionStrings["DB"].ConnectionString);
report.Dictionary.Databases.Add(database);
report.Dictionary.Synchronize();
report.Dictionary.Connect();
StiWebDesigner1.Design(report);

Thank you.