Thread: Oledb Connection(Completely Different from first post)

i wrote this bit of c# code to go into the database and fetch a username but it keeps on saying the connection is not open but i opened it so i do not understand. This code is written within a class which i call i the main :

Code:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.OleDb;

namespace ConsoleApplication1
{
    class @dbconnection
    {
        private OleDbConnection conn = new OleDbConnection();

        void con()
        {
            conn.ConnectionString = "Provider=SQLOLEDB;Data Source=localhost\\sqlexpress;Integrated Security=SSPI;Initial Catalog=ecg_projectDB2";
            conn.Open();
        }

         public OleDbConnection connection
         {
            get
            {
                 return conn;
            }              
         }      
    }

    class @test
    {
        private static string user;
        public static string username
        {
            get
            {
                return user;
            }
            set
            {
                user = value;
            }
        }

        public void getname()
        {

            OleDbCommand cmd = new OleDbCommand();
            dbconnection db = new dbconnection();
            cmd.Connection = db.connection;

            cmd.CommandText = "select * from ecg_projectDB2.dbo.adminusers where password = 'user'";
            cmd.CommandType = CommandType.Text;
            
            OleDbDataReader dr =  default(OleDbDataReader);
            
            dr = cmd.ExecuteReader();
            if(dr.Read())
            {
                username = (string)dr["username"];
                Console.Write(username);
            }
            dr.Dispose();
            dr.Close();
       
        }
    }
}

Yeah Sorry, this is just the class file not the main and for you saying it's messy, this is how i was taught in vb and i'm trying to rewrite the code and apply some of the same techniques in c#, plus i don't know any other method so if you have a better way of doing it i'd really appreciate it.