public List <Candidates> Load() { try { using (MySqlConnection con = new MySqlConnection(GOC_Tabulation_System.Config.GetConnectionString())) { con.Open(); string sql = "SELECT * FROM candidates"; MySqlCommand cmd = new MySqlCommand(sql, con); MySqlDataReader reader = cmd.ExecuteReader(); //loop while have record while (reader.Read()) { //instantiate model Candidates candidate = new Candidates(); //prepare properties candidate.id = Convert.ToInt32(reader["id"].ToString()); candidate.candidates = reader["can_no"].ToString(); ListCandidates.Add(candidate); } } } catch (MySqlException ex) { MessageBox.Show("ERROR : " + ex.ToString(), "Tabulation System", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(ListCandidates); }//End of Load