loop through xml node

foreach (XmlNode xRoomNode in xDoc.DocumentElement.SelectNodes(“Student/Subject”))
{
sqlCommand.Parameters.Add(“@room_code”, SqlDbType.VarChar, 500).Value = xRoomNode.SelectSingleNode(“@SubjectCode”).InnerText;
}