Can't get MySql string working from other cs file

Question

i try to connect with my MySql connection in a other .cs file but i cant reach the connection string con which is located in the MySQL.cs here is the code i am using:

MainPage.cs

Data_Layer.MySQL mm = new Data_Layer.MySQL();

        private async void LoginKlik(object sender, EventArgs e)
        {

            try
            {
              mm.con.Open();
            }
         catch
         {}
         finally
         {}

I am getting a red line under the line mm.con.Open(); with the statement inaccisebale due protection level

MySQL.cs

namespace VerlofXamarin.Data_Layer
{
    public class MySQL
    { 
            MySqlConnection con = new MySqlConnection("Server=arabig.nl;Port=3306;database=arabignl_project;User Id=arabignl_project;Password=JariR0800;charset=utf8");
    }
}

You need to read a good tutorial on C# and understand what is the scope of a variable and how to make that variable public — Steve, Dec 07 '17 at 10:05

Ruben Sebastian · Answer 1 · 2017-12-07T10:53:52.440

1

As Sebastian Hofmann pointed c# declares fields as private by default. Like MySqlConnection con doesn't have a modifier is private, change it to public and will be accecible.

public MySqlConnection con = new MySqlConnection("Server=arabig.nl;Port=3306;database=arabignl_project;User Id=arabignl_project;Password=JariR0800;charset=utf8");

An extended explanation about this here

More info of access modifiers

edited Dec 07 '17 at 10:53

answered Dec 07 '17 at 10:11

Ruben Sebastian

141
10

That's not correct. C# implicitely declares all variables private, if not specified. If it was internal, it would be accessible. – Sebastian Hofmann Dec 07 '17 at 10:20

score 0 · Answer 2 · answered Dec 07 '17 at 10:31

0

This should do the trick:

public MySqlConnection con = new MySqlConnection("Server=arabig.nl;Port=3306;database=arabignl_project;User Id=arabignl_project;Password=JariR0800;charset=utf8");

answered Dec 07 '17 at 10:31

Jose

71
3

Can't get MySql string working from other cs file

2 Answers2