following is the xml, I need to classify this xml use IF-THEN-ELSE SQL statement using vb on a click button.
<?xml version="1.0"?>
<school>
<grades>
<grade>
<level>K </level>
<student_count>
<boys>49 </boys>
<girls>41 </girls>
</student_count>
</grade>
<grade>
<level>1 </level>
<student_count>
<boys>29 </boys>
<girls>32 </girls>
</student_count>
</grade>
<grade>
<level>2 </level>
<student_count>
<boys>26 </boys>
<girls>31 </girls>
</student_count>
</grade>
</grades>
<principal>
<name>Dr. Hamilton </name>
<experience timein="years">
<time>14 </time>
</experience>
</principal>
<classrooms />
</school>
