Loop through a datatable to get multiple row values values,asp.net

I have table with data like this,
This is example data
ID Name Job       DeptName Loc
1     a       Mgr      sales         USA
1      a       xxx       ffff             UK
2        b     tttt        pur          IND
2         b     nnn      orde         ggg
The above table i want to display in browser like below
<Employees> <ID>1</ID> <NAME>a</NAME> <DEPTS> <Dept> <Job>mgr</Job> <DeptName>sales</DeptName> <Dept> <Dept> <Job>xxx</Job> <DeptName>fff</DeptName> ...