C#

I'm new to programming.

I've created a ListView1 in C#

This ListView1 contains the columns: Student, DOB, and Location.

There are different groups. Each student is grouped together with other students sharing the same age group.

The DOB field is in date format representing date of birth of each student.



Student DOB       Location

Group1
AAA     10-05-2000  Mumbai
BBB     05-02-2000  Pune
CCC     01-01-2000  Delhi (youngest)

Group2
DDD     20-03-1999  Lucknow (youngest)
EEE     15-06-1999  Chennai
FFF     18-09-1999  Ahmedabad


Can you please help me with the Code to automatically delete all items except the youngest student in each of the groups (by comparing DOB)?

Thanks a lot in advance.  :) 

Hi guyss, I have a listview that loads the data of the Menu table in the database (MsSql 2012). The table has four columns ID, Product, Price and Quantity. So i am trying to make the rows of each items in the listview that will go red if the quantity in the database is 0. I've set the quantities of each Products so that i can identify if it will work.Apparently this is my code right now, but nothing happens when i put the method redRowL in the Form1_Load.

Note: The listview only loads the ID, Product and Price.

public void redRowL()
       {


           try
           {
       foreach(ListViewItem item in listView2.Items)
         {
                       SqlConnection cn = new SqlConnection();
                   con.Open();
                   string qwe = "Select " +  item.SubItems[0].Text  + " from Menu where Quantity = 0";



                    SqlCommand cmd = new SqlCommand(qwe, con);
                   dr = cmd.ExecuteReader();
                   while (dr.Read())
                   {
                         item.BackColor = Color.Red;
                   }
         }
           }
           catch
           {
               MessageBox.Show("Rows are Red , Your eye is Blue, What will yo do if im inlove with you?", "PHugOts Error");

           }
           con.Close();
       }

int focallength = MainCamera.GetInt32Setting(PropertyID.FocalLength);