Why Can I not Get the reference of an object from another class in a namespace c#?

Question

I am trying to open a connection to a database and I have used a configuration string to connect and I've instantiated the sqlConnection object. I would like to be able to use this reference in a new classes method. Why am I not able to achieve this? Why does it say "this class cannot be inherited"?

namespace sqlLibrary
{
    public class sqlStuff
    {
        SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["SurplusConnectionString"].ConnectionString);  

    }

    public class commands : sqlStuff
    {
        public void executeQuery()
        {
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = myConnection; --> Not able to get reference from sql stuff class? 
        } 
    }    
}

I doubt that's all it says. Show us the entire error message. All relevant info. — rory.ap
– rory.ap, Commented Jul 5, 2017 at 19:45

Sergey Berezovskiy · Accepted Answer · 2017-07-05 19:53:41Z

7

By default, fields (and other class members) have private access modifier. Thus they are not visible in child classes. You should explicitly specify protected visibility

 protected SqlConnection myConnection

See Accessibility Levels (C# Reference)

edited Jul 5, 2017 at 19:53

answered Jul 5, 2017 at 19:48

Sergey Berezovskiy

237k44 gold badges441 silver badges468 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Why Can I not Get the reference of an object from another class in a namespace c#?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related