Creating reports and dashboards | Stimulsoft community forum

hi,

I am having this error:
Message:ExecuteReader: CommandText property has not been initialized.
Type:System.InvalidOperationException

at this point:
report.Render(false)

sample code

DataTable dtTemp = new DataTable("lostpassword");
.
.
.
StiReport report = StiReport.GetReportFromAssembly("E:\\Projects\\HRS\\HRS\\lostpassword.dll");
report.RegData(dtTemp);
report.Render(false);

report.ExportDocument(Stimulsoft.Report.StiExportFormat.Pdf, "E:\\Projects\\HRS\\HRS\\" + sUserID + ".pdf");

thank you .

i am try to clear connection string but the problem still .


report.Dictionary.Databases.Clear();

report.Dictionary.Databases.Add(new StiSqlDatabase("HRS", strConString));

Hello,

You are use Data from Sql database and from DataTable at same time?

Thank you.

thank you ,

yes , but how i can useing Data from DataTable Only ?

In other words, how do I delete the link between the report file (during design) and the database?

I deleted The ConnectionString and SQL Stament Manual, but to no avail!

Hello,

You can use following code:
If you need replace Sql Source by DataTable DataSource you need use same Name of Data Source.

Thank you.