Обработка баз данных на Visual Basic®.NET

Прайс Кевин Т.

<LastName>Hobaica</LastName>

<DepartmentID>2</DepartmentID>

<Salary>18000</Salary>

</tblEmployee>

<tblEmployee>

<ID>2043</ID>

<FirstName>Brad</FirstName>

<LastName>Townsend</LastName>

<DepartmentID>2</DepartmentID>

<Salary>12000</Salary>

</tblEmployee>

<tblEmployee>

<ID>2044</ID>

<FirstName>Jennifer</FirstName>

<LastName>Eves</LastName>

<DepartmentID>2</DepartmentID>

<Salary>26000</Salary>

</tblEmployee>

<tblEmployee>

<ID>204V</ID>

<FirstName>Angela</FirstName>

<LastName>Stefanac</LastName>

<DepartmentID>2</DepartmentID>

<Salary>16000</Salary>

</tblEmployee>

<tblEmployee>

<ID>2048</ID>

<FirstName>Marjorie</FirstName>

<LastName>Bassett</LastName>

<DepartmentID>2</DepartmentID>

<Salary>34000</Salary>

</tblEmployee>

<tblEmployee>

<ID>2052</ID>

<FirstName>Mike</FirstName>

<LastName>Doberstein</LastName>

<DepartmentID>2</DepartmentID>

<Salary>42000</Salary>

</tblEmployee>

<tblEmployee>

<ID>2056</ID>

<FirstName>Mikki</FirstName>

<LastName>Lemay</LastName>

<DepartmentID>2</DepartmentID>

<Salary>50000</Salary>

</tblEmployee>

<tblEmployee>

<ID>2060</ID>

<FirstName>Richard</FirstName>

<LastName>Rosenthal</LastName>

<DepartmentID>2</DepartmentID>

<Salary>58000</Salary>

</tblEmployee>

 </tblDepartment>

 <tblDepartment>

<ID>3</ID>

<DepartmentName>Sales</DepartmentName>

<tblEmployee>

<ID>2037</ID>

<FirstName>Kathleen</FirstName>

<LastName>Johnson</LastName>

<DepartmentID>3</DepartmentID>

<Salary>18000</Salary>

</tblEmployee>

<tblEmployee>

<ID>2041</ID>

<FirstName>Matthew</FirstName>

<LastName>Haglund</LastName>

<DepartmentID>3</DepartmentID>

<Salary>30000</Salary>

</tblEmployee>

<tblEmployee>

<ID>2045</ID>

<FirstName>Steve</FirstName>

<LastName>Marshall</LastName>

<DepartmentID>3</DepartmentID>

<Salary>42000</Salary>

</tblEmployee>

<tblEmployee>

<ID>2049</ID>

<FirstName>Joe</FirstName>

<LastName>Chideya</LastName>

<DepartmentID>3</DepartmentID>

<Salary>54000</Salary>

</tblEmployee>

<tblEmployee>

<ID>2053</ID>

<FirstName>Terri</FirstName>

<LastName>Woodruff</LastName>

<DepartmentID>3</DepartmentID>

<Salary>66000</Salary>

</tblEmployee>

<tblEmployee>

<ID>2057</ID>

<FirstName>Randy</FirstName>