C#

<?xml version="1.0" encoding="UTF-8" ?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:param name="testParam">Test value</xsl:param>
</xsl:stylesheet>

public void WriteToConsole()
{
  // Create a new XmlDocument.
  XmlDocument doc = new XmlDocument();
  // Load the Xslt file into the document.
  doc.Load("../../MyTest.xslt");
  // Create the namespace manager and load the document nametable.
  XmlNamespaceManager mgr = new XmlNamespaceManager(doc.NameTable);
  // If you don't add the xsl namespace in, you'll get errors attempting
  // to parse the document.
  string xsltMgr = "xsl";
  string xsltUri = "http://www.w3.org/1999/XSL/Transform";
  mgr.AddNamespace(xsltMgr, xsltUri);

  try
  {
    // Select the node that you want, and don't forget the namespace
    XmlNode node = doc.SelectSingleNode("//xsl:param[@name='testParam']", mgr);
    // Write out the inner text.
    Console.WriteLine(node.InnerText);
  }
  catch (Exception ex)
  {
    Console.WriteLine(ex.Message);
  }
}

private int GetValue(string xmlFile, string title)
{
  XPathDocument doc = new XPathDocument(xmlFile);
  XPathNavigator nav = doc.CreateNavigator();
  XPathExpression expr = nav.Compile(string.Format(
    "ceiling(count(//Category[Title='{0}']/Category1/MetaData))", title);
  object obj = nav.Evaluate(expr);
  int output = 0;
  if (obj != null)
  {
    output = Convert.ToInt32(obj);
  }
  return output;
}

Abubakarsb wrote:

First I tried with your code friend, but it was giving error with 'title'
Second and most important one I don't have any phiysical XML file I am using webservice to fetch data. I am using xsl only to format it. data is infact coming from database exists in another country. I am only using web service method. Hope you will understand my situation now.

Stream xmlStream = GetStreamFromDataSource();

XPathDocument doc = new XPathDocument(xmlStream);

XPathExpression expr = nav.Compile(string.Format("ceiling(count(.//Category[Title='{0}']/Category/MetaData))", "I Claudius"));