Best Way To Deal With XML - Sql 2000)?

this is my requirement

1 receive an xml string
2 data procress (retrieve data from db 、updata from db ... )
3 return an result of xml string

this the way I did

1 receive an xml string
2 parse xml by this way

string NO = xml.GetElementByTat("NO")[0].InnerText;
string Name = xml.GetElementByTat("Name")[0].InnerText;
use data to active with Database
ex: select Manager from deparement where EMPNo = 'No' and EMPNAME = 'NAME'

3 return an result xml to the who call webservice
string rtnXml = "<ProjectTeam>"
+"<No>A121</NO>"
+"<Name>Jack</Name>"
+"<Manager>Allen</Manager>"
+"</ProjectTeam>";

like this... but sometimes this way is mass.. do you have other idea to deal with xml ?