Parameter Error

[cloudsnake]

stimulsoft Reports.Net version 2009.3.600
I like stimulsoft Reports.Net ,but I have a problem ;

Code: Select all

                StiReport report = new StiReport();
                StiSqlDatabase db = new StiSqlDatabase("MyConnection", @"Password=sa;Data Source=SERVER;Integrated Security=False;Initial Catalog=TtX;User ID=sa");
                StiSqlSource mySource = new StiSqlSource("MyConnection", "MySource", "MySource");

                mySource.Parameters.Add(new StiDataParameter("&No", (int)SqlDbType.NVarChar, 16));
                mySource.SqlCommand = string.Format(@"SELECT admin.* FROM [admin] WHERE admin.admin_no = '{0}'", "@No");

                report.Dictionary.Databases.Add(db);
                report.Dictionary.DataSources.Add(mySource);
                report.Dictionary.Connect(false);
                mySource.SynchronizeColumns();





                report.Design();

                report.Dictionary.DataSources["MySource"].Parameters["@No"].ParameterValue = "T00023";   //  This is a Error
                report.Compile();
                report.Show();

report.Dictionary.DataSources["MySource"].Parameters["@No"].ParameterValue = "T00023"; have is a Error
thanx;

how do?

[Edward]

Hi

Please change the code a little bit:

report.Compile();
report["@No"]= "T00023";

Thank you.