C#

namespace ConsoleApplication2
{
	/// <summary>
	/// Summary description for Class1.
	/// </summary>
	class Class1
	{
		public string app;
		public void perform()
		{
			OdbcConnection con= null;
			con = new OdbcConnection();
			ADIBCrypto.Encryption64 crpto = new ADIBCrypto.Encryption64();
			string connString = crpto.GetCnnStr(ConfigurationSettings.AppSettings["appname"],ConfigurationSettings.AppSettings["dsnSybase"]);
			con.ConnectionString = connString;
			con.Open();
			Console.WriteLine("Connection Opened Successfully");
			Console.WriteLine("Enter the Application");
			app=Console.ReadLine();
			XmlDataDocument doc = new XmlDataDocument();
			doc.Load(ConfigurationSettings.AppSettings["app"]);
			XmlNodeList nodes = doc.GetElementsByTagName("Row");
			foreach(XmlNode node in nodes)
			{ 
				if(node.HasChildNodes && node.ChildNodes.Count > 0)
				{
					string a_ID = node.ChildNodes[0].InnerText;
					string a_ApplicationDescription = node.ChildNodes[1].InnerText;
					string a_Category = node.ChildNodes[2].InnerText;
					string a_Business_Owner = node.ChildNodes[3].InnerText;
					string a_CreatedID = node.ChildNodes[4].InnerText;
					string a_CreatedTimeStamp = node.ChildNodes[5].InnerText;
					string a_Status = node.ChildNodes[6].InnerText;
					if(a_ID==app)
					{
						Console.WriteLine("{0}",a_Category);
						Console.ReadLine();
					}
				}
			}
		}
		static void Main(string[] args)
		{
			Class1 cc = new Class1();
			cc.perform();
		}
	}
}

<Row>
    <ID>TestApp01</ID>
    <ApplicationDescription>Test App 01</ApplicationDescription>
    <Category>CM</Category>
    <Business_Owner></Business_Owner>
    <CreatedID></CreatedID>
    <CreatedTimeStamp></CreatedTimeStamp>
    <Status>A</Status>
 </Row>
<Row>
    <ID>TestApp02</ID>
    <ApplicationDescription>Test App 02</ApplicationDescription>
    <Category>CM</Category>
    <Business_Owner></Business_Owner>
    <CreatedID></CreatedID>
    <CreatedTimeStamp></CreatedTimeStamp>
    <Status>A</Status>
 </Row>