[asp.net] xml 다루기

XmlDocument doc = new XmlDocument();
doc.Load( Server.MapPath( @"../xml\query.xml" ) );
XmlNode root = doc.SelectSingleNode("root");
XmlNode target = root.SelectSingleNode( "//query[@id='" + query_menu + "']" );
 
string ret_str = target.InnerText;
string return_type = target.Attributes["return_type"].Value;
 
/* 데이터가 리스트타입인 경우
List<string> ret_list = new List<string>();
foreach( XmlNode node in target ) {
  ret_list.Add( node.InnerText );
}
string ret_str = ( ret_list.Count > 0 ) ? "'" + String.Join( "','", ret_list.ToArray() ) + "'" : "";
*/
 
Response.Write( ret_str +  return_type );
Response.End();

/xml/query.xml

<?xml version="1.0" encoding="UTF-8"?>
<root>
  <query id="test.get_count" return_type='S'>
    select count(*) from test where seq = #seq#
  </query>
 
  <query id="test.get_list" return_type='M'>
    select * from test $where$
  </query>
</root>