1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
 

              try
              {
            
                  // Create the SQL command...
                  SqlCommand cmd = new SqlCommand(select_command, Conn);

                  // Construct the data reader
                  using (SqlDataReader reader = cmd.ExecuteReader())
                  {

                      // And iterate through the data
                      while (reader.Read())
                      {
                        mF.listBox1.Items.Add(reader[1].ToString());
                        
                       // mF.listBox1.Refresh();                  
                      }

                      reader.Close();
                  }
                  Conn.Close();
                  
              }
              catch (Exception e)
              {
                  MessageBox.Show(e.Message);
              }