How do I access object in one class from another class.

Question

0.00/5 (No votes)

See more:

, +

Here is my database connection class.I want to access 'oracleCommand' object reference from another class.

<pre>public class DBConnection
        { 
            //public OracleCommand oracleCommand;
            public string cmd = "";
            public void makeConnection()
            {
                //Opening connection
                string connectionString = "XXXX";
                OracleConnection con = new OracleConnection();
                con.ConnectionString = connectionString;
                con.Open();
                OracleCommand oracleCommand = con.CreateCommand();
                cmd = oracleCommand.CommandText;
                //Clossing resources
                con.Close();
                oracleCommand.Dispose();
            }

Then I want to execute the following query.

dbConnection.cmd = "SELECT COUNT(JOB_ID) FROM EmployeeTable WHERE STATUS='Pending'";
                OracleDataReader Reader = dbConnection.oracleCommand.ExecuteReader();
                Reader.Read();

But 'dbConnection.oracleCommand.ExecuteReader()' does not hit when debugging. Does anyone has an idea?

What I have tried:

I created '

public OracleCommand oracleCommand;

object and tried to pass.But it does not execute.

Posted 12-Mar-18 3:00am

Member 13716754

Updated 12-Mar-18 3:09am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

F-ES Sitecore · Answer 1 · 2018-03-12T03:10:00

oracleCommand only exists inside makeConnection so only code inside that function can access it, so I don't understand how your code even compiles. If you want to make a connection available you'll need to write a function like

public static OracleCommand GetConnection()
{
    string connectionString = "XXXX";
    OracleConnection con = new OracleConnection();
    con.ConnectionString = connectionString;
    con.Open();
    OracleCommand oracleCommand = con.CreateCommand();
    return oracleCommand;
}

Something like that anyway, and you'd call it like

var c = DBConnection.GetConnection();

Note the "static" on the method declaration.

The calling code would need to handle the cleaning up of the resources which is why code like this is usually a bad idea. Just create the command in any code that needs it.