int i = 0;
dataGridView1.Rows.Clear();
cn.Open();
cmd = new SqlCommand("select *from tblNewStudentEntry where status like 'Active'", cn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
i++;
dataGridView1.Rows.Add(i, dr["academicyear"].ToString(), dr["currentglevel"].ToString(), dr["strand"].ToString(), dr["section"].ToString(), dr["lrn"].ToString(), dr["Photo"].ToString(), dr["lname"].ToString(), dr["fname"].ToString(), dr["mname"].ToString(),DateTime.Parse( dr["bdate"].ToString()).ToShortDateString(), dr["age"].ToString(), dr["birthplace"].ToString(), dr["studcontactno"].ToString(), dr["gender"].ToString());
}
dr.Close();
cn.Close();