Copying and Pasting cs Code

In cs, like in almost any computer programming language, reading data from a file can be tricky. You add extra lines of code to tell the computer what to do. Sometimes you can copy and paste these lines from other peoples’ code.

For example, you can follow the pattern in this listing:

         private void loadStudents() {
             lvStudents.Items.Clear();

             OleDbCommand cmd;
             OleDbDataReader reader;

             string name, gender, cur, sy, lev, adv, sec;
             cur = cmbCurriculum.Text.ToUpper();
             sy = cmbSchoolYear.Text.ToUpper();
             lev = cmbLevel.Text.ToUpper();
             adv = cmbAdviser.Text.ToUpper();
             sec = cmbSection.Text.ToUpper();

             try {
                 using (OleDbConnection cn = new OleDbConnection(conString)) {
                     string sort = "";
                     if (add) {
                         sort = " ORDER BY id DESC";
                     }
                     string sql = "SELECT * FROM tblStudent WHERE (curriculum='" + cur + "' AND schoolyear='" + sy + "' AND slevel='" + lev + "' AND ssection='" + sec + "' AND adviser='" + adv + "')" + sort + ";";

                     cmd = new OleDbCommand(sql, cn);
                     cn.Open();
                     reader = cmd.ExecuteReader();
                     if (reader.HasRows) {
                         while (reader.Read()) {
                             string id = reader["ID"].ToString();
                             string lname = reader["lname"].ToString();
                             string ext = reader["ext"].ToString();
                             if (ext.Length > 0) {
                                 ext = " " + ext;
                             } else {
                                 ext = "";
                             }
                             string fname = ", " + reader["fname"].ToString();
                             string mname = reader["mi"].ToString();
                             if (mname.Length > 0) {
                                 mname = " " + mname[0] + ".";
                             } else {
                                 mname = " ";
                             }
                             name = lname + ext + fname + mname;
                             gender = reader["gender"].ToString();

                             string[] row = { id, name, gender };
                             ListViewItem item = new ListViewItem(row);
                             lvStudents.Items.Add(item);
                         }
                     }
                     cn.Close();
                 }
             } catch (Exception ex) {
                 MessageBox.Show("Error: " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
             }
             txtResults.Text = "Result(s): " + lvStudents.Items.Count;
         }