0

I'm trying to make a simple login form in C# with a mysql db but it keep throwing me this error "the name 'connectdb' does not exist in current context". I tried setting it inside, outside everything but it doesn't work then how do i fix it?

class ConnectionClass
{
   public MySqlConnection connectdb;

        public ConnectionClass()
        {
            string host = "192.168.0.19";
            string db = "test-db";
            string username = "root";
            string password = "";
            string connection_string = "datasource =" + host + "; database=" + db + "; port=3336; username =" + username + "; password =" + password + "; SslMode=none;";

            connectdb = new MySqlConnection(connection_string);
        }
    }
    class USER
    {
        public string log_username { set; get; }
        public string log_password { set; get; }
        public Int32 log_role { set; get; }

        public bool User_verification()
        {
            connectdb.Open();
            MySqlDataReader rd;
            bool check = false;
            using (var cmd = new MySqlCommand())
            {
                cmd.CommandText = "SELECT * FROM `users` WHERE username=@user AND password=@pass";
                cmd.CommandType = CommandType.Text;
                cmd.Connection = connectdb;

                cmd.Parameters.Add("@user", MySqlDbType.VarChar).Value = log_username;
                cmd.Parameters.Add("@pass", MySqlDbType.VarChar).Value = log_password;

                rd = cmd.ExecuteReader();

                while (rd.Read())
                {
                    log_role = rd.GetInt32("role");
                }
                connectdb.Close();
            }
            return check;

        }
}

0 Answers0