Esempi in C# (CSharp) per SchoolCanteen DBGate.GetColumnFromDB

Esempio n. 1

        private void AddUser_Load(object sender, EventArgs e)
        {
            string query = "select name from Classes";

            classBox.DataSource = DBGate.GetColumnFromDB(Properties.Settings.Default.ConnectionString, query);
            query = "select name from Years where ID <> '12'";
            yearBox.DataSource = DBGate.GetColumnFromDB(Properties.Settings.Default.ConnectionString, query);
        }

Esempio n. 2

        private void AddUser_Load(object sender, EventArgs e)
        {
            string query = "select name from Roles";

            roleBox.DataSource = DBGate.GetColumnFromDB(Properties.Settings.Default.ConnectionString, query);
        }