示例#1
0
        private void loadWorkerCombo()
        {
            string workerSelect = "SELECT        S_NAME, FIRST_NAME, LAST_NAME " +
                                  "FROM            WORKER";

            command = new SqlCommand(workerSelect, connection);
            //open the connection to the database
            try
            {
                connection.Open();
                //create the SqlDataReader object using the command object
                SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);
                //use loop to read data
                while (reader.Read())
                {
                    //create temp object and call constructor
                    StudentWorker tempWorker = new StudentWorker();
                    //read the rows and save in tempMemb
                    tempWorker.WUserName  = reader["S_NAME"].ToString();
                    tempWorker.WFirstName = reader["FIRST_NAME"].ToString();
                    tempWorker.WLastName  = reader["LAST_NAME"].ToString();

                    //add tempWorker object to the list
                    workers.Add(tempWorker);
                }
                //close the database
                connection.Close();
                //load the name in the combo box
                foreach (StudentWorker aWorker in workers)
                {
                    string workerName = aWorker.WFirstName + " " + aWorker.WLastName;
                    cboStudWorker.Items.Add(workerName);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error Loading Workers: " + ex);
            }
        }
示例#2
0
        //Gets all workers from WORKERS table
        private void collectWorkers()
        {
            //Query to get all student worker usernames
            string workerSelect = "SELECT S_NAME, FIRST_NAME, LAST_NAME, PASSWORD FROM WORKER";

            command = new SqlCommand(workerSelect, connection);

            try
            {
                connection.Open();
                SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);

                //Reads the usernames and stores them
                while (reader.Read())
                {
                    StudentWorker tempWork = new StudentWorker();

                    tempWork.WUserName  = reader["S_NAME"].ToString();
                    tempWork.WFirstName = reader["FIRST_NAME"].ToString();
                    tempWork.WLastName  = reader["LAST_NAME"].ToString();
                    tempWork.Password   = reader["PASSWORD"].ToString();

                    workers.Add(tempWork);
                }

                loadWorkers();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error 1 Worker Display: \n" + ex);
            }
            finally
            {
                connection.Close();
            }
        }