Retrieve second column from List
<p>I currently have a class to retrieve records from a sql database and put them into a list.
The record have multiple columns and i need to insert the data from the second column from all records into a combobox.</p>

<p>How is this achieved as im unable to find anything about it.</p>

<p>Processor Class:</p>

<pre><code>namespace RegForm
{
    public class ClientProcessor
    {
        public List&lt;Client&gt; ClientList = new List&lt;Client&gt;();


        public ClientProcessor()
        {
        }

        public void LoadClients()
        {
            string sqlc = ConfigurationManager.ConnectionStrings["sqlconn"].ConnectionString;
            SqlConnection conn = new SqlConnection(sqlc);

            if (conn.State != ConnectionState.Open)
            {
                conn.Open();
            }

            SqlCommand cmd = new SqlCommand("SELECT * FROM Clients ORDER BY CID", conn);
            try
            {
                SqlDataReader dr = cmd.ExecuteReader();

                ClientList = new List&lt;Client&gt;();

                if (dr.HasRows)
                {

                    while (dr.Read())
                    {
                        Client newClient = new Client();
                        newClient.ID = Convert.ToInt32(dr["CID"]);
                        newClient.CNAME= dr["CNAME"].ToString();

                        ClientList.Add(newClient);
                    }
                }
            }
            catch (Exception EX)
            {
                Console.WriteLine(EX.Message);
                Console.WriteLine(EX.InnerException);
            }

            if (conn.State == ConnectionState.Open)
            {
                conn.Close();
            }
        }
    }
}
</code></pre>
