The ConnectionString property has not been initialized error when i use stimulsoft report in asp.net
Posted: Wed Apr 24, 2019 9:29 am
I have a Stimulsoft report. and now I want to use this report in asp.net.when I call my report in the local mode it works truly in my system and didn't have any problem. but when I publish my web form and change the connection string of my code to server address and run it in my local computer it worked true but when I upload it I faced to below error:
The ConnectionString property has not been initialized.
this is my code that calls my report:
and the current connection string that I used for the published site is:
I have searched through the Forum but couldn't find a way to do it. Many Thanks in advance.
The ConnectionString property has not been initialized.
this is my code that calls my report:
Code: Select all
LblCourseId.Text = Request.QueryString["CourseId"];
string ConnectionString = ConfigurationManager.ConnectionStrings["KDUIS-v1ConnectionString"].ConnectionString;
string ServerLocation = HttpContext.Current.Server.MapPath(string.Empty);
StiReport MyStiReport = new StiReport();
MyStiReport.Dictionary.Databases.Add(new Stimulsoft.Report.Dictionary.StiSqlDatabase("Connection", ConnectionString));
MyStiReport.Load(ServerLocation + "\\Report\\AttendanceList.mrt");
MyStiReport.Dictionary.Variables["CourseId"].Value = LblCourseId.Text;
StiWebViewer1.Report = MyStiReport;Code: Select all
<add name="KDUIS-v1ConnectionString" connectionString="Data Source=address of my site ;Initial Catalog= my db ;Persist Security Info=True;User ID=username ;Password= password " providerName="System.Data.SqlClient" />