This is a migrated thread and some comments may be shown as answers.

Passing Parameters to sql query

3 Answers 756 Views

General Discussions

This is a migrated thread and some comments may be shown as answers.

Manuel asked on 19 Dec 2011, 04:07 PM

query.png

Hi there,

How I can pass parameters to my sql queries in query builder. Please look at picture.

In my ReportViewer I do that:

public SGASeguranca()
        {
            InitializeComponent();

            try
            {

                ReportViewer1.Report = "ReportClass.ParticipantesReuniao, ReportClass, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null";
                ReportViewer1.ReportServiceUri = new Uri("../ReportService.svc", UriKind.RelativeOrAbsolute);
                ReportViewer1.RenderBegin += new Telerik.ReportViewer.Silverlight.RenderBeginEventHandler(ReportViewer1_RenderBegin);

            }
            catch(Exception e)
            {
            }

        }

        void ReportViewer1_RenderBegin(object sender, Telerik.ReportViewer.Silverlight.RenderBeginEventArgs args)
        {
            args.ParameterValues["REUNIAOID"] = 1010;

        }

And in code-behind of my report I do that:

   void ParticipantesReuniao_NeedDataSource(object sender, System.EventArgs e)
        {
            Telerik.Reporting.Processing.Report report = (Telerik.Reporting.Processing.Report)sender;

            this.sqlDataSource1.Parameters[0].Value = report.Parameters["REUNIAOID"].Value;

            // Set the SqlDataSource component as it's DataSource
            report.DataSource = this.sqlDataSource1;
        }

But now, I want use this REUNIAOID in query builder.

How I can do that?

Thanks in advance

3 Answers, 1 is accepted

-1