Ad:

C# Discussion Thread
Marked Solved
Views: 2873

Oct 14th, 2009

Active Reports passing variable to AR class

Expand Post »

Hi,

How do I pass my variable or textbox data from form to Active Reports class where I prepare my sql string so that I can use my variable in "Where" clause..like select * from personnel where name=' " + textboxName.Text + " ' ";

Thanks,
snky

Similar Threads

Passing Variable to another Class in Java
How to call a variable from other class in Java
Passing variable sql php in PHP
how to pass class variable to another class in Java

snakay

Reputation Points: 4

Solved Threads: 0

Junior Poster in Training

Offline

78 posts
since May 2009

Permalink

Oct 14th, 2009

Re: Active Reports passing variable to AR class

http://www.datadynamics.com/forums/82/ShowForum.aspx

Visit http://www.datadynamics.com/Help/Act...arameters.html and expand the topics "To add parameters to a SQL query" and "To add parameters at run time in C#" or "To add parameters at run time in Visual Basic.NET". That should show you how to do exactly what you are asking.

If you have more questions please feel free to use the very active ActiveReports Support forum on our website at http://www.datadynamics.com/forums/82/ShowForum.aspx .

Hope this helps!

Scott Willeke
GrapeCity / Data Dynamics

scottwilleke

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

3 posts
since Oct 2009

Permalink

Oct 18th, 2009

Re: Active Reports passing variable to AR class

Just in case people are interestedi this is how I solved it.

C# Syntax (Toggle Plain Text)
private void toolStripButton1_Click(object sender, EventArgs e)
 //Create the report and assign the data source
                        NewActiveReport2 rpt = new NewActiveReport2(dfID.Text);
                        rpt.Run(false);
                        this.viewer1.Document = rpt.Document;
private void toolStripButton1_Click(object sender, EventArgs e)
 //Create the report and assign the data source
                        NewActiveReport2 rpt = new NewActiveReport2(dfID.Text);
                        rpt.Run(false);
                        this.viewer1.Document = rpt.Document;

in the reporting class of AR

C# Syntax (Toggle Plain Text)
 
public NewActiveReport2(string sicilno)
        {
            //
            // Required for Windows Form Designer support
            //
            InitializeComponent();
            string strWhere = sicilno;
            strKomut = "select id,period,name,lastname from per015_ssk where id='" + strWhere + "' ";
 
 private void NewActiveReport2_ReportStart(object sender, EventArgs e)
        {
            DataAccess print_reader = new DataAccess();//create object of the class to handle datareader operations
            ok = print_reader.executar_re(strKomut);
            this.DataSource = print_reader;// bind datareader resultset
 
 private void NewActiveReport2_DataInitialize(object sender, EventArgs e)
        {
            Fields.Add("PERIOD");
            Fields.Add("ID");
            Fields.Add("NAME");
            Fields.Add("LASTNAME");
        }
 
private void NewActiveReport2_ReportEnd(object sender, EventArgs e)
        {
            ok.Close();
        }
 
 
private void NewActiveReport2_FetchData(object sender, FetchEventArgs eArgs)
        {
            try
            {
                ok.Read();
                // List them in order with datasource ordering not to get exception
 
                Fields["PERIOD"].Value = ok[0].ToString();
                Fields["ID"].Value = ok[1].ToString();
                Fields["NAME"].Value = ok[2].ToString();
                Fields["LASTNAME"].Value = ok[3].ToString();
                eArgs.EOF = false;
            }
            catch
            {
                eArgs.EOF = true;
            }
        }
public NewActiveReport2(string sicilno)
        {
            //
            // Required for Windows Form Designer support
            //
            InitializeComponent();
            string strWhere = sicilno;
            strKomut = "select id,period,name,lastname from per015_ssk where id='" + strWhere + "' ";

 private void NewActiveReport2_ReportStart(object sender, EventArgs e)
        {
            DataAccess print_reader = new DataAccess();//create object of the class to handle datareader operations
            ok = print_reader.executar_re(strKomut);
            this.DataSource = print_reader;// bind datareader resultset

 private void NewActiveReport2_DataInitialize(object sender, EventArgs e)
        {
            Fields.Add("PERIOD");
            Fields.Add("ID");
            Fields.Add("NAME");
            Fields.Add("LASTNAME");
        }

private void NewActiveReport2_ReportEnd(object sender, EventArgs e)
        {
            ok.Close();
        }


private void NewActiveReport2_FetchData(object sender, FetchEventArgs eArgs)
        {
            try
            {
                ok.Read();
                // List them in order with datasource ordering not to get exception
                
                Fields["PERIOD"].Value = ok[0].ToString();
                Fields["ID"].Value = ok[1].ToString();
                Fields["NAME"].Value = ok[2].ToString();
                Fields["LASTNAME"].Value = ok[3].ToString();
                eArgs.EOF = false;
            }
            catch
            {
                eArgs.EOF = true;
            }
        }

And it does it.

Thanks Scott Willeke
snky

snakay

Reputation Points: 4

Solved Threads: 0

Junior Poster in Training

Offline

78 posts
since May 2009

Permalink

Oct 18th, 2009

Great! Some things notes to consider

I am interested, so I'm glad you posted it. Use whatever, works out well for you, there is no "right" answer. However, here are some things for you to consider...

If you set an IDataReader instance to the DataSource property of the report you don't need to use FetchData. AR will automatically get the fields from the IDataReader instance and allow you to use them in the report. Just set the DataField property of a textbox to the name of the field (exactly as it is returned from the database).

It seems you're using your own data layer to actually execute the query. However, if you did let AR query the database directly you can use a sql statement with AR like the following:
this.DataSource.ConnectionString = "select id, period, name, lastname from per015_ssk where id='<%PerID|Enter PER ID|100>' ";

Then, outside of the report you can specify the value for it as follows:
myReportObject.Parameters["PerID"].Value = "some value";

ActiveReports will automatically update the query before it is executed. If you do not provide a value AR will prompt the end user for a value with "Enter PER ID" as the prompt (you can change that above).

Of course, if you must use an existing data layer then that is fine too!

Scott Willeke
GrapeCity Inc.

scottwilleke

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

3 posts
since Oct 2009

Permalink

Oct 19th, 2009

Re: Active Reports passing variable to AR class

Thank you for your reply,

For the first part of your advise that is not to use FetchData event, what I did was I replaced datareader instance within ReportStart as you said.

C# Syntax (Toggle Plain Text)
 
private void NewActiveReport2_ReportStart(object sender, EventArgs e)
        {
 
DataAccess print_reader = new DataAccess
 ok = print_reader.executar_re(strKomut);    
this.DataSource = print_reader;
 
Fields["PERIOD"].Value = ok[0].ToString();  
Fields["ID"].Value = ok[1].ToString();                
Fields["NAME"].Value = ok[2].ToString();                
Fields["LASTNAME"].Value = ok[3].ToString();
 
        }
private void NewActiveReport2_ReportStart(object sender, EventArgs e)
        {

DataAccess print_reader = new DataAccess
 ok = print_reader.executar_re(strKomut);    
this.DataSource = print_reader;

Fields["PERIOD"].Value = ok[0].ToString();  
Fields["ID"].Value = ok[1].ToString();                
Fields["NAME"].Value = ok[2].ToString();                
Fields["LASTNAME"].Value = ok[3].ToString();

        }

and it worked. But the rest of the advise can you elaborate further. Suppose I don't use the datalayerclass and use AR for sql query, 1-where do I put "this.DataSource.ConnectionString = "select id, period, name, lastname from per015_ssk where id='<%PerID|Enter PER ID|100>' "; "
2-where do I put "myReportObject.Parameters["PerID"].Value = "some value"; ". Is it the mainform ? Can I have a small sample of what you are advising. I like to find most appropriate and professional way of using AR, so open to any idea that helps.

Thanks
snky

snakay

Reputation Points: 4

Solved Threads: 0

Junior Poster in Training

Offline

78 posts
since May 2009

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in C# Forum Timeline: C# Meemory Acess Violation - Marshall.Copy

Next Thread in C# Forum Timeline: Desinging in C# window application.

DaniWeb Message

Cancel Changes

User Name
Password